• 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

    (@sanjaydabhoya)

    Hi @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.