[geeklog-users] An SQL error has occured. Please see error.log for details
tony at tonybibbs.com
Mon Feb 2 15:41:38 EST 2004
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.
naderrau at services01.student.math.uwaterloo.ca wrote:
> 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?
> This mail sent through www.mywaterloo.ca
> geeklog-users mailing list
> geeklog-users at lists.geeklog.net
More information about the geeklog-users