Unable to create reports or groups
-
Every time I try to create (or duplicate) a group or report, I get the same error:
Error: Report has not been created.
Here’s the error recorded in the PHP error log (warning: it’s long).
[22-Jul-2014 21:10:22] WordPress database error Field ‘weight’ doesn’t have a default value for query INSERT INTO wp_32_exportsreports_reports SET
name
=’WAR Posts Report’,group
=’1′,disabled
=0,created
=’2014-07-22 21:10:22′,updated
=’2014-07-22 21:10:22′,disable_export
=0,default_none
=0,role_access
=’administrator’,sql_query
=’SELECT ID,post_title,post_name,post_date,post_content FROM wp_32_posts WHERE post_type=\’post\”,sql_query_count
=”,field_data
='[{\”name\”:\”ID\”,\”real_name\”:\”\”,\”label\”:\”Post ID\”,\”filter_label\”:\”\”,\”hide_report\”:0,\”hide_export\”:0,\”group_related\”:\”0\”,\”custom_display\”:\”\”,\”type\”:\”text\”,\”search\”:0,\”filter\”:0,\”filter_default\”:\”\”,\”filter_ongoing\”:\”\”,\”filter_ongoing_default\”:\”\”,\”total_field\”:0,\”related\”:\”\”,\”related_field\”:\”\”,\”related_sql\”:\”\”},{\”name\”:\”post_title\”,\”real_name\”:\”\”,\”label\”:\”Post Title\”,\”filter_label\”:\”\”,\”hide_report\”:0,\”hide_export\”:0,\”group_related\”:\”0\”,\”custom_display\”:\”\”,\”type\”:\”text\”,\”search\”:0,\”filter\”:0,\”filter_default\”:\”\”,\”filter_ongoing\”:\”\”,\”filter_ongoing_default\”:\”\”,\”total_field\”:0,\”related\”:\”\”,\”related_field\”:\”\”,\”related_sql\”:\”\”},{\”name\”:\”post_name\”,\”real_name\”:\”\”,\”label\”:\”Post\’s Slug\”,\”filter_label\”:\”\”,\”hide_report\”:0,\”hide_export\”:0,\”group_related\”:\”0\”,\”custom_display\”:\”\”,\”type\”:\”text\”,\”search\”:0,\”filter\”:0,\”filter_default\”:\”\”,\”filter_ongoing\”:\”\”,\”filter_ongoing_default\”:\”\”,\”total_field\”:0,\”related\”:\”\”,\”related_field\”:\”\”,\”related_sql\”:\”\”},{\”name\”:\”post_date\”,\”real_name\”:\”\”,\”label\”:\”Post Date\”,\”filter_label\”:\”\”,\”hide_report\”:0,\”hide_export\”:0,\”group_related\”:\”0\”,\”custom_display\”:\”\”,\”type\”:\”date\”,\”search\”:0,\”filter\”:0,\”filter_default\”:\”\”,\”filter_ongoing\”:\”\”,\”filter_ongoing_default\”:\”\”,\”total_field\”:0,\”related\”:\”\”,\”related_field\”:\”\”,\”related_sql\”:\”\”},{\”name\”:\”post_content\”,\”real_name\”:\”\”,\”label\”:\”Post Content\”,\”filter_label\”:\”\”,\”hide_report\”:1,\”hide_export\”:0,\”group_related\”:\”0\”,\”custom_display\”:\”\”,\”type\”:\”text\”,\”search\”:0,\”filter\”:0,\”filter_default\”:\”\”,\”filter_ongoing\”:\”\”,\”filter_ongoing_default\”:\”\”,\”total_field\”:0,\”related\”:\”\”,\”related_field\”:\”\”,\”related_sql\”:\”\”}]’ made by do_action(‘reports-admin_page_exports-reports-admin-reports’), call_user_func_array, exports_reports_reports, WP_Admin_UI->go, WP_Admin_UI->save
- The topic ‘Unable to create reports or groups’ is closed to new replies.