Duplicator Giving me Same error time and time again

  • Resolved johnf1982

    (@johnf1982)


    5 years, 9 months ago

    Why has this tool suddenly stopped working correctly? I’ve used this tool to duplicate nearly 200 websites and now all of a sudden I am getting the same errors and I can no longer deploy websites properly.

    Same exact results on deployment, no matter which websites I am duplicating.

    8 Database errors, shown below:

    SERIALIZATION ERRORS (8)
    Use the SQL below to display data that may have not been updated correctly during the serialization process.
    SELECT option_value, autoload FROM wp_options WHERE option_id = “78”;
    SELECT option_value, autoload FROM wp_options WHERE option_id = “196”;
    SELECT option_value, autoload FROM wp_options WHERE option_id = “401”;
    SELECT option_value, autoload FROM wp_options WHERE option_id = “772”;
    SELECT option_value, autoload FROM wp_options WHERE option_id = “774”;
    SELECT option_value, autoload FROM wp_options WHERE option_id = “1106”;
    SELECT option_value, autoload FROM wp_options WHERE option_id = “1904”;
    SELECT option_value, autoload FROM wp_options WHERE option_id = “2963”;

    9 deploy errors from the log file, shown below:

    **ERROR** database error write ‘Duplicate entry ‘{77364e709e689a4’ for key ‘PRIMARY” – [sql=INSERT INTO wp_wfFileMods VALUES(“{77364e709e689a4782f38e184dd30091647cc8…]
    **ERROR** database error write ‘Duplicate entry ‘{77364e709e689a4’ for key ‘PRIMARY” – [sql=INSERT INTO wp_wfFileMods VALUES(“{77364e709e689a4782f38e184dd30091647cc8…]
    **ERROR** database error write ‘Duplicate entry ‘{77364e709e689a4’ for key ‘PRIMARY” – [sql=INSERT INTO wp_wfFileMods VALUES(“{77364e709e689a4782f38e184dd30091647cc8…]
    **ERROR** database error write ‘Duplicate entry ‘{77364e709e689a4’ for key ‘PRIMARY” – [sql=INSERT INTO wp_wfFileMods VALUES(“{77364e709e689a4782f38e184dd30091647cc8…]
    **ERROR** database error write ‘Duplicate entry ‘{77364e709e689a4’ for key ‘PRIMARY” – [sql=INSERT INTO wp_wfFileMods VALUES(“{77364e709e689a4782f38e184dd30091647cc8…]
    **ERROR** database error write ‘Duplicate entry ‘{77364e709e689a4’ for key ‘PRIMARY” – [sql=INSERT INTO wp_wfFileMods VALUES(“{77364e709e689a4782f38e184dd30091647cc8…]
    **ERROR** database error write ‘Duplicate entry ‘{77364e709e689a4’ for key ‘PRIMARY” – [sql=INSERT INTO wp_wfFileMods VALUES(“{77364e709e689a4782f38e184dd30091647cc8…]
    **ERROR** database error write ‘Duplicate entry ‘{77364e709e689a4’ for key ‘PRIMARY” – [sql=INSERT INTO wp_wfFileMods VALUES(“{77364e709e689a4782f38e184dd30091647cc8…]
    **ERROR** database error write ‘Duplicate entry ‘{77364e709e689a4’ for key ‘PRIMARY” – [sql=INSERT INTO wp_wfFileMods VALUES(“{77364e709e689a4782f38e184dd30091647cc8…]
    ERRORS FOUND: 9

    What is the problem here? Why is this all of a sudden happening? Nothing has changed. I am using the same exact server I have been using. I am using the same exact step by step process I’ve used to create the other 200 websites. There is no reason for this to be happening.

Viewing 1 replies (of 1 total)
  • Cory Lamle

    (@corylamleorg)

    5 years, 9 months ago

    Hey @johnf1982,

    The reason for this is that data is added to your database from plugins/themes and even the WordPress core on an on-going base. When your using plugins like WordFence they can be added every minute. When you previously create a package the data above wasn’t in the database creation script. Now there is new data which is showing the notices…

    Just by looking at your info above you should be good.

    1. The serialization errors are no longer labeled “errors” in the newer versions of the plugin. They are simply notices. If you’re not running into an issue with the newly created site then you can simply ignore them. They are placed there to give a notice should the install find any issues with serialized data. Since some plugins simply store the data and never flush it then there are cases were legacy data is left behind (kind of like how data builds up in the windows registry).

    2. The deploy errors are from WordFence. In most cases, if you just clear out the WordFence logs and those should go away or when you build the package you can just exclude that table. If you want to know the exact cause you might send the errors over to the WordFence team.

    Hope that helps~

Viewing 1 replies (of 1 total)
  • The topic ‘Duplicator Giving me Same error time and time again’ is closed to new replies.