search

Faf4a / aoi.sqlite

SQL implementation for aoi.js
3 stars 0 forks source link

I do nothing and this error happens, bot shutsdown after #1

Open LightslicerGP opened 1 week ago

LightslicerGP commented 1 week ago 
c:\Users\LightslicerGP\node_modules\aoi.sqlite\classes\Database.js:210
      this.client.db.prepare(sql).run(query);
                                  ^

TypeError: SQLite3 can only bind numbers, strings, bigints, buffers, and null
    at c:\Users\LightslicerGP\node_modules\aoi.sqlite\classes\Database.js:210:35
    at sqliteTransaction (c:\Users\LightslicerGP\node_modules\better-sqlite3\lib\methods\transaction.js:65:24)
    at SQLDatabase.deleteMany (c:\Users\LightslicerGP\node_modules\aoi.sqlite\classes\Database.js:214:7)
    at handleResidueData (c:\Users\LightslicerGP\node_modules\aoi.js\src\events\Custom\handleResidueData.js:2:21)
    at Timeout._onTimeout (c:\Users\LightslicerGP\node_modules\aoi.sqlite\classes\Database.js:79:73)
    at listOnTimeout (node:internal/timers:573:17)
    at process.processTimers (node:internal/timers:514:7)

no idea, here and there the bot just gives an error like this and then it breaks. i have no clue

LightslicerGP commented 1 week ago 
c:\Users\LightslicerGP\node_modules\aoi.sqlite\classes\Database.js:210
      this.client.db.prepare(sql).run(query);
                                  ^

TypeError: SQLite3 can only bind numbers, strings, bigints, buffers, and null
    at c:\Users\LightslicerGP\node_modules\aoi.sqlite\classes\Database.js:210:35
    at sqliteTransaction (c:\Users\LightslicerGP\node_modules\better-sqlite3\lib\methods\transaction.js:65:24)
    at SQLDatabase.deleteMany (c:\Users\LightslicerGP\node_modules\aoi.sqlite\classes\Database.js:214:7)
    at handleResidueData (c:\Users\LightslicerGP\node_modules\aoi.js\src\events\Custom\handleResidueData.js:2:21)
    at Timeout._onTimeout (c:\Users\LightslicerGP\node_modules\aoi.sqlite\classes\Database.js:79:73)
    at listOnTimeout (node:internal/timers:573:17)
    at process.processTimers (node:internal/timers:514:7)

once again

LightslicerGP commented 1 week ago 
      let validQuery = typeof query === 'object' ? JSON.stringify(query) : query; // added according to chatgpt 10/10/24
      this.client.db.prepare(sql).run(validQuery);

trying this, possibly fixes it (yes i asked chatgpt but like what am i meant to do i dont know enough js or get what is happening)