-
Bug
-
Resolution: Won't Fix
-
Major
-
None
-
4.0.0-b1
-
None
-
PHP 8.4.26; phpBB 4.0.0-a3-dev; Oracle AI Database 26ai Free release 23.26.3.0.0; Linux disposable containers.
Codex reproduced failures during a clean phpBB 4.0 development installation on
Oracle. Doctrine returns uppercase column keys, but the search-index and
profile-language installation tasks access lowercase keys. Language installation
also calls `lastInsertId()` on a connection that cannot supply the expected
Oracle sequence-backed ID through that API.
Reproduction:
1. Prepare an empty Oracle schema and install the phpBB 4.0 development branch
using the CLI installer.
2. Let installation create the default content, languages, profile-language
data, and search index.
3. Observe missing-key failures in the search/profile-language tasks and the
inserted-language ID retrieval failure. Correcting only the first task does
not resolve the remaining installation failures.
Expected: a clean Oracle installation completes, indexes the default content,
and associates profile-language data with the actual installed language IDs.
Proposed correction: normalize the fetched rows to lowercase in the affected
tasks and retrieve the inserted language ID with a parameterized lookup of the
language's unique ISO code.
Codex ran the installer test directory: 23 tests and 31 assertions passed,
including lowercase/uppercase rows and language ID lookup. A clean installation
on PHP 8.4.26, phpBB 4.0.0-a3-dev, and Oracle AI Database 26ai Free release
23.26.3 completed without the previous warnings/errors and passed 33 extension
integration assertions.
Patch and regression tests: https://github.com/bonelifer/phpbb/pull/2
—
Investigated and written by [Codex](https://openai.com/codex/) on behalf of William Jacoby ([bonelifer](https://github.com/bonelifer)).

