Database error message appearing

  • Resolved hoardinghopes

    (@hoardinghopes)


    3 years, 1 month ago

    WordPress database error: [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 'AND author_id = 0' at line 1]
SELECT * FROM wp_ayssurvey_surveys WHERE status != 'trashed' ORDER BY id DESC AND author_id = 0

    I’m seeing the above error message with Survey Maker 3.4.5. It looks as if the query has been constructed in the wrong order?

    I’ve run it manually against the database and hit the same message, but it works if I rearrange the query to:

    SELECT * FROM wp_ayssurvey_surveys WHERE status != 'trashed' AND author_id=0 ORDER BY id DESC;

    This is not breaking the survey or the site as far as I can tell, but it’s clearly not doing something it wants to.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Jasmine

    (@hyenokian)

    3 years, 1 month ago

    Dear @hoardinghopes,

    Thank you for the topic.

    I am sorry for the problem you are experiencing.
    We have checked and found the problem you are mentioning.

    We will surely fix the issue in the upcoming update of the plugin.
    For now, please contact us via this form so that we can provide you with the fixed zip file as soon as possible.

    Thank you.

    Thread Starter hoardinghopes

    (@hoardinghopes)

    3 years, 1 month ago

    Thanks Jasmine

    Plugin Support Jasmine

    (@hyenokian)

    3 years, 1 month ago

    Dear @hoardinghopes,

    Thank you for your reply and patience.

    I am glad to inform you that we have already fixed the issue in the latest version of the plugin and updated it accordingly.
    So, you can update the plugin to the latest version and check the case again.

    Thank you.

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

The topic ‘Database error message appearing’ is closed to new replies.