News: dupclicate news-ID after upgrade Topic is solved

[rednose]

Good Morning

I installed a new 2.2.21 CMS version, but copied the old news DB entries ( more as 800 entries, to much to copy them one by one). All was well, display as ususally.
But when I want to make a new entry i get an error "Duplicate entry '21' for key 'cms_module_news.PRIMARY' "

Everytime I try it counts further, so wenn there's no solution, i will make a test entry 800 times.

Is there a possiblity to let the modul start the ID count from 801? In the DB it is called "news_id"

Kind regards
Gabrielle

[Jo Morg]

It looks like you only copied part of the news db tables. You should have copied all six tables used by the module. The auto-incremental auto-generated ids come from the tables sufixed with '_seq'. If you have done that already and still experience the same issue, then it's possible that you have a corrupt '_seq' table.

[rednose]

It was the fact that is was a little corrupt, it had 2 ID's in it instead of only 1. I emptied the content of the table and inserted the value again. And until now it stays that way.

Thank you so much for your feedback.