Problem - Error/Warning: SQL Statement

[Tam]

Warning shows up during looting:

INSERT OR REPLACE INTO Normal_Rules (item_name, item_rul) VALUES (?,?)

 

[Algar]

@grimmier
I have absolutely zero clue and don't touch anything loot related.

 

[Tam]

It looks like part of the loot_lib.Lua, referenced on line 171 - where the SQLite db is defined (created on 378). And is failing on line 302.

You can see the same error trying to add (and then remove) from the Global/Normal items table.

 

[grimmier]

@grimmier
I have absolutely zero clue and don't touch anything loot related.

It looks like part of the loot_lib.lua, referenced on line 171 - where the SQLite db is defined (created on 378). And is failing on line 302.

You can see the same error trying to add (and then remove) from the Global/Normal items table.

PR submitted.

 

[Tam]

Grimmier, sorry, I'm still seeing this error. Looting "works," but that warning shows up each time. I do have multiple bots, and they are all pointed to the common database (I assume intended).

INSERT OR REPLACE INTO Normal_Rules (item_name, item_rule) VALUES (?,?)

Added info;

Loot.ini and LootNScoot_x_x.ini seem to update.

The issue seems that LootRules_<server name>.db is not being created fully. A zero-byte file is created, but the schema is not.

EDIT #2

I think I have it working now.
- I tried to /lootutils reload - this (with a zero size db) noted was not v3, seemed to do an update, and then failed.
- What seemed to work is downloading your lootnscoot script by itself, running it outside of RGMercs, having it created the DB (which it did on load, and then I am not getting errors.

Will continue to watch