Schema definition for user_items_stats was not using a composite primary key. This resulted in the inability to insert more than a single row per user, as userID was the lone primary key. Added itemID to primary key.
To patch an existing database, use mig-bug-18.sql (e.g. sqlite3 matomat.db < mig-bug-18.sql)
Schema definition for user_items_stats was not using a composite primary key. This resulted in the inability to insert more than a single row per user, as userID was the lone primary key. Added itemID to primary key.
To patch an existing database, use mig-bug-18.sql (e.g. sqlite3 matomat.db < mig-bug-18.sql)