Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > Free Torrent Source
Reply
  #1  
Old 7th October 2013, 19:04
varbeast's Avatar
varbeast varbeast is offline
Member
 
Join Date: Oct 2013
France
Posts: 3
Default 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
Reply With Quote
  #2  
Old 7th October 2013, 19:36
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,113
Default
remove
Code:
TYPE=MyISAM
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum
My Current Demo is here http://demo.btmanager.org/
Reply With Quote
  #3  
Old 8th October 2013, 11:25
varbeast's Avatar
varbeast varbeast is offline
Member
 
Join Date: Oct 2013
France
Posts: 3
Default ???
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 ?

Reply With Quote
  #4  
Old 11th October 2013, 05:27
leperkuan leperkuan is offline
Member
 
Join Date: Aug 2008
Posts: 3
Default
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.
Reply With Quote
The Following User Says Thank You to leperkuan For This Useful Post:
varbeast (15th October 2013)
Reply

Tags
fts , problemes , sql

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 23:10. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.