Home » News about this site » Isulong SEOph WordPress Problems

Isulong SEOph WordPress Problems

This 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.

Be Sociable, Share!
Posted in News about this site

8 comments on “Isulong SEOph WordPress Problems

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>