SQL syntax error
-
When I run the clone it gives me a bad gateway error 502.
I checked the error loggs and they report SQL syntax errors, seen below.WordPress database 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 ‘WHERE
blog_id!= %d /* From [***/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [***/wp-admin/network/plugins.php?activate=true&plugin_status=all&paged=1&s=] in [***/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://***/wp-admin/network/plugin-install.php?s=Multisite+Cloner&tab=search&type=termI’m running version 0.2.2 on WordPress 4.6.1 multisite setup hosted on wpengine
-
Thanks for letting me know. We run few multisites on WPE and haven’t come across this. I’ll take a look today.
@infotexsupport I can’t reproduce the issue you’ve having.
Could you provide a few details?
* It looks like you’ve just installed the plugin. Then clicked its “Settings” link. Correct?
* Do you have any site in your network, other than the main site?Thanks!
Hi Manuel,
I installed the plugin and network activated as per the instructions.
I have about 8 sites in my multisite setup.
In the settings I have selected a site which is not site ID 1 and have Copy users checkedI am also running Avada 5 theme.
Hope this helps.
I have a full error log of when I tried to run the plugin, however its to long to fit in this support ticket.
So the error happens when you try to create a new site via “Sites > Add new”?
You can send me the full error log to {my first name} @ tipit dot net
I click Clone on my selected site which takes me to a page to enter the site URL, title, language and email address.
wp-admin/network/site-new.php?clone_from=3I fill in this data then click Add Site, which then takes a few minutes and then goes to the bad gateway error 502.
/wp-admin/network/site-new.php?action=add-site
If I refresh after the error I get a WordPress message saying “Are you sure you want to do this?” but with no buttons.I have also sent you an email with the error log.
Thanks.
I have the full error log from WPE when I last tested the plugin
Please not I have blocked out the domain and full file directory for security[Fri Nov 18 16:12:24.845996 2016] [:error] [pid 11184] [client 109.238.70.226:39479] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/] in’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-login.php[Fri Nov 18 16:12:24.846397 2016] [:error] [pid 11184] [client 109.238.70.226:39479] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/] in’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-login.php[Fri Nov 18 16:12:30.024004 2016] [:error] [pid 11181] [client 109.238.70.226:39526] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/[Fri Nov 18 16:12:30.024392 2016] [:error] [pid 11181] [client 109.238.70.226:39526] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/[Fri Nov 18 16:12:34.391114 2016] [:error] [pid 11184] [client 109.238.70.226:39566] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/plugins.php] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/[Fri Nov 18 16:12:34.391462 2016] [:error] [pid 11184] [client 109.238.70.226:39566] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/plugins.php] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/[Fri Nov 18 16:13:27.808006 2016] [:error] [pid 11182] [client 109.238.70.226:40220] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/settings.php?page=wp_mu_clone_settings] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/plugins.php[Fri Nov 18 16:13:27.808359 2016] [:error] [pid 11182] [client 109.238.70.226:40220] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/settings.php?page=wp_mu_clone_settings] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/plugins.php[Fri Nov 18 16:16:58.399171 2016] [:error] [pid 29849] [client 109.238.70.226:42883] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/settings.php?page=wp_mu_clone_settings] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/settings.php?page=wp_mu_clone_settings[Fri Nov 18 16:16:58.399541 2016] [:error] [pid 29849] [client 109.238.70.226:42883] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/settings.php?page=wp_mu_clone_settings] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/settings.php?page=wp_mu_clone_settings[Fri Nov 18 16:17:02.240409 2016] [:error] [pid 29573] [client 109.238.70.226:42922] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/sites.php] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/settings.php?page=wp_mu_clone_settings[Fri Nov 18 16:17:02.240945 2016] [:error] [pid 29573] [client 109.238.70.226:42922] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/sites.php] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/settings.php?page=wp_mu_clone_settings[Fri Nov 18 16:17:06.445654 2016] [:error] [pid 6880] [client 109.238.70.226:42967] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/site-new.php?clone_from=3] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/sites.php[Fri Nov 18 16:17:06.446023 2016] [:error] [pid 6880] [client 109.238.70.226:42967] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/site-new.php?clone_from=3] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/sites.php[Fri Nov 18 16:17:15.790163 2016] [:error] [pid 6916] [client 109.238.70.226:43018] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/admi’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/admin-ajax.php?action=autocomplete-user&autocomplete_type=search&autocomplete_field=user_email&term=inf] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/site-new.php?clone_from=3[Fri Nov 18 16:17:15.790511 2016] [:error] [pid 6916] [client 109.238.70.226:43018] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/admi’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/admin-ajax.php?action=autocomplete-user&autocomplete_type=search&autocomplete_field=user_email&term=inf] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/site-new.php?clone_from=3[Fri Nov 18 16:17:18.946086 2016] [:error] [pid 6877] [client 109.238.70.226:43130] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/site-new.php?action=add-site] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/site-new.php?clone_from=3[Fri Nov 18 16:17:18.946481 2016] [:error] [pid 6877] [client 109.238.70.226:43130] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/site-new.php?action=add-site] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id, referer: http://DOMAINNAME/wp-admin/network/site-new.php?clone_from=3[Fri Nov 18 16:19:07.694140 2016] [:error] [pid 16539] [client 109.238.70.226:44668] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/site-new.php?action=add-site] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id[Fri Nov 18 16:19:07.694491 2016] [:error] [pid 16539] [client 109.238.70.226:44668] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/site-new.php?action=add-site] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id[Fri Nov 18 16:19:11.589256 2016] [:error] [pid 16537] [client 109.238.70.226:44692] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/site-new.php?action=add-site] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id[Fri Nov 18 16:19:11.589611 2016] [:error] [pid 16537] [client 109.238.70.226:44692] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/netw’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/network/site-new.php?action=add-site] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id[Fri Nov 18 16:19:59.319770 2016] [:error] [pid 16535] [client 109.238.70.226:45258] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/] in’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_id[Fri Nov 18 16:19:59.320121 2016] [:error] [pid 16535] [client 109.238.70.226:45258] WordPress database 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 ‘WHERE
blog_id!= %d /* From [DOMAINNAME/wp-admin/] in’ at line 1 for query SELECTblog_idFROMwp_blogsORDER BYblog_idASC LIMIT 0,1 WHEREblog_id!= %d /* From [DOMAINNAME/wp-admin/] in [FILEDIR/wp-content/plugins/multisite-cloner/multisite-cloner.php:54] */ made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), call_user_func_array, MultiSiteCloner->init_multisite_cloner, MultiSiteCloner->get_first_blog_idUpdating to version 0.2.2.1 fixed this issue thanks to @manuelrazzari
The topic ‘SQL syntax error’ is closed to new replies.