news module throwing a database error whilst trying to add news article
Posted: Wed Jun 18, 2008 8:41 am
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?
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?