[Plugin: Relevanssi – A Better Search] Relevanssi SQL Error

  • 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.

    https://www.ads-software.com/extend/plugins/relevanssi/

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

    (@msaari)

    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.

    Thread Starter Perryb2006

    (@perryb2006)

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

    Thread Starter Perryb2006

    (@perryb2006)

    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 ??

    Plugin Author Mikko Saari

    (@msaari)

    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.

    Thread Starter Perryb2006

    (@perryb2006)

    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: https://www.ads-software.com/support/topic/error-in-sql-syntax-1?replies=1

    Created a ticket there too!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: Relevanssi – A Better Search] Relevanssi SQL Error’ is closed to new replies.