Hi all,

News 1.3 is giving me the following error :

SELECT s.*, t.topic_frontpage FROM xoops_stories s, xoops_topics t WHERE (published > 0 AND published <= 1113761809) AND (expired = 0 OR expired > 1113761809) AND (s.topicid=t.topic_id) AND topicid IN (1,,,,,,) ORDER BY s.published DESC LIMIT 0, 10
Error number: 1064
Error message: 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 ',,,,) ORDER BY s.published DESC LIMIT 0, 10' at line

I can understand that MySQL doesn't like the IN (1,,,,,,) part of the query above. I am however not sure why I am getting this error. As far as I know nothing has changed on the site (execpt for content) and none of the topicid's start with 1.
Also I cannot find any stories in the database without a topicid as the error above might suggest.

Any thoughts on this error are more than welcome !

greetings Highlander

Updating the News module has fixed this issue ** Hurrah **, however I am still curious how this error was created.

Any thoughts ??

Greetings Highlander