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

Oracle installation fails on Doctrine row casing and inserted language IDs

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Fix
    • Icon: Major Major
    • None
    • 4.0.0-b1
    • Installation system
    • 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)).

            Unassigned Unassigned
            bonelifer bonelifer
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: