I've been trying to dump the structure of my database this evening with MySQLMan and it works fine, but when I tried running it back through the monitor it gives a syntax error. So I thought maybe it was a mysqlman bug so I tried with PhpMyAdmin and the same thing happens.
The structure is:
ID int(5) NOT NULL auto_increment,
Full_Name varchar(25) NOT NULL default '',
Username varchar(15) NOT NULL default '',
Password varchar(15) NOT NULL default '',
Contact_Email varchar(35) NOT NULL default '',
Email varchar(35) NOT NULL default '',
Active tinyint(1) NOT NULL default '1',
Digest tinyint(1) NOT NULL default '0',
Last_Sent int(12) default NULL,
PRIMARY KEY (ID),
UNIQUE KEY ID (ID,Username,Email,Contact_Email)
)
The weird thing is, when I run it from the MySQL Monitor using SSH it creates the table with no errors. Any ideas?
The error given is:
You have an error in your SQL syntax near 'CREATE TABLE Members ( ID int(5) NOT NULL auto_increment, Full_Name varchar(' at line 5
Thanks!
The structure is:
Code:
CREATE TABLE Members ( ID int(5) NOT NULL auto_increment,
Full_Name varchar(25) NOT NULL default '',
Username varchar(15) NOT NULL default '',
Password varchar(15) NOT NULL default '',
Contact_Email varchar(35) NOT NULL default '',
Email varchar(35) NOT NULL default '',
Active tinyint(1) NOT NULL default '1',
Digest tinyint(1) NOT NULL default '0',
Last_Sent int(12) default NULL,
PRIMARY KEY (ID),
UNIQUE KEY ID (ID,Username,Email,Contact_Email)
)
The weird thing is, when I run it from the MySQL Monitor using SSH it creates the table with no errors. Any ideas?
The error given is:
You have an error in your SQL syntax near 'CREATE TABLE Members ( ID int(5) NOT NULL auto_increment, Full_Name varchar(' at line 5
Thanks!