Hi ,
i’ve just buyed you pro version of go live update url’s and tested it out. Somehow it does not work:
: [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://kiesfang.wwaren.ch’, ‘https://www.kiesfang.ch’)’ at line 1]
UPDATE wp_icl_reminders SET show = replace(show, ‘http://kiesfang.wwaren.ch’, ‘https://www.kiesfang.ch’)
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:\\/\\/kiesfang.wwaren.ch’, ‘https:\\/\\/www.kiesfang.’ at line 1]
UPDATE wp_icl_reminders SET show = replace(show, ‘http:\\/\\/kiesfang.wwaren.ch’, ‘https:\\/\\/www.kiesfang.ch’)
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, ‘httpkiesfang.wwaren.ch’, ‘httpswww.kiesf’ at line 1]
UPDATE wp_icl_reminders SET show = replace(show, ‘httpkiesfang.wwaren.ch’, ‘httpswww.kiesfang.ch’)
Could you explain, what went wrong.
Thank you and best regards,
Daniel Gäumann
Hi Daniel,
Thank you for adding the database error to your request. This was very helpful!
I tracked this down to an issue with WPML naming a database column the same as a MySQL command. I have written a patch and released version
5.2.4
of Go Live Update URLS just now.Please updated to this new version and the error will go away.
Have a great day!
Mat Lipe
Hi Lipe
Thanks a bunch. With that we can use this tool for other Sites as well.
Best regards,
Daniel