Geeklog Forums

Sorry for the 2 posts - not sure what happened to the first one. After a successful install, I am getting errors when loading the main geeklog page (i.e. geeklog.mydomain.com), and a peek at 'error.log' shows the following:

Sun Oct 12 14:51:39 2003 - 1064: You have an error in your SQL syntax near '= gl_comments.sid) AND (gl_stories.perm_anon >= 2) AND (gl_stories.draft_flag = ' at line 1 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

Anyone have any ideas? Many thanks.

See this thread. Still not sure why and when that happens, though

bye, Dirk

Thanks for the link - fresh copy of the lib-common.php did not help. FWIW, I am also using Mac OS X (server version), which has MySQL v 3.23.53 installed.