Romcenter

I have a problem with the merged DAT for c64.
This error comes and goes "multiple rows in singleton select".
The last time I did create a new DB and add the roms step by step and the error did not come again.
No I did update the DB with the new DAT and the error comes back.

Is it possible to debug the update? I have no clue what the reason for this error is.

Loading database J:\DATs\Commodore - 64 (merged 20130101084249).rdt
Commodore - 64 (merged 20130101084249) database version = 3,7002
Rom mode : split
Bios mode : split
Sample mode : merged
Plugin : arcade.dll
Loading gameslist
94331 games loaded.
Updating games status
Status updated for 94331 items.
Green games : 94331, yellow games : 0, red games : 0
Updating fileslist
Query Paths list
Check drives availability
Ready
Database closed
Open new db
Loading database J:\DATs\Commodore - 64 (merged 20130107201325).rdt
Commodore - 64 (merged 20130107201325) database version = 3,7002
Rom mode : split
Bios mode : split
Sample mode : merged
Plugin : arcade.dll
Import datas from [J:\DATs\Commodore - 64 (merged 20130107201325).dat] to [J:\DATs\Commodore - 64 (merged 20130107201325).rdt]
Rom mode : split
Bios mode : split
Sample mode : merged
10000 lines loaded
...
670000 lines loaded
Import datas
10000/390925 lines added
...
390000/390925 lines added
Done. 390925 roms added.
673945 lines loaded
Rom mode : split
Bios mode : split
Sample mode : merged
Reindexing.
pass 1/5
Execution time: 0h 4m 44s
pass 2/5
Execution time: 0h 1m 40s
pass 3/5
Execution time: 0h 1m 10s
pass 4/5
Execution time: 0h 3m 4s
pass 5/5
Execution time: 0h 0m 44s
Rebuilding and reordering database. Please wait...
**Error :multiple rows in singleton select
At procedure 'P_UPDATEROMID' line: 21, col: 3
At procedure 'P_REFRESHSTATUS' line: 9, col: 3
At procedure 'P_CHANGEMODE' line: 22, col: 3
multiple rows in singleton select
GDS Code: 335544652 - SQL Code: -811 - Error Code: 332
Loading database J:\DATs\Commodore - 64 (merged 20130107201325).rdt
Commodore - 64 (merged 20130107201325) database version = 3,7002
Rom mode : split
Bios mode : split
Sample mode : merged
Plugin : arcade.dll
Loading gameslist
94340 games loaded.
Updating games status
Status updated for 94340 items.
Green games : 0, yellow games : 0, red games : 94340

I was able to restore the rdt from a backup.

Here is a link to a archive with the rdt and the dat to update this rdt.

http://www.mediafire.com/download.php?88qgk5fav11frxm

So you can reproduce the error on your computer.

Don't worry about the size of 126 MB.
The rdt is 671 MB and the dat is 68 MB big.

I use Mame 0.37b5 with old pc... I have data file and complete romset, but I must remove neo-geo games to save space... it's possible?