Bravo List
Register
Go Back   > Bravo List > P2P > Forum > Community Cafe
Reply
  #1  
Old 3rd November 2015, 13:48
esteo esteo is offline
Member
 
Join Date: Apr 2010
P2P
Posts: 1
Default bti tracker 1.4.8
Processing file: ../sql/database.sql

Starting at the line: 1

Error at the line 28: ) TYPE=MyISAM;

Quote:
Query: -- -- -- -- -- CREATE TABLE `bannedip` ( `id` int(10) unsigned NOT NULL auto_increment, `added` int(11) NOT NULL default '0', `addedby` int(10) unsigned NOT NULL default '0', `comment` varchar(255) NOT NULL default '', `first` bigint(11) unsigned default NULL, `last` bigint(11) unsigned default NULL, PRIMARY KEY (`id`), KEY `first_last` (`first`,`last`) ) 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 15
Stopped on error


?????
Reply With Quote
  #2  
Old 3rd November 2015, 14:19
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,113
Default
remove the
Code:
TYPE=MyISAM
like so
Code:
CREATE TABLE bannedip ( 
id int(10) unsigned NOT NULL auto_increment, 
added int(11) NOT NULL default '0', 
addedby int(10) unsigned NOT NULL default '0', 
comment varchar(255) NOT NULL default '', 
first bigint(11) unsigned default NULL, 
last bigint(11) unsigned default NULL, 
PRIMARY KEY (id), 
KEY first_last (first,last) 
);
__________________
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
Reply

Tags
bti , tracker

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 19:11. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.