Error: multiple rows in singleton select

[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

[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.

[danaesigler]

I also experienced this one.

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

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

[PaNo]

Hi,

I also get such errors with any rom folder with a fresh RomCenter 3.7.1 Portable Version.

Creating a database from output of MAMEUI64 v0.201 seems to work as well as doing by import from a dat file.

Code: Select all

=============================================
Willkommen zu RomCenter 3.7.1
Datenbanke Engine WI-V6.3.1.26351 Firebird 2.5
Vorlage Datenbankversion = 3,7002
Auf neue RomCenter Version überprüfen
Lade Datenbank D:\Programme\Util\Emu\RomCenter-v3.7.1-portable\romcenter\datas\mameui64-v0.201.rdt
mameui64-v0.201 Datenbank Version = 3,7002
Keine Aktualisierungen gefunden.
Rom Modus: zusammengefügt
Bios Modus : zusammengefügt
Sample Modus : zusammengefügt
Plug-In: arcade.dll
Lade Spieleliste
36731 Spiele geladen.
Aktualisiere Spielestatus
Status aktualisiert für 52819 Elemente.
Grüne Spiele : 805, Gelbe Spiele : 36, Rote Spiele : 35890
Aktualisiere Dateiliste
  Pfadliste abfragen
Prüfe Laufwerksverfügbarkeit
Fertig

What I don't understand is the presented numbers for green, yellow and red games. Shouldn't that be 0 since there are none involved yet ?!?

Anyway, when I attempt to open a rom path (for example a v0.197 version with 11994 roms) , I only see variations of this:

Code: Select all

Einen neuen Rompfad hinzufügen
Rom-Pfad hinzufügen [<a-valid-and-correct-path>\_Mame_Roms_0.197\]
Lade 11994 Dateien in Datenbank
50 Dateien geladen
100 Dateien geladen
150 Dateien geladen
[...]
11900 Dateien geladen
11950 Dateien geladen
11994 Dateien geladen
Neue Dateien analysieren
Aktualisiere Spielestatus
Status aktualisiert für 52819 Elemente.
Grüne Spiele : 805, Gelbe Spiele : 36, Rote Spiele : 35890
Aktualisiere Dateiliste
Fehler: 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
Fertig

There is no further information given on the occured problem and not a single rom is shown to do anything with afterwards.

When you try to redo the action and open the same path once again ...

Code: Select all

Einen neuen Rompfad hinzufügen
Rom-Pfad hinzufügen [<a-valid-and-correct-path>\_Mame_Roms_0.197\]
Pfad befindet sich bereits in Datenbank. Übersprungen.
Neue Dateien analysieren
Aktualisiere Spielestatus
Status aktualisiert für 52819 Elemente.
Grüne Spiele : 805, Gelbe Spiele : 36, Rote Spiele : 35890
Aktualisiere Dateiliste
Fehler: 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
Fertig

... it just throws another error message stating the path has already been added. I'm sorry, but it has quite obviously NOT done so! And of course, there is not even a way to remove a path again ...

Auditing these roms in MAMEUI64 on the same rom path returns this (followed by the expected list of detected problems):

Code: Select all

Correct: 33.430
Incorrect: 1.892
Total: 35.322

Any ideas ... ???

[RomCenter]

Does it work with romcenter 4 ?