• Resolved zippy1970

    (@zippy1970)


    I’m trying to restore my site from a Duplicator Package. When I reach the Test steps, I notice my site hasn’t changed and there’s a deployment error. Looking at the installer-log.txt, I see the following line:

    ********************************************************************************
    DATABASE-ROUTINES
    ********************************************************************************
    --------------------------------------
    SERVER ENVIROMENT
    --------------------------------------
    MYSQL VERSION:	This Server: 5.0.32 -- Build Server: 5.0.32
    TIMEOUT:	5000
    MAXPACK:	268435456
    --------------------------------------
    DATABASE RESULTS
    --------------------------------------
    **ERROR** database error write 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; 

    How can I solve this?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hey @zippy1970,

    Thanks for the feedback! There are a few items on the FAQ that may provide a solution with this issue, this one may get you going.

        – What is Compatibility mode & ‘Unknown collation’ errors?
        – https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-110-q

    You may also check the permissions of the database user. Are their any other log details besides that entry?

    Let me know if any of them help~

    Thread Starter zippy1970

    (@zippy1970)

    The database user has all right granted to the database. Also, it’s not a collation error. The current version of MySQL is the same version that was used when the package was created.

    But I’m now faced with another problem. When I go to “Duplicator” -> “Packages” in the WordPress Dashboard, it says “No packages Found”. For some reason, all my packages have disappeared. But when I look inside the “wp-snapshots” folder, I can see some packages.

    Thread Starter zippy1970

    (@zippy1970)

    Well, apparently the wp_duplicator_packages table is empty in the database. How did that happen???

    Can I restore from the files themselves? Perhaps by copying some files from the “wp-snapshots” folder to the domain root?

    Hey @zippy1970,

    You can copy/FTP the files themselves. Just grab the associated installer.php and archive.zip files and place them in the new empty directory path. Be sure that the database your connecting to is a new fresh empty DB.

    The only time the duplicator_packages table is emptied is at install time on a new site after your run step 2. The packages from the old site are never copied to the new site. The packages could have been removed from the original site if you used the original databases connection string and not the new database string. But even that being the case the installer will not let you continue to connect with a database that has tables in it, so I’m not sure how the tables would end up empty. I have never really heard of that happening so I’m not really sure why the table would be empty, that is very odd…

    As far as the install script, are there any other errors past the section below?

    **ERROR** database error write ‘You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘;

    Typically the SQL statement being executed will be shown additional information with the error…

    Hope that helps~

    • This reply was modified 7 years, 1 month ago by Cory Lamle.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Deploy Error’ is closed to new replies.