Title: WordPress database error: wp_wsal_occurences
Last modified: June 9, 2022

---

# WordPress database error: wp_wsal_occurences

 *  Resolved [qdevsz](https://wordpress.org/support/users/qdevsz/)
 * (@qdevsz)
 * [3 years, 12 months ago](https://wordpress.org/support/topic/wordpress-database-error-wp_wsal_occurences/)
 * 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 INTO`wp_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](https://wordpress.org/support/users/westguard/)
 * (@westguard)
 * [3 years, 12 months ago](https://wordpress.org/support/topic/wordpress-database-error-wp_wsal_occurences/#post-15724991)
 * Hi [@qdevsz](https://wordpress.org/support/users/qdevsz/)
 * This error is unrelated to WS Form. It appears to be caused by this plugin:
 * [https://wordpress.org/plugins/wp-security-audit-log/](https://wordpress.org/plugins/wp-security-audit-log/)
 * I’d recommend reaching out to them for further support.
 * Many thanks!
 * Mark
 *  [ladyjl](https://wordpress.org/support/users/ladyjl/)
 * (@ladyjl)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-wp_wsal_occurences/#post-15738635)
 * [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](https://wordpress.org/support/users/westguard/)
 * (@westguard)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-wp_wsal_occurences/#post-15803285)
 * [@ladyjl](https://wordpress.org/support/users/ladyjl/) I’d recommend posting 
   that error in the forum for:
 * [https://wordpress.org/plugins/wp-security-audit-log/](https://wordpress.org/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.

 * ![](https://ps.w.org/ws-form/assets/icon-256x256.jpg?rev=2834651)
 * [WS Form LITE - Drag & Drop Contact Form Builder](https://wordpress.org/plugins/ws-form/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ws-form/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ws-form/)
 * [Active Topics](https://wordpress.org/support/plugin/ws-form/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ws-form/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ws-form/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [Mark Westguard](https://wordpress.org/support/users/westguard/)
 * Last activity: [3 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-wp_wsal_occurences/#post-15803285)
 * Status: resolved