Announcement

Collapse
No announcement yet.

Mysql error: (1064)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql error: (1064)

    At an unspecified future time we might receive an SQL error
    “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”
    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.
    --------------------
    Jazlyn
Working...
X