Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 06:59 am EDT

Geeklog Forums

odd News Block issue


Status: offline

ScurvyDawg

Forum User
Full Member
Registered: 11/06/02
Posts: 523
embarrassed
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.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

Status: offline

ScurvyDawg

Forum User
Full Member
Registered: 11/06/02
Posts: 523
confused
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

Status: offline

ScurvyDawg

Forum User
Full Member
Registered: 11/06/02
Posts: 523
confused
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\'
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by ScurvyDawg: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
 Quote

Status: offline

squatty

Forum User
Full Member
Registered: 01/21/02
Posts: 269
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?
 Quote

Status: offline

ScurvyDawg

Forum User
Full Member
Registered: 11/06/02
Posts: 523
hopeful
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.
 Quote

All times are EDT. The time is now 06:59 am.

  • 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