Geeklog Forums

I upgraded to 1.3.8. RC1 and now I get this error in the news block. I want to understand what went wrong here before I upgrade any further. The error is 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 \'where provider=\'Cool sites\'\' at line 1 Please any assistance is most welcome.

Standard reply: Open your error.log file and look for the corresponding entry there. It will have the complete SQL request that caused the problem. This will usually make it a lot easier to pin down the problem ... bye, Dirk

Ok ... I am sorry I got the standard answer Dirk. Sorry for being such a newb sometimes. Would you share your insights about these error as I seem to have many of these and I can not see that they relate to the news plugin at all but the menu. My error log is filled with gobs of these. Sat Jul 12 12:59:47 2003 - SELECT * FROM mnu_index WHERE ((perm_anon >= 3) OR (perm_members >= 2) OR ((group_id = 2) AND (perm_group >= 2)) OR ((group_id = 4) AND (perm_group >= 2)) OR ((group_id = 7) AND (perm_group >= 2)) OR ((group_id = 11) AND (perm_group >= 2)) OR ((group_id = 5) AND (perm_group >= 2)) OR ((group_id = 13) AND (perm_group >= 2)) OR ((group_id = 12) AND (perm_group >= 2)) OR ((group_id = 52) AND (perm_group >= 2)) OR ((group_id = 51) AND (perm_group >= 2)) OR ((group_id = 10) AND (perm_group >= 2)) OR ((group_id = 8) AND (perm_group >= 2)) OR ((group_id = 1) AND (perm_group >= 2)) OR ((group_id = 14) AND (perm_group >= 2)) OR ((group_id = 3) AND (perm_group >= 2)) OR ((group_id = 6) AND (perm_group >= 2)) OR ((group_id = 9) AND (perm_group >= 2)) OR ((group_id = 50) AND (perm_group >= 2)) OR ((group_id = 53) AND (perm_group >= 2)) OR ((owner_id = 7) AND (perm_owner >= 2))) AND (lang = \'english\') ORDER BY m_pos ASC Sat Jul 12 12:59:47 2003 - nrows = 16 language = english

That doesn\'t look like an error at all. More like some debug output that the author of the menu plugin forgot to deactivate ... And, as you noticed, it doesn\'t have anything to do with the above-mentioned error. The error message in your first post includes the words \"Cool sites\" - try searching your error.log for these words to find the actual error message. bye, Dirk

Here it is I found the offending line. Any insights? Has anyone else had this issue I do not know what I missed but I must have missed something. Tue Jul 1 00:32:02 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 \'where provider=\'Cool sites\'\' at line 1 SQL in question: select newsid, rdfurl, rdfupdated, provider, category from where provider=\'Cool sites\'

I\'m not familiar with that block, but the SQL request is missing the table name between the \"from\" and the \"where\". bye, Dirk

Did you recently do an upgrade? If so, make sure the lib-database.php file has the table entry for the news block.

---

In a world without walls and fences, who needs Windows and Gates?

Aha that must be it. THanks Squatty. I will see if I can find the table entry within the documentation I have. Thanks to you both for your time. Thank you.