[BUG 3.40] Dynamic SQL Error, unexpected end of file

[cibomatto2002]

I got this error sometimes.

error.jpg (87.76 KiB) Viewed 214 times

[RomCenter]

Could you be more precise, what did you do to raise this error ? Adding a folder? Fix a folder ?
Can you build a method to reproduce the problem ?
Is it linked to a folder ? a datafile ?

[cibomatto2002]

This seems to happend when I repair roms with the updated rom sets I may repair to many roms at one time :) Also it happends when I got to rename alot of roms the only way I get around this is to restall romcenter then repair less roms at a time.

[RomCenter]

One special file should produce the error, tell me if you find it.

[cibomatto2002]

How do I find One special file ?

I do not understand

Do you think it may be the MAME I have MAMEUIFX32

[RomCenter]

Maybe one of your rom have something special (special char or empty or something not usual).
It is when you fix this file that the error occurs.
It will be solved as soon as this file is identified.

[A.Bogard]

I have the same error... The first time I saw it was when I added my main rom folder...

Error :Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 384
Invalid token
Error Code: 249

Update: The error gets when reading a huge cuantity of roms:

1800 archivos cargados
Error :Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 384
Invalid token
Error Code: 249
2000 archivos cargados

It gets when loading 1800, 2400 or 5600 files, but it appears just once If you have until 2000 files, the error appears again if you have more than this quantity in the numbers given before.

Update: Finally I identified how to get the error:

[quote="cibomatto2002"]I got this error sometimes.

[attachment=0]error.jpg[/attachment][/quote]

It happens when moving more than 160 roms to an specific folder and scanning them to recognize new romsets. In my case, I tried to move them into my main rom folder.

It seems that happens just once. Here's the provisional way to avoid this mistake.

1. Let romcenter finish the work to read the roms. Don't press it.
2. After RC reports the SQL error and accepting, CLOSE THE PATH WHERE YOUR ROMS ARE.
3. Restart Romcenter and add again the rompath. Be sure to close it COMPLETELY using the task administrator in windows. After restarting, reload your sets in the path you readded. Surely you'll get the same error I reported twice...
4. Done.

Avoid to:

1. Move huge ammounts of roms - I think that moving after update around more than 150 files crashes RC. Update files in groups of 20 or 30. The same for moving them.
2. By the moment AVOID to use the RC command "move files to..." Close RC, move the fixed files, Restart it and press F5 to update...

Dunno if this works but it's a temporary "fix".

I'll report later if something new appears.

[RomCenter]

I'm sure it's not a question of number of roms.
I fixed a problem in the wip version (3.41) about quotes(') in zip comment which produce the same error. Maybe it's the same problem here.