Title: SQL insertion error
Last modified: September 24, 2020

---

# SQL insertion error

 *  [dilinger](https://wordpress.org/support/users/dilinger/)
 * (@dilinger)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/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_add
 * 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 (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_add
 * This 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

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Sanjay Dabhoya](https://wordpress.org/support/users/sanjaydabhoya/)
 * (@sanjaydabhoya)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/sql-insertion-error/#post-13477238)
 * Hi [@dilinger](https://wordpress.org/support/users/dilinger/)
 * Thank you for using User Activity log plugin.
 * Sorry for the inconvenience caused to you.
 * I have checked for your issue in the local environment and it’s working well.
   We need to check this in detail on your website. Can you please contact us via
   WordPress slack channel so we can communicate with you and help you to fix your
   issue.
 * Thank you

Viewing 1 replies (of 1 total)

The topic ‘SQL insertion error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/user-activity-log_2b5346.svg)
 * [User Activity Log](https://wordpress.org/plugins/user-activity-log/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/user-activity-log/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/user-activity-log/)
 * [Active Topics](https://wordpress.org/support/plugin/user-activity-log/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/user-activity-log/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/user-activity-log/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Sanjay Dabhoya](https://wordpress.org/support/users/sanjaydabhoya/)
 * Last activity: [5 years, 7 months ago](https://wordpress.org/support/topic/sql-insertion-error/#post-13477238)
 * Status: not resolved