Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-7538

Query exceeds maximum value for user_login_attempts

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: 3.0.8-RC1
    • Component/s: Login
    • Labels:
      None

      Description

      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.

      http://phpbb.fckeditor.net/ucp.php?mode=login
      Demo Account:
      phpbb.com/phpbb3

      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

        Activity

        Hide
        bantu Andreas Fischer added a comment -

        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.

        Show
        bantu Andreas Fischer added a comment - 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.
        Hide
        primehalo primehalo added a comment -

        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.

        Show
        primehalo primehalo added a comment - 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.
        Hide
        bantu Andreas Fischer added a comment -

        Will investiate.

        Show
        bantu Andreas Fischer added a comment - Will investiate.

          People

          • Assignee:
            Unassigned
            Reporter:
            theinfernosin theinfernosin
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development