Isulong SEOph Wordpress Problems
By Benj Arriola - Posted on Mon Jul 31, 2006This Wordpress Blog website is going to transfer to a new host, and just to be sure of the transition process, another blog of ours was transfered earlier. Files were simply compied and the MySQL database was backed up as an SQL dump file and imported on the new web host.
Everything seemed to work fine, until we got this error that appears everytime a post is made:
WordPress database error: [Duplicate entry '0' for key 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (’0′,’_pingme’,'1′)WordPress database error: [Duplicate entry '0' for key 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (’0′,’_encloseme’,'1′)Warning: Cannot modify header information - headers already sent by (output started at /XXX/wp-includes/wp-db.php:102) in /XXX/wp-admin/post.php on line 60
And I did a search and ended up at an unresolved thread on Wordpress Support Pages.
Problem is, I moved the site to a hosting company with MySQL 3.23 only. And my blog was originally running on MySQL 4.1.19. My initial problem was importing the data into the new MySQL database, and when I noticed the version differences, I decided to export the data to be MySQL 3.23 compatible. And this is where the problem occured. The Auto-Increment field was disabled in all tables that need it. And that is the cause of the problem.
I had to install phpMyAdmin manually since it was not installed by default of the new host and they do not allow SSH access as well by default and I edited the following tables:
wp_categories: Edited cat_ID to auto_increment
wp_comments: Edited comment_ID to auto_crement
wp_linkcategories: Edited cat_id to auto_crement
wp_links: Edited link_id to auto_crement
wp_options: Edited option_id to auto_crement
wp_post2cat: Edited rel_id to auto_increment
wp_postmeta: Edited meta_id to auto_increment
wp_post: Edited ID to auto_increment
wp_usermeta: Edited umeta_id to auto_increment
wp_users: Edited ID to auto_increment
After doing that, the problem should dissapear.
8 Responses to “Isulong SEOph Wordpress Problems”
Leave a Reply
July 31st, 2006 at 3:55 am
[...] After doing a hosting migration of an Isulong SEOph website, MySQL problems arise but was solved. [...]
September 4th, 2006 at 3:13 am
Man, you just saved my tail. Thanks!
September 4th, 2006 at 11:24 am
Glad to know it helped someone.
October 3rd, 2006 at 7:56 am
hi
i have the same problem. get the same error message. i have notified the host and await their response.unfortunately i can’t log into phpmyadmin on the host server to check and change the auto-increments as you suggest (the pc i am using does not allow logging into secure sites for security reasons) so i will try that this evening when i can use another machine.
thanks for the info.
regards
clive
March 23rd, 2007 at 1:41 am
Hey, thanks for the info, I’ve been looking for this solution for the pass 5 hrs thanks.
March 24th, 2007 at 8:12 pm
I am happy to know you found the solution Garth.
Benj
June 27th, 2007 at 4:19 pm
This helped me out a great deal. I was going from a box with 5.0 installed to a production site with 4.x and had exported with MYSQL40 backwards compatibility checked in phpMyAdmin.
Thanks,
Dan
July 1st, 2007 at 1:18 pm
[...] Basically it looks like my host had moved my database to a server with a previous version of MySQL which effectively removed the auto_increment setting on all my tables - which I discovered and fixed thanks to an article on SEO Religion. [...]