Dadabase error

[diwascha]

Description

Add some description...

Steps to Reproduce

Add steps to reproduce the error...

Info

Error: DatabaseError: SqliteError
update SingleValue set value = 21, modifiedBy = 'SYSTEM', modified = '2026-07-02T04:33:57.882Z' where parent = 'Misc' and fieldname = 'openCount' - unable to open database file

Stack:

SqliteError: update `SingleValue` set `value` = 21, `modifiedBy` = '__SYSTEM__', `modified` = '2026-07-02T04:33:57.882Z' where `parent` = 'Misc' and `fieldname` = 'openCount' - unable to open database file
    at Client_BetterSQLite3._query (C:\Users\User\AppData\Local\Temp\355Z5Y4bNUbWcQQ985xJZfG1JxY\resources\app.asar\node_modules\knex\lib\dialects\better-sqlite3\index.js:39:38)
    at executeQuery (C:\Users\User\AppData\Local\Temp\355Z5Y4bNUbWcQQ985xJZfG1JxY\resources\app.asar\node_modules\knex\lib\execution\internal\query-executioner.js:37:17)
    at Client_BetterSQLite3.query (C:\Users\User\AppData\Local\Temp\355Z5Y4bNUbWcQQ985xJZfG1JxY\resources\app.asar\node_modules\knex\lib\client.js:146:12)
    at Runner.query (C:\Users\User\AppData\Local\Temp\355Z5Y4bNUbWcQQ985xJZfG1JxY\resources\app.asar\node_modules\knex\lib\execution\runner.js:123:36)
    at ensureConnectionCallback (C:\Users\User\AppData\Local\Temp\355Z5Y4bNUbWcQQ985xJZfG1JxY\resources\app.asar\node_modules\knex\lib\execution\internal\ensure-connection-callback.js:13:17)
    at Runner.ensureConnection (C:\Users\User\AppData\Local\Temp\355Z5Y4bNUbWcQQ985xJZfG1JxY\resources\app.asar\node_modules\knex\lib\execution\runner.js:300:20)
    at Runner.run (C:\Users\User\AppData\Local\Temp\355Z5Y4bNUbWcQQ985xJZfG1JxY\resources\app.asar\node_modules\knex\lib\execution\runner.js:30:19)
    at _DatabaseCore.#updateSingleValue (C:\Users\User\AppData\Local\Temp\355Z5Y4bNUbWcQQ985xJZfG1JxY\backend\database\core.ts:842:14)
    at _DatabaseCore.#updateSingleValues (C:\Users\User\AppData\Local\Temp\355Z5Y4bNUbWcQQ985xJZfG1JxY\backend\database\core.ts:821:7)
    at _DatabaseCore.update (C:\Users\User\AppData\Local\Temp\355Z5Y4bNUbWcQQ985xJZfG1JxY\backend\database\core.ts:356:7)

Version: 0.36.0
Platform: win32
Path: /index.html
Language: English
Country: np

Feature Flags

Accounting Settings:

{
  "enableDiscounting": false,
  "enableInventory": false,
  "enablePriceList": true,
  "enableInvoiceReturns": true,
  "enableFormCustomization": false,
  "enableERPNextSync": false,
  "enableLead": false,
  "enablePricingRule": false,
  "enableItemEnquiry": false,
  "enableLoyaltyProgram": false,
  "enableCouponCode": false,
  "enableitemGroup": true,
  "enablePointOfSaleWithOutInventory": false,
  "enablePartialPayment": true
}

POS Settings:

{
  "weightEnabledBarcode": false,
  "canChangeRate": false,
  "hideUnavailableItems": false,
  "canEditDiscount": false,
  "ignorePricingRule": false
}

Inventory Settings:

{
  "enablePointOfSale": false
}

[mihir-kandoi]

The failure occurs while writing Misc.openCount. The database directory must also be writable for SQLite journal files. Please provide:

• The Books version and whether the database is on a local disk, network drive, removable drive, or sync service.
• Whether both the file and its containing directory are writable.
• Whether a backup copy in a writable local folder opens successfully.

The Temp path in the stack identifies the application runtime, not necessarily the database location. Keeping this open pending that distinction.