#1064 - You have an error in your SQL syntax;

Brought to you by: bluenotemkvi

#1064 - You have an error in your SQL syntax;

Forum: Help

Creator: wazburn

Created: 2013-09-05

Updated: 2015-05-20

wazburn - 2013-09-05

Im getting error below when trying to import create_tables.sql via phpmyadmin>import

1064 - 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 'TYPE=MyISAM' at line 18

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Lockie - 2013-09-25

I encountered the same error. It turns out that TYPE has been deprecated.

Open create_tables.sql in a text editor and change the 8 instances of the word "TYPE" to "ENGINE".

If you then encounter an error relating to TIMESTAMP on line 100, remove the "(14)" so it reads "timestamp timestamp NOT NULL,".

So far my install has been working fine with those changes, so hope that helps!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Sherwin Gaddis - 2015-05-20

I was getting the issue with the timestamp. Thanks for the tip.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.