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 #147

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
when  I install the phurl ,It failed and tip this ,what can I do ?

what I upload is in the picture.

Original issue reported on code.google.com by gs13...@gmail.com on 4 May 2013 at 1:27

Attachments:

GoogleCodeExporter commented 9 years ago 
just replace 'TYPE = MYISAM' with 'ENGINE = MYISAM' in 3.php (2 places) 

it's the problem of mysql's version.

Original comment by ryan.di...@gmail.com on 17 May 2013 at 6:50

GoogleCodeExporter commented 9 years ago 
 mysql_query("CREATE TABLE IF NOT EXISTS `phurl_urls` ( id int(10) unsigned NOT NULL auto_increment, url text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, code varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '', alias varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '', date_added datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY  (id), UNIQUE KEY code (code), KEY alias (alias) ) ENGINE = MYISAM") or die(mysql_error());

in line 30 of 3.php replace TYPE with ENGINE and it will work fine.

Original comment by 1leadsbr...@gmail.com on 27 Nov 2014 at 5:35