• 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.