Database errors during writing

  • Resolved alex.mqt

    (@alexmqt)


    9 years, 10 months ago

    Hi,

    I’ve installed Duplicator on my local website to copy it to my server.
    After, when I want to install it on the server, there are hundreds of errors of writing in the database. And when I want to access to the website, it needs a WordPress installation again (impossible to do because of database errors at the end of it). However, WordPress seems to be copied to the server as there are the folders of wp in it.

    I’ve tried with Duplicator version 0.5.18 and 0.5.19 (development), with WordPress (4.2.2) installed on the server and without. Always the same errors.

    Thanks in advance for your help!

    https://www.ads-software.com/plugins/duplicator/

Viewing 8 replies - 31 through 38 (of 38 total)

  • ok , I’ll open a ticket on the plug-in

    Hey willbe,

    Thanks for the feedback! If you can give the developer version a try it may have the fixes for your issue. The very latest version (1.1.0) can be found by following these instructions:

    -> Browse to https://www.ads-software.com/extend/plugins/duplicator/developers/
    -> Click on “Development Version” link and download the zip plugin file
    -> Uninstall your current version and install this one

    Look for the compatibility mode options on the database tab. Let me know if this solves your issue…

    Thanks

    Hi Cory! I’m chiming in on this thread because I think I’m having the same problem as the people above. But it looks like you’re really close to a fix!! I’m hoping I can piggyback on to things. Forgive me, I’m a relative novice when it comes to databases, but I’m picking it up as I go. Here’s what’s happening with me:

    When WP 4.2 changed the tables from utf8 to utf8mb4, it screwed a bunch of us over who have hosts with older mysql versions. Any mysql that is 5.5.3 or higher can deal with this just fine. Unfortunately, my host’s is 5.1.7. Unless I start completely from scratch (which isn’t really an option) I’m left looking for a workaround.

    I downloaded the developer’s version from above and tried to enable compatibility mode in when building a package. It said “this option is only available with mysqldump mode.”

    So I went to settings and under database build clicked “use mysqldump.” It couldn’t find it at its default location, so I went and downloaded MySQL Workbench (https://dev.mysql.com/downloads/workbench/) and installed it. I entered /Applications/MySQLWorkbench.app/Contents/MacOS (I also tried /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump) into the custom path and clicked save.

    I went back to build the package, compatibility mode options were now available. I checked them all and built the package.

    As it starts to build, I get the following error:
    ———-
    Details
    Server Status: 200 -OK
    Error Message:
    DUPLICATOR ERROR: Please see the ‘Package Log’ file link below.
    ———-

    Any ideas where I’m going wrong? Am I even heading down the right path?

    If you want to submit a ticket I can look at your log.

    Thxs

    Thanks Cory. Submitted.

    Sounds good! Thxs

    i’m getting desperate i tried everything,

    this is my error code

    server code: 200
    status: OK
    response:
    INSTALL ERROR!
    No tables where created during step 1 of the install. Please review the installer-log.txt file for sql error messages. You may have to manually run the installer-data.sql with a tool like phpmyadmin to validate the data input. If you have enabled compatibility mode during the package creation process then the database server version your using may not be compatible with this script.

    Hey DopaminSX,

    Checkout this question on the FAQs page I believe it may help or provide some clues about this issue:
    -> Browse to: https://lifeinthegrid.com/duplicator-faq
    -> Find section: “Database”

    There is a chance that this could be related to your DB user permissions.

    Hope that helps!

Viewing 8 replies - 31 through 38 (of 38 total)
  • The topic ‘Database errors during writing’ is closed to new replies.