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

IP limit index name too long on Oracle

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.9-RC1
    • Component/s: Installation system
    • Labels:
      None
    • Environment:
      Oracle 10g

      Description

      The new table that was added for IP limitations on login is too long when attempting to install on Oracle. The following error is thrown:

      SQL : CREATE INDEX phpb9_login_attempts_attempt_ip ON phpb9_login_attempts (attempt_ip, attempt_time)
      ORA-00972: identifier is too long

      The limit is 30 characters for Oracle.

        Activity

        Hide
        Noxwizard Patrick Webster added a comment -

        Tested on Oracle and Firebird, the fix allows it to install.

        Show
        Noxwizard Patrick Webster added a comment - Tested on Oracle and Firebird, the fix allows it to install.

          People

          • Assignee:
            naderman Nils Adermann
            Reporter:
            Noxwizard Patrick Webster
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development