[geeklog-users] SQL error on index.php

Everett Littles eslittles at ucdavis.edu
Sat Jul 24 13:23:21 EDT 2004


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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 1075 bytes
Desc: not available
URL: <https://pairlist8.pair.net/pipermail/geeklog-users/attachments/20040724/b05d6b00/attachment.bin>


More information about the geeklog-users mailing list