Welcome to Geeklog, Anonymous Monday, June 17 2024 @ 05:00 pm EDT

Geeklog Forums

SQL error in News Plugin RC1


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 = '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?

All times are EDT. The time is now 05:00 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