trpclman59

I’planning on using this plugin to copy data from dev to stage, and from prod or stage to dev. Because the wp-config.php already has the right values in the site i’m copying to, I want to be able to skip copying/creating a new one and just use the existing file.

I’ll take a look at the code and see if I can figure it out.

@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.

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

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

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

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

I’m having the same problem