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
              Permalink
              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