Error Message: couldn’t execute ‘SELECT /*!40001 SQL_NO_CACHE */…

  • Resolved 2yudith

    (@2yudith)


    1 year, 8 months ago

    Hi,

    We recently started using a cron job on our server to trigger the wp-cron script. When our backup is running we get the following feedback:


    mysqldump: Couldn’t execute ‘SELECT /*!40001 SQL_NO_CACHE */ option_id, option_name, option_value, autoload FROM mf_options WHERE 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)

    I have no idea in which direction this message points. Do you think we need to change anything? Have we set it up wrong?

    We would be grateful for your feedback.
    Thank you and best regards

    Judith

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Support nrobertsudp

    (@nrobertsudp)

    1 year, 8 months ago

    Hi there,

    As this problem relates directly to your MariaDB server you should ask your hosting provider for assistance. They will be familiar with the MariaDB server version and can help set up the cron-job.

    Best regards,

    Nick

Viewing 1 replies (of 1 total)

The topic ‘Error Message: couldn’t execute ‘SELECT /*!40001 SQL_NO_CACHE */…’ is closed to new replies.

Tags