Error on drop database and table #192

gsustalo · 2020-01-23T10:38:02Z

Which version are you using?
2.3.7

Describe the bug
Dropping tables always return next error:

core.js:9110 ERROR Error: Uncaught (in promise): TypeError: Cannot set property 'count' of undefined

Dropping databases always return next error:

Error: TypeError: Cannot read property 'pkCol' of undefined

Tables are not dropped really in IndexedDB storage. Wherever, when query 'show tables' is submmited, this tables don't are returned

Example
nSQL().dropDatabase("my_db").then(() => { // never }).catch(() => { // ALWAYS!! })

    nSQL('users')
      .query('drop')
      .exec()
      .then(() => {
    // never
}).catch(() => {
    // ALWAYS!! 
})`

m11m · 2020-02-03T22:49:02Z

I've seen something similar.

Which adapter (or value of mode in db config) are you using?

gsustalo · 2020-02-04T07:02:09Z

I'm using 'PERM' mode.
Just like in:
https://nanosql.io/databases.html#creating-a-database

patowazhir · 2020-02-07T21:52:16Z

Hi! Did you get any far with this? I'm using 'TEMP' and seeing it as well.

patowazhir · 2020-02-07T22:29:37Z

To be more specific, seeing it when dropping a table:
await nSQL(this.tableName).query('drop').exec();

nevf · 2020-02-16T08:19:19Z

Update: Ok I've had a closer look at my code and I'm not actually using 'drop' after all because it didn't (possibly still doesn't) delete indexes. I'm using 'delete' instead to delete all rows in the table.
++++
No problems using 'drop' in my application.
result = await nSQL( this.dbTableName )).query( 'drop' ).exec()

You could try rebuilding indexes.
const result = await nSQL( this.dbTableName ).query( 'rebuild indexes' ).exec()

ClickSimply / Nano-SQL

Error on drop database and table #192

Error on drop database and table #192

gsustalo commented Jan 23, 2020

m11m commented Feb 3, 2020

gsustalo commented Feb 4, 2020

patowazhir commented Feb 7, 2020

patowazhir commented Feb 7, 2020

nevf commented Feb 16, 2020 •

edited

ClickSimply / Nano-SQL

Join GitHub today

Error on drop database and table #192

Error on drop database and table #192

Comments

gsustalo commented Jan 23, 2020

m11m commented Feb 3, 2020

gsustalo commented Feb 4, 2020

patowazhir commented Feb 7, 2020

patowazhir commented Feb 7, 2020

nevf commented Feb 16, 2020 • edited

nevf commented Feb 16, 2020 •

edited