Error: multiple rows in singleton select

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

Moderators: Wanderer, Logiqx, Iron Man

Forum rules
No roms requests or illegal links
Tester

Error: multiple rows in singleton select

Post by Tester » Thu Nov 17, 2011 10:34 pm

I got this error when I want to add a rompath

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: 335544652Error Code: 332

This is the dat and rdt file

http://www.mediafire.com/?cjxclezltt9a97v

Tester

Re: Error: multiple rows in singleton select

Post by Tester » Fri Nov 18, 2011 7:44 pm

I did find the bug in RomCenter, the dat file contains roms with the same CRC but different md5/sha1.
I did remove the md5 and sha1 attributes and then it works, the rompath was successfully added and all roms are found. But this not a fix, because the md5/sha1 in the dat file was not wrong.

danaesigler
Pong
Pong
Posts: 1
Joined: Thu Jan 19, 2012 2:47 am

Re: Error: multiple rows in singleton select

Post by danaesigler » Thu Jan 19, 2012 2:51 am

I also experienced this one.

Madman

Re: Error: multiple rows in singleton select

Post by Madman » Wed Apr 12, 2017 1:00 pm

Problem still happens with romcenter 3.71 and 4.0.0 beta 10.1. Dat source MAMEUI64 0.184 exe. Trying to check/update full set (split roms)

I know that mame is the source of the problem. Different files having the same CRC and different SHA.

Will there be a workaround in Romcenter? Or a report option to identify the files and manually fix the problem?

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

Re: Error: multiple rows in singleton select

Post by RomCenter » Tue Apr 25, 2017 6:17 pm

These kinds of problems with mame are handled by romcenter. This error is a bug.
I will investigate and fix it.
But it will be tricky to reproduce the problem. Can you send me a log file, or maybe identify a file which raise the error ?
Eric - RomCenter developer
http://www.romcenter.com

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests