Geeklog Forums

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

Can somebody help me interepret why this might be happening?

Thanks,
Neil

And I'm using MAC OSX.3, too, if it matters..(?)

That may indeed matter. See this thread, for example.

bye, Dirk