[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

>

>  

>