|
|
|||||||
| Webanwendungen Alle Fragen zu Installation und Problemlösung (Torrent-Flux, Hostsoftware, Serversoftware) |
 |
|
|
Themen-Optionen | Ansicht |
27.11.2013, 16:49
|
#1 | |||||||||||
|
Neuling
Registriert seit: 27.04.2011
Beitr?ge: 15
Abgegebene Danke: 8
Erhielt 0 Danke für 0 Beiträge
Downloads: 31
Uploads: 0 Nachrichten: 36 Renommee-Modifikator:
0  |
torrentflux-b4rt 1.0-beta2 - Setup Fehler
Hallo Freunde
ich habe ein Problem und zwar kann ich über papMyadmin nicht die SQL datei rein kopieren kommt dann das Mein System: root mit Debian 7.2 MySQL Server: Localhost via UNIX socket Server Version: 5.5.31-0+wheezy1 Protokoll-Version: 10 Benutzer: root@localhost MySQL-Zeichensatz: UTF-8 Unicode (utf8) Webserver Apache/2.2.22 (Debian) MySQL-Client-Version: 5.5.31 PHP Erweiterung: mysqli Dokumentation phpMyAdmin Versionsinformationen: 3.4.11.1deb2 Fehler SQL-Befehl: -- ----------------------------------------------------------------------------- -- $Id: mysql_torrentflux-b4rt-1.0.sql 2667 2007-03-21 20:43:58Z b4rt $ -- ----------------------------------------------------------------------------- -- -- MySQL-File for 'torrentflux-b4rt-1.0'. -- -- This Stuff is provided 'as-is'. In no way will the authors be held -- liable for any damages to your soft- or hardware from this. -- ----------------------------------------------------------------------------- -- -- tf_cookies -- CREATE TABLE tf_cookies( cid INT( 10 ) NOT NULL AUTO_INCREMENT , uid INT( 10 ) NOT NULL DEFAULT '0', host VARCHAR( 255 ) DEFAULT NULL , data VARCHAR( 255 ) DEFAULT NULL , PRIMARY KEY ( cid ) ) TYPE = MYISAM ; MySQL meldet: Dokumentation #1064 - 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 20 und wenn ich es über die Setup.php mache kommt das torrentflux-b4rt 1.0-beta2 - Setup Database - Creation + Test - MySQL The installation will now try to connect to the database server, create a new database if applicable and run some tests to check we can create tables in the database. Ok: Created database b4rt Query Error: CREATE TABLE tf_test ( tf_key VARCHAR(255) NOT NULL default '', tf_value TEXT NOT NULL, PRIMARY KEY (tf_key) ) TYPE=MyISAM Error: kann mir da einer helfen wäre super lieb von euch Lg DrTukTuk Ge?ndert von DrTukTuk (27.11.2013 um 16:56 Uhr) |
|||||||||||
|
|
|
27.11.2013, 16:59
|
#2 | |||||||||||
|
Erfahrener Benutzer
Registriert seit: 09.01.2012
Ort: Zwischen RAM und SSD
Alter: 35
Beitr?ge: 275
Abgegebene Danke: 195
Erhielt 30 Danke für 4 Beiträge
Downloads: 125
Uploads: 0 Nachrichten: 306 Renommee-Modifikator:
402  |
TYPE=MyISAM muss so ENGINE=MyISAM
also probiers mal so Code:
CREATE TABLE tf_cookies( cid INT( 10 ) NOT NULL AUTO_INCREMENT , uid INT( 10 ) NOT NULL DEFAULT '0', host VARCHAR( 255 ) DEFAULT NULL , data VARCHAR( 255 ) DEFAULT NULL , PRIMARY KEY ( cid ) ) ENGINE = MYISAM ; Ge?ndert von T89 (27.11.2013 um 17:01 Uhr) |
|||||||||||
|
|
|
|
27.11.2013, 17:40
|
#3 | |||||||||||
|
Neuling
Registriert seit: 27.04.2011
Beitr?ge: 15
Abgegebene Danke: 8
Erhielt 0 Danke für 0 Beiträge
Themenstarter
Downloads: 31
Uploads: 0 Nachrichten: 36 Renommee-Modifikator:
0 |
Also so muss das ok:
Code:
-- -----------------------------------------------------------------------------
-- $Id: mysql_torrentflux-b4rt-1.0.sql 2667 2007-03-21 20:43:58Z b4rt $
-- -----------------------------------------------------------------------------
--
-- MySQL-File for 'torrentflux-b4rt-1.0'.
--
-- This Stuff is provided 'as-is'. In no way will the authors be held
-- liable for any damages to your soft- or hardware from this.
-- -----------------------------------------------------------------------------
--
-- tf_cookies
--
CREATE TABLE tf_cookies (
cid int(10) NOT NULL auto_increment,
uid int(10) NOT NULL default '0',
host VARCHAR(255) default NULL,
data VARCHAR(255) default NULL,
PRIMARY KEY (cid)
) ENGINE = MYISAM ;
--
-- tf_links
--
CREATE TABLE tf_links (
lid int(10) NOT NULL auto_increment,
url VARCHAR(255) NOT NULL default '',
sitename VARCHAR(255) NOT NULL default 'Old Link',
sort_order TINYINT(3) UNSIGNED default '0',
PRIMARY KEY (lid)
) ENGINE = MYISAM ;
INSERT INTO tf_links VALUES (NULL,'http://tf-b4rt.berlios.de/','tf-b4rt','0');
--
-- tf_log
--
CREATE TABLE tf_log (
cid int(14) NOT NULL auto_increment,
user_id VARCHAR(32) NOT NULL default '',
file VARCHAR(200) NOT NULL default '',
action VARCHAR(200) NOT NULL default '',
ip VARCHAR(15) NOT NULL default '',
ip_resolved VARCHAR(200) NOT NULL default '',
user_agent VARCHAR(200) NOT NULL default '',
time VARCHAR(14) NOT NULL default '0',
PRIMARY KEY (cid)
) ENGINE = MYISAM ;
--
-- tf_messages
--
CREATE TABLE tf_messages (
mid int(10) NOT NULL auto_increment,
to_user VARCHAR(32) NOT NULL default '',
from_user VARCHAR(32) NOT NULL default '',
message TEXT,
IsNew int(11) default NULL,
ip VARCHAR(15) NOT NULL default '',
time VARCHAR(14) NOT NULL default '0',
force_read TINYINT(1) default '0',
PRIMARY KEY (mid)
) ENGINE = MYISAM ;
--
-- tf_rss
--
CREATE TABLE tf_rss (
rid int(10) NOT NULL auto_increment,
url VARCHAR(255) NOT NULL default '',
PRIMARY KEY (rid)
) ENGINE = MYISAM ;
--
-- tf_users
--
CREATE TABLE tf_users (
uid int(10) NOT NULL auto_increment,
user_id VARCHAR(32) BINARY NOT NULL default '',
password VARCHAR(34) NOT NULL default '',
hits int(10) NOT NULL default '0',
last_visit VARCHAR(14) NOT NULL default '0',
time_created VARCHAR(14) NOT NULL default '0',
user_level TINYINT(1) NOT NULL default '0',
hide_offline TINYINT(1) NOT NULL default '0',
theme VARCHAR(100) NOT NULL default 'default',
language_file VARCHAR(60) default 'lang-english.php',
state TINYINT(1) NOT NULL default '1',
PRIMARY KEY (uid)
) ENGINE = MYISAM ;
--
-- tf_transfers
--
CREATE TABLE tf_transfers (
transfer VARCHAR(255) NOT NULL default '',
type ENUM('torrent','wget','nzb') NOT NULL default 'torrent',
client ENUM('tornado','transmission','mainline','azureus','wget','nzbperl') NOT NULL default 'tornado',
hash VARCHAR(40) NOT NULL DEFAULT '',
datapath VARCHAR(255) NOT NULL default '',
savepath VARCHAR(255) NOT NULL default '',
running ENUM('0','1') NOT NULL default '0',
rate SMALLINT(4) NOT NULL default '0',
drate SMALLINT(4) NOT NULL default '0',
maxuploads TINYINT(3) unsigned NOT NULL default '0',
superseeder ENUM('0','1') NOT NULL default '0',
runtime ENUM('True','False') NOT NULL default 'False',
sharekill SMALLINT(4) unsigned NOT NULL default '0',
minport SMALLINT(5) unsigned NOT NULL default '0',
maxport SMALLINT(5) unsigned NOT NULL default '0',
maxcons SMALLINT(4) unsigned NOT NULL default '0',
rerequest MEDIUMINT(8) unsigned NOT NULL default '0',
PRIMARY KEY (transfer)
) ENGINE = MYISAM ;
--
-- tf_transfer_totals
--
CREATE TABLE tf_transfer_totals (
tid VARCHAR(40) NOT NULL default '',
uptotal BIGINT(80) NOT NULL default '0',
downtotal BIGINT(80) NOT NULL default '0',
PRIMARY KEY (tid)
) ENGINE = MYISAM ;
--
-- tf_trprofiles
--
CREATE TABLE tf_trprofiles (
id MEDIUMINT(8) NOT NULL auto_increment,
name VARCHAR(255) NOT NULL default '',
owner INT(10) NOT NULL default '0',
public ENUM('0','1') NOT NULL default '0',
rate SMALLINT(4) NOT NULL default '0',
drate SMALLINT(4) NOT NULL default '0',
maxuploads TINYINT(3) unsigned NOT NULL default '0',
superseeder ENUM('0','1') NOT NULL default '0',
runtime ENUM('True','False') NOT NULL default 'False',
sharekill SMALLINT(4) unsigned NOT NULL default '0',
minport SMALLINT(5) unsigned NOT NULL default '0',
maxport SMALLINT(5) unsigned NOT NULL default '0',
maxcons SMALLINT(4) unsigned NOT NULL default '0',
rerequest MEDIUMINT(8) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE = MYISAM ;
--
-- tf_xfer
--
CREATE TABLE tf_xfer (
user_id VARCHAR(32) NOT NULL default '',
date DATE NOT NULL default '0000-00-00',
download BIGINT(80) NOT NULL default '0',
upload BIGINT(80) NOT NULL default '0',
PRIMARY KEY (user_id,date)
) ENGINE = MYISAM ;
--
-- tf_settings_user
--
CREATE TABLE tf_settings_user (
uid INT(10) NOT NULL,
tf_key VARCHAR(255) NOT NULL default '',
tf_value TEXT NOT NULL
) ENGINE = MYISAM ;
--
-- tf_settings
--
CREATE TABLE tf_settings (
tf_key VARCHAR(255) NOT NULL default '',
tf_value TEXT NOT NULL,
PRIMARY KEY (tf_key)
) ENGINE = MYISAM ;
INSERT INTO tf_settings VALUES ('path','/usr/local/torrentflux/');
INSERT INTO tf_settings VALUES ('max_upload_rate','10');
INSERT INTO tf_settings VALUES ('max_download_rate','0');
INSERT INTO tf_settings VALUES ('max_uploads','4');
INSERT INTO tf_settings VALUES ('minport','49160');
INSERT INTO tf_settings VALUES ('maxport','49300');
INSERT INTO tf_settings VALUES ('superseeder','0');
INSERT INTO tf_settings VALUES ('rerequest_interval','1800');
INSERT INTO tf_settings VALUES ('enable_search','1');
INSERT INTO tf_settings VALUES ('show_server_load','1');
INSERT INTO tf_settings VALUES ('loadavg_path','/proc/loadavg');
INSERT INTO tf_settings VALUES ('days_to_keep','30');
INSERT INTO tf_settings VALUES ('minutes_to_keep','3');
INSERT INTO tf_settings VALUES ('rss_cache_min','20');
INSERT INTO tf_settings VALUES ('page_refresh','60');
INSERT INTO tf_settings VALUES ('default_theme','default');
INSERT INTO tf_settings VALUES ('default_language','lang-english.php');
INSERT INTO tf_settings VALUES ('debug_sql','1');
INSERT INTO tf_settings VALUES ('die_when_done','False');
INSERT INTO tf_settings VALUES ('sharekill','0');
INSERT INTO tf_settings VALUES ('pythonCmd','/usr/bin/python');
INSERT INTO tf_settings VALUES ('searchEngine','TorrentSpy');
INSERT INTO tf_settings VALUES ('TorrentSpyGenreFilter','a:1:{i:0;s:0:\"\";}');
INSERT INTO tf_settings VALUES ('TorrentBoxGenreFilter','a:1:{i:0;s:0:\"\";}');
INSERT INTO tf_settings VALUES ('TorrentPortalGenreFilter','a:1:{i:0;s:0:\"\";}');
INSERT INTO tf_settings VALUES ('enable_metafile_download','1');
INSERT INTO tf_settings VALUES ('enable_file_priority','1');
INSERT INTO tf_settings VALUES ('searchEngineLinks','a:5:{s:7:\"isoHunt\";s:11:\"isohunt.com\";s:7:\"NewNova\";s:11:\"newnova.org\";s:10:\"TorrentBox\";s:14:\"torrentbox.com\";s:13:\"TorrentPortal\";s:17:\"torrentportal.com\";s:10:\"TorrentSpy\";s:14:\"torrentspy.com\";}');
INSERT INTO tf_settings VALUES ('maxcons','40');
INSERT INTO tf_settings VALUES ('showdirtree','1');
INSERT INTO tf_settings VALUES ('maxdepth','0');
INSERT INTO tf_settings VALUES ('enable_multiops','1');
INSERT INTO tf_settings VALUES ('enable_wget','1');
INSERT INTO tf_settings VALUES ('enable_multiupload','1');
INSERT INTO tf_settings VALUES ('enable_xfer','1');
INSERT INTO tf_settings VALUES ('enable_public_xfer','1');
INSERT INTO tf_settings VALUES ('bin_grep','/bin/grep');
INSERT INTO tf_settings VALUES ('bin_netstat','/bin/netstat');
INSERT INTO tf_settings VALUES ('bin_php','/usr/bin/php');
INSERT INTO tf_settings VALUES ('bin_awk','/usr/bin/awk');
INSERT INTO tf_settings VALUES ('bin_du','/usr/bin/du');
INSERT INTO tf_settings VALUES ('bin_wget','/usr/bin/wget');
INSERT INTO tf_settings VALUES ('bin_unrar','/usr/bin/unrar');
INSERT INTO tf_settings VALUES ('bin_unzip','/usr/bin/unzip');
INSERT INTO tf_settings VALUES ('bin_cksfv','/usr/bin/cksfv');
INSERT INTO tf_settings VALUES ('bin_uudeview','/usr/local/bin/uudeview');
INSERT INTO tf_settings VALUES ('btclient','tornado');
INSERT INTO tf_settings VALUES ('btclient_tornado_options','');
INSERT INTO tf_settings VALUES ('btclient_transmission_bin','/usr/local/bin/transmissioncli');
INSERT INTO tf_settings VALUES ('btclient_transmission_options','');
INSERT INTO tf_settings VALUES ('metainfoclient','btshowmetainfo.py');
INSERT INTO tf_settings VALUES ('enable_restrictivetview','1');
INSERT INTO tf_settings VALUES ('perlCmd','/usr/bin/perl');
INSERT INTO tf_settings VALUES ('ui_displayfluxlink','1');
INSERT INTO tf_settings VALUES ('ui_dim_main_w','900');
INSERT INTO tf_settings VALUES ('enable_bigboldwarning','1');
INSERT INTO tf_settings VALUES ('enable_goodlookstats','1');
INSERT INTO tf_settings VALUES ('ui_displaylinks','1');
INSERT INTO tf_settings VALUES ('ui_displayusers','1');
INSERT INTO tf_settings VALUES ('xfer_total','0');
INSERT INTO tf_settings VALUES ('xfer_month','0');
INSERT INTO tf_settings VALUES ('xfer_week','0');
INSERT INTO tf_settings VALUES ('xfer_day','0');
INSERT INTO tf_settings VALUES ('enable_bulkops','1');
INSERT INTO tf_settings VALUES ('week_start','Monday');
INSERT INTO tf_settings VALUES ('month_start','1');
INSERT INTO tf_settings VALUES ('hack_multiupload_rows','6');
INSERT INTO tf_settings VALUES ('hack_goodlookstats_settings','63');
INSERT INTO tf_settings VALUES ('enable_dereferrer','1');
INSERT INTO tf_settings VALUES ('auth_type','0');
INSERT INTO tf_settings VALUES ('index_page_connections','1');
INSERT INTO tf_settings VALUES ('index_page_stats','1');
INSERT INTO tf_settings VALUES ('index_page_sortorder','dd');
INSERT INTO tf_settings VALUES ('index_page_settings','1266');
INSERT INTO tf_settings VALUES ('bin_sockstat','/usr/bin/sockstat');
INSERT INTO tf_settings VALUES ('nice_adjust','0');
INSERT INTO tf_settings VALUES ('xfer_realtime','1');
INSERT INTO tf_settings VALUES ('skiphashcheck','0');
INSERT INTO tf_settings VALUES ('enable_umask','0');
INSERT INTO tf_settings VALUES ('enable_sorttable','1');
INSERT INTO tf_settings VALUES ('drivespacebar','tf');
INSERT INTO tf_settings VALUES ('bin_vlc','/usr/local/bin/vlc');
INSERT INTO tf_settings VALUES ('debuglevel','0');
INSERT INTO tf_settings VALUES ('docroot','/var/www/');
INSERT INTO tf_settings VALUES ('enable_index_ajax_update_silent','0');
INSERT INTO tf_settings VALUES ('enable_index_ajax_update_users','1');
INSERT INTO tf_settings VALUES ('wget_ftp_pasv','0');
INSERT INTO tf_settings VALUES ('wget_limit_retries','3');
INSERT INTO tf_settings VALUES ('wget_limit_rate','0');
INSERT INTO tf_settings VALUES ('enable_index_ajax_update_title','1');
INSERT INTO tf_settings VALUES ('enable_index_ajax_update_list','1');
INSERT INTO tf_settings VALUES ('enable_index_meta_refresh','0');
INSERT INTO tf_settings VALUES ('enable_index_ajax_update','0');
INSERT INTO tf_settings VALUES ('index_ajax_update','10');
INSERT INTO tf_settings VALUES ('transferStatsType','ajax');
INSERT INTO tf_settings VALUES ('transferStatsUpdate','5');
INSERT INTO tf_settings VALUES ('auth_basic_realm','torrentflux-b4rt');
INSERT INTO tf_settings VALUES ('servermon_update','5');
INSERT INTO tf_settings VALUES ('enable_home_dirs','1');
INSERT INTO tf_settings VALUES ('path_incoming','incoming');
INSERT INTO tf_settings VALUES ('enable_tmpl_cache','0');
INSERT INTO tf_settings VALUES ('btclient_mainline_options','');
INSERT INTO tf_settings VALUES ('bandwidthbar','tf');
INSERT INTO tf_settings VALUES ('display_seeding_time','1');
INSERT INTO tf_settings VALUES ('ui_displaybandwidthbars','1');
INSERT INTO tf_settings VALUES ('bandwidth_down','10240');
INSERT INTO tf_settings VALUES ('bandwidth_up','10240');
INSERT INTO tf_settings VALUES ('webapp_locked','0');
INSERT INTO tf_settings VALUES ('enable_btclient_chooser','1');
INSERT INTO tf_settings VALUES ('transfer_profiles','3');
INSERT INTO tf_settings VALUES ('transfer_customize_settings','2');
INSERT INTO tf_settings VALUES ('transferHosts','0');
INSERT INTO tf_settings VALUES ('pagetitle','torrentflux-b4rt');
INSERT INTO tf_settings VALUES ('enable_sharekill','1');
INSERT INTO tf_settings VALUES ('transfer_window_default','transferStats');
INSERT INTO tf_settings VALUES ('index_show_seeding','1');
INSERT INTO tf_settings VALUES ('enable_personal_settings','1');
INSERT INTO tf_settings VALUES ('enable_nzbperl','0');
INSERT INTO tf_settings VALUES ('nzbperl_badAction','0');
INSERT INTO tf_settings VALUES ('nzbperl_server','');
INSERT INTO tf_settings VALUES ('nzbperl_user','');
INSERT INTO tf_settings VALUES ('nzbperl_pw','');
INSERT INTO tf_settings VALUES ('nzbperl_threads','0');
INSERT INTO tf_settings VALUES ('nzbperl_conn','1');
INSERT INTO tf_settings VALUES ('nzbperl_rate','0');
INSERT INTO tf_settings VALUES ('nzbperl_create','0');
INSERT INTO tf_settings VALUES ('nzbperl_options','');
INSERT INTO tf_settings VALUES ('fluazu_host','localhost');
INSERT INTO tf_settings VALUES ('fluazu_port','6884');
INSERT INTO tf_settings VALUES ('fluazu_secure','0');
INSERT INTO tf_settings VALUES ('fluazu_user','');
INSERT INTO tf_settings VALUES ('fluazu_pw','');
INSERT INTO tf_settings VALUES ('fluxd_dbmode','php');
INSERT INTO tf_settings VALUES ('fluxd_loglevel','0');
INSERT INTO tf_settings VALUES ('fluxd_Fluxinet_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Qmgr_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Rssad_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Watch_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Trigger_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Maintenance_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Fluxinet_port','3150');
INSERT INTO tf_settings VALUES ('fluxd_Qmgr_interval','15');
INSERT INTO tf_settings VALUES ('fluxd_Qmgr_maxTotalTransfers','5');
INSERT INTO tf_settings VALUES ('fluxd_Qmgr_maxUserTransfers','2');
INSERT INTO tf_settings VALUES ('fluxd_Rssad_interval','1800');
INSERT INTO tf_settings VALUES ('fluxd_Rssad_jobs','');
INSERT INTO tf_settings VALUES ('fluxd_Watch_interval','120');
INSERT INTO tf_settings VALUES ('fluxd_Watch_jobs','');
INSERT INTO tf_settings VALUES ('fluxd_Maintenance_interval','600');
INSERT INTO tf_settings VALUES ('fluxd_Maintenance_trestart','0');
INSERT INTO tf_settings VALUES ('fluxd_Trigger_interval','600');
--
-- tf_settings_dir
--
CREATE TABLE tf_settings_dir (
tf_key VARCHAR(255) NOT NULL default '',
tf_value TEXT NOT NULL,
PRIMARY KEY (tf_key)
) ENGINE = MYISAM ;
INSERT INTO tf_settings_dir VALUES ('dir_public_read','1');
INSERT INTO tf_settings_dir VALUES ('dir_public_write','0');
INSERT INTO tf_settings_dir VALUES ('dir_enable_chmod','1');
INSERT INTO tf_settings_dir VALUES ('enable_dirstats','1');
INSERT INTO tf_settings_dir VALUES ('enable_maketorrent','1');
INSERT INTO tf_settings_dir VALUES ('dir_maketorrent_default','tornado');
INSERT INTO tf_settings_dir VALUES ('enable_file_download','1');
INSERT INTO tf_settings_dir VALUES ('enable_view_nfo','1');
INSERT INTO tf_settings_dir VALUES ('package_type','tar');
INSERT INTO tf_settings_dir VALUES ('enable_sfvcheck','1');
INSERT INTO tf_settings_dir VALUES ('enable_rar','1');
INSERT INTO tf_settings_dir VALUES ('enable_move','0');
INSERT INTO tf_settings_dir VALUES ('enable_rename','1');
INSERT INTO tf_settings_dir VALUES ('move_paths','');
INSERT INTO tf_settings_dir VALUES ('dir_restricted','lost+found:CVS:Temporary Items:Network Trash Folder:TheVolumeSettingsFolder');
INSERT INTO tf_settings_dir VALUES ('enable_vlc','1');
INSERT INTO tf_settings_dir VALUES ('vlc_port','8080');
--
-- tf_settings_stats
--
CREATE TABLE tf_settings_stats (
tf_key VARCHAR(255) NOT NULL default '',
tf_value TEXT NOT NULL,
PRIMARY KEY (tf_key)
) ENGINE = MYISAM ;
INSERT INTO tf_settings_stats VALUES ('stats_enable_public','0');
INSERT INTO tf_settings_stats VALUES ('stats_show_usage','1');
INSERT INTO tf_settings_stats VALUES ('stats_deflate_level','9');
INSERT INTO tf_settings_stats VALUES ('stats_txt_delim',';');
INSERT INTO tf_settings_stats VALUES ('stats_default_header','0');
INSERT INTO tf_settings_stats VALUES ('stats_default_type','all');
INSERT INTO tf_settings_stats VALUES ('stats_default_format','xml');
INSERT INTO tf_settings_stats VALUES ('stats_default_attach','0');
INSERT INTO tf_settings_stats VALUES ('stats_default_compress','0');
Ge?ndert von DrTukTuk (27.11.2013 um 18:13 Uhr) |
|||||||||||
|
|
|
|
27.11.2013, 17:49
|
#4 | |||||||||||
|
Erfahrener Benutzer
Registriert seit: 09.01.2012
Ort: Zwischen RAM und SSD
Alter: 35
Beitr?ge: 275
Abgegebene Danke: 195
Erhielt 30 Danke für 4 Beiträge
Downloads: 125
Uploads: 0 Nachrichten: 306 Renommee-Modifikator:
402 |
NEIN nich so
PHP-Code:
PHP-Code:
|
|||||||||||
|
|
|
|
19.08.2014, 10:31
|
#5 | |||||||||||
|
Neuling
Registriert seit: 19.08.2014
Beitr?ge: 2
Abgegebene Danke: 0
Erhielt 0 Danke für 0 Beiträge
Downloads: 0
Uploads: 0 Nachrichten: 0 Renommee-Modifikator:
0 |
Hallo,
ich bin neu hier und habe das Forum nur endeckt, da ich den gleichen fehler bekomme. Leider habe ich es noch nicht ganz gerafft was bei mir noch falsch ist. Vielleicht kann mir einer helfen. Wenn ich das direkt über die php-Oberfläche einfüge. Dann kommt keine Fehlermeldung. Nur beim ausführen der setup datei. Code:
-- -----------------------------------------------------------------------------
-- $Id: mysql_torrentflux-b4rt-1.0.sql 1504 2006-11-07 14:34:11Z b4rt $
-- -----------------------------------------------------------------------------
--
-- MySQL-File for 'torrentflux-b4rt-1.0'.
--
-- This Stuff is provided 'as-is'. In no way will the authors be held
-- liable for any damages to your soft- or hardware from this.
-- -----------------------------------------------------------------------------
--
-- tf_cookies
--
CREATE TABLE tf_cookies (
cid int(5) NOT NULL auto_increment,
uid int(10) NOT NULL default '0',
host VARCHAR(255) default NULL,
data VARCHAR(255) default NULL,
PRIMARY KEY (cid)
) ENGINE=MyISAM;
--
-- tf_links
--
CREATE TABLE tf_links (
lid int(10) NOT NULL auto_increment,
url VARCHAR(255) NOT NULL default '',
sitename VARCHAR(255) NOT NULL default 'Old Link',
sort_order TINYINT(3) UNSIGNED default '0',
PRIMARY KEY (lid)
) ENGINE=MyISAM;
INSERT INTO tf_links VALUES (NULL,'http://tf-b4rt.berlios.de/','tf-b4rt','0');
--
-- tf_log
--
CREATE TABLE tf_log (
cid int(14) NOT NULL auto_increment,
user_id VARCHAR(32) NOT NULL default '',
file VARCHAR(200) NOT NULL default '',
action VARCHAR(200) NOT NULL default '',
ip VARCHAR(15) NOT NULL default '',
ip_resolved VARCHAR(200) NOT NULL default '',
user_agent VARCHAR(200) NOT NULL default '',
time VARCHAR(14) NOT NULL default '0',
PRIMARY KEY (cid)
) ENGINE=MyISAM;
--
-- tf_messages
--
CREATE TABLE tf_messages (
mid int(10) NOT NULL auto_increment,
to_user VARCHAR(32) NOT NULL default '',
from_user VARCHAR(32) NOT NULL default '',
message TEXT,
IsNew int(11) default NULL,
ip VARCHAR(15) NOT NULL default '',
time VARCHAR(14) NOT NULL default '0',
force_read TINYINT(1) default '0',
PRIMARY KEY (mid)
) ENGINE=MyISAM;
--
-- tf_rss
--
CREATE TABLE tf_rss (
rid int(10) NOT NULL auto_increment,
url VARCHAR(255) NOT NULL default '',
PRIMARY KEY (rid)
) ENGINE=MyISAM;
--
-- tf_users
--
CREATE TABLE tf_users (
uid int(10) NOT NULL auto_increment,
user_id VARCHAR(32) NOT NULL default '',
password VARCHAR(34) NOT NULL default '',
hits int(10) NOT NULL default '0',
last_visit VARCHAR(14) NOT NULL default '0',
time_created VARCHAR(14) NOT NULL default '0',
user_level TINYINT(1) NOT NULL default '0',
hide_offline TINYINT(1) NOT NULL default '0',
theme VARCHAR(100) NOT NULL default 'default',
language_file VARCHAR(60) default 'lang-english.php',
state TINYINT(1) NOT NULL default '1',
PRIMARY KEY (uid)
) ENGINE=MyISAM;
--
-- tf_torrents
--
CREATE TABLE tf_torrents (
torrent VARCHAR(255) NOT NULL default '',
running ENUM('0','1') NOT NULL default '0',
rate SMALLINT(4) NOT NULL default '0',
drate SMALLINT(4) NOT NULL default '0',
maxuploads TINYINT(3) unsigned NOT NULL default '0',
superseeder ENUM('0','1') NOT NULL default '0',
runtime ENUM('True','False') NOT NULL default 'False',
sharekill SMALLINT(4) unsigned NOT NULL default '0',
minport SMALLINT(5) unsigned NOT NULL default '0',
maxport SMALLINT(5) unsigned NOT NULL default '0',
maxcons SMALLINT(4) unsigned NOT NULL default '0',
savepath VARCHAR(255) NOT NULL default '',
btclient VARCHAR(32) NOT NULL default 'tornado',
hash VARCHAR(40) DEFAULT '' NOT NULL,
datapath VARCHAR(255) NOT NULL default '',
PRIMARY KEY (torrent)
) ENGINE=MyISAM;
--
-- tf_trprofiles
--
CREATE TABLE tf_trprofiles (
id MEDIUMINT(8) NOT NULL auto_increment,
name VARCHAR(255) NOT NULL default '',
owner INT(10) NOT NULL default '0',
public ENUM('0','1') NOT NULL default '0',
rate SMALLINT(4) NOT NULL default '0',
drate SMALLINT(4) NOT NULL default '0',
maxuploads TINYINT(3) unsigned NOT NULL default '0',
superseeder ENUM('0','1') NOT NULL default '0',
runtime ENUM('True','False') NOT NULL default 'False',
sharekill SMALLINT(4) unsigned NOT NULL default '0',
minport SMALLINT(5) unsigned NOT NULL default '0',
maxport SMALLINT(5) unsigned NOT NULL default '0',
maxcons SMALLINT(4) unsigned NOT NULL default '0',
rerequest MEDIUMINT(8) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM;
--
-- tf_torrent_totals
--
CREATE TABLE tf_torrent_totals (
tid VARCHAR(40) NOT NULL default '',
uptotal BIGINT(80) NOT NULL default '0',
downtotal BIGINT(80) NOT NULL default '0',
PRIMARY KEY (tid)
) ENGINE=MyISAM;
--
-- tf_xfer
--
CREATE TABLE tf_xfer (
user_id VARCHAR(32) NOT NULL default '',
date DATE NOT NULL default '0000-00-00',
download BIGINT(80) NOT NULL default '0',
upload BIGINT(80) NOT NULL default '0',
PRIMARY KEY (user_id,date)
) ENGINE=MyISAM;
--
-- tf_settings_user
--
CREATE TABLE tf_settings_user (
uid INT(10) NOT NULL,
tf_key VARCHAR(255) NOT NULL default '',
tf_value TEXT NOT NULL
) ENGINE=MyISAM;
--
-- tf_settings
--
CREATE TABLE tf_settings (
tf_key VARCHAR(255) NOT NULL default '',
tf_value TEXT NOT NULL,
PRIMARY KEY (tf_key)
) ENGINE=MyISAM;
INSERT INTO tf_settings VALUES ('path','/usr/local/torrentflux/');
INSERT INTO tf_settings VALUES ('advanced_start','1');
INSERT INTO tf_settings VALUES ('max_upload_rate','10');
INSERT INTO tf_settings VALUES ('max_download_rate','0');
INSERT INTO tf_settings VALUES ('max_uploads','4');
INSERT INTO tf_settings VALUES ('minport','49160');
INSERT INTO tf_settings VALUES ('maxport','49300');
INSERT INTO tf_settings VALUES ('rerequest_interval','1800');
INSERT INTO tf_settings VALUES ('enable_search','1');
INSERT INTO tf_settings VALUES ('show_server_load','1');
INSERT INTO tf_settings VALUES ('loadavg_path','/proc/loadavg');
INSERT INTO tf_settings VALUES ('days_to_keep','30');
INSERT INTO tf_settings VALUES ('minutes_to_keep','3');
INSERT INTO tf_settings VALUES ('rss_cache_min','20');
INSERT INTO tf_settings VALUES ('page_refresh','60');
INSERT INTO tf_settings VALUES ('default_theme','default');
INSERT INTO tf_settings VALUES ('default_language','lang-english.php');
INSERT INTO tf_settings VALUES ('debug_sql','1');
INSERT INTO tf_settings VALUES ('torrent_dies_when_done','False');
INSERT INTO tf_settings VALUES ('sharekill','0');
INSERT INTO tf_settings VALUES ('pythonCmd','/usr/bin/python');
INSERT INTO tf_settings VALUES ('searchEngine','TorrentSpy');
INSERT INTO tf_settings VALUES ('TorrentSpyGenreFilter','a:1:{i:0;s:0:\"\";}');
INSERT INTO tf_settings VALUES ('TorrentBoxGenreFilter','a:1:{i:0;s:0:\"\";}');
INSERT INTO tf_settings VALUES ('TorrentPortalGenreFilter','a:1:{i:0;s:0:\"\";}');
INSERT INTO tf_settings VALUES ('enable_torrent_download','1');
INSERT INTO tf_settings VALUES ('enable_file_priority','1');
INSERT INTO tf_settings VALUES ('searchEngineLinks','a:5:{s:7:\"isoHunt\";s:11:\"isohunt.com\";s:7:\"NewNova\";s:11:\"newnova.org\";s:10:\"TorrentBox\";s:14:\"torrentbox.com\";s:13:\"TorrentPortal\";s:17:\"torrentportal.com\";s:10:\"TorrentSpy\";s:14:\"torrentspy.com\";}');
INSERT INTO tf_settings VALUES ('maxcons','40');
INSERT INTO tf_settings VALUES ('enable_mrtg','1');
INSERT INTO tf_settings VALUES ('showdirtree','1');
INSERT INTO tf_settings VALUES ('maxdepth','0');
INSERT INTO tf_settings VALUES ('enable_multiops','1');
INSERT INTO tf_settings VALUES ('enable_wget','1');
INSERT INTO tf_settings VALUES ('enable_multiupload','1');
INSERT INTO tf_settings VALUES ('enable_xfer','1');
INSERT INTO tf_settings VALUES ('enable_public_xfer','1');
INSERT INTO tf_settings VALUES ('bin_grep','/bin/grep');
INSERT INTO tf_settings VALUES ('bin_netstat','/bin/netstat');
INSERT INTO tf_settings VALUES ('bin_php','/usr/bin/php');
INSERT INTO tf_settings VALUES ('bin_awk','/usr/bin/awk');
INSERT INTO tf_settings VALUES ('bin_du','/usr/bin/du');
INSERT INTO tf_settings VALUES ('bin_wget','/usr/bin/wget');
INSERT INTO tf_settings VALUES ('bin_unrar','/usr/bin/unrar');
INSERT INTO tf_settings VALUES ('bin_unzip','/usr/bin/unzip');
INSERT INTO tf_settings VALUES ('bin_cksfv','/usr/bin/cksfv');
INSERT INTO tf_settings VALUES ('btclient','tornado');
INSERT INTO tf_settings VALUES ('btclient_tornado_options','');
INSERT INTO tf_settings VALUES ('btclient_transmission_bin','/usr/local/bin/transmissioncli');
INSERT INTO tf_settings VALUES ('btclient_transmission_options','');
INSERT INTO tf_settings VALUES ('metainfoclient','btshowmetainfo.py');
INSERT INTO tf_settings VALUES ('enable_restrictivetview','1');
INSERT INTO tf_settings VALUES ('perlCmd','/usr/bin/perl');
INSERT INTO tf_settings VALUES ('ui_displayfluxlink','1');
INSERT INTO tf_settings VALUES ('ui_dim_main_w','900');
INSERT INTO tf_settings VALUES ('enable_bigboldwarning','1');
INSERT INTO tf_settings VALUES ('enable_goodlookstats','1');
INSERT INTO tf_settings VALUES ('ui_displaylinks','1');
INSERT INTO tf_settings VALUES ('ui_displayusers','1');
INSERT INTO tf_settings VALUES ('xfer_total','0');
INSERT INTO tf_settings VALUES ('xfer_month','0');
INSERT INTO tf_settings VALUES ('xfer_week','0');
INSERT INTO tf_settings VALUES ('xfer_day','0');
INSERT INTO tf_settings VALUES ('enable_bulkops','1');
INSERT INTO tf_settings VALUES ('week_start','Monday');
INSERT INTO tf_settings VALUES ('month_start','1');
INSERT INTO tf_settings VALUES ('hack_multiupload_rows','6');
INSERT INTO tf_settings VALUES ('hack_goodlookstats_settings','63');
INSERT INTO tf_settings VALUES ('enable_dereferrer','1');
INSERT INTO tf_settings VALUES ('auth_type','0');
INSERT INTO tf_settings VALUES ('index_page_connections','1');
INSERT INTO tf_settings VALUES ('index_page_stats','1');
INSERT INTO tf_settings VALUES ('index_page_sortorder','dd');
INSERT INTO tf_settings VALUES ('index_page_settings','1266');
INSERT INTO tf_settings VALUES ('bin_sockstat','/usr/bin/sockstat');
INSERT INTO tf_settings VALUES ('nice_adjust','0');
INSERT INTO tf_settings VALUES ('xfer_realtime','1');
INSERT INTO tf_settings VALUES ('skiphashcheck','0');
INSERT INTO tf_settings VALUES ('enable_umask','0');
INSERT INTO tf_settings VALUES ('enable_sorttable','1');
INSERT INTO tf_settings VALUES ('drivespacebar','tf');
--
INSERT INTO tf_settings VALUES ('bin_vlc','/usr/local/bin/vlc');
INSERT INTO tf_settings VALUES ('debuglevel','0');
INSERT INTO tf_settings VALUES ('docroot','/var/www/');
INSERT INTO tf_settings VALUES ('enable_index_ajax_update_silent','0');
INSERT INTO tf_settings VALUES ('enable_index_ajax_update_users','1');
INSERT INTO tf_settings VALUES ('wget_ftp_pasv','0');
INSERT INTO tf_settings VALUES ('wget_limit_retries','3');
INSERT INTO tf_settings VALUES ('wget_limit_rate','0');
INSERT INTO tf_settings VALUES ('enable_index_ajax_update_title','1');
INSERT INTO tf_settings VALUES ('enable_index_ajax_update_list','1');
INSERT INTO tf_settings VALUES ('enable_index_meta_refresh','0');
INSERT INTO tf_settings VALUES ('enable_index_ajax_update','0');
INSERT INTO tf_settings VALUES ('index_ajax_update','10');
INSERT INTO tf_settings VALUES ('details_type','ajax');
INSERT INTO tf_settings VALUES ('details_update','5');
INSERT INTO tf_settings VALUES ('auth_basic_realm','torrentflux-b4rt');
INSERT INTO tf_settings VALUES ('servermon_update','5');
INSERT INTO tf_settings VALUES ('enable_home_dirs','1');
INSERT INTO tf_settings VALUES ('path_incoming','incoming');
INSERT INTO tf_settings VALUES ('enable_tmpl_cache','0');
INSERT INTO tf_settings VALUES ('btclient_mainline_options','');
INSERT INTO tf_settings VALUES ('bandwidthbar','tf');
INSERT INTO tf_settings VALUES ('display_seeding_time','1');
INSERT INTO tf_settings VALUES ('ui_displaybandwidthbars','1');
INSERT INTO tf_settings VALUES ('bandwidth_down','10240');
INSERT INTO tf_settings VALUES ('bandwidth_up','10240');
INSERT INTO tf_settings VALUES ('webapp_locked','0');
INSERT INTO tf_settings VALUES ('enable_btclient_chooser','1');
INSERT INTO tf_settings VALUES ('enable_transfer_profile','1');
INSERT INTO tf_settings VALUES ('transfer_profile_level','2');
INSERT INTO tf_settings VALUES ('transfer_customize_settings','1');
INSERT INTO tf_settings VALUES ('downloadhosts','0');
INSERT INTO tf_settings VALUES ('pagetitle','torrentflux-b4rt');
INSERT INTO tf_settings VALUES ('fluxd_dbmode','php');
INSERT INTO tf_settings VALUES ('fluxd_loglevel','0');
INSERT INTO tf_settings VALUES ('fluxd_Fluxinet_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Qmgr_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Rssad_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Watch_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Trigger_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Clientmaint_enabled','0');
INSERT INTO tf_settings VALUES ('fluxd_Fluxinet_port','3150');
INSERT INTO tf_settings VALUES ('fluxd_Qmgr_interval','15');
INSERT INTO tf_settings VALUES ('fluxd_Qmgr_maxTotalTorrents','5');
INSERT INTO tf_settings VALUES ('fluxd_Qmgr_maxUserTorrents','2');
INSERT INTO tf_settings VALUES ('fluxd_Rssad_interval','1800');
INSERT INTO tf_settings VALUES ('fluxd_Rssad_jobs','');
INSERT INTO tf_settings VALUES ('fluxd_Watch_interval','120');
INSERT INTO tf_settings VALUES ('fluxd_Watch_jobs','');
INSERT INTO tf_settings VALUES ('fluxd_Trigger_interval','600');
INSERT INTO tf_settings VALUES ('fluxd_Clientmaint_interval','600');
--
-- tf_settings_dir
--
CREATE TABLE tf_settings_dir (
tf_key VARCHAR(255) NOT NULL default '',
tf_value TEXT NOT NULL,
PRIMARY KEY (tf_key)
) ENGINE=MyISAM;
INSERT INTO tf_settings_dir VALUES ('dir_public_read','1');
INSERT INTO tf_settings_dir VALUES ('dir_public_write','0');
INSERT INTO tf_settings_dir VALUES ('dir_enable_chmod','1');
INSERT INTO tf_settings_dir VALUES ('enable_dirstats','1');
INSERT INTO tf_settings_dir VALUES ('enable_maketorrent','1');
INSERT INTO tf_settings_dir VALUES ('dir_maketorrent_default','tornado');
INSERT INTO tf_settings_dir VALUES ('enable_file_download','1');
INSERT INTO tf_settings_dir VALUES ('enable_view_nfo','1');
INSERT INTO tf_settings_dir VALUES ('package_type','tar');
INSERT INTO tf_settings_dir VALUES ('enable_sfvcheck','1');
INSERT INTO tf_settings_dir VALUES ('enable_rar','1');
INSERT INTO tf_settings_dir VALUES ('enable_move','0');
INSERT INTO tf_settings_dir VALUES ('enable_rename','1');
INSERT INTO tf_settings_dir VALUES ('move_paths','');
INSERT INTO tf_settings_dir VALUES ('dir_restricted','lost+found:CVS:Temporary Items:Network Trash Folder:TheVolumeSettingsFolder');
INSERT INTO tf_settings_dir VALUES ('enable_vlc','1');
INSERT INTO tf_settings_dir VALUES ('vlc_port','8080');
--
-- tf_settings_stats
--
CREATE TABLE tf_settings_stats (
tf_key VARCHAR(255) NOT NULL default '',
tf_value TEXT NOT NULL,
PRIMARY KEY (tf_key)
) ENGINE=MyISAM;
INSERT INTO tf_settings_stats VALUES ('stats_enable_public','0');
INSERT INTO tf_settings_stats VALUES ('stats_show_usage','1');
INSERT INTO tf_settings_stats VALUES ('stats_deflate_level','9');
INSERT INTO tf_settings_stats VALUES ('stats_txt_delim',';');
INSERT INTO tf_settings_stats VALUES ('stats_default_header','0');
INSERT INTO tf_settings_stats VALUES ('stats_default_type','all');
INSERT INTO tf_settings_stats VALUES ('stats_default_format','xml');
INSERT INTO tf_settings_stats VALUES ('stats_default_attach','0');
INSERT INTO tf_settings_stats VALUES ('stats_default_compress','0');
Ge?ndert von Lex (20.08.2014 um 12:41 Uhr) Grund: Quote => Codebox |
|||||||||||
|
|
|
|
20.08.2014, 10:13
|
#6 | |||||||||||
|
Erfahrener Benutzer
Registriert seit: 14.01.2009
Ort: hinter den sieben bergen
Beitr?ge: 411
Abgegebene Danke: 53
Erhielt 14 Danke für 4 Beiträge
Downloads: 69
Uploads: 1 Nachrichten: 0 Renommee-Modifikator:
668 |
oben ist eindeutig beschrieben was zu ändern ist !
|
|||||||||||
|
|
|
|
20.08.2014, 17:23
|
#7 | |||||||||||
|
Neuling
Registriert seit: 19.08.2014
Beitr?ge: 2
Abgegebene Danke: 0
Erhielt 0 Danke für 0 Beiträge
Downloads: 0
Uploads: 0 Nachrichten: 0 Renommee-Modifikator:
0 |
Hi,
ich habe es aus meiner Sicht überall geändert. weisst du denn was vielleicht noch fehlt. Ich finde den Fehler einfach nicht. Bzw. habe ich versuch nach diesem threat hier zu arbeiten. |
|||||||||||
|
|
|
|
20.08.2014, 18:40
|
#8 |
|
Master Coder
Registriert seit: 10.03.2008
Ort: Zuhause
Beitr?ge: 8.037
Abgegebene Danke: 1.199
Erhielt 2.928 Danke für 266 Beiträge
Downloads: 28
Uploads: 9 Nachrichten: 357 Renommee-Modifikator:
10 |
hier gibt es noch andere beiträge über den flux unter anderem auch zur installation!
Den es geht auch ohne die setup datei würde ich mal nach einer der anleitungen vorgehen dann sollte es funzen
__________________
Code:
require_once('include/gehirn.php');
session_start();
if(empty($action))
{
echo "<td class="tablea">Kopf anstrengen und Nachdenken</td>";
}
else
{
echo "<td class="tablea">Kopf zuviel angestrenkt nun Qualmt er ;)</td>";
}
|
|
|
|
|
20.08.2014, 23:00
|
#9 | |||||||||||
|
Erfahrener Benutzer
Registriert seit: 07.06.2008
Ort: 3. Datei links nach der index.php
Beitr?ge: 172
Abgegebene Danke: 38
Erhielt 3 Danke für 1 Beitrag
Downloads: 12
Uploads: 0 Nachrichten: 0 Renommee-Modifikator:
194 |
Entweder ohne setup.php oder aber in der setup.php
PHP-Code:
[OT] oder so... Habe fertig zu dem ressourcen fressendem teil, ich bevorzuge r-torrent mit ru-torrent. [/OT]
__________________
Wer Rechtschreibfehler findet, darf sich beschenkt fühlen  Ich übernehme keine Gewähr für Gewehre die ich nicht selber zerlegt habe |
|||||||||||
|
|
|
|
21.08.2014, 16:59
|
#10 | ||||||||||||
|
Profi
Registriert seit: 12.01.2011
Ort: @home
Alter: 42
Beitr?ge: 584
Abgegebene Danke: 99
Erhielt 136 Danke für 35 Beiträge
Downloads: 4
Uploads: 0 Nachrichten: 747 Renommee-Modifikator:
1641 |
Zitat:
mfg 
__________________
 il faut de tout pour faire un monde.
Ge?ndert von Lex (23.08.2014 um 00:23 Uhr) Grund: Rechtschreibfehler |
||||||||||||
|
|
|
|
| Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, G?ste: 1) | |
|
|
Linear-Darstellung
