[PHPBB3-7538] Query exceeds maximum value for user_login_attempts Created: 15/Jul/08 Updated: 22/Jan/17 Resolved: 15/Oct/10
|phpBB Import Key:||http://www.phpbb.com/bugs/all/ticket.php?ticket_id=30605|
I was trying to login on this website that had used mysqli for the database and it spit out this error:
Out of range value adjusted for column 'user_login_attempts' at row 1 
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Could it be, because the failed login attempts we're higher then the actual login attempts and there wasn't a check correctly making sure if that value was to big?
Just like to help out as I don't know what version of this board it, but I still would like to report it.
It was for a wysiwyg mod on phpbb. (I'm almost not sure what version of phpBB this is, but I know its 3.x.x
|Comment by bantu [ 20/Jul/08 ]|
We cannot tell on which codebase the site is running or if there are any modifications on it, because we do not have access to the site. It sounds like you do neither.
|Comment by primehalo [ 15/Jul/10 ]|
I had this same error happen on my phpbb3.0.7-PL1 installation. In the mysql database, the user_login_attempts field is a tinyint(4) which can only hold a number less than or equal to 127. The error occurred because the value in the database was 127 and code in the auth_db.php was still trying to increment it. I modified the code so that it would check the user_login_attempts value before incrementing, and that seemed to fix the problem.
|Comment by bantu [ 15/Jul/10 ]|