Romcenter 3.60 Bug
Moderator: Wanderer
Forum rules
No roms requests or illegal links
No roms requests or illegal links
Romcenter 3.60 Bug
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!!
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
This is interesting.
Could you tell me which mame version you're using ?
Thank you.
Could you tell me which mame version you're using ?
Thank you.
Eric - RomCenter developer
Report bugs here.
Report bugs here.
Re: Romcenter 3.60 Bug
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.
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.
Last edited by alexx on Sun Jun 03, 2012 9:14 pm, edited 2 times in total.
Re: Romcenter 3.60 Bug
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 ?
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 ?
Eric - RomCenter developer
Report bugs here.
Report bugs here.
Re: Romcenter 3.60 Bug
i have identify 2 roms!
pr8210.zip
simutrek.zip
Do you want that i send you?
pr8210.zip
simutrek.zip
Do you want that i send you?
Re: Romcenter 3.60 Bug
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!
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
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...?
Is there a way to determine which ROM(s) is causing the issue...?
Re: Romcenter 3.60 Bug
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.
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.
Eric - RomCenter developer
Report bugs here.
Report bugs here.
Re: Romcenter 3.60 Bug
Just to give you an update... tested 3.61 and all now works fine with the 0.146 romset.
Cheers.
Cheers.
Re: Romcenter 3.60 Bug
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!
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!