Page 1 of 1

cannot post news article [SQL bug: duplicate entry]

Posted: Fri Sep 19, 2008 4:03 pm
by tombigdaddy
Hello, I'm working with CMSMadeSimple 1.4.1, WAMP: Apache 2.2.8, PHP 5.2.6, MySQL 5.0.51b
it's on a windows XP machine.

I did not do the setup, just took over, and have no previous experience with CMSMS. I don't work that much with cms platforms, so I apologise if I'm missing the obvious.

when anyone tries to create a new news article, once filled in and clicked on save, it displays following error message:
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,'1','t','t','t','published','2008-09-19 16:45:56','2008-09-19 16:45:56',NULL,'2008-09-19 16:46:08','2008-09-19 16:46:08','1','')
Duplicate entry '0' for key 1
I did try modifying the table 'cms_module_news' to auto_increment but it doesn't seem to have helped
successfully ran:
ALTER TABLE cms_module_news AUTO-INCREMENT =1
Would be greatful for any help, as meant to be launching soon  :-\