WordPress database error: wp_wsal_occurences

  • Resolved qdevsz

    (@qdevsz)


    3 years, 12 months ago

    I’m experiencing an error which I believe is leading to display issues with mobile views of my form. It has to do with my WP site’s database, I haven’t been able to find any information about the issue elsewhere, here’s the error:

    24.10.184.166:0] WordPress database error Unknown column 'client_ip' in 'field list' for query REPLACE INTOwp_wsal_occurrences(site_id,alert_id,created_on,client_ip,severity,object,event_type,user_agent,user_roles,username,user_id,session_id,post_status,post_type,post_id) VALUES (1, 1000, '1654801134.711125', '', '', '', '', '', '', NULL, NULL, '', '', '', 0) /* From [(redacted).wpengine.com/wp-login.php?wpe-login=true] in [(redacted)/wp-content/plugins/wp-security-audit-log/classes/Adapters/MySQL/ActiveRecordAdapter.php:339

    I checked and the wp_wsal_occurences table is present in the database, I’m not sure how to approach resolving the issue. Any help is appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Mark Westguard

    (@westguard)

    3 years, 12 months ago

    Hi @qdevsz

    This error is unrelated to WS Form. It appears to be caused by this plugin:

    https://ww.wp.xz.cn/plugins/wp-security-audit-log/

    I’d recommend reaching out to them for further support.

    Many thanks!

    Mark

    ladyjl

    (@ladyjl)

    3 years, 11 months ago

    [Wed Jun 15 00:17:11.281978 2022] [fcgid:warn] [pid 3175:tid 112025463166720] [client ] mod_fcgid: stderr: WordPress database error Unknown column ‘client_ip’ in ‘where clause’ for query SELECT * FROM wp_wsal_occurrences WHERE client_ip = AND alert_id = 1003 AND site_id = 1 AND ( created_on BETWEEN 1655251200 AND 1655337599 ); made by wp_signon, wp_authenticate, do_action(‘wp_login_failed’), WP_Hook->do_action, WP_Hook->apply_filters, WSAL_Sensors_LogInOut->event_login_failure, WSAL_Models_Occurrence->check_unknown_users, WSAL_Adapters_MySQL_Occurrence->check_unknown_users, WSAL_Adapters_MySQL_ActiveRecord->load_multi_query

    having the same issue any idea on this

    Plugin Author Mark Westguard

    (@westguard)

    3 years, 11 months ago

    @ladyjl I’d recommend posting that error in the forum for:

    https://ww.wp.xz.cn/plugins/wp-security-audit-log/

    This error is unrelated to WS Form LITE.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WordPress database error: wp_wsal_occurences’ is closed to new replies.