• This bug occurs to Duplicator 0.5.2 with WP 3.9. Using development version 0.5.3 resolves the problems.

    We have found that Duplicator version 0.5.2 is producing blank sql dump rows as follows:

    INSERT INTOwp_comments` VALUES(“”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”);
    INSERT INTO wp_options VALUES(“”, “”, “”, “”);
    INSERT INTO wp_redirection_404 VALUES(“”, “”, “”, “”, NULL, “”);
    INSERT INTO wp_posts VALUES(“”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”);`

    and so on, including tables created by other WP plugin. The package is created successfully without any error, and even successfully deployed on other site without errors within Duplicator page. Only when you view your new site, error establishing database connection found. Then trying to access wp-login or wp-admin shows WP error page saying database needs repairs with the need of adding db-repair to true on wp-config. The repairs complete and you still have the same problem because the database imported have blank entries.

    Our setup is NGINX with PHP5-FPM, connected to remote MySQL. Database dump is powered by PHP, not mysqldump.

    If you have this issues, try the development version 0.5.3

    https://wordpress.org/plugins/duplicator/

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Deploy success, DB needs repairs. Caused by blank SQL dump’ is closed to new replies.