Import error and database unavailable

  • Hello,
    I downloaded this plugin today and attempted an export from one site for import to another.

    During export, I did not do any find/replace, and I selected to not import spam comments or post revisions.

    The export appeared to work ok, but when importing I got the following error:

    SQLSTATE[23000]:Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constraint fails.

    After then attempting to access All Pages in wp-admin, I am asked to add define(‘WP_DEBUG’, false); to the wp-config.php file, which I did.

    I then clicked Repair, and ended up withe the following results:

    The wp_users table is okay.

The wp_usermeta table is okay.

The wp_posts table is not okay. It is reporting the following error: Table 'wordpress537.wp_posts' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_posts table. Error: Table 'wordpress537.wp_posts' doesn't exist

The wp_comments table is not okay. It is reporting the following error: Table 'wordpress537.wp_comments' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_comments table. Error: Table 'wordpress537.wp_comments' doesn't exist

The wp_links table is not okay. It is reporting the following error: Table 'wordpress537.wp_links' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_links table. Error: Table 'wordpress537.wp_links' doesn't exist

The wp_options table is not okay. It is reporting the following error: Table 'wordpress537.wp_options' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_options table. Error: Table 'wordpress537.wp_options' doesn't exist

The wp_postmeta table is not okay. It is reporting the following error: Table 'wordpress537.wp_postmeta' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_postmeta table. Error: Table 'wordpress537.wp_postmeta' doesn't exist

The wp_terms table is okay.

The wp_term_taxonomy table is okay.

The wp_term_relationships table is okay.

The wp_commentmeta table is not okay. It is reporting the following error: Table 'wordpress537.wp_commentmeta' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_commentmeta table. Error: Table 'wordpress537.wp_commentmeta' doesn't exist

Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

wp_posts: Table 'wordpress537.wp_posts' doesn't exist
wp_comments: Table 'wordpress537.wp_comments' doesn't exist
wp_links: Table 'wordpress537.wp_links' doesn't exist
wp_options: Table 'wordpress537.wp_options' doesn't exist
wp_postmeta: Table 'wordpress537.wp_postmeta' doesn't exist
wp_commentmeta: Table 'wordpress537.wp_commentmeta' doesn't exist

    Assistance with fixing this would be greatly appreciated.

    https://www.ads-software.com/plugins/all-in-one-wp-migration/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Pim J. Iliev

    (@pimjitsawang)

    Hi trixee,

    I am sorry for the inconvenience.
    Please install the latest version of the plugin from https://www.dropbox.com/s/ln71mdycke4e1in/all-in-one-wp-migration.zip?dl=0 and see if your issue is resolved.
    It is not officially released yet as we are testing it out to make sure it is working on as many sites as we can.
    It has reached a stable state and it is ready for production use.

    The new version is not back-compatible with archives made in the previous versions of the plugin.
    That is due to the fact that we have implemented our own open source archiving format that is similar to Tar and is 10 times faster than zip.
    This makes exporting and importing 10 times faster.

    Make sure to clean your cache by doing a hard refresh when you install the plugin.
    Here is how to do it on:
    Windows: ctrl + shift + R
    Mac: command + shift + R
    Linux: ctrl + shift + R

    Let me know if you run into any issues or write to support at servmask.com for better assistance.

    Thread Starter trixee

    (@trixee)

    Thanks, but the problem is that I now can’t access the wp-admin that I was migrating to as the database is broken. I need a way of fixing the database first. Your plugin essentially deleted a bunch of tables, which is not what I expected from a migration. It should have just inserted new stuff into existing tables.

    Plugin Author Pim J. Iliev

    (@pimjitsawang)

    Hi trixee,

    Can you please send us the email to support at servmask.com so that we could get your issue resolved?

    Best,

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Import error and database unavailable’ is closed to new replies.