Re: 1062 Duplicate entry '0' for key 1
would be cool if someone posted an SQL patch to fix alll auto_increment collumns that are not auto_increment now...
Originally Posted by adanker
or is there a better way to do it, without screwing up your migrated data?
I fixed the one in the admin activity log, but i have to fix it in the other tables too... the banner history log i guess... (when the error shows up on the bottom of the page on the main site)
probably need to edit other tables with history in it...
ALTER TABLE admin_activity_log CHANGE COLUMN log_id log_id int(15) NOT NULL auto_increment;
ALTER TABLE banners_history CHANGE COLUMN banners_history_id banners_history_id int(11) NOT NULL auto_increment;
e.g. orders_status_history, paypal_payment_status_history, project_version_history
Last edited by Vixay; 3 Jun 2006 at 05:50 AM.
"Drunk on the Nectar of Life" - me