cannot post news article [SQL bug: duplicate entry]

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Locked
tombigdaddy

cannot post news article [SQL bug: duplicate entry]

Post 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  :-\
Locked

Return to “CMSMS Core”