[PHPBB3-9892] Firebird index name length limit is not taken into account

XML

Word

Printable

GitHub Pull Request URL:
https://github.com/vvondra/phpbb3/compare/ticket/9892
Fix URL:
https://github.com/phpbb/phpbb3/pull/226

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.

caused

PHPBB3-11278 Firebird tables are not removed correctly on 3.0.9-rc1 update

PHPBB3-10267 Missing strlen() on $table_prefix in db tools index name length check

is related to

PHPBB3-10482 sql_create_table doesn't check correctly index length