`no such table`: error in production since v3.11.0 (works in dev)

[maximepvrt]

Environment

│ Operating system macOS 25.2.0 │
│ │ CPU Apple M3 Pro (11 cores) │
│ │ Node.js version v22.22.0 │
│ │ nuxt/cli version 3.32.0 │
│ │ Package manager pnpm 10.28.1 │
│ │ Nuxt version 4.2.2 │
│ │ Nitro version 2.13.1 │
│ │ Builder vite 7.3.1 │
│ │ Config $development, compatibilityDate, content, extends, hooks, nitro, routeRules, runtimeConfig, site │
│ │ Modules -

Version

v3.11.0

Reproduction

https://github.com/benevolt/ligilab-front/tree/bug-content-3.11/benevolt (branch bug-content-3.11)

Description

Since upgrading to Nuxt Content v3.11.0, we are experiencing an error only in production, while:

• everything works correctly in development
• it was working perfectly in production with the previous version

The error occurs when calling Nuxt Content’s internal query endpoint.

[request error] [unhandled] [POST] http://localhost:3000/__nuxt_content/blogEngagement/query?v=v3.5.0--u00c6T4vV1FHY8bnnmoo5FSsOD4G-c8yUAI68N9RwAE
 H3Error: no such table: _content_blogEngagement
    at StatementWrapper._statement (file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:18399:56)
    ... 8 lines matching cause stack trace ...
    at async C$1 (file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:915:7329) {
  cause: Error: no such table: _content_blogEngagement
      at StatementWrapper._statement (file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:18399:56)
      at StatementWrapper.all (file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:18408:21)
      at Object.all (file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:18446:30)
      at Object.handler (file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:18685:36)
      at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
      at async Object.<anonymous> (file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:2039:19)
      at async file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:5815:18
      at async toNodeHandle (file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:2310:7)
      at async b$1 (file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:915:7042)
      at async C$1 (file:///Users/maxime/Repos/ligilab-front/benevolt/.output/server/chunks/nitro/nitro.mjs:915:7329) {
    code: 'ERR_SQLITE_ERROR',
    errcode: 1,
    errstr: 'SQL logic error'
  },
  statusCode: 500,
  fatal: false,
  unhandled: true,
  statusMessage: undefined,
  data: undefined
}

Additional context

No response

Logs

[dargmuesli]

Sometimes the contents.sqlite seems to be empty 🤔 but not in all cases, my ci check didn't catch the issue but I found it too at times when I build myself. Frontend navigation works though, just SSR-loading a page directly shows the issue for me.

[dargmuesli]

See #3701 for a fix :)