Database errors

Hi… it is multi-site.
Logging in works, but produces three database errors as below. User name is mg30admin, user number 28.

thanks for your interest, Tony

Mar 06, 12:34:00 WordPress database error Table ‘antipole_wp00.wp_12_aiowps_login_activity’ doesn’t exist for query UPDATE wp_12_aiowps_login_activity SET logout_date = ‘2014-03-06 12:34:00’ WHERE user_id = 28 AND login_ip = ‘109.158.111.61’ AND logout_date = ‘0000-00-00 00:00:00’ made by wp_logout, wp_clear_auth_cookie, do_action(‘clear_auth_cookie’), call_user_func_array, AIOWPSecurity_User_Login->wp_logout_action_handler
Mar 06, 12:34:11 WordPress database error Table ‘antipole_wp00.wp_12_aiowps_login_lockdown’ doesn’t exist for query SELECT * FROM wp_12_aiowps_login_lockdown WHERE release_date > now() AND failed_login_ip LIKE ‘109.158.111%’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wpmem, wpmem_login, wp_signon, wp_authenticate, apply_filters(‘authenticate’), call_user_func_array, AIOWPSecurity_User_Login->aiowp_auth_login, AIOWPSecurity_User_Login->check_locked_user
Mar 06, 12:34:11 WordPress database error Table ‘antipole_wp00.wp_12_aiowps_login_activity’ doesn’t exist for query INSERT INTO wp_12_aiowps_login_activity (user_id, user_login, login_date, login_ip) VALUES (’28’, ‘mg30admin’, ‘2014-03-06 12:34:11’, ‘109.158.111.61’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wpmem, wpmem_login, wp_signon, do_action(‘wp_login’), call_user_func_array, AIOWPSecurity_User_Login::wp_login_action_handler

No – I have not changed the DB pre-fix – had not plucked up courage for that!

Have examined DB with PHPMyAdmin and find one set of aiowps tables without the _12 prefix, i.e.:
wp_aiowps_failed_login
wp_aiowps_global_meta
wp_aiowps_login_activity
wp_aiowps_login_lockdown

Methinks these tables have been created at the network level but are being sought for at the site level?
NB I have AIOWPS network activated. Could that be wrong? I might have activated it first at site level – cannot be sure – then decided it would be good to have on all sites so activated at network level.

thanks, Tony

Could not deactivate at sub-site level as AIOWPS does not show in the list of plugins at sub-site level while it is activated at network level.
I did a deactivate at network level, and the plugin reappeared at sub site level and as not active. I left that unchanged.
I then reactivated at network level.
At sub-site level AIOWPS was available again. I note it had remembered my options from before, so it is not a completely fresh start.
Problem remains – only tables in DB are without prefix and login/logout activity makes requests with pre-fix

I await your further advice, Tony

OK – I deactivated at network level and then activated at site level on several sites.

The AIOWPS tables have been created with the correct pre-fix (e.g. wp_12_aiowps_login_activity) and the errors have ceased.

This is a useful work-around. However, as I am sure you will realise, there are some features/settings that are only available at the network level (User Registration for example) and my network level log-in is not protected from a Brute Force attack.

Thank you for your help and support.

regards, Tony