Database Error on latest update

  • markemark

    (@markemark)


    8 years, 7 months ago

    ON all admin pages now get error:

    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 ‘meta_key=’_sked’ ORDER BY post_title LIMIT 0, 50′ at line 1]
    SELECT SQL_CALC_FOUND_ROWS fk6o_posts.*, meta_value as sked FROM fk6o_posts JOIN fk6o_postmeta ON fk6o_postmeta.post_id = fk6o_posts.ID WHERE 1=1 meta_key=’_sked’ ORDER BY post_title LIMIT 0, 50

    If I deactivate RSPVmaker it goes away, so I can see this is the cause:

    If I turn of debug it doesn’t give me much more information

    [01-Nov-2017 09:54:41 UTC] 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 ‘meta_key=’_sked’ ORDER BY post_title LIMIT 0, 50′ at line 1 for query SELECT SQL_CALC_FOUND_ROWS fk6o_posts.*, meta_value as sked FROM fk6o_posts JOIN fk6o_postmeta ON fk6o_postmeta.post_id = fk6o_posts.ID WHERE 1=1 meta_key=’_sked’ ORDER BY post_title LIMIT 0, 50 made by include(‘wp-admin/admin-header.php’), do_action(‘admin_notices’), WP_Hook->do_action, WP_Hook->apply_filters, rsvptoast_admin_notice, get_toast_templates, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

    Can you please help me fix this.

    Many thanks

    Mark

    • This topic was modified 8 years, 7 months ago by markemark.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter markemark

    (@markemark)

    8 years, 6 months ago

    Just updated to Version 4.9.6 – and still get same error ????

    Plugin Author davidfcarr

    (@davidfcarr)

    8 years, 6 months ago

    Sorry I didn’t respond sooner. Have you done any customizations on top of RSVPMaker? I’m puzzled because there are only a couple of places where the plugin sets up a query like that (to look up event templates) and neither one should have an effect on all admin pages.

    Plugin Author davidfcarr

    (@davidfcarr)

    8 years, 6 months ago

    Are you running the Toastmasters extension by any chance?

    Plugin Author davidfcarr

    (@davidfcarr)

    8 years, 6 months ago

    I found a scenario where this occurs with the RSVPMaker for Toastmasters extension, with no future meetings published. Fixed in release 4.9.9.

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

The topic ‘Database Error on latest update’ is closed to new replies.