Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   Free Torrent Source (http://www.bvlist.com/forumdisplay.php?f=25)
-   -   FTS, sql problemes (http://www.bvlist.com/showthread.php?t=9558)

varbeast 7th October 2013 19:04

FTS, sql problemes
 
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 :wallbash:

joeroberts 7th October 2013 19:36

remove
Code:

TYPE=MyISAM

varbeast 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 ? :sos:

:welcome:

leperkuan 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.


All times are GMT +2. The time now is 01:03.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.