WordPress database error when cloning

  • Resolved flinty2000

    (@flinty2000)


    2 months, 1 week ago

    Hi,

    We run a wordpress/woocommerce multisite with 3 subsites.

    We tried to clone one of the subsites but when the clone process got to around 5% we get got the following error message:

    WordPress database error: Could not perform query because it contains invalid data.

    Missing row 23558 in wp_2_actionscheduler_actions – could not be preloaded
    Missing row 23559 in wp_2_actionscheduler_actions – could not be preloaded
    Missing row 23560 in wp_2_actionscheduler_actions – could not be preloaded

    It’s strange because our staging site on blogvault cloned the site within 10 minues without issue . The staging site is an exact copy of our live site.

    Can you advise what maybe causing the issue please?

    Thank you

Viewing 1 replies (of 1 total)
  • Plugin Author Never Settle

    (@neversettle)

    Hey @flinty2000

    Sorry for the late response. Action Scheduler tables tend to be large and cloning the data from the tables could lead in the errors. The data is loaded into memory in batches, and from the log size, it can be very large and in most cases with unique constraints. I would advise omitting these tables during the clone process or enabling the “Skip Views” and “Skip Constraints” in the cloner settings

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.