DATABASE ERROR: database error write

  • Resolved stuart

    (@lone-walker)


    4 years, 5 months ago

    Been using Duplicator for a few months now and all been working fine, but just tried to use it on a new site (hosted by IONOS aka 1-to-1) and getting pretty fatal error message at Step 3:
    WARNING: DATABASE ERROR: database error write

    followed by:
    WARNING: Database Table row count validation was failed

    The install error file is filled with lines like this:
    **ERROR** database error write ‘Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.

    I suspect it’s due to the fact that the IONOS db is MySQL v5.7 and I’m duplicating from a MariaDB at v10.4.10 – but I have no upgrade options on the IONOS hosting.

    Any ideas how I can fix this?
    Thanks

Viewing 8 replies - 1 through 8 (of 8 total)

  • Hey @lone-walker,

    One step 2 of the installer there are a few options for database mode… more details are here:

    ? ? – What if I get database errors or general warnings on the install report?
    ? ? – https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-260-q

    You might also try building in PHP mode see Settings > Packages…

    If you want to submit a support ticket for this issue we can have a closer look at your setup. Please provide a link to this thread when submitting the ticket.

    Thanks~

    I’m having exactly the same problem duplicating a 1and1.com site. This used to work just fine a couple of months ago. Is there any more info on how to fix this?

    Hey @mikeschumann,

    You might try to switch to building your database in PHP Mode. In the plugin goto Settings > Packages Tab > Choose PHP Code. Then try to reinstall.

    Let me know if that helps~

    PHP Mode was selected when I created the package.

    One additional note: The WordPress site that created the duplicator package uses MySQL 5.5. The database for the new site is MySQL 5.7. Not sure if this has anything to do with my problem.

    I ran a test with an old MySQL 5.5 database that I no longer needed in my hosting account. The website installed correctly. My problem is definitely the result of trying to install a Duplicator package that was created with a MySQL 5.5 database to a new site using MySQL 5.7. Any suggestions on how I can solve this problem?

    I ran another test. I converted my website’s WordPress MySQL 5.5 database to 5.7 using the process outlined in the IONOS help files (Exporting the database using phpMyAdmin, and the Importing the file into a new MySQL 5.7 database). I then updated the WordPress wp-config.php file with the new database info. Once I did this, I tested the website. I then ran duplicator on this website and created a new package for this MySQL 5.7 based website. I then tried to install this package on an IONOS website using a MySQL 5.7 database. I ended up getting the exact same errors as before.

    Bottom line, the problem is not related to a mismatch of MySQL database versions, but rather a result of trying to install a Duplicator package using a MySQL 5.7 database. I’m not sure if this is an IONOS only problem, or if this is more widespread than that.

    Hey @mikeschumann,

    Honestly, I don’t ever really recall seeing anyone commit that exact error, so it does seem more related to an IONOS problem. If none of the options for the mode in step 2 installer work, I’m not quite sure what else to try. Maybe your host can take a look at the SQL script and provide us some feedback.

    Thanks

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘DATABASE ERROR: database error write’ is closed to new replies.