At an unspecified future time we might receive an SQL error
while executing the query or sometime even on our site. There two possibilities for this error where 1) where semicolon [ ; ] is not used for terminating the create statement and 2) Due to the word CHARSET.
The possible solution for these cause are as follows
1. Add semicolon [ ; ]at the end of you Create statement.
2. Replace the line ENGINE=MyISAM DEFAULT CHARSET=latin1 with "ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_bin;"
And this should fix your issue.
“Executing SQL... MySQL ERROR: (1064) You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 1
QUERY:
CREATE TABLE `wl_admin` (`id` int(6) unsigned NOT NULL auto_increment,`username` varchar(50) NOT NULL default '',`passwd` varchar(32) NOT NULL default '',PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1
ERROR: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 1”
QUERY:
CREATE TABLE `wl_admin` (`id` int(6) unsigned NOT NULL auto_increment,`username` varchar(50) NOT NULL default '',`passwd` varchar(32) NOT NULL default '',PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1
ERROR: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 1”
The possible solution for these cause are as follows
1. Add semicolon [ ; ]at the end of you Create statement.
2. Replace the line ENGINE=MyISAM DEFAULT CHARSET=latin1 with "ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_bin;"
And this should fix your issue.