FTS, sql problemes

varbeast · #1 7th October 2013, 19:04

I still have problemes with my localhost setting, now I get the following errors step:sql(4/5) :

"Error at the line 11:)TYPE=MyISAM

Query:CREATE TABLE'addedrequests' (id'int(10)unsigned NOT NULL auto_increment,'requestid' int(10) unsigned NOT NULL default'0', 'userid' int(10) unsigned NOT NULL default '0', PRIMARY KEY ('id'), KEY'pollid' ('id'), KEY 'userid' ('userid'), KEY 'requested_userid' ('requested','userid')) TYPE=MyISAM;

MySQL: 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 9

Stopped on error "

Where ist the problem? I've edit the index.php file and everything seems correct to me. maybe someone can help me ... I'm working with the latest ubuntu version and lamp(MySQL 5.5)
maybe someone knows another free torrent template newer and easier to install?
thx for helping

joeroberts · #2 7th October 2013, 19:36

remove

Code:

TYPE=MyISAM

varbeast · #3 8th October 2013, 11:25

Thanks for answering so fast, but maybe I'm stupid 'cause I can't find the line ... . maybe you can say to me where I've to look for ?

leperkuan · #4 11th October 2013, 05:27

replace

Code:

 TYPE = MYISAM

with

Code:

ENGINE = MyISAM

replace

Code:

 TYPE=MYISAM

with

Code:

ENGINE=MyISAM

There are other instances

Bump: It seems as though with the updates of PHP this script has become unusable. It will need to be modified to run on the newest versions of PHP, It seems to run great on php 5.2.8 but not on 5.4 which means you cannot run the newest version of apache either. These options are un-safe.

The only idea i have at this point is to ask the creator to update the script or do it alone.

I really liked this script in the past. I will say it has a few bugs and im sure its hackable.

The Following User Says Thank You to leperkuan For This Useful Post:
varbeast (15th October 2013)