Welcome to Geeklog, Anonymous Saturday, August 31 2024 @ 11:35 pm EDT
Geeklog Forums
SQL error in News Plugin RC1
....
Anonymous
News plugin installed nicely. But when I tried to use it, it caused a white screen and reported a SQL error. I checked the log and found this:
Fri 23 Jan 2004 07:27:12 AM EST - Parse error in http://www.newsisfree.com/HPE/xml/feeds/69/1469.xml: junk after document element at line 2
Fri 23 Jan 2004 07:27:12 AM EST - 1064: You have an error in your SQL syntax near 'where uid ='2'' at line 7. SQL in question:
update gl_news_users set
rdfupdated = '2004-01-23 07:27:09',
cache_age = '1074860829',
cache_expire='1',
cache = 'Sorry, the news feed you selected is currently unavailable. Please select another topic.',
where uid ='2'
Not sure what this means, but it seems it doesn't like the cache table.
I am using MYSQL 3.23.58 (part of Redhat 9). The plugin was develop using MYSQL 4.X. Could my problem be caused by a MYSQL incompatibility?
Fri 23 Jan 2004 07:27:12 AM EST - Parse error in http://www.newsisfree.com/HPE/xml/feeds/69/1469.xml: junk after document element at line 2
Fri 23 Jan 2004 07:27:12 AM EST - 1064: You have an error in your SQL syntax near 'where uid ='2'' at line 7. SQL in question:
update gl_news_users set
rdfupdated = '2004-01-23 07:27:09',
cache_age = '1074860829',
cache_expire='1',
cache = 'Sorry, the news feed you selected is currently unavailable. Please select another topic.',
where uid ='2'
Not sure what this means, but it seems it doesn't like the cache table.
I am using MYSQL 3.23.58 (part of Redhat 9). The plugin was develop using MYSQL 4.X. Could my problem be caused by a MYSQL incompatibility?
3
3
Quote
All times are EDT. The time is now 11:35 pm.
- 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