cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

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

HPSeitz
Active Participant
0 Kudos
2,207

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

HPSeitz
Active Participant
0 Kudos

I guess the following will do the trick

"db": {
    "kind": "sqlite",
    "schema_evolution": "auto"
}
jlong
Product and Topic Expert
Product and Topic Expert
0 Kudos
You might need to run `cds deploy` as well.
Ask a Question