Question Re: Error: SQLITE_ERROR: no such table: sqlite_schema after upgrade to cds v6.7.0 in Technology Q&A

Error: SQLITE_ERROR: no such table: sqlite_schema after upgrade to cds v6.7.0

HPSeitz — Fri, 14 Apr 2023 10:15:33 GMT

After upgrade to the lastest version of cds v6.7.0 the command cds deploy --to sqlite:mysqlite.db fails with the following error:

[Error: SQLITE_ERROR: no such table: sqlite_schema in: 
SELECT 1 FROM sqlite_schema ALIAS_1 WHERE name = ? LIMIT 1] {
  errno: 1,
  code: 'SQLITE_ERROR',
  query: 'SELECT 1 FROM sqlite_schema ALIAS_1 WHERE name = ? LIMIT 1',
  values: [ 'cds_xt_Extensions' ]<br>

With the previous version cds v6.6.1 it works fine and the deployment to sqlite work as expected. The cap project is a "normal" one, no extension stuff.

Is there any setting necessary to mark the project with the v6.7.0 version to prevent the failing SELECT statement?

Re: Error: SQLITE_ERROR: no such table: sqlite_schema after upgrade to cds v6.7.0

HPSeitz — Sat, 15 Apr 2023 15:16:59 GMT

I guess the following will do the trick

"db": {
    "kind": "sqlite",
    "schema_evolution": "auto"

Re: Error: SQLITE_ERROR: no such table: sqlite_schema after upgrade to cds v6.7.0

HPSeitz — Sat, 15 Apr 2023 15:18:30 GMT

I guess the following will do the trick

"db": {
    "kind": "sqlite",
    "schema_evolution": "auto"
}

Re: Error: SQLITE_ERROR: no such table: sqlite_schema after upgrade to cds v6.7.0

jlong — Fri, 03 Oct 2025 10:57:47 GMT

You might need to run `cds deploy` as well.