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.
- [geeklog-users] SQL error on index.php Everett Littles
- Re: [geeklog-users] SQL error on index.php Dirk Haun
- Re: [geeklog-users] SQL error on index.php Everett Littles