You have an error in your SQL syntax

WOW!! I don’t see that very often…
I love fellow developers ??

I’ll get it added and let you know…

Thanks much!!

Hi @trpclman59

The developer line is now updated. Please let me know your results..

Thxs

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.

@trpclman59 – That is exactly how I’m using this plugin too! I would be very interested on what you find out ??

@wynot, trpclman59

Checkout this thread it might help:
https://www.ads-software.com/support/topic/wp-config-switch?replies=2

Cheers~

Hey Thanks, lifeinthegrid!

I think that will work for me … will try it out and see how it goes.

Excellent, thxs for the feedback….

Duplicator – Installer

1 Deploy
2 Update
3 Test
version: 0.5.1 [Help]
installer-log.txt
Step 3: Test Site

IMPORTANT FINAL STEPS!
1. Read Install Report Deploy Errors: 0 Update Errors: 2 Warnings: 1
2. Resave Permalinks Updates URL rewrite rules in .htaccess (requires login)
3. Test Entire Site Validate all pages, links images and plugins
4. File Cleanup Removes all installer files (requires login)

To re-install start over at step 1.
The .htaccess file was reset. Resave plugins that write to this file.
Database Results
Tables Rows Cells
Created 41 318411 n/a
Scanned 41 317995 3174487
Updated 4 52013 53671
Errors & Warnings
(click links below to view details)
Deploy Errors (0)
Update Errors (2) General Warnings (1)
STEP2: UPDATE ERRORS (2)
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 ‘key,id FROM wp__plu_captcha_services LIMIT 0, 25001’ at line 1
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 ‘key,id FROM wp_bad_behavior LIMIT 0, 25001’ at line 1

TABLE KEY ERRORS (0)
A primary key is required on a table to efficiently run the update engine. Below is a list of tables and the rows that will need to be manually updated. Use the query below to find the data.
SELECT @row := @row + 1 as row, t.* FROM some_table t, (SELECT @row := 0) r
No missing primary key errors

SERIALIZATION ERRORS (0)
Use the SQL below to display data that may have not been updated correctly during the serialization process.
No serialization errors found
GENERAL WARNINGS
The following is a list of warnings that may need to be fixed in order to finalize your setup. For more details about warnings see the wordpress codex..
MEDIA SETTINGS WARNING: The table ‘wp_options’ has at least one the following values [‘upload_url_path’,’upload_path’] set please validate settings. These settings can be changed in the wp-admin by going to Settings->Media area see ‘Uploading Files’

Know a bit – but not advanced enough….
With changes made in the past couple of days to the plugin, will changes help resolve the above by uninstall on WP site, also check cPanel, wp snapshots and Duplicator plugin properly removed. Then reinstall?
NB: Running WP 3.4.2 trying to get localhost up to upgrade; WP – Theme – Plugins…. Site in desperate need of TLC to get going again!

If you require assistance then, as per the Forum Welcome, please post your own topic.

This topic has been resolved.

Thanks Esmi,

Thought it might have been closed, so have sent a ticket through support system to owner of plugin.

Thanks @esmi