Page 1 of 1

Error: multiple rows in singleton select

Posted: Thu Nov 17, 2011 10:34 pm
by Tester
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

Re: Error: multiple rows in singleton select

Posted: Fri Nov 18, 2011 7:44 pm
by Tester
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.

Re: Error: multiple rows in singleton select

Posted: Thu Jan 19, 2012 2:51 am
by danaesigler
I also experienced this one.

Re: Error: multiple rows in singleton select

Posted: Wed Apr 12, 2017 1:00 pm
by Madman
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?

Re: Error: multiple rows in singleton select

Posted: Tue Apr 25, 2017 6:17 pm
by RomCenter
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 ?