WordPress.org

Ready to get started?Download WordPress

Forums

Relevanssi - A Better Search
Relevanssi SQL Error (6 posts)

  1. Perryb2006
    Member
    Posted 3 years ago #

    Hi,
    Following error was registered in error log file:

    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 'AND link = 0' at line 1 for query DELETE FROM wp_relevanssi WHERE doc = AND link = 0 made by do_action_ref_array, call_user_func_array, check_and_publish_future_post, wp_publish_post, wp_transition_post_status, do_action, call_user_func_array, relevanssi_update_child_posts, relevanssi_publish, relevanssi_add, relevanssi_index_doc, relevanssi_remove_doc
    [05-Jul-2011 00:01:25] 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 'AND type = 'post'' at line 1 for query DELETE FROM wp_relevanssi WHERE item = AND type = 'post' made by do_action_ref_array, call_user_func_array, check_and_publish_future_post, wp_publish_post, wp_transition_post_status, do_action, call_user_func_array, relevanssi_update_child_posts, relevanssi_publish, relevanssi_add, relevanssi_index_doc, relevanssi_remove_item
    [05-Jul-2011 00:01:25] 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 '' at line 1 for query DELETE FROM wp_relevanssi_excerpt_cache WHERE post = made by do_action_ref_array, call_user_func_array, check_and_publish_future_post, wp_publish_post, wp_transition_post_status, do_action, call_user_func_array, relevanssi_update_child_posts, relevanssi_publish, relevanssi_add, relevanssi_index_doc, relevanssi_purge_excerpt_cache

    I have no idea what this means but it cropped up after updating to wordpress 3.1.4.

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

  2. Mikko Saari
    Member
    Plugin Author

    Posted 3 years ago #

    Thanks, I'll have to see if I can hunt down what's causing this. Might be tricky, but I'll see what I can do.

  3. Perryb2006
    Member
    Posted 3 years ago #

    Also, I emailed you about 3 empty tables created by Relevanssi. Is it safe to drop them?

  4. Perryb2006
    Member
    Posted 3 years ago #

    And I have updated to wordpress 3.2 (yay!), just wanted to confirm if Relevanssi works with it.

    P.S: The front end seems to be working just fine :)

  5. Mikko Saari
    Member
    Plugin Author

    Posted 3 years ago #

    Sorry, I forgot to answer your email. Yes, if you don't plan to use logs, feel free to drop the tables. It's just easiest to create them just in case, as couple of empty tables doesn't really strain the database.

    Yeah, it seems to me as well that Relevanssi (both free and Premium) works with 3.2.

  6. Perryb2006
    Member
    Posted 3 years ago #

    Not a problem :)

    It's just that the db looks neat :) Nothing more, nothing less.

    And a similar error was registered by upPrev Notification plugin: http://wordpress.org/support/topic/error-in-sql-syntax-1?replies=1

    Created a ticket there too!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags