Error: multiple rows in singleton select

Forum rules
No roms requests or illegal links

Post a reply

Smilies
:D :) :( :o :shock: :? 8) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :wink: :!: :?: :idea: :arrow: :| :mrgreen: :clap: :hum: :gnak: :lol: :super: :uh: :toobad:
View more smilies

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Error: multiple rows in singleton select

Re: Error: multiple rows in singleton select

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 ?

Re: Error: multiple rows in singleton select

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?

Re: Error: multiple rows in singleton select

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

I also experienced this one.

Re: Error: multiple rows in singleton select

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.

Error: multiple rows in singleton select

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

Top