[geeklog-users] An SQL error has occured. Please see error.log for details

[naderrau at services01.student.math.uwaterloo.ca]

Hi,

I just installed GL last night and finally got it running this morning.

The page comes up but it says :
An SQL error has occured. Please see error.log for details

And error.log says :

Mon Feb 2 23:01:12 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
near '= gl_comments.sid) AND (gl_stories.perm_anon >= 2) AND (gl_stor. SQL in
question: SELECT 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 ((.sid = gl_comments.sid) AND (gl_stories.perm_anon >= 2) AND
(gl_stories.draft_flag = 0) AND (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_pollquestions.perm_anon IS NOT NULL)))) GROUP BY
gl_comments.sid ORDER BY 7 DESC LIMIT 15

I'm using the latest GL, and my PHP is higher than 4.04.  And I'm using Mac
OSX.3 if it matters...(?)

Can somebody help me interepret why this might be happening?

Thanks,
Neil

----------------------------------------
This mail sent through www.mywaterloo.ca