Welcome to Geeklog, Anonymous Monday, October 14 2024 @ 04:09 pm EDT
Geeklog Forums
1064 Error
bcbrock
\"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.draft_flag = 0) AND (tid IN\"
In error.log, it records:
Tue Jul 22 09:36:27 2003 - 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.draft_flag = 0) AND (tid IN 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.draft_flag = 0) AND (tid IN (\'Announcments\',\'FunFacts\',\'General\',\'Hints\'))) LEFT JOIN gl_pollquestions ON ((qid = gl_comments.sid)) WHERE (gl_comments.date >= (DATE_SUB(NOW(), INTERVAL 172800 SECOND))) AND ((((gl_stories.owner_id IS NOT NULL AND gl_stories.perm_owner IS NOT NULL) OR (gl_stories.group_id IS NOT NULL AND gl_stories.perm_group IS NOT NULL) OR (gl_stories.perm_members IS NOT NULL))) OR (((gl_pollquestions.owner_id IS NOT NULL AND gl_pollquestions.perm_owner IS NOT NULL) OR (gl_pollquestions.group_id IS NOT NULL AND gl_pollquestions.perm_group IS NOT NULL) OR (gl_pollquestions.perm_members IS NOT NULL)))) GROUP BY gl_comments.sid ORDER BY 7 DESC LIMIT 15
Any suggestions, please?
~Brian
Dirk
bcbrock
I didn\'t think I had changed anything but edit only the one line to the config file in lib-common.php, but at your mention of lib-common, I replaced it with a fresh copy, and tried again. This time, it worked. I must have accidentally hit a keystroke when I was editing the first time without realizing it.
Thank you very much for your help!
~Brian
~Brian
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content