I have some problems with mysql i think! maybe php? i try to install xbtit torrent cms for testing but it does not import correctly all database tables from database.sql file i have been tryed torrentrader but there is problem to... i change config.php and mysql.php but then i get error something like this: cannot connect mysql etc...
Ubuntu linux 16.04 LTS webmin/Virtualmin latest.
xbtit original database.sql
https://www.upload.ee/files/6554796/database.sql.html
TorrentTrader original config.php
https://www.upload.ee/files/6554811/config.php.html
TorrentTrader original mysql.php
https://www.upload.ee/files/6554823/mysql.php.html
with xbtit it cannot import those tables:
-- XBTT --------------------------------------------------------
create table if not exists xbt_announce_log ( id int not null auto_increment, ipa int unsigned not null, port int not null, event int not null, info_hash binary(20) not null, peer_id binary(20) not null, downloaded bigint unsigned not null, left0 bigint unsigned not null, uploaded bigint unsigned not null, uid int not null, mtime int not null, primary key (id) ) engine = myisam;
create table if not exists xbt_config ( name varchar(255) not null, value varchar(255) not null ) engine = myisam;
create table if not exists xbt_deny_from_clients ( peer_id char(20) not null ) engine = myisam;
create table if not exists xbt_deny_from_hosts ( begin int unsigned not null, end int unsigned not null ) engine = myisam;
create table if not exists xbt_files ( fid int not null auto_increment, info_hash binary(20) not null, down_multi int not null default 100, up_multi int not null default 100, leechers int not null default 0, seeders int not null default 0, completed int not null default 0, flags int not null default 0, mtime int not null, ctime int not null, primary key (fid), unique key (info_hash) ) engine = myisam;
create table if not exists xbt_files_users
(
fid int not null,
uid int not null,
active tinyint not null,
announced int not null,
completed int not null,
downloaded bigint unsigned not null,
left bigint unsigned not null,
uploaded bigint unsigned not null,
down_rate int(11) NOT NULL ,
up_rate int(11) NOT NULL,
peer_id binary(8) NOT NULL,
completed_time int not null,
mtime int not null,
unique key (fid, uid),
key (uid)
) engine = myisam;
create table if not exists xbt_scrape_log ( id int not null auto_increment, ipa int unsigned not null, info_hash binary(20), uid int not null, mtime int not null, primary key (id) ) engine = myisam;
CREATE TABLE IF NOT EXISTS xbtit_users (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
username varchar(40) NOT NULL DEFAULT '',
password varchar(40) NOT NULL DEFAULT '',
salt varchar(20) NOT NULL DEFAULT '',
pass_type enum('1','2','3','4','5','6','7') NOT NULL DEFAULT '1',
dupe_hash varchar(20) NOT NULL DEFAULT '',
id_level int(10) NOT NULL DEFAULT '1',
random int(10) DEFAULT '0',
email varchar(50) NOT NULL DEFAULT '',
language tinyint(4) NOT NULL DEFAULT '1',
style tinyint(4) NOT NULL DEFAULT '6',
joined datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
lastconnect datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
lip bigint(11) DEFAULT '0',
downloaded bigint(20) DEFAULT '0',
uploaded bigint(20) DEFAULT '0',
avatar varchar(200) DEFAULT NULL,
avatar_upload enum('yes','no') NOT NULL DEFAULT 'no',
avatar_upload_name varchar(60) NOT NULL,
pid varchar(32) NOT NULL DEFAULT '',
flag tinyint(1) unsigned NOT NULL DEFAULT '0',
topicsperpage tinyint(3) unsigned NOT NULL DEFAULT '15',
postsperpage tinyint(3) unsigned NOT NULL DEFAULT '15',
torrentsperpage tinyint(3) unsigned NOT NULL DEFAULT '15',
profileview int(9) NOT NULL DEFAULT '0',
cip varchar(15) DEFAULT NULL,
time_offset varchar(4) NOT NULL DEFAULT '0',
temp_email varchar(50) NOT NULL DEFAULT '',
smf_fid int(10) NOT NULL DEFAULT '0',
ipb_fid int(10) NOT NULL DEFAULT '0',
seedbonus decimal(12,6) NOT NULL DEFAULT '0.000000',
tot_on int(10) NOT NULL DEFAULT '0',
rank_switch enum('yes','no') NOT NULL DEFAULT 'no',
old_rank varchar(12) NOT NULL DEFAULT '3',
timed_rank datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
donor enum('yes','no') NOT NULL DEFAULT 'no',
up_med varchar(10) NOT NULL DEFAULT '0',
connectable enum('yes','no','unknown') NOT NULL DEFAULT 'unknown',
custom_title varchar(50) DEFAULT NULL,
sb decimal(12,6) NOT NULL DEFAULT '0.000000',
whereheard varchar(255) NOT NULL,
rat_warn_level varchar(10) NOT NULL DEFAULT '0',
rat_warn_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
bandt enum('yes','no') NOT NULL DEFAULT 'no',
warn enum('yes','no') NOT NULL DEFAULT 'no',
warnreason varchar(255) NOT NULL,
warnadded datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
warns bigint(20) DEFAULT '0',
warnaddedby varchar(255) NOT NULL,
dob date NOT NULL,
birthday_bonus tinyint(1) NOT NULL DEFAULT '0',
immunity enum('yes','no') NOT NULL DEFAULT 'no',
invitations int(10) NOT NULL DEFAULT '0',
invited_by int(10) NOT NULL DEFAULT '0',
invitedate datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
reputation varchar(10) NOT NULL DEFAULT '0',
block_comment enum('yes','no') DEFAULT 'no',
showporn enum('yes','no') NOT NULL DEFAULT 'yes',
clientinfo text NOT NULL,
modcomment text NOT NULL,
supcomment text NOT NULL,
blackjack_stats text NOT NULL,
invisible enum('yes','no') NOT NULL DEFAULT 'no',
browser varchar(255) NOT NULL DEFAULT 'unknown',
userbar int(11) NOT NULL DEFAULT '1',
usercounter bigint(20) DEFAULT '0',
ban enum('yes','no') NOT NULL DEFAULT 'no',
ban_added varchar(50) NOT NULL,
ban_added_by varchar(50) NOT NULL,
ban_comment varchar(255) NOT NULL,
allowdownload enum('yes','no') DEFAULT 'yes',
allowupload enum('yes','no') DEFAULT 'yes',
proxy enum('yes','no') DEFAULT 'no',
announce enum('yes','no') NOT NULL DEFAULT 'no',
booted enum('yes','no') NOT NULL DEFAULT 'no',
whybooted varchar(255) NOT NULL,
addbooted datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
whobooted varchar(255) NOT NULL,
left_l varchar(10) NOT NULL DEFAULT 'yes',
emailnot enum('yes','no') NOT NULL DEFAULT 'no',
subscription text,
dona enum('yes','no') NOT NULL DEFAULT 'no',
donb enum('yes','no') NOT NULL DEFAULT 'no',
birt enum('yes','no') NOT NULL DEFAULT 'no',
mal enum('yes','no') NOT NULL DEFAULT 'no',
fem enum('yes','no') NOT NULL DEFAULT 'no',
bann enum('yes','no') NOT NULL DEFAULT 'no',
war enum('yes','no') NOT NULL DEFAULT 'no',
par enum('yes','no') NOT NULL DEFAULT 'no',
bot enum('yes','no') NOT NULL DEFAULT 'no',
trmu enum('yes','no') NOT NULL DEFAULT 'no',
trmo enum('yes','no') NOT NULL DEFAULT 'no',
vimu enum('yes','no') NOT NULL DEFAULT 'no',
vimo enum('yes','no') NOT NULL DEFAULT 'no',
friend enum('yes','no') NOT NULL DEFAULT 'no',
junkie enum('yes','no') NOT NULL DEFAULT 'no',
staff enum('yes','no') NOT NULL DEFAULT 'no',
sysop enum('yes','no') NOT NULL DEFAULT 'no',
parked int(9) NOT NULL DEFAULT '0',
gotgift enum('yes','no') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
trophy varchar(10) NOT NULL DEFAULT '0',
referral varchar(40) NOT NULL,
sbox enum('yes','no') NOT NULL DEFAULT 'no',
gender int(9) NOT NULL DEFAULT '2',
tor varchar(10) NOT NULL DEFAULT 'last',
pchat varchar(40) NOT NULL,
forumbanned enum('yes','no') NOT NULL DEFAULT 'no',
commentpm enum('true','false') NOT NULL DEFAULT 'true',
team int(10) unsigned NOT NULL DEFAULT '0',
on_topic int(11) NOT NULL DEFAULT '0',
on_forum int(11) NOT NULL DEFAULT '0',
helped varchar(255) NOT NULL,
helplang varchar(255) NOT NULL,
helpdesk enum('yes','no') DEFAULT 'no',
PRIMARY KEY (id),
UNIQUE KEY username (username),
KEY id_level (id_level),
KEY pid (pid),
KEY cip (cip),
KEY smf_fid (smf_fid),
KEY ipb_fid (ipb_fid),
KEY avatar_upload (avatar_upload)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
--
{$db_prefix}usernameCREATE TABLE IF NOT EXISTS {$db_prefix}username (
uid int(10) NOT NULL,
username varchar(30) NOT NULL,
org varchar(30) NOT NULL,
date varchar(30) NOT NULL
) ENGINE=MyISAM ;