OnPoint Plugins

  • Plugins
    • Advanced Sidebar Menu
    • Go Live Update Urls
  • About
    • Services
    • Showcase
  • Blog
  • Contact
  • Support
  • Log In
← Back to support

MySQL error with WPML plugin

Resolved

Requested: 3 years and 3 months ago

when i update the url,i got these error

 

./wp-cli.phar go-live update http://wp001.advichcloud.com http://aabbccdd.whalecloudexport.com

Updating any http://wp001.advichcloud.com URLs to http://aabbccdd.whalecloudexport.com…

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 ‘show = replace(show, ‘http:\\/\\/wp001.advichcloud.com’, ‘http:\\/\\/aabbccdd.wh’ at line 1 for query DELETE FROM `wp_options` WHERE `option_name` = ‘wpml.WPML_ST_DB_Cache.lock’ made by include(‘phar://wp-cli.phar/php/boot-phar.php’), include(‘phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/wp-cli.php’), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, Go_Live_Update_URLS\Pro\WP_CLI\Go_Live->update, Go_Live_Update_Urls_Database->update_the_database, Go_Live_Update_Urls__Updaters__JSON->update_data, Go_Live_Update_Urls__Updaters__Abstract->update_column

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 ‘show = replace(show, ‘httpwp001.advichcloud.com’, ‘httpaabbccd’ at line 1 for query UPDATE wp_icl_reminders SET show = replace(show, ‘httpwp001.advichcloud.com’, ‘httpaabbccdd.whalecloudexport.com’) made by include(‘phar://wp-cli.phar/php/boot-phar.php’), include(‘phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/wp-cli.php’), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, Go_Live_Update_URLS\Pro\WP_CLI\Go_Live->update, Go_Live_Update_Urls_Database->update_the_database, Go_Live_Update_Urls__Updaters__Url_Encoded->update_data, Go_Live_Update_Urls__Updaters__Abstract->update_column

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 ‘virtual = replace(virtual, ‘http:\\/\\/wp001.advichcloud.com’, ‘http:\\/\\/aabbc’ at line 1 for query UPDATE wp_wc_product_meta_lookup SET virtual = replace(virtual, ‘http:\\/\\/wp001.advichcloud.com’, ‘http:\\/\\/aabbccdd.whalecloudexport.com’) made by include(‘phar://wp-cli.phar/php/boot-phar.php’), include(‘phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/wp-cli.php’), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, Go_Live_Update_URLS\Pro\WP_CLI\Go_Live->update, Go_Live_Update_Urls_Database->update_the_database, Go_Live_Update_Urls__Updaters__JSON->update_data, Go_Live_Update_Urls__Updaters__Abstract->update_column

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 ‘virtual = replace(virtual, ‘httpwp001.advichcloud.com’, ‘httpa’ at line 1 for query UPDATE wp_wc_product_meta_lookup SET virtual = replace(virtual, ‘httpwp001.advichcloud.com’, ‘httpaabbccdd.whalecloudexport.com’) made by include(‘phar://wp-cli.phar/php/boot-phar.php’), include(‘phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/wp-cli.php’), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, Go_Live_Update_URLS\Pro\WP_CLI\Go_Live->update, Go_Live_Update_Urls_Database->update_the_database, Go_Live_Update_Urls__Updaters__Url_Encoded->update_data, Go_Live_Update_Urls__Updaters__Abstract->update_column

 

Plugin: Go Live Update Urls

  1. OnPoint Plugins

    3 years and 3 months ago

    Hi Neo,

    I have tracked down the issue deep within the WPML plugin.

    I am currently working to see if I am able to fix it from this plugin’s side. I will let you know what I figure out.

    Back soon.

    Mat Lipe

  2. OnPoint Plugins

    3 years and 3 months ago

    Hi Neo,

    I was able to locate and patch the issue from our end. We had a release cycle already started for this week so I was able to sneak the fix in before it went out.

    Please update to version 5.3.0 of basic and 2.7.0 of PRO to resolve the issue.

    Have a great day!

    Mat Lipe

New Response Cancel reply

You must be logged in to respond. Only PRO members are allowed to respond to support requests.

© 2023 · WordPress Development · Terms Of Service · Privacy Policy · Cookie Policy · Log in

  • Plugins
  • Blog
  • Contact