A Problem of Dates in Giocoso - Fixed

As I discussed in the last post here, Giocoso can be affected by the problem of 'fake, duplicate play completions' being inserted into its PLAYS table one second later than the real completion of a play is recorded.

I promised a fix: today is therefore the release day for Giocoso Version 3.09. The new version adds a trigger to the PLAYS table that prevents such fake duplicate plays being created in the future. The fix does not go back and eliminate any existing fake duplicates, since that would involve automatically deleting data from PLAYS, and that sort of thing is very tricky to get 100% right and thus not endanger good data.

The changelog for this release documents the query you can issue to see if any fake duplicates exist; deleting them if any do is an exercise left for those brave enough to use a tool such as sqlitebrowser to do the deed.

In short, Version 3.09 adds something to prevent future problems but doesn't try to fix past problems that may already have happened (but which should be incredibly rare anyway).

The usual rules apply: to update Giocoso, take the Administration menu, Option 4 ("Check for program updates") and follow the prompts -which essentially means supplying the sudo password when asked. Quit out of Giocoso once the update has been applied and then re-launch it to have the changes applied. Any errors you see on-screen as you quit old Giocoso can be safely ignored.

Leave a Reply

Your email address will not be published. Required fields are marked *