Yea that seemed to allow me to save correctly. I will try and rebuild the workflow again to see if that fixes it.

Thanks,

No I have all my wordpress debug errors and warnings saved in a file, and when I am trying to save the field, there is no errors or warnings.

Hi Kevin,

I have updated to 0.9.9.4, and the field only works as a checkbox. When I save it as a select field and try and change the value, when it saves, it has saved the new record and did not remove the old one.

I looked in the database, and the post I am editing, only keeps one __relate_post meta, but it does not delete the __relate_post of the last related post it was related too.

Here is the field:

piklist('field', array(
		 'type' => 'select'
		 ,'field' => '_' . piklist::$prefix . 'relate_post'
		 ,'label' => __('Mission Trip', 'extreme')
		 ,'choices' => piklist(
		   get_posts(array(
			 'post_type' => 'post_mission_trip'
			 ,'numberposts' => -1
			 ,'orderby' => 'meta_value_num'
			 ,'meta_key' => 'trip_begin'
			 ,'order' => 'DESC'
			 ,'post_status' => 'any'
		   ))
		   ,array('ID', 'post_title')
		 )
		 ,'relate' => array(
		   'scope' => 'post'
		 )
	   ));

I am not using any other relate_post fields with this post type or in the metabox.

Hi guys, I just tried to update my data again after updating to 0.9.9.3, and I received the this error still in my debug logs.

[19-Oct-2015 15:08:04 UTC] WordPress database error Got error 'empty (sub)expression' from regexp for query SELECT DISTINCT SQL_CALC_FOUND_ROWS xs_users.* FROM xs_users INNER JOIN xs_usermeta ON ( xs_users.ID = xs_usermeta.user_id ) WHERE 1=1 AND ( 
  ( xs_usermeta.meta_key = 'user_jobs_group' AND CAST(xs_usermeta.meta_value AS CHAR) RLIKE '' )
) ORDER BY user_login ASC  made by do_action('wp_ajax_piklist_update_0_9_9'), call_user_func_array, Piklist_Update_0_9_9->ajax, include('/plugins/extreme-items/parts/meta-boxes/job-meta-box.php'), WP_User_Query->__construct, WP_User_Query->query
[19-Oct-2015 15:08:05 UTC] WordPress database error Got error 'empty (sub)expression' from regexp for query SELECT DISTINCT SQL_CALC_FOUND_ROWS xs_users.* FROM xs_users INNER JOIN xs_usermeta ON ( xs_users.ID = xs_usermeta.user_id ) WHERE 1=1 AND ( 
  ( xs_usermeta.meta_key = 'user_jobs_group' AND CAST(xs_usermeta.meta_value AS CHAR) RLIKE '' )
) ORDER BY user_login ASC  made by do_action('wp_ajax_piklist_update_0_9_9'), call_user_func_array, Piklist_Update_0_9_9->ajax, include('/plugins/extreme-items/parts/meta-boxes/job-side.php'), WP_User_Query->__construct, WP_User_Query->query

So That was part of the problem. I can see that it did update some of my other fields, but it keeps failing. It just stalls, and this is what is in the debug log. I have tried running it 2 times and it keeps getting stuck here.

[14-Oct-2015 17:26:08 UTC] WordPress database error Got error 'empty (sub)expression' from regexp for query SELECT user_id FROM xs_usermeta WHERE meta_key = 'user_jobs_group' AND CAST(meta_value AS CHAR) RLIKE '' ORDER BY CAST(meta_value AS CHAR)  made by do_action('wp_ajax_piklist_update_0_9_9'), call_user_func_array, Piklist_Update_0_9_9->ajax, include('/plugins/extreme-items/parts/meta-boxes/job-meta-box.php'), WP_User_Query->__construct, WP_User_Query->prepare_query, WP_Meta_Query->get_sql, apply_filters_ref_array, call_user_func_array, Piklist_WordPress::get_meta_sql, Piklist_WordPress::get_sql_for_query
[14-Oct-2015 17:26:09 UTC] WordPress database error Got error 'empty (sub)expression' from regexp for query SELECT user_id FROM xs_usermeta WHERE meta_key = 'user_jobs_group' AND CAST(meta_value AS CHAR) RLIKE '' ORDER BY CAST(meta_value AS CHAR)  made by do_action('wp_ajax_piklist_update_0_9_9'), call_user_func_array, Piklist_Update_0_9_9->ajax, include('/plugins/extreme-items/parts/meta-boxes/job-side.php'), WP_User_Query->__construct, WP_User_Query->prepare_query, WP_Meta_Query->get_sql, apply_filters_ref_array, call_user_func_array, Piklist_WordPress::get_meta_sql, Piklist_WordPress::get_sql_for_query

I uploaded my two files that are listed in the error logs.
https://drive.google.com/folderview?id=0BwbidsNuwyPoVEJodHdzeGZkaFU&usp=sharing

thanks

How would I force the rerun of the script?

Would I delete the “piklist_updates” row from my wp_options table?

I think maybe it just was not run properly, because I think my plugin was not turned on when the last update was run.

Thanks,