mysqldump: Couldn’t execute ‘SELECT

  • Resolved mattiasf

    (@mattiasf)


    5 years, 1 month ago

    I started getting e-mails about my cron jobs, and on a daily basis I get this error message, seems to be coming from updraft:

    mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */option_id,option_name,option_value,autoloadFROMwpf9_optionsWHERE WHERE option_name NOT LIKE "updraft_jobdata_%" AND option_name NOT LIKE "_site_transient_update_%"': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE option_name NOT LIKE "updraft_jobdata_%" AND option_name NOT LIKE "_sit...' at line 1 (1064)

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor DNutbourne

    (@dnutbourne)

    5 years, 1 month ago

    Hi,

    Apologies for the inconvenience.

    Do the backups on the site appear to be completing successfully?
    Please could you send us a copy of the latest log?
    (The contents will be too long to post here, but you can use an online service such as Pastebin and post the link here).

    Please could you also send us the MySQL version for the site? This can be found in the Site Information under the UpdraftPlus Advanced Tools tab.

    Thread Starter mattiasf

    (@mattiasf)

    5 years, 1 month ago

    No worries. here you go: https://pastebin.com/mD33Z114

    Database backups seems to work fine.

    Except I have some encoding issue, so I sometimes manually have to save the .sql dump file as utf-8 or similar before I can import it into database using, e.g. Sequel Ace / Sequel Pro MySQL MacOS Client.

    Plugin Author David Anderson / Team Updraft

    (@davidanderson)

    5 years, 1 month ago

    Hi,

    The log indicates you’re running an old version of UpdraftPlus; please update it and all should be well (the changelog item beginning “Strip the redundant WHERE” in the changelog entry 15th October 2020 is relevant).

    David

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘mysqldump: Couldn’t execute ‘SELECT’ is closed to new replies.