Thread: jr_alerts SQL syntax error

[08-Apr-2013 17:36:48 UTC] 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 '->jr_alerts WHERE post_id = 5663' at line 1 for query SELECT count(1) FROM $wpdb->jr_alerts WHERE post_id = 5663 made by do_action('wp_ajax_inline-save'), call_user_func_array, wp_ajax_inline_save, edit_post, wp_update_post, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, jr_manual_job_alerts_set_new

[08-Apr-2013 17:36:48 UTC] WordPress database error Duplicate entry '5663' for key 'post_id' for query INSERT INTO `wp_jr_alerts` (`post_id`,`alert_type`,`last_user_id`,`last_activity`) VALUES (5663,'(location=anywhere.*|location=Budapest.*).*(job_type=all.*|job_type=133).*(job_cat=all.*|job_cat=142)',0,0) made by do_action('wp_ajax_inline-save'), call_user_func_array, wp_ajax_inline_save, edit_post, wp_update_post, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, jr_manual_job_alerts_set_new, jr_job_alerts_set_new

[08-Apr-2013 17:36:48 UTC] 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 '->jr_alerts WHERE post_id = 5663' at line 1 for query SELECT count(1) FROM $wpdb->jr_alerts WHERE post_id = 5663 made by do_action('wp_ajax_inline-save'), call_user_func_array, wp_ajax_inline_save, edit_post, wp_update_post, wp_insert_post, wp_transition_post_status, do_action('pending_to_publish'), call_user_func_array, jr_update_job_start_date, wp_update_post, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, jr_manual_job_alerts_set_new
[08-Apr-2013 17:36:48 UTC] WordPress database error Duplicate entry '5663' for key 'post_id' for query INSERT INTO `wp_jr_alerts` (`post_id`,`alert_type`,`last_user_id`,`last_activity`) VALUES 

(5663,'(location=anywhere.*|location=Budapest.*).*(job_type=all.*|job_type=133).*(job_cat=all.*|job_cat=142)',0,0) made by do_action('wp_ajax_inline-save'), call_user_func_array, wp_ajax_inline_save, edit_post, wp_update_post, wp_insert_post, wp_transition_post_status, do_action('pending_to_publish'), call_user_func_array, jr_update_job_start_date, wp_update_post, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, jr_manual_job_alerts_set_new, jr_job_alerts_set_new