• Good afternoon,

    I hope you’re doing well today. We’re just reaching out to notify you that we’re observing a very high amount of errors being generated for our site and it is breaking the website from time to time. Currently the log size is over 4gb which doesn’t sound like a lot until you consider how the log is solely made up of text. 
     
    The same error is populating the logs over and over again at a very fast pace (over 1000 per minute) and it’s coming from the User Activity Log Pro plugin. Here is the error that it’s reporting:
     

    [Thu Mar 28 15:22:41.673619 2024] [php:notice] [pid 18249] [client 142.126.202.131:0] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''wp_ualp_user_activity_login' SET login_status = 'logout',time_logout = '2024-03' at line 1 for query UPDATE 'wp_ualp_user_activity_login' SET login_status = 'logout',time_logout = '2024-03-28 11:22:41' WHERE session_token ='bVX2UtsJhJZadLcCGp0NRxuRxCCfyTxNa7AQy9ZtOBK' /* From [citroenvie.com/wp-admin/edit-comments.php?s=&comment_status=spam&pagegen_timestamp=2024-03-28+15%3A22%3A34&_total=402&_per_page=20&_page=1&_ajax_fetch_list_nonce=6e6cdf58ad&_wp_http_referer=%2Fwp-admin%2Fedit-comments.php%3Fcomment_status%3Dspam&_wpnonce=98ffff667f&_wp_http_referer=%2Fwp-admin%2Fedit-comments.php%3Fcomment_status%3Dspam&action=-1&comment_type=&comment_spam_reason=&_destroy_nonce=553f09014e&_wp_http_referer=%2Fwp-admin%2Fedit-comments.php%3Fcomment_status%3Dspam&delete_all=Empty+Spam&paged=1&action2=-1&_destroy_nonce=553f09014e&_wp_http_referer=%2Fwp-admin%2Fedit-comments.php%3Fcomment_status%3Dspam] in [/nas/content/live/citroenvie/wp-content/plugins/user-activity-log-pro/includes/ualp-hooks.php:3556] */ made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, ualp_logged_in_usersupdate, referer: https://citroenvie.com/wp-admin/edit-comments.php?comment_status=spam

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • I am using User Activity Log Pro plugin and have exactly same problem.
    I copied exemplary query UPDATE ‘abc_ualp_user_activity_login’ SET login_status = ‘logout’,time_logout = ‘2024-08-03 10:35:31′ WHERE session_token =’biElZ8vAnipHb2efSIsiZCcrJ4t5r5d0l9lOAwdI1Bw’ to phpmyadmin and it returned error: Something is wrong in your syntax near ”xyyv_ualp_user_activity_login’ SET login_status = ‘logout’,time_logout = ‘2024-‘ w linii 1.

    After some tests it turns out that the problem is the apostrophes. Changing from standard apostrophes (‘abc_ualp_user_activity_login’) to tilted apostrophes (abc_ualp_user_activity_login) solves problem, at least in phpmyadmin.

    I kindly ask for a quick fix in every query.

    Thank you

Viewing 1 replies (of 1 total)

The topic ‘Urgent: Excessive Plugin Errors Generating Breaking Website’ is closed to new replies.