Fixed [BUG 3.30] Quote escaping problems

[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]

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 ynamic SQL Error
SQL error code = -104
Token unknown - line 47, column 167
Entraineur
Invalid token
Error Code: 249
Ready

[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]

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

[Wanderer]

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

[langdon]

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

[Wanderer]

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.

[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

[RomCenter]

Version 3.31 is released