Romcenter 3.60 Bug

[alexx]

Hallo! When load mame roms appear this

Error: multiple rows in singleton select
At procedure 'P_UPDATEROMID' line: 11, col: 3
At procedure 'P_LOADFILES' line: 82, col: 1
multiple rows in singleton select
GDS Code: 335544652 - SQL Code: -811 - Error Code: 332

and not load nothing!!

[RomCenter]

This is interesting.
Could you tell me which mame version you're using ?
Thank you.

[alexx]

mameui 146 and mamext 146. The error is in both versions and also with dat files! Always the same error.
I have 3 directory with roms. This error appear when load the 77 bios roms that i have. It is indifferent if i load first this directory or not.

[RomCenter]

How much roms are in you rom folder ? One of them is throwing the error and I need your help to identify it.
If they are not to big, you could zip them and post it on a rapidshare site.
If they are too big, could you try to split it and test which part is raising the error ?

[alexx]

i have identify 2 roms!
pr8210.zip
simutrek.zip
Do you want that i send you?

[alexx]

another error
I have closed the directory with bios roms with no errors. After i have reload this directory and

Errore: deadlock
update conflicts with concurrent update
concurrent transaction number is 13288
deadlock
GDS Code: 335544336 - SQL Code: -913 - Error Code: 16

in addition i have see that many bios roms are not recognized!

[RomCenter]

Thank you. I will check that.

[rcantor77]

I now have the same issue after merging in all the updates from 0.142 to 0.146.

Is there a way to determine which ROM(s) is causing the issue...?

[RomCenter]

The 'multiple rows in singleton select' issue is caused by the rom in device pr8210. This rom is also duplicated in device simutrek.
It is fixed in 3.6.1
I'm preparing the new release.
Unfortunatly, current database will not be upgradable. You will have to create a new database and re-add all roms paths.

[rcantor77]

Just to give you an update... tested 3.61 and all now works fine with the 0.146 romset.
Cheers.