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

Logging in with Mobile Device triggers SQL error on *_login_attempts.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 3.0.9-RC1
    • 3.0.9-RC2
    • Login
    • None
    • PHP 5.3.4, MySQL(i) 5.1.53, LG Optimus 2X Default Browser.

    Description

      When logging in with a mobile device I receive an SQL error on the new table *_login_attempts. Data too long for column 'attempt_browser'.

      Default value is too small at 150 or value needs to be trimmed as in session.php for session_browser.

      The browser string is 164 chars,

      Mozilla/5.0 (Linux; U; Android 2.2.2; en-gb; LG-P990 Build/FRG83G) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1 MMS/LG-Android-MMS-V1.0/1.2

      Attachments

        Activity

          People

            naderman Nils Adermann
            CoC CoC [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: