"multiple rows in singleton select" Error Code: 332

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
User avatar
The Wizard of DATz
PacMan
PacMan
Posts: 5
Joined: Wed Nov 14, 2012 8:22 pm
Contact:

"multiple rows in singleton select" Error Code: 332

Post by The Wizard of DATz »

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

User avatar
The Wizard of DATz
PacMan
PacMan
Posts: 5
Joined: Wed Nov 14, 2012 8:22 pm
Contact:

Re: "multiple rows in singleton select" Error Code: 332

Post by The Wizard of DATz »

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.

qaism123
Pong
Pong
Posts: 1
Joined: Sat Oct 04, 2014 5:38 am

Re: "multiple rows in singleton select" Error Code: 332

Post by qaism123 »

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?
aliiiiii

Locked