news module throwing a database error whilst trying to add news article

[scotch33]

Hi,

WEhen trying to add an article I am getting

"DEBUG: SQL = INSERT INTO cms_module_news (news_id, news_category_id, news_title, news_data, summary, status, news_date, start_time, end_time, create_date, modified_date,author_id,news_extra) VALUES (0,'0','test','test','test','published','2008-06-18 08:43:40','2008-06-18 08:43:40',NULL,'2008-06-18 08:43:51','2008-06-18 08:43:51','1','')
Duplicate entry '0' for key 1"

Would the way to get around this be going into the database and changing the value for the single article that's in there?  Can I change it to ')' to stop the clash,?  Or am I on the wrong lines entirely?

[calguy1000]

something is amis with your database, the news_id should never be 0

I'd try unistalling and re-installing News again.  but have a backup because uninstalling the module drops the tables that it uses.