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

Bugs are now stored in a bug tracker application. Click on the "Support/Bug reports" link above.

Moderator: Wanderer

Locked
cibomatto2002
Galaga
Galaga
Posts: 32
Joined: Tue Feb 12, 2008 2:33 am

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

Post by cibomatto2002 »

I got this error sometimes.
error.jpg
error.jpg (87.75 KiB) Viewed 20782 times

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

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

Post by 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 ?
Eric - RomCenter developer
Report bugs here.

cibomatto2002
Galaga
Galaga
Posts: 32
Joined: Tue Feb 12, 2008 2:33 am

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

Post by 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.

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

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

Post by RomCenter »

One special file should produce the error, tell me if you find it.
Eric - RomCenter developer
Report bugs here.

cibomatto2002
Galaga
Galaga
Posts: 32
Joined: Tue Feb 12, 2008 2:33 am

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

Post by cibomatto2002 »

How do I find One special file ?

I do not understand

Do you think it may be the MAME I have MAMEUIFX32

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

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

Post by 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.
Eric - RomCenter developer
Report bugs here.

A.Bogard
Galaga
Galaga
Posts: 19
Joined: Sat Mar 29, 2008 4:16 pm

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

Post by 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.

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

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

Post by 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.
Eric - RomCenter developer
Report bugs here.

Locked