Thread

MySQL ERROR:

Error Number: 1062

Description: Duplicate entry ‘0’ for key 1

Query: INSERT INTO `exp_revision_tracker` (`tracker_id`, `item_id`, `item_table`, `item_field`, `item_data`, `item_date`) VALUES (’‘, ‘18’, ‘exp_templates’, ‘template_data’, ‘{assign_variable:my_weblog=\"default_site\"}\n{assign_variable:my_template_group=\"sitename\"}\n\n\n\n\n\n\n\n\n\n\n\n\n \n\n\n\n\n\n\n\n\n\n\n\n{exp:weblog:entries weblog=\"default_site\" limit=\"1\" dynamic=\"off\" url_title=\"welcome1\" disable=\"categories|member_data|pagination|trackbacks\" }\n\n
\n \n
\n

Any idea what is causing this and how to resolve it?

you may have set any unique key constraint for your “exp_revision_tracker” table, please check that

Sorry, I’m not a DB expert - can you possibly explain that in a less technical way?

check this url

http://blogs.vinuthomas.com/2008/06/18/mysql-error-1062-duplicate-entry-0-for-key-1/

check data type size of field “tracker_id” of table “exp_revision_tracker”

Sorry, can you point me towards where/how to do this within phpmyAdmin?

So I’ve changed the type to BIGINT and attributes to UNSIGNED in the table where EE is throwing an error - I’ve attached a screenshot to show this.

But it still throws the same error unfortunately.

Can EE staff possibly shed some light on this?

Thanks,
Andrew