Violation of PRIMARY or UNIQUE key constraint "INTEG_66" on table "FILEGAMES"
In RomCenter, when I create a new DataBase from mame 0.245, I have this error message after a moment when it does the scan :
Thanks, T.
Comments (3)
-
-
same issue here… please help us!
-
Same here. On trying to import XML (https://github.com/mamedev/mame/releases/download/mame0258/mame0258lx.zip) from MAME 0.258, I get:
Log saved to C:\ProgramData\romcenter\romcenter_xml.log
Initializing...
Add database 'mame'
Check for a new version...
Ready
Dat in Mame162 format
Loading games from mame0258.xml
Analysing 46065 games
Creating new database mame0258 from datafile mame0258.xml
Copy Database template
46065 games to import
Loading rom for 46065 games.
Reading 864412 rom...
Importing 864412 rom...
Rebuilding and reordering database. Please wait...
Analysing rom...
Error: execute procedure P_LOADDATAFILE(8)
Error: violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES"
Problematic key value is ("GAMEID" = 31097, "GAMEROMID" = 113054)
At procedure 'P_FG_UPDATEFILEGAMES' line: 132, col: 5
At procedure 'P_LOADDATAFILE' line: 178, col: 5
Duration: 03:06:32
Ready
- Log in to comment
Exact same issue. I haven’t been able to create a new database for several MAME versions.