Romcenter 3.60 Bug

Get help with running Romcenter 3 here. Please do not post roms requests or illegal links, posts will be deleted.

Moderator: Wanderer

Forum rules
No roms requests or illegal links
alexx
PacMan
PacMan
Posts: 7
Joined: Sun Jun 03, 2012 5:05 pm

Romcenter 3.60 Bug

Post 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!!

User avatar
RomCenter
Author
Author
Posts: 1519
Joined: Fri Sep 28, 2001 12:34 pm
Location: France
Contact:

Re: Romcenter 3.60 Bug

Post by RomCenter »

This is interesting.
Could you tell me which mame version you're using ?
Thank you.
Eric - RomCenter developer
Report bugs here.

alexx
PacMan
PacMan
Posts: 7
Joined: Sun Jun 03, 2012 5:05 pm

Re: Romcenter 3.60 Bug

Post 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.
Last edited by alexx on Sun Jun 03, 2012 9:14 pm, edited 2 times in total.

User avatar
RomCenter
Author
Author
Posts: 1519
Joined: Fri Sep 28, 2001 12:34 pm
Location: France
Contact:

Re: Romcenter 3.60 Bug

Post 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 ?
Eric - RomCenter developer
Report bugs here.

alexx
PacMan
PacMan
Posts: 7
Joined: Sun Jun 03, 2012 5:05 pm

Re: Romcenter 3.60 Bug

Post by alexx »

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

alexx
PacMan
PacMan
Posts: 7
Joined: Sun Jun 03, 2012 5:05 pm

Re: Romcenter 3.60 Bug

Post 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!

User avatar
RomCenter
Author
Author
Posts: 1519
Joined: Fri Sep 28, 2001 12:34 pm
Location: France
Contact:

Re: Romcenter 3.60 Bug

Post by RomCenter »

Thank you. I will check that.
Eric - RomCenter developer
Report bugs here.

rcantor77
Pong
Pong
Posts: 2
Joined: Mon Jun 04, 2012 6:34 pm

Re: Romcenter 3.60 Bug

Post 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...?

User avatar
RomCenter
Author
Author
Posts: 1519
Joined: Fri Sep 28, 2001 12:34 pm
Location: France
Contact:

Re: Romcenter 3.60 Bug

Post 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.
Eric - RomCenter developer
Report bugs here.

rcantor77
Pong
Pong
Posts: 2
Joined: Mon Jun 04, 2012 6:34 pm

Re: Romcenter 3.60 Bug

Post by rcantor77 »

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

danhackley

Re: Romcenter 3.60 Bug

Post 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!

User avatar
RomCenter
Author
Author
Posts: 1519
Joined: Fri Sep 28, 2001 12:34 pm
Location: France
Contact:

Re: Romcenter 3.60 Bug

Post by RomCenter »

Please try with romcenter 4.
Eric - RomCenter developer
Report bugs here.

Locked