Forum Subject: 1064 Error

Posted on: 07/22/03 10:45am
By: bcbrock

While upgrading from 1.3.7sr2 to 1.3.8, I\'m getting the following onscreen:

\"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?

Re:1064 Error

Posted on: 07/22/03 11:03am
By: Dirk

[QUOTE BY= bcbrock]LEFT JOIN gl_stories ON ((.sid = gl_comments.sid) AND (gl_stories.draft_flag = 0) AND[/QUOTE] The name of the table (gl_stories, in this case) is missing there in front of the \".sid\". But that\'s impossible, because it has the table name just before and after that point. Did you edit anything in lib-common.php (apart from the path to the config.php file)? bye, Dirk

Re:1064 Error

Posted on: 07/22/03 11:14am
By: bcbrock

Dirk -

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