Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-9892

Firebird index name length limit is not taken into account

XMLWordPrintable

      Firebird 2.1 has a maximum length of an index name equal to 31 characters.

      For example when creating the index for the QaA CAPTCHA plug-in this error occurs:

      General Error
      SQL ERROR [ firebird ]
       
      unsuccessful metadata update Name longer than database column size [-607]
       
      SQL
       
      CREATE INDEX phpbb_captcha_questions_lang_iso ON phpbb_captcha_questions(lang_iso)
       
      BACKTRACE
      

      The reason is that phpbb_captcha_questions_lang_iso is 32 characters long.

            naderman Nils Adermann
            ameeck ameeck
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: