Hello,
there is an SQL error in the function lockout() in secure.php when BWPS tries to ban an host:
$wpdb->insert(
$wpdb->base_prefix . 'bwps_lockouts',
array(
'type' => $type,
'active' => 1,
'starttime' => $currtime,
'exptime' => $exptime,
'host' => $wpdb->escape( $_SERVER['REMOTE_ADDR'] ),
'user' => ''
)
);
the column user is defined as bigint(20) and an empty string is sent in the query.
The correct query should be :
$wpdb->insert(
$wpdb->base_prefix . 'bwps_lockouts',
array(
'type' => $type,
'active' => 1,
'starttime' => $currtime,
'exptime' => $exptime,
'host' => $wpdb->escape( $_SERVER['REMOTE_ADDR'] ),
'user' => 0
)
);
or maybe you can try to send NULL ?
Could you confirm this is an error and fix it in the next release ?
Thank you for your answer