[BUG 3.31] Dynamic Sql Error

[psxlover]

I get an error when I try to refresh a rompath

Code: Select all

Dynamic SQL ERROR
SQL Error Code = -104
Unexpected end of command - line 1, column 316
Invalid token
Error Code: 249

[RomCenter]

I suspect a strange character somewhere.
What is the name of your rom path ?
Does it crash at the begining or on a special filename ?

[psxlover]

The funny thing is that if I close the rompath and open it again it opens without any problems. But if I try to update it first it hangs on Breath of Fire (U) by Mode 7.zip. When I remove it it hangs on Breath of Fire 2 (U) by Mode 7.zip anf then Dragon Ball Z - The Legacy Of Goku (U) by Mode 7.zip and then ESPN Winter X-Games Snowboarding 2002 (U) by Mode 7.zip, Guilty Gear X (J) by Eurasia.zip....

Code: Select all

Check new files
  Adding archive Ecks vs Sever (U-M5) by Mode 7.zip to the Database
  Adding archive Egg Mania (U-M3) by Mode7.zip to the Database
  Adding archive Fairly Odd Parents Enter the Cleft (U) by Mode7.zip to the Database
  Adding archive Frogger Adventure 2 - The Lost Wand (U-M2) by Mode7.zip to the Database
  Adding archive Frogger's Journey - The Forgotten Relic (U) by Mode7.zip to the Database
  Adding archive Go! Go! Beckham! Adventure On Soccer Island (E-M5) by Eurasia.zip to the Database
  Adding archive Golden Sun - The Lost Age (U) by Megaroms.zip to the Database
  Adding archive Gradius Advance (E) by Eurasia.zip to the Database
  Adding archive Guilty Gear X (J) by Eurasia.zip to the Database
Execution time: 0h 0m 14s
  Query Paths list
Done

Here it stops and throughs the error
If I update again:

Code: Select all

Refresh rom path...
Preparing I:\Emulators\Game Boy\GBA Roms\
200 files loaded
400 files loaded
600 files loaded
800 files loaded
1000 files loaded
1060 files loaded
Check modified files
0 files removed
Check new files
  Adding archive Guilty Gear X (J) by Eurasia.zip to the Database
Execution time: 0h 0m 14s
  Query Paths list
Done

And again error. After I remove Guilty Gear X (J) by Eurasia.zip:
http://img19.imageshack.us/img19/1161/35226365.png

The same thing happens with Salt Lake 2002 (U-M6) by Mode 7.zip, Yu-Gi-Oh! - The Eternal Duelist Soul (U) by Mode7.zi

[psxlover]

When I loaded a different database (PH_GBA_(2810)[RC].rdt) I got errors in different files Creatures (Europe) (En,Fr,De).zip, Flintstones, The - Big Trouble in Bedrock (Europe) (En,Fr,De,Es,It).zip....