This is what I get when I try to reload a dumped database: ERROR 1064 at line 194: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'to text NOT NULL, subject text NOT NULL, message text NOT N
Here is the ofending table @ line 194:
CREATE TABLE wsnlinks_email ( id int(11) NOT NULL auto_increment, to text NOT NULL, subject text NOT NULL, message text NOT NULL, headers text NOT NULL, timesent int(11) NOT NULL default '0', ip text NOT NULL, replacement text NOT NULL, mime tinyint(1) NOT NULL default '0', UNIQUE KEY id (id) ) TYPE=MyISAM;
to needs to be quoted as `to`... but I'm going to be dumping the backup system anyway in favor of using mysql commands (simply calling them through php so that you don't have to remember them), even though it won't work for safe mode hosts and possibly not for windows hosts, since WSN's backup mechanism really can't work for a large database.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on SQL Error v3.12
Forum Regular
Usergroup: Customer
Joined: Oct 14, 2004
Total Topics: 54
Total Comments: 127
This is what I get when I try to reload a dumped database:
ERROR 1064 at line 194: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'to text NOT NULL,
subject text NOT NULL,
message text NOT N
Here is the ofending table @ line 194:
CREATE TABLE wsnlinks_email (
id int(11) NOT NULL auto_increment,
to text NOT NULL,
subject text NOT NULL,
message text NOT NULL,
headers text NOT NULL,
timesent int(11) NOT NULL default '0',
ip text NOT NULL,
replacement text NOT NULL,
mime tinyint(1) NOT NULL default '0',
UNIQUE KEY id (id)
) TYPE=MyISAM;
Any Ideas?
mysqld Ver 4.0.21-standard
Forum Regular
Usergroup: Customer
Joined: Oct 14, 2004
Total Topics: 54
Total Comments: 127
I guess the dump mangled the syntax or something so I just copied an pasted the correct syntax from the setup.sql file...then it worked.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
to needs to be quoted as `to`... but I'm going to be dumping the backup system anyway in favor of using mysql commands (simply calling them through php so that you don't have to remember them), even though it won't work for safe mode hosts and possibly not for windows hosts, since WSN's backup mechanism really can't work for a large database.