I got this error sometimes.
Fixed [BUG 3.40] Dynamic SQL Error, unexpected end of file
Moderator: Wanderer
-
- Galaga
- Posts: 32
- Joined: Tue Feb 12, 2008 2:33 am
Re: [BUG 3.40]Dynamic SQL Error, unexpected end of file
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 ?
Can you build a method to reproduce the problem ?
Is it linked to a folder ? a datafile ?
Eric - RomCenter developer
Report bugs here.
Report bugs here.
-
- Galaga
- Posts: 32
- Joined: Tue Feb 12, 2008 2:33 am
Re: [BUG 3.40]Dynamic SQL Error, unexpected end of file
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.
Re: [BUG 3.40]Dynamic SQL Error, unexpected end of file
One special file should produce the error, tell me if you find it.
Eric - RomCenter developer
Report bugs here.
Report bugs here.
-
- Galaga
- Posts: 32
- Joined: Tue Feb 12, 2008 2:33 am
Re: [BUG 3.40] Dynamic SQL Error, unexpected end of file
How do I find One special file ?
I do not understand
Do you think it may be the MAME I have MAMEUIFX32
I do not understand
Do you think it may be the MAME I have MAMEUIFX32
Re: [BUG 3.40] Dynamic SQL Error, unexpected end of file
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.
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.
Report bugs here.
Re: [BUG 3.40] Dynamic SQL Error, unexpected end of file
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.
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.
Re: [BUG 3.40] Dynamic SQL Error, unexpected end of file
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.
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.
Report bugs here.