WordPress.org

Support

Support » Plugins and Hacks » Relevanssi - A Better Search » [Resolved] WordPress database error You have an error in your SQL syntax

[Resolved] WordPress database error You have an error in your SQL syntax

  • 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 ‘[Resolved] WordPress database error You have an error in your SQL syntax’ is closed to new replies.
Skip to toolbar