I just finished installing Geelklog 1.3.9 on my machine.
It is OS 10.3 with PHP 4.3.6 and MySQL 4.0.2
The whole process was flawless until I tried to access my main page.
I got the following error:

An SQL error has occured. Please see error.log for details.

When I check my error.log it reads as follows:

Sat Jul 24 10:18:58 2004 - 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use$
CT DISTINCT count(*) AS dups, type, question, gl_stories.title, gl_stories.sid, qid, max(gl_comments.date) as lastdate FROM gl_comments LEFT JOIN gl_stories ON (($
tid IN ('General','GeekLog'))) LEFT JOIN gl_pollquestions ON ((qid = gl_comments.sid) A
ND (gl_pollquestions.perm_anon >= 2)) WHERE (gl_comments.date >= (DATE_SUB(NOW(), INTERVAL 172800 SECOND))) AND ((((gl_stories.perm_anon IS NOT NULL))) OR (((gl_p$

I tried dumping my whole db and starting over and got the same results.

Any clues?

Thanks.

Reply via email to