search

cnwangjie / phurl

Automatically exported from code.google.com/p/phurl
0 stars 0 forks source link

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 1 #125

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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 1

Original issue reported on code.google.com by stone...@gmail.com on 18 Aug 2011 at 3:38

GoogleCodeExporter commented 9 years ago 
Just googled and it seems changing 'TYPE=MyISAM' to 'ENGINE = MyISAM'
seems to fix it

Original comment by itspa...@gmail.com on 19 Aug 2011 at 12:59

GoogleCodeExporter commented 9 years ago 
Interesting, I'll look into this a little and it should no longer be an issue 
in v3, hopefully.

Original comment by he...@phurlproject.org on 15 Dec 2011 at 12:54

GoogleCodeExporter commented 9 years ago

Original comment by he...@phurlproject.org on 29 May 2012 at 11:30

GoogleCodeExporter commented 9 years ago 
Hi, Change "TYPE = MYISAM" in install/3.php line:28 & 30 to "ENGINE = MYISAM".
Run again. Success!

Original comment by skausha...@gmail.com on 26 Sep 2012 at 8:13

GoogleCodeExporter commented 9 years ago 
As "TYPE" is deprecated in favor of "ENGINE" since MySQL 4.1 (a few years now), 
perhaps it would make sense to fix this bug and make MySQL 5.5 work out of the 
box in 2.4.3.

http://dev.mysql.com/doc/refman/4.1/en/myisam-storage-engine.html

BTW, why is the engine type MyISAM so important? Perhaps it can be removed?

Original comment by 2010ster...@gmail.com on 25 Apr 2013 at 10:27