Fix that worked for me I found on
https://www.gog.com/forum/general_beta_gog_galaxy_2.0/the_failed_to_load_game_database_error/page6 See Skolia's post about the SQL lite query
Post minor edited:
I've found a way to fix the issue but it may be too technical for some
You will need a SQLite editor, found on [url]
https://sqlitebrowser.org/dl/[/url]
OR
https://sqlitebrowser.org 1. First, make sure GoG Galaxy is completely shut down. It should not show up in Task Manager.
2. Next, backup galaxy-2.0.db (it should be in %ProgramData%\GOG.com\Galaxy\storage ) (if you see a db-shm and a db-wal file Galaxy is still running.)
3. Open a copy of the galaxy-2.0.db in the SQLite editor. Click on the "Execute SQL" tab (or locate a similar function if it's not the same editor).
Paste this in the execute SQL window and run it. This will set the install dates for today instead of what they actually are. (Paste this entire block in at once):
INSERT INTO ProductConfiguration(ProductID,createdAt)
SELECT productID, CURRENT_TIMESTAMP
FROM InstalledBaseProducts
WHERE NOT EXISTS (SELECT 1 FROM ProductConfiguration WHERE InstalledBaseProducts.productID = ProductConfiguration.productID);
4. If it completes without any errors you should write changes and exit the editor. (If you see a db-shm and a db-wal file your SQLite editor is still running.)
5. You can now copy the updated .db back into the "%ProgramData%\GOG.com\Galaxy\storage"
6. GoG Galaxy should start ok now.
This SQL query will show you any missing information from the ProductConfiguration table for installed games (if it doesn't return any rows, this table is fine):
SELECT productID
FROM InstalledBaseProducts
WHERE productID NOT IN
(SELECT productID
FROM ProductConfiguration);
