OnPoint Plugins

← Back to support

SQL Error

Resolved

Requested: 7 years and 6 months ago

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

  1. 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

     

  2. Hi Lipe

    Thanks a bunch. With that we can use this tool for other Sites as well.

     

    Best regards,
    Daniel