DATABASE ERROR: Cannot add or update a child row

  • Resolved mappel

    (@mappel)


    2 years, 5 months ago

    Hello ??
    I used duplicator in the past and it always worked like a charm!
    Haven’t used it for a year or so now…

    Can you point me in the right direction of what I did wrong?
    I backed up my wordpress installation with duplicator and installed it locally… I’m using xampp… after I ran the installer.php file and the database connection was valid I got a lot of errors:

    DATABASE ERROR: ‘Cannot add or update a child row: a foreign key constraint fails (xampp_folder.wp_wc_download_log, CONSTRAINT fk_wp_wc_download_log_permission_id FOREIGN KEY (permission_id) REFERENCES wp_woocommerce_downloadable_product_permissions (`pe)’
    [SQL=/* INSERT TABLE DATA: wp_wc_download_log */
    INSERT INTO wp_wc_download_log VALUES(“47”, “2019-09-06 02:33:38”, “81”, “28”, “xx.xxx.xx.xx”);…]

    I did get this error multiple times…

    another one:
    E_DEPRECATED Return type of Requests_Cookie_Jar::offsetExists($key) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
    FILE: C:\xampp\htdocs\xampp_folder\wp-includes\Requests\Cookie\Jar.php[63]

    Can you point me in the right direction of what went wrong?

    Help is very much appreciated, thanks!
    Warm regards,
    Markus

Viewing 1 replies (of 1 total)

  • Hey @mappel

    Thanks for the feedback! For a quick fix you could try to exclude the wp_wc_download_log table from the package build, it looks like a log table so it’s possible it may not be needed. You can also try to change the SQL Script build mode from what it currently is, which can be found in the Settings > Packages Tab.

    Otherwise, if you would like to submit a support ticket for this issue we can have a closer look at your setup. Please provide a link to this forum thread when submitting the ticket.

    Thanks~

Viewing 1 replies (of 1 total)
  • The topic ‘DATABASE ERROR: Cannot add or update a child row’ is closed to new replies.