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

[Tony Bibbs]

This is wrong:

"(.sid = gl_comments.sid)"

there should be a table name before ".sid".

Not sure why that is happening, though.  Submit this as a bug even 
though experience tells me this is usually a user-mistake during the 
installation process rather than a bug.  We'll try and reproduce it.

--Tony

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