You have an error in your SQL syntax

  • Resolved wynot

    (@wynot)


    10 years, 10 months ago

    Hi – I have been using the Duplicator plugin to transfer sites back and forth from dev to prod (and prod to dev) with no problems.
    I have been getting this error when trying to duplicate a copy of a live production site to my localhost dev environment:

    From Duplicator plugin —

    STEP2: UPDATE ERRORS (1)
    Errors that show here are the result of queries that could not be performed.
    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 ‘before,after,rows,id FROM wp_ult25_layout LIMIT 0, 25001’ at line 1

    I really love this plugin and feel its worth the effort to try to figure it out. I’ve also asked the Ultimatum theme developer and he said that since the theme works on many sites/server environments that it must be something in the plugin.

    Environment Info: (wonder if this could be the cause?)
    Localhost:
    WP Version: WP 3.8.1
    Web Server Info: Apache/2.2.22 (Win32) PHP/5.3.13
    PHP Version: 5.3.13
    MySQL Version: 5.5.24-log

    Prod:
    WP Version: WP 3.8.1
    Web Server Info: Apache mod_fcgid/2.3.10-dev
    PHP Version: 5.4.23
    MySQL Version: 5.5.32-cll-lve

    Using latest Duplicator Version 0.5.1 on both prod and dev servers.
    Thanks for any help you can provide!

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

Viewing 15 replies - 1 through 15 (of 26 total)

  • I’m having the same problem

    Thread Starter wynot

    (@wynot)

    Hi trpclman59!
    Are you using the Ultimatum theme framework too?

    No, I’m not. I’m using woocommerce and the room09 theme.

    The error I get is identical to yours except, of course the table name is different

    Thread Starter wynot

    (@wynot)

    hmmm. interesting … I am presently in process of trying the dev version of the plugin v0.5.2 to see if that helps…. will post back with update

    Thread Starter wynot

    (@wynot)

    Yay!! Resolved it — for me the dev version 0.5.2 worked!!

    Thread Starter wynot

    (@wynot)

    oops forgot to mark as resolved…

    I tried dev version 0.5.2 and I had to extract the package manually and delete the wp-config.php file for the installer to work, and I’m still getting the same error:

    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 ‘FROM wp_ccp_woo_compare_cat_fields LIMIT 0, 25001’ at line 1

    Thread Starter wynot

    (@wynot)

    Did you deactivate the the plugin, then delete it before you installed the dev version of it?

    I’m trying to find where the query that causes the error happens. I can complete the SQL with a ‘SELECT * ‘ so now I have ‘SELECT * FROM wp_ccp_woo_compare_cat_fields LIMIT 0, 25001’ and plug this in phpmyadmin, and I’m able to execute it without errors. So the problem must be before or after the ‘FROM’ part of the SQL

    Hey @trpclman59,

    Submit a support ticket and I’ll have a closer look at your setup…

    Cheers~

    Where can the dev 5.2 version be found? I’m encountering a similar error when trying to install. 38 update errors along these lines:

    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 'FROM wp_agm_maps LIMIT 0, 25001' at line 1

    Prod:
    OS Type Linux gmot 2.6.32.45-grsec-2.2.2-r3 #8 SMP Mon Oct 10 13:33:17 PDT 2011 x86_64
    Server Software Apache
    PHP Version 5.3.27
    MySQL Server 5.1.56-log
    Memory Limit 128 MB

    local development on MacBook Pro
    DesktopServer Limited edition version 3.6.1 Build 1103
    MySQL 5.1.44
    Apache/2.4.4 (Unix)
    PHP/5.4.19
    OpenSSL/1.0.1e
    mod_perl/2.0.8-dev Perl/v5.16.3
    Database client version: libmysql – mysqlnd 5.0.10 – 20111026 – $Id: e707c415db32080b3752b232487a435ee0372157 $
    PHP extension: mysql

    Hey richpav,

    Yes 0.5.2 has a fix for reserved mysql words. If your table has a reserved mysql name that is used as a column name then the error will occur. For example column names like ‘key’, ‘before’, ‘describe’ will cause issues.

    The very latest version (0.5.2) can be found by following these instructions:

    -> Browse to https://www.ads-software.com/extend/plugins/duplicator/developers/
    -> Look for the section “Other Versions”
    -> Click on “Development Version” and download the zip plugin file
    -> Uninstall your current version and install this one
    -> Note: This is a development line version so please test in your sandbox first to make sure you have no issues…

    Let me know if this solves your issue…

    Thanks

    lieinthegrid I’m new here. Where do you submit a support ticket?

    Hey trpclman59,

    Goto the Resources Page
    Find LifeInTheGrid Info
    Submit a ticket

    I should be able to look into this pretty quickly…

    Cheers~

    @lifeinthegrid

    I found the problems. The problem extracting had to do with permissions.

    The problem with the SQL was that this particular table only had int. fields, so $colList was empty.

    I modified the load function in the DUPX_Serializer class of the installation.php file so the table is not updated when no columns are found.

    Here is the sample code:

    //Paged Records
    if( $colList != ”)
    {
    for ($page = 0; $page < $pages; $page++) {
    .
    .
    .
    .
    }
    }

    Please let me know when the next version is out.

Viewing 15 replies - 1 through 15 (of 26 total)
  • The topic ‘You have an error in your SQL syntax’ is closed to new replies.