Posted on: 07/11/03 09:51pm
By: ScurvyDawg
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.
Re:odd News Block issue
Posted on: 07/12/03 04:16am
By: Dirk
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
Re:odd News Block issue
Posted on: 07/12/03 01:12pm
By: ScurvyDawg
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
Re:odd News Block issue
Posted on: 07/12/03 01:36pm
By: Dirk
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
Re:odd News Block issue
Posted on: 07/12/03 01:55pm
By: ScurvyDawg
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\'
Re:odd News Block issue
Posted on: 07/12/03 02:22pm
By: Dirk
[QUOTE BY= ScurvyDawg]SQL in question: select newsid, rdfurl, rdfupdated, provider, category from where provider=\'Cool sites\' [/QUOTE]
I\'m not familiar with that block, but the SQL request is missing the table name between the \"from\" and the \"where\".
bye, Dirk
Re:odd News Block issue
Posted on: 07/12/03 02:38pm
By: squatty
Did you recently do an upgrade? If so, make sure the lib-database.php file has the table entry for the news block.
Re:odd News Block issue
Posted on: 07/12/03 02:43pm
By: ScurvyDawg
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.