WordPress database error You have an error in your SQL syntax

  • Resolved 12sp

    (@sp12)


    11 years, 2 months ago

    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)

    11 years, 2 months ago

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

    Thread Starter 12sp

    (@sp12)

    11 years, 2 months ago

    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)

    11 years, 2 months ago

    That is always possible.

    Thread Starter 12sp

    (@sp12)

    11 years, 2 months ago

    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.