OnPoint Plugins

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

SQL Error

Resolved

Requested: 4 years and 1 week 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

Plugin: Go Live Update Urls

  1. OnPoint Plugins

    4 years and 1 week ago

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

    4 years and 1 week ago

    Hi Lipe

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

     

    Best regards,
    Daniel

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