Support » Plugin: Relevanssi - A Better Search » WordPress database error You have an error in your SQL syntax

  • Resolved 12sp

    (@sp12)


    I started getting this 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 ''typeitem' ('type', 'item')' at line 1 for query ALTER TABLE wp_relevanssi ADD INDEX 'typeitem' ('type', 'item') made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, relevanssi_check_old_data

    and similar errors.

    http://wordpress.org/extend/plugins/relevanssi/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Mikko Saari

    (@msaari)

    Looks like your MySQL server version might be incompatible with Relevanssi.

    The odd thing is that I have two separate sites (different accounts, e tc.) The sites are set up basically the same way, but only one site is getting this error. AND only one blog on that site.

    Do you think the plugin was corrupted somehow during the installation?
    I’ll uninstall and reinstall and see what happens. I’ll let you know what happens.

    Plugin Author Mikko Saari

    (@msaari)

    That is always possible.

    There have been no more errors since reinstalling.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress database error You have an error in your SQL syntax’ is closed to new replies.