SQL insertion error
-
When running wordpress’s cron script, I’ve been seeing the following errors:
WordPress database error Column ‘ip_address’ cannot be null for query INSERT INTO
wp_cdwr2r_ualp_user_activity
(post_id
,post_title
,user_id
,user_name
,user_role
,user_email
,ip_address
,modified_date
,object_type
,action
) VALUES (97535, ‘image-sitemap-5.xml’, 0, ”, ”, ”, NULL, ‘2020-09-24 06:30:05’, ‘jp_img_sitemap’, ‘jp_img_sitemap updated’) made by do_action_ref_array(‘jp_sitemap_cron_hook’), WP_Hook->do_action, WP_Hook->apply_filters, Jetpack_Sitemap_Manager->callback_sitemap_cron_hook, Jetpack_Sitemap_Builder->update_sitemap, Jetpack_Sitemap_Builder->build_next_sitemap_file, Jetpack_Sitemap_Builder->build_next_sitemap_of_type, Jetpack_Sitemap_Builder->build_one_image_sitemap, Jetpack_Sitemap_Librarian->store_sitemap_data, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, ual_shook_transition_post_status, ual_get_activity_function, ual_user_activity_addWordPress database error Column ‘ip_address’ cannot be null for query INSERT INTO
wp_cdwr2r_ualp_user_activity
(post_id
,post_title
,user_id
,user_name
,user_role
,user_email
,ip_address
,modified_date
,object_type
,action
) VALUES (97495, ‘sitemap.xml’, 0, ”, ”, ”, NULL, ‘2020-09-24 06:30:13’, ‘jp_sitemap_master’, ‘jp_sitemap_master updated’) made by do_action_ref_array(‘jp_sitemap_cron_hook’), WP_Hook->do_action, WP_Hook->apply_filters, Jetpack_Sitemap_Manager->callback_sitemap_cron_hook, Jetpack_Sitemap_Builder->update_sitemap, Jetpack_Sitemap_Builder->build_next_sitemap_file, Jetpack_Sitemap_Builder->build_master_sitemap, Jetpack_Sitemap_Librarian->store_sitemap_data, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, ual_shook_transition_post_status, ual_get_activity_function, ual_user_activity_addThis is running wordpress 5.5.1, with User Activity Log 1.4.4 and Jetpack 8.9.1. We are running cron from crontab with php’s cli (rather than using the website), so that might be the reason why there’s no IP address. In other words, we have the following in cron:
*/10 * * * * www-data cd /path/to/site.org; php /path/to/site.org/wp-cron.php
- The topic ‘SQL insertion error’ is closed to new replies.