[SOLVED] ERROR 1062, duplicate DB row in flexicontent_templates DB table

Hello,
today a strange error is appeared suddenly: error 1062.

"1062 Duplicate entry 'blog-category-above-description-line1-nolabel' for key 'PRIMARY' SQL=INSERT INTO xxx_flexicontent_templates (`template`, `layout`, `position`, `fields`) VALUES('blog','category','above-description-line1-nolabel','created,created_by') "

Is there anybody could help me in order to fix it?
Now i cannot use anymore Flexicontent, it's completely blocked.
Thank you in advance for your support.

Salvatore
www.sharinglook.com

Hello

try this:
go to phpmyadmin and check and repair the DB table

Hello,
i tried but without success, see enclosed screen shot.
Any other suggestions?
Can i provide you admin access?
Thank you
Salvatore

Hello


you posted a picture of table listing ?


you need to
1. go to the db table listing (click on db name)
2. select tables and click repair
See instructions here:
www.siteground.com/tutorials/php ... tabase.htm


-- if the above does not work
then you will need to empty the table (empty, not delete it)
www.siteground.com/tutorials/php ... gement.htm

and then READD all fields to template positions again

(you may want to back the table first)

Hello emptying the table all works fine!
Thank you for your usual courtesy.
Regards
Salvatore

Hi,
Just for the record, i have the same error after changing the domain name.
I tried to repair without success. I'm going to erase the data in the table and recreate it.
Anyway, i saw change in the blog page : all the template made by myself are unchanged.

Have a nice day,