cancel
Showing results for 
Search instead for 
Did you mean: 

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

HPSeitz
Active Participant
0 Kudos

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?

HPSeitz
Active Participant
0 Kudos

I guess the following will do the trick

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

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"
}