Fixed [BUG 3.30] Quote escaping problems

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

Moderator: Wanderer

Locked
linFox
Pong
Pong
Posts: 2
Joined: Mon Apr 17, 2006 3:18 am
Contact:

Fixed [BUG 3.30] Quote escaping problems

Post by linFox »

I've just recently been having issues with importing dats that have single quotes in them, I guess they're not being escaped properly for the database.

I've figured out that it's in the game name and rom name, eg:
¬pname¬pdes¬gname¬gdes¬rna'me.ext¬00000000¬1¬¬¬ or
¬pname¬pdes¬gna'me¬gdes¬rname.ext¬00000000¬1¬¬¬

They fail and give errors like:
**Error :Dynamic SQL Error
SQL error code = -104
Token unknown - line 2, column 164
me


It's happened to me in 3.20 and 3.30.

langdon
Pong
Pong
Posts: 2
Joined: Wed Apr 01, 2009 10:59 pm

Dynamic SQL Error

Post by langdon »

When I try to load games list from a datafile I get an error. The datafile is from dat-o-matic (I tried both RC and CM formats, both say the same exact error).

=============================================
Welcome to RomCenter 3.30
Database Engine WI-V6.3.5.13206 Firebird 2.0
Template database version = 3.2070
Ready
Copy Database template
Open new db
Loading database C:\Documents and Settings\langdon\Application Data\romcenter\Datas\Nintendo - DS Decrypted (20090401_CM).rdt
Nintendo - DS Decrypted (20090401_CM) database version = 3.207
Rom mode : split
Bios mode : split
Sample mode : merged
Plugin : arcade.dll
Import datas from [C:\Documents and Settings\langdon\Application Data\romcenter\Datas\Nintendo - DS Decrypted (20090401_CM).dat] to [C:\Documents and Settings\langdon\Application Data\romcenter\Datas\Nintendo - DS Decrypted (20090401_CM).rdt]
Import datas
Rom mode: split
Bios mode: split
Sample mode: merged
10000 lines loaded
Import roms in database
Database closed
**Error :Dynamic SQL Error
SQL error code = -104
Token unknown - line 47, column 167
Entraineur
Invalid token
Error Code: 249
Ready

langdon
Pong
Pong
Posts: 2
Joined: Wed Apr 01, 2009 10:59 pm

Re: [BUG 3.30] Quote escaping problems

Post by langdon »

Ahh, this appears to be my problem as well.

viewtopic.php?f=2&t=1983

I found it was easy enough to fix (just find all instances of ' and replace them with '' (two single quotes)). Shame.

money_114
Galaga
Galaga
Posts: 10
Joined: Sun Jul 20, 2008 7:30 am

romcenter 3.30 bug?

Post by money_114 »

Sorry,My Englinsh is very poor. I hope you can understand it.

When I used romcenter3.30 load no-intro Nintendo - Nintendo Entertainment System (20090218) (RC)
romcenter3.30 loaded failed,log:

Welcome to RomCenter 3.30
Database Engine WI-V6.3.5.13206 Firebird 2.0
Template database version = 3.2070
Ready
Copy Database template
Open new db
Loading database D:\模拟用\Romcenter\romcenter\datas\Nintendo - Nintendo Entertainment System (20090218) (RC).rdt
Nintendo - Nintendo Entertainment System (20090218) (RC) database version = 3.207
Rom mode : split
Bios mode : split
Sample mode : merged
Plugin : arcade.dll
Import datas from [D:\模拟用\Romcenter\romcenter\datas\Nintendo - Nintendo Entertainment System (20090218) (RC).dat] to [D:\模拟用\Romcenter\romcenter\datas\Nintendo - Nintendo Entertainment System (20090218) (RC).rdt]
Import datas
Rom mode: split
Bios mode: split
Sample mode: merged
10000 lines loaded
Import roms in database
Database closed
**Error : Dynamic SQL Error
SQL error code = -104
Token unknown - line 2, column 162
89
Invalid token
Error Code: 249
Ready

User avatar
Wanderer
Board master
Board master
Posts: 791
Joined: Wed Oct 03, 2001 10:37 am
Location: Milky way

Re: Dynamic SQL Error

Post by Wanderer »

MODERATOR ACTION
Similar issue reported. Post by money_114 has been merged with this one.

langdon
Pong
Pong
Posts: 2
Joined: Wed Apr 01, 2009 10:59 pm

Re: Dynamic SQL Error

Post by langdon »

Wanderer: This issue is the same as viewtopic.php?f=11&t=1978 as well. I proposed a temporary solution in that thread.

User avatar
Wanderer
Board master
Board master
Posts: 791
Joined: Wed Oct 03, 2001 10:37 am
Location: Milky way

Re: Dynamic SQL Error

Post by Wanderer »

langdon wrote:Wanderer: This issue is the same as viewtopic.php?f=11&t=1978 as well. I proposed a temporary solution in that thread.
Right. I had forgotten about that. Thanks.
MODERATOR ACTION
Threads merged.

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

Re: [BUG 3.30] Quote escaping problems

Post by RomCenter »

Ok ok
I fixed the problem, and also the next problem about roms extensions (on nds dat for example).
I will try to publish a fix tomorrow, as I'm away for 10 days next week 8)
Eric - RomCenter developer
Report bugs here.

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

Re: Fixed [BUG 3.30] Quote escaping problems

Post by RomCenter »

Eric - RomCenter developer
Report bugs here.

Locked