Page 1 of 1

Romcenter 3.60 Bug

Posted: Sun Jun 03, 2012 5:13 pm
by 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!!

Re: Romcenter 3.60 Bug

Posted: Sun Jun 03, 2012 5:59 pm
by RomCenter
This is interesting.
Could you tell me which mame version you're using ?
Thank you.

Re: Romcenter 3.60 Bug

Posted: Sun Jun 03, 2012 6:52 pm
by 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.

Re: Romcenter 3.60 Bug

Posted: Sun Jun 03, 2012 6:57 pm
by 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 ?

Re: Romcenter 3.60 Bug

Posted: Sun Jun 03, 2012 7:23 pm
by alexx
i have identify 2 roms!
pr8210.zip
simutrek.zip
Do you want that i send you?

Re: Romcenter 3.60 Bug

Posted: Sun Jun 03, 2012 7:39 pm
by 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!

Re: Romcenter 3.60 Bug

Posted: Sun Jun 03, 2012 9:12 pm
by RomCenter
Thank you. I will check that.

Re: Romcenter 3.60 Bug

Posted: Mon Jun 04, 2012 6:36 pm
by 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...?

Re: Romcenter 3.60 Bug

Posted: Mon Jun 04, 2012 6:47 pm
by 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.

Re: Romcenter 3.60 Bug

Posted: Tue Jun 05, 2012 1:11 am
by rcantor77
Just to give you an update... tested 3.61 and all now works fine with the 0.146 romset.
Cheers.

Re: Romcenter 3.60 Bug

Posted: Fri Dec 30, 2016 3:02 pm
by danhackley
I have the same error message after adding a ROM directory:

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

No ROMs appears in the ROM menu. I have the latest version of MAME datafile:

RomCenter statistics for database mame64

Number of sets: 34341
11461 mains sets (33.37%)
22810 clones (66.42%)
70 bios files (0.2%)
817 disks files (2.38%)
1104 samples files (3.21%)

Number of roms: 131485
129682 programs roms (98.63%)
451 bios roms (0.34%)
766 disks roms (0.58%)
656 samples roms (0.5%)

0 verified (0%)
128173 ok (97.48%)
1376 bad dumps (1.05%)
2310 no dumps (1.76%)

Number of files: 0
0 identified files (0%)
0 unknown files (0%)

And the 0.180 ROM set for MAME.

Any help appreciated!

Re: Romcenter 3.60 Bug

Posted: Fri Dec 30, 2016 5:50 pm
by RomCenter
Please try with romcenter 4.