SQL Error v3.12: WSN Support

SQL Error v3.12
Did a dump and trying reload...

Version:

SQL Error v3.12

tradenet
Experienced

Usergroup: Customer
Joined: Oct 14, 2004
Total Topics: 17
Total Posts: 56

Posted 01/14/05 - 10:28 AM:	#1
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

tradenet
Experienced

Usergroup: Customer
Joined: Oct 14, 2004
Total Topics: 17
Total Posts: 56

Posted 01/14/05 - 10:43 AM:	#2
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. Edited by tradenet on 01/14/05 - 10:52 AM

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6163

Posted 01/14/05 - 02:31 PM:	#3
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.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.