I'm using DBTools to connect to MySQL database on ISP server. With the same tool I'm managing a database with the same structure, but locally.
From time to time I'm exporting everything from the remote database into a .sql file. I'm runing this sql query file to populate the local database.
I'm running the next SQL statement:
INSERT INTO discussion (TopicID, ReplicaID, RaspunsID, UtilizatorID, CategorieID, TitluTopic, Topic, Blocat, Deschis, Pentru, DeLa, DataAdaugare, IP) VALUES(353, 351, 351, 18, 1, 'Trafic', 'Deocamdata nu exista trafic indeajuns de consistent pentru a asigura o mai mare frecventa de mesaje postate.\r\n\r\nSite-ul este la inceput de drum, nu are indeajuns continut pentru a atrage mai multi vizitatori; numarul de membri este inca mic. Speram ca in timp sa rezolvam toate aceste \'neajunsuri\'.', 'N', 0, 0, 0, '2002-11-01 13:46:25', '24.xxx.xxx.xxx');
and I'm getting this error:
"You have an error in your SQL syntax near "Deocamdata nu exista trafic indeajuns de consistent pentru a asigura o mai mare' at line 1
Is this a DBTools bug or the statement is wrong in some point (I don't see it)?
The structure of the table is:
CREATE TABLE discussion (
TopicID double(22,0) NOT NULL auto_increment,
ReplicaID double(22,0) NOT NULL default '0',
RaspunsID double(22,0) NOT NULL default '0',
UtilizatorID int(11) default NULL,
CategorieID int(11) default NULL,
TitluTopic varchar(255) default NULL,
Topic longtext,
Blocat char(1) default NULL,
Deschis int(11) default NULL,
Pentru int(11) default NULL,
DeLa int(11) default NULL,
DataAdaugare datetime NOT NULL default '0000-00-00 00:00:00',
IP varchar(20) default NULL,
PRIMARY KEY (TopicID),
UNIQUE KEY PrimaryKey (TopicID),
KEY CategorieID (CategorieID)
)
Thank you
