Update to V0.18 then got this error on demo company

[ahbeeahkao]

Description

Add some description...

Steps to Reproduce

Add steps to reproduce the error...

Info

Error: DatabaseError: SqliteError create table CustomForm (name text not null, createdBy text not null, modifiedBy text not null, created datetime not null, modified datetime not null, primary key (name)) - table CustomForm already exists

Stack:

SqliteError: create table `CustomForm` (`name` text not null, `createdBy` text not null, `modifiedBy` text not null, `created` datetime not null, `modified` datetime not null, primary key (`name`)) - table `CustomForm` already exists
    at Client_BetterSQLite3._query (C:\Users\user\AppData\Local\Programs\Frappe Books\resources\app.asar\node_modules\knex\lib\dialects\better-sqlite3\index.js:39:38)
    at executeQuery (C:\Users\user\AppData\Local\Programs\Frappe Books\resources\app.asar\node_modules\knex\lib\execution\internal\query-executioner.js:37:17)
    at Client_BetterSQLite3.query (C:\Users\user\AppData\Local\Programs\Frappe Books\resources\app.asar\node_modules\knex\lib\client.js:146:12)
    at Runner.query (C:\Users\user\AppData\Local\Programs\Frappe Books\resources\app.asar\node_modules\knex\lib\execution\runner.js:123:36)
    at Runner.queryArray (C:\Users\user\AppData\Local\Programs\Frappe Books\resources\app.asar\node_modules\knex\lib\execution\runner.js:217:21)
    at ensureConnectionCallback (C:\Users\user\AppData\Local\Programs\Frappe Books\resources\app.asar\node_modules\knex\lib\execution\internal\ensure-connection-callback.js:11:19)
    at Runner.ensureConnection (C:\Users\user\AppData\Local\Programs\Frappe Books\resources\app.asar\node_modules\knex\lib\execution\runner.js:300:20)
    at Runner.run (C:\Users\user\AppData\Local\Programs\Frappe Books\resources\app.asar\node_modules\knex\lib\execution\runner.js:30:19)
    at DatabaseCore.

[18alantom]

@ahbeeahkao demo usage and creation seems to work for me, do you have any steps I can use to reproduce the issue so I can replicate and fix it?

[mildred]

This was probably a demo database created from an older version which did not have these columns in the schema. Similar to #777

[akshayitzme]

closing due to inactivity