[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