floydg
Posts: 2052
Joined: 6/27/2004 From: Middletown, NJ Status: offline
|
quote:
ORIGINAL: n01487477 quote:
ORIGINAL: BigDuke66 Messing around with the regions I changed the region file and when loading it I get the screen full of these errors: ... Table=Regions Values=(76,'Pacific Ocean'South' - Austral Islands'Single'') java.sql.SQLException: Unexpected token: SOUTH in statement [INSERT INTO Regions VALUES ( 79,'Pacific Ocean'South] ... s VALUES ( 106,'Russia - Anadyr & Markovo'Single] ... Table=Regions Values=(46,'Middle East'Off-Map' - Abadan & Khorramshahr') In the Tracker itself everything looks fine but when restarting the Tracker many regions show up as "Unknow 30" or other numbers that are the now used region number. Looks to me like the ' in the names are the problem, again I would like to ask what "special" signs can be used in the names. Well now I think you are fighting SQL using single quotes ('')... This is not the same as the other error. THis is a DB insert error. There are too many special tokens that can be included, including (),/,"",'', | etc that should not be used. Yes, the single quote (') is not an allowed character in the region name. I think that the double quote (") would work okay, though. How far do you need to push this?
|