Unknown items added to the DB get marked as removed #1

New issue

Open

opened 2020-09-12 11:56:13 +00:00 by King_DuckZ · 0 comments

King_DuckZ commented

2020-09-12 11:56:13 +00:00

Owner

When the items table is updated it gets compared to the freshly downloaded item list. Items not in the new list get marked as 'removed'. However the items table may contain null items, which get added by functions that update shop snapshots (they get added in order to satisfy foreign key constraints). These will always get marked as 'removed' on the next items update, because the newly downloaded table doesn't contain them.
The next time a shop tries to sell of on these items they get re-added to the items table.
This should not happen, null items can't become 'removed'.

When the items table is updated it gets compared to the freshly downloaded item list. Items not in the new list get marked as 'removed'. However the items table may contain null items, which get added by functions that update shop snapshots (they get added in order to satisfy foreign key constraints). These will always get marked as 'removed' on the next items update, because the newly downloaded table doesn't contain them. The next time a shop tries to sell of on these items they get re-added to the items table. This should not happen, null items can't become 'removed'.