v7 migration fails at install, due to knex new release

[fugudesign]

Hi there,

I just tried to create my first Adonis app by following the "Getting Started" install guide (https://docs.adonisjs.com/installation).
But for me the installation fail, at every try…
My Mac is under Tahoe, with latest Node 24/NPM 11 (with NVM), Sqlite 3.51…
As there is no log i don't understand what's happening. After some googling, i'm not able to find anyone with the same issue…

Has someone any idea about this please?
Thanks in advance.

Here my terminal trace :

❯ npm init adonisjs@latest

> npx
> "create-adonisjs"


     _       _             _         _ ____  
    / \   __| | ___  _ __ (_)___    | / ___| 
   / _ \ / _` |/ _ \| '_ \| / __|_  | \___ \ 
  / ___ \ (_| | (_) | | | | \__ \ |_| |___) |
 /_/   \_\__,_|\___/|_| |_|_|___/\___/|____/ 
                                             

❯ Where should we create your new project? · ./adonisjs-test
❯ Select the kind of app you want to create? · Hypermedia app
❯ Download starter kit (1.09 s)
  Downloaded "github:adonisjs/starter-kits/hypermedia"
❯ Install packages (58 s)
  Packages installed using "npm"
❯ Prepare application (902 ms)
  Application ready
❯ Migrate database (1.45 s)
  Command failed with exit code 1: node ace 'migration:run'

[fugudesign]

After some code researches, i realized knex released the 3.2.0 yesterday, when i did my first install tries (last release before: december 2023). I asked to Claude analyzing the issue to report it:

---                                                                                                                             
  Bug report: knex 3.2.0 breaks @adonisjs/lucid 22 (ESM + SQLite)                                                                 
                                                                                                                                  
  Context: @adonisjs/lucid 22 + knex 3.2.0 (released after ~3 years without release since 3.1.0)                                  
                                                                                                                                  
  Two issues introduced in knex 3.x:                                                                                              
                                                                                                                                  
  ---                                                                                                                             
  Issue 1 — knex.knex is not a function
                                       
  knex/knex.mjs (the ESM entrypoint) does not re-export knex as knex.knex, unlike knex.js (CJS). When Lucid imports knex via ESM,
  it calls knex.knex(config) which is undefined.                                                                                  
   
  Workaround: Patch knex.mjs to add:                                                                                              
  knex.knex = knex;
  knex.default = knex;                                                                                                            
                  
  ---
  Issue 2 — Cannot find module 'knex/lib/dialects/sqlite3'
                                                                                                                                  
  In knex 3.x, lib/dialects/sqlite3 is a directory (with an index.js), but knex/package.json exports map only exposes ./lib/* as a
   wildcard resolving to files. There is no explicit export for ./lib/dialects/sqlite3 → ./lib/dialects/sqlite3/index.js.         
                  
  Lucid statically imports libsql.cjs which references knex/lib/dialects/sqlite3, causing a resolution failure even when SQLite is
   not used.      
                                                                                                                                  
  Workaround: Add explicit entries to knex/package.json#exports:                                                                  
  "./lib/dialects/sqlite3": "./lib/dialects/sqlite3/index.js",
  "./lib/dialects/better-sqlite3": "./lib/dialects/better-sqlite3/index.js"                                                       
                                                                           
  ---
  Both issues are currently worked around via a postinstall script that patches the knex files directly. The fix needs to live    
  either in knex (fix exports + ESM self-reference) or in Lucid (avoid relying on knex.knex and use explicit subpath imports).    
                                                                                                                                  
  ---

[fugudesign]

Finally reported in Lucid repo: adonisjs/lucid#1163

[thetutlage]

Fixed for now by pinning knex version.