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

[Neil Derraugh (UW)]

As it turns out set $_CONF['hidenewcomments'] = 1;'ing seems to mask the 
symptoms.

Thanks go out to Dirk!  :)
Neil D

naderrau at services01.student.math.uwaterloo.ca wrote:

>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
>_______________________________________________
>geeklog-users mailing list
>geeklog-users at lists.geeklog.net
>http://lists.geeklog.net/listinfo/geeklog-users
>
>  
>