Support » Fixing WordPress » New Records Get ID = 0 After MySQL InnoDB Restore

  • Resolved joeloew

    (@joeloew)


    Stack: WP v2.0.3/IIS6/MySQL 5.0/PHP5
    DB type is InnoDB.

    I recently restored a mysql backup from one machine to another via sql script.

    There were no restore errors, but new Users, Pages and Posts do not complete correctly. There are no errors when creating items via dashboard.

    Using wp-register.php says: “ERROR: Couldn’t register you… please contact the webmaster !”

    Pages and Posts just dissappear; the new user has only the wp_user data (no meta).

    Upon closer inspection, I see that the new record has an ID of 0 and child updates are missing (which explains why the meta lookups fail).

    I can manually change the ID and create the meta, but the next attempt still tries a record with ID 0.

    If I leave the 0 record, subsequent records still do not go to the correct next ID.

    I assume this is a db setup problem, but not sure how to fix it.

    Help!!!

    -joe

Viewing 5 replies - 1 through 5 (of 5 total)
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘New Records Get ID = 0 After MySQL InnoDB Restore’ is closed to new replies.