[PHPBB3-7538] Query exceeds maximum value for user_login_attempts Created: 15/Jul/08  Updated: 22/Jan/17  Resolved: 15/Oct/10

Status: Closed
Project: phpBB3
Component/s: Login
Affects Version/s: 3.0.0
Fix Version/s: 3.0.8-RC1

Type: Bug Priority: Major
Reporter: theinfernosin Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None

Fix URL: http://github.com/bantu/phpbb3/compare/ticket%2F7538
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:

General Error
SQL ERROR [ mysqli ]

Out of range value adjusted for column 'user_login_attempts' at row 1 [1264]

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.

Demo Account:

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 Andreas Fischer [ 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 Andreas Fischer [ 15/Jul/10 ]

Will investiate.

Generated at Sat Feb 16 06:58:07 UTC 2019 using Jira 7.12.3#712004-sha1:5ef91d760d7124da5ebec5c16a948a4a807698df.