When transferring the site to Wordpress to a local server, to replace the url, I used the below query via phpmyadmin. And before problems never arose:

UPDATE wp_options SET option_value = REPLACE( option_value, 'http://example.com', 'http://localhost/example.com' ) WHERE option_name = 'home' OR option_name = 'siteurl'

And now in the query window, REPLACE , is underlined with the following error:

The statement was found, but there was no delimiter between it and the previous one. (about REPLACE)

And at the request itself, the following error occurs:

# 1064 - You have an error in your SQL syntax; check it out.

I tried different ways that I found, but nothing helped. On LAN, I use xampp 5.6.14-3.

  • When transferring wp, you can use wp-cli , if there are problems - you can post a bug, let them think)) - BOPOH
  • and you are trying to fulfill this request directly? Maybe you were sealed in the original request (for example, they put an extra quote in the address), but here in the example there is no such error. If the request is one-to-one, try to execute the request in the console (not via pma), can pma itself do something wrong? - BOPOH
  • @BOPOH yes, request one to one. Through the console, the query worked fine. Probably the problem is still in PM. Thanks for the help) - Alexey
  • The same error is something related to the version of phpmyadmin, and the solution was also not found. - megahanga

0