Members   Search      Help    Register    Login    Home
Home » Support Forums for PMBT 1.X » General Help » setup
icon13.gif  setup [message #1431] Thu, 25 October 2007 11:38 Go to next message
krisis007 is currently offline krisis007  Latvia
Messages: 1
Registered: October 2007
Leecher
When i setup your tracker this error comes out











Step 4: Installing Database


Notice: Undefined property: sql_db::$query_result in C:\xampp\htdocs\setup\udl\mysql.php on line 206
Checking files...OK
Creating table addedrequests...OK
Creating table admin_forum...OK
Creating table avps...OK
Creating table bans...OK
Creating table blackjack...OK
Creating table bonus...OK
Creating table cards...OK
Creating table casino...OK
Creating table casino_bets...OK
Creating table casino_config...OK
Creating table categories...OK
Creating table comments...OK
Creating table comments_notify...OK
Creating table complaints...OK
Creating table config...OK
Creating table countries...OK
Creating table download_completed...OK
Creating table faq...OK
Creating table files...OK
Creating table filter...OK
Creating table flashscores...OK
Creating table lottery_config...OK
Creating table offers...OK
Creating table offervotes...OK
Creating table offres_config...OK
Creating table online_users...OK
Creating table paypal...OK
Creating table peers...OK
Creating table pollanswers...OK
Creating table polls...OK
Creating table privacy_backup...OK
Creating table privacy_file...OK
Creating table privacy_global...OK
Creating table private_messages...OK
Creating table private_messages_blacklist...OK
Creating table private_messages_bookmarks...OK
Creating table ratings...OK
Creating table ratiowarn...OK
Creating table ratiowarn_config...OK
Creating table requests...OK
Creating table requist_config...OK
Creating table rules...OK
Creating table search_text...OK
Creating table seeder_notify...OK
Creating table shouts...OK
Creating table smiles...OK
Creating table snatched...OK
Creating table thanks...OK
Creating table tickets...OK
Creating table torrents...OK
Creating table trackers...OK
Creating table users...OK
Installing default smileys...OK
Installing default smileys...OK
Creating default categories...OK
Creating default Rules
Error executing SQL Query INSERT INTO `torrent_rules` VALUES (1, 2, 'hdghsuuw'); INSERT INTO `torrent_rules` VALUES (2, 3, 'g...
Error ID: 1064
Error Message: 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 '; INSERT INTO `torrent_rules` VALUES (2, 3, 'gfgdh'); INSERT INTO `torrent_rul' at line 1
Notice: Undefined property: sql_db::$query_result in C:\xampp\htdocs\setup\udl\mysql.php on line 206
A fatal error occurred during setup. Please fix the above error and try running Setup again, or refreshing your browser.

Notice: Undefined property: sql_db::$query_result in C:\xampp\htdocs\setup\udl\mysql.php on line 206

Notice: Undefined property: sql_db::$query_result in C:\xampp\htdocs\setup\udl\mysql.php on line 154



Copyright 2005-2006 phpMyBitTorrent Team. All rights reserved. Distributed under GNU/GPL license.






Re: setup [message #1433 is a reply to message #1431] Thu, 25 October 2007 11:54 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
what version are you setting up?

http://a.imageshack.us/img831/5562/mybikes.png
Re: setup [message #1574 is a reply to message #1431] Mon, 26 November 2007 17:28 Go to previous messageGo to next message
lordmat is currently offline lordmat  Germany
Messages: 1
Registered: November 2007
Leecher
i have the same problem with this version -> phpMyBitTorrent-FulMod

what happens?


mysql -version 5.0.44



edit: ive included the install.sql with phpmyadmin to my database and the config_default.sql too.

but ive i open my browser and go to the tracker it comes

phpMyBitTorrent not correctly installed! Ensure you have run setup.php or config_default.sql!!

Is there an Option to switch "install on/off?" Smile


ive changed the config.php and now it works, but with some bugs/sql erros

First one is one start page.

Quote:

Error executing SQL Query SELECT torrent_torrents.*, IF(torrent_torrents.numratings < '', NULL, ROUND(torrent_torrents.ratingsum / torrent_torrents.numratings, 1)) AS rating, torrent_categories.name AS cat_name, torrent_categories.image AS cat_pic, U.username, IF(U.name IS NULL, U.username, U.name) as user_name, U.level as user_level FROM torrent_torrents LEFT JOIN torrent_categories ON category = torrent_categories.id LEFT JOIN torrent_users U ON torrent_torrents.owner = U.id WHERE visible = 'yes' AND banned = 'no' AND torrent_torrents.password IS NULL ORDER BY torrent_torrents.evidence DESC, torrent_torrents.added DESC LIMIT 0,;
Error ID: 1064
Error Message: 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 '' at line 1


The next one is when i want to register me, the default settings of member is 100 but the page said to me

Quote:

Limmet reached
Sorry, The current user account limit (0) has been reached. Inactive accounts are pruned all the time, please check back again later...


something wrong with the database? Smile


i think the problem is php5 on my server, damn! Smile


thx in advanced

cheers
lordmat

[Updated on: Mon, 26 November 2007 19:09]

Report message to a moderator

Re: setup [message #1575 is a reply to message #1574] Mon, 26 November 2007 20:41 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
your data base is not set up properly!
you need to run the updated install you can find it on sourceforge.net here http://sourceforge.net/project/showfiles.php?group_id=129993
or here http://downloads.sourceforge.net/phpmybittorrent/PMBTMODEDse tup.rar?use_mirror=easynews


http://a.imageshack.us/img831/5562/mybikes.png
Re: setup [message #1750 is a reply to message #1431] Sun, 03 February 2008 14:02 Go to previous messageGo to next message
kikokku is currently offline kikokku  Thailand
Messages: 1
Registered: February 2008
Leecher
same my problem

i use ii6
php 4.4.6
mysql 4.018
phpMyBitTorrentV1.2.2

can't continue



Creating table rules...
Error executing SQL Query CREATE TABLE `torrent_rules` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `text` text(225) NOT NULL, `public` enum('yes','no') NOT NULL default 'yes', `level` enum('user','premium','moderator','admin') NOT NULL default 'user', PRIMARY KEY (`id`) ) TYPE=MyISAM;
Error ID: 1064
Error Message: 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 '(225) NOT NULL, `public` enum('yes','no') NOT NULL default '
Notice: Undefined property: query_result in D:\setup\phpMyBitTorrentV1.2.2\phpMyBitTorrent\html\setup\ud l\mysql.php on line 206


A fatal error occurred during setup. Please fix the above error and try running Setup again, or refreshing your browser.


Notice: Undefined property: query_result in D:\setup\phpMyBitTorrentV1.2.2\phpMyBitTorrent\html\setup\ud l\mysql.php on line 206

Notice: Undefined property: query_result in D:\setup\phpMyBitTorrentV1.2.2\phpMyBitTorrent\html\setup\ud l\mysql.php on line 154

[Updated on: Sun, 03 February 2008 14:03]

Report message to a moderator

Re: setup [message #1751 is a reply to message #1750] Sun, 03 February 2008 15:21 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
open html/setup/sql/install-MySQL4.sql
and chang
CREATE TABLE `#prefix#_rules` (
   `id` int(11) NOT NULL auto_increment,
   `title` varchar(255) NOT NULL default '',
   `text` text(225) NOT NULL,
   `public` enum('yes','no') NOT NULL default 'yes',
   `level` enum('user','premium','moderator','admin') NOT NULL default 'user',
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

to
CREATE TABLE `torrent_rules` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `text` tinytext NOT NULL,
  `public` enum('yes','no') NOT NULL default 'yes',
  `level` enum('user','premium','moderator','admin') NOT NULL default 'user',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM


http://a.imageshack.us/img831/5562/mybikes.png
Re: setup [message #1846 is a reply to message #1751] Wed, 12 March 2008 05:28 Go to previous messageGo to next message
titanstorm is currently offline titanstorm  Canada
Messages: 6
Registered: March 2008
Location: Calgary
Leecher
joeroberts wrote on Sun, 03 February 2008 08:21

open html/setup/sql/install-MySQL4.sql
and chang
CREATE TABLE `#prefix#_rules` (
   `id` int(11) NOT NULL auto_increment,
   `title` varchar(255) NOT NULL default '',
   `text` text(225) NOT NULL,
   `public` enum('yes','no') NOT NULL default 'yes',
   `level` enum('user','premium','moderator','admin') NOT NULL default 'user',
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

to
CREATE TABLE `torrent_rules` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `text` tinytext NOT NULL,
  `public` enum('yes','no') NOT NULL default 'yes',
  `level` enum('user','premium','moderator','admin') NOT NULL default 'user',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM





Operating system Linux
Service Status Click to View
Kernel version 2.6.9-023stab046.2-smp
Machine Type i686
Apache version 1.3.39 (Unix)
PERL version 5.8.8
Path to PERL /usr/bin/perl
Path to sendmail /usr/sbin/sendmail
Installed Perl Modules Click to View
PHP version 4.4.7
MySQL version 4.1.22-standard-log
cPanel Build 11.18.2-RELEASE 21613
Theme cPanel X v2.6.0
Documentation Click to View
cPanel Pro 1.0 (RC1)


Tried what you suggested and now I get this...

Creating table ratings...OK

Creating table ratiowarn...OK

Creating table ratiowarn_config...OK

Creating table requests...OK

Creating table requist_config...OK

Creating table search_text...
Error executing SQL Query CREATE TABLE `torrent_rules` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `text` tinytext NOT NULL, `public` enum('yes','no') NOT NULL default 'yes', `level` enum('user','premium','moderator','admin') NOT NULL default 'user', PRIMARY KEY (`id`) ) TYPE=MyISAM CREATE TABLE `cdntorrent_search_text` ( `id` int(20) unsigned NOT NULL auto_increment, `text` varchar(25) NOT NULL default '', `hit` int(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `text` (`text`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Error ID: 1064
Error Message: 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 'CREATE TABLE `cdntorrent_search_text` ( `id` int(20) unsigned NOT NULL auto_i' at line 12

A fatal error occurred during setup. Please fix the above error and try running Setup again, or refreshing your browser.

[Updated on: Wed, 12 March 2008 05:33]

Report message to a moderator

Re: setup [message #1847 is a reply to message #1846] Wed, 12 March 2008 11:45 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
CREATE TABLE `torrent_rules` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `text` tinytext NOT NULL,
  `public` enum('yes','no') NOT NULL default 'yes',
  `level` enum('user','premium','moderator','admin') NOT NULL default 'user',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

sorry forgot the ;


http://a.imageshack.us/img831/5562/mybikes.png
Re: setup [message #1848 is a reply to message #1847] Thu, 13 March 2008 05:27 Go to previous messageGo to next message
titanstorm is currently offline titanstorm  Canada
Messages: 6
Registered: March 2008
Location: Calgary
Leecher
Yeah I picked up on that and with fixing that I get this...

Creating table users...OK

Installing default smileys...OK

Installing default smileys...OK

Creating default categories...OK

Creating default Rules
Error executing SQL Query INSERT INTO `torrent_rules` SET `title` = 'Downloading rules - By not following...
Error ID: 1064
Error Message: 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 '; INSERT INTO `torrent_rules` SET `title` = 'how do you get files', `text` = '' at line 1

A fatal error occurred during setup. Please fix the above error and try running Setup again, or refreshing your browser.

Not sure what the hell I'm missing... seems like I am the only one with this issue??
Re: setup [message #1849 is a reply to message #1848] Thu, 13 March 2008 11:13 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
change your setup/steps/4.php with this
<?php
/*
*-------------------------------phpMyBitTorrent--------------------------------*
*--- The Ultimate BitTorrent Tracker and BMS (Bittorrent Management System) ---*
*--------------   Created By Antonio Anzivino (aka DJ Echelon)   --------------*
*-------------               http://www.p2pmania.it               -------------*
*------------ Based on the Bit Torrent Protocol made by Bram Cohen ------------*
*-------------              http://www.bittorrent.com             -------------*
*------------------------------------------------------------------------------*
*------------------------------------------------------------------------------*
*--   This program is free software; you can redistribute it and/or modify   --*
*--   it under the terms of the GNU General Public License as published by   --*
*--   the Free Software Foundation; either version 2 of the License, or      --*
*--   (at your option) any later version.                                    --*
*--                                                                          --*
*--   This program is distributed in the hope that it will be useful,        --*
*--   but WITHOUT ANY WARRANTY; without even the implied warranty of         --*
*--   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          --*
*--   GNU General Public License for more details.                           --*
*--                                                                          --*
*--   You should have received a copy of the GNU General Public License      --*
*--   along with this program; if not, write to the Free Software            --*
*-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA --*
*--                                                                          --*
*------------------------------------------------------------------------------*
*------              ©2005 phpMyBitTorrent Development Team              ------*
*-----------               http://phpmybittorrent.com               -----------*
*------------------------------------------------------------------------------*
*/

require_once("../include/configdata.php");
require_once(
"udl/database.php");


function
btsqlerror($sql) { //Returns SQL Error
        
global $db;
        
$err = Array();
        
$err = $db->sql_error();
        echo
"<br />\n";
        echo
"<font class=\"err\">";
        echo
_btsqlerror1.$sql;
        echo
"<br />";
        echo
_btsqlerror2.$err["code"];
        echo
"<br />";
        echo
_btsqlerror3.$err["message"];
        echo
"</font>";
        
$db->sql_query("",END_TRANSACTION);
}

echo
"<p align=\"center\"><font size=\"5\">"._step4."</font></p>\n";
echo
"<p>&nbsp</p>";

$db = new sql_db($db_host, $db_user, $db_pass, $db_name, $db_persistency);

$can_proceed = true;
$db->sql_query("",BEGIN_TRANSACTION);

echo
"<p>"._checkingfiles;
foreach(
explode(":","install-".$db_type.":smiles:categories-".$language) as $sqlscript) {
        if (!
is_readable("sql/".$sqlscript.".sql")) {
                
$can_proceed = false;
                echo
"<br /><font class=\"err\">".str_replace("**file**","install-".$db_type.".sql",_step4fnotfound)."</font>";
        }
}
if (
$can_proceed) echo "<font class=\ok\">OK</font>";
echo
"</p>";


#Creating Tables
if ($can_proceed) {
        
$fp = @fopen("sql/install-".$db_type.".sql","r");
        
$installscript = "";
        while (!
feof($fp)) $installscript .= @fgets($fp,1000);
        @
fclose($fp);
        unset(
$fp);
        
//echo "<p><textarea rows=\"4\" cols=\"65\">".htmlspecialchars($installscript)."</textarea></p>";
        //preg_match_all('/^(?P<query>CREATE TABLE `(?P<table>[\\w]*)`[^;]*;)$/sim', $installscript, $scripts);
        
$scripts = explode(";",$installscript);
        
//print_r($scripts);
        
unset($installscript);
        foreach (
$scripts as $script) {
                if (!
preg_match('/^CREATE TABLE `#prefix#_([\\w]*)`[^;]*$/sim', $script, $matches)) continue;
                
$script .= ";"; //Splitting string removes semicolon
                
$script = str_replace("#prefix#",$db_prefix,$script);
                echo
"<p>".str_replace("**table**",$matches[1],_tblcreating);
                if (!
$db->sql_query($script)) {
                        
$can_proceed = false;
                        
btsqlerror($script);
                        break;
                } else echo
"<font class=\"ok\">OK</font>";
                echo
"</p>\n";
                unset(
$script, $matches);
        }
        unset(
$scripts);
}

#Inserting default smileys
if ($can_proceed) {
        
$fp = @fopen("sql/smiles.sql","r");
        
$installscript = "";
        while (!
feof($fp)) $installscript .= @fgets($fp,1000);
        @
fclose($fp);
        unset(
$fp);
        
$installscript = str_replace("#prefix#",$db_prefix,$installscript);
        
//echo "<p><textarea rows=\"4\" cols=\"65\">".htmlspecialchars($installscript)."</textarea></p>\n";
        
echo "<p>"._installsmiles;
        if (!
$db->sql_query($installscript)) {
                
$can_proceed = false;
                
btsqlerror(substr($installscript,0,100)."..."); //Shorted for better display
        
} else echo "<font class=\"ok\">OK</font>";
        echo
"</p>\n";
        unset(
$installscript);
}
#Inserting default Pay-pal
if ($can_proceed) {
        
$fp = @fopen("sql/pay-pal.sql","r");
        
$installscript = "";
        while (!
feof($fp)) $installscript .= @fgets($fp,1000);
        @
fclose($fp);
        unset(
$fp);
        
$installscript = str_replace("#prefix#",$db_prefix,$installscript);
        
//echo "<p><textarea rows=\"4\" cols=\"65\">".htmlspecialchars($installscript)."</textarea></p>\n";
        
echo "<p>"._installsmiles;
        if (!
$db->sql_query($installscript)) {
                
$can_proceed = false;
                
btsqlerror(substr($installscript,0,100)."..."); //Shorted for better display
        
} else echo "<font class=\"ok\">OK</font>";
        echo
"</p>\n";
        unset(
$installscript);
}

if (
$can_proceed) {
        
$fp = @fopen("sql/categories-".$language.".sql","r");
        
$installscript = "";
        while (!
feof($fp)) $installscript .= @fgets($fp,1000);
        @
fclose($fp);
        unset(
$fp);
        
$installscript = str_replace("#prefix#",$db_prefix,$installscript);
        
//echo "<p><textarea rows=\"4\" cols=\"65\">".htmlspecialchars($installscript)."</textarea></p>\n";
        
echo "<p>"._installcategories;
        if (!
$db->sql_query($installscript)) {
                
$can_proceed = false;
                
btsqlerror(substr($installscript,0,100)."..."); //Shorted for better display
        
} else echo "<font class=\"ok\">OK</font>";
        echo
"</p>\n";
        unset(
$installscript);
}


if (
$can_proceed) {
        echo
"<p>"._step4complete."</p>";
        echo
"<p><input type=\"submit\" value=\""._nextstep."\" /></p>\n";
        echo
"<input type=\"hidden\" name=\"step\" value=\"5\" />\n";
} else {
        echo
"<p>"._step4failed."</p>";
}

$db->sql_query("",END_TRANSACTION);
$db->sql_close();

?>


http://a.imageshack.us/img831/5562/mybikes.png
Re: setup [message #1853 is a reply to message #1849] Sun, 16 March 2008 19:25 Go to previous messageGo to next message
idolsmasher is currently offline idolsmasher  Canada
Messages: 4
Registered: March 2008
Leecher
Hi!
I too am getting the "undefined property" errors on the same lines in "mysql.php". It shows that the tables and things were created ok but these messages show up outside that list. When I go to the login page after setup, none of the graphics appear and everything is white and washed out and much of the text only appears if you highlight it.

I tried the fixes you mention here but they did not work. Any other ideas? I'm trying to set this up with phpbb3. Thanks!
Re: setup [message #1854 is a reply to message #1853] Sun, 16 March 2008 19:29 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
are you using the modded version? if so what version of the modd

http://a.imageshack.us/img831/5562/mybikes.png

[Updated on: Sun, 16 March 2008 19:50]

Report message to a moderator

Re: setup [message #1855 is a reply to message #1431] Sun, 16 March 2008 19:52 Go to previous messageGo to next message
idolsmasher is currently offline idolsmasher  Canada
Messages: 4
Registered: March 2008
Leecher
I think so but I'm not sure. The .rar file is named phpMyBitorrent-hacks and I got it from the phpbb forums.

Just so you know, I can do edits but I'm not a coder. I really don't know much about the actual coding itself unfortunately. Help is much appreciated. Smile
Re: setup [message #1856 is a reply to message #1855] Sun, 16 March 2008 19:54 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
can you give me the addy so that I may see this error of a white page

http://a.imageshack.us/img831/5562/mybikes.png
Re: setup [message #1857 is a reply to message #1856] Sun, 16 March 2008 19:58 Go to previous messageGo to next message
idolsmasher is currently offline idolsmasher  Canada
Messages: 4
Registered: March 2008
Leecher
Well, I deleted the tables and re did the install with the changes in this thread and didn't complete the setup because the errors came up again. I will do the rest of the setup now and get back to you shortly.
Re: setup [message #1858 is a reply to message #1431] Sun, 16 March 2008 20:07 Go to previous messageGo to next message
idolsmasher is currently offline idolsmasher  Canada
Messages: 4
Registered: March 2008
Leecher
On setup I get another message now:

Error executing SQL Query
INSERT INTO torrent_config (sitename, siteurl, cookiedomain, cookiepath, admin_email, language, welcome_message, announce_text, allow_html, torrent_prefix, torrent_per_page, onlysearch, max_torrent_size, announce_interval, announce_interval_min, dead_torrent_interval, minvotes, time_tracker_update, best_limit, down_limit, torrent_complaints, torrent_global_privacy, disclaimer_check, gfx_check, upload_level, download_level, announce_level, max_num_file, max_share_size, global_min_ratio, autoscrape, min_num_seed_e, min_size_seed_e, allow_backup_tracker, stealthmode, upload_dead, invites_open, invite_only, max_members, auto_clean, free_dl, addprivate, GIGSA, RATIOA, WAITA, GIGSB, RATIOB, WAITB, GIGSC, RATIOC, WAITC, GIGSD, RATIOD, WAITD, version) VALUES .....etc

Error ID: 1146
Error Message: Table '********.torrent_config' doesn't exist

Looks like I need to go back to the original files before the edits to get back to where I was.

[Updated on: Sun, 16 March 2008 20:08]

Report message to a moderator

Re: setup [message #1859 is a reply to message #1858] Sun, 16 March 2008 20:19 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
looks like you need to start from begining and not use any of the changes from the forum as they do not apply to modded version

http://a.imageshack.us/img831/5562/mybikes.png
Re: setup [message #1860 is a reply to message #1849] Wed, 19 March 2008 04:29 Go to previous messageGo to next message
titanstorm is currently offline titanstorm  Canada
Messages: 6
Registered: March 2008
Location: Calgary
Leecher
[quote title=joeroberts wrote on Thu, 13 March 2008 04:13]change your setup/steps/4.php with this...
quote]


It worked!! You da MAN... for step 4 Crying or Very Sad

Notice: Undefined variable: sub_rewrite_engine in /home/cdntorr/public_html/setup/steps/5.php on line 336

Notice: Undefined variable: sub_minupload_size_file in /home/cdntorr/public_html/setup/steps/5.php on line 361

Notice: Undefined variable: RATIOA in /home/cdntorr/public_html/setup/steps/5.php on line 372

Step 5: phpMyBitTorrent Configuration



Error executing SQL Query

INSERT INTO cdntorr_config (sitename, siteurl, cookiedomain, admin_email, language, welcome_message, announce_text, allow_html, rewrite_engine, torrent_prefix, torrent_per_page, onlysearch, max_torrent_size, announce_interval, announce_interval_min, dead_torrent_interval, minvotes, time_tracker_update, best_limit, down_limit, torrent_complaints, torrent_global_privacy, disclaimer_check, gfx_check, upload_level, download_level, announce_level, max_num_file, max_share_size, global_min_ratio, autoscrape, min_num_seed_e, min_size_seed_e, allow_backup_tracker, stealthmode, upload_dead, invites_open, invite_only, max_members, auto_clean, free_dl, addprivate, GIGSA, RATIOA, WAITA, GIGSB, RATIOB, WAITB, GIGSC, RATIOC, WAITC, GIGSD, RATIOD, WAITD, version) VALUES ('Canadian Bittorrent', 'http://canadiantorrent.com', 'canadiantorrent.com', 'webmaster@canadiantorrent.com', 'english', '', '', 'true', 'false', '', '10', 'false', '0', '300', '0', '1500', '0', '3600', '0', '0', 'false', 'false', 'true', 'true', 'user', 'all', 'all', '0', '0', '0.00', 'true', '0', '0', 'true', 'false', 'false', 'false', 'false', '50000', '600', 'false', 'false', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.2.1');

Error ID: 1054
Error Message: Unknown column 'torrent_prefix' in 'field list'

Now you have to configure your new phpMyBitTorrent Tracker. The following are all configuration parameters available, that allow you to customize every aspect of the tracker. However, you will need only to make sure that the basic parameters are set correctly. You will always be able to change the settings by logging in as an Administrator into your Config Panel.

Notice: Use of undefined constant _admresetbtn - assumed '_admresetbtn' in /home/cdntorr/public_html/setup/steps/5.php on line 410

It is really weird... I didn't have this issue when I installed the "original" version... then I cleared the server and trying to install the modded version now I am having a lot of issues. Hope it isn't user issue... either way thank you VERY much for your help.

[Updated on: Wed, 19 March 2008 04:35]

Report message to a moderator

Re: setup [message #1861 is a reply to message #1860] Wed, 19 March 2008 06:08 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
something dont look rite there I disable rewrite_engine for install because it is not 100% complete and dont work on all servers and this install that you are useing has it you need to check your install files and make sure that you have the proper version from here
wich is the latest version.
I well be updating this version by the start of next week because i have done some more clean up on the theme and worked on Markup Validation for WC3.


http://a.imageshack.us/img831/5562/mybikes.png
Re: setup [message #1862 is a reply to message #1861] Wed, 19 March 2008 16:11 Go to previous messageGo to next message
titanstorm is currently offline titanstorm  Canada
Messages: 6
Registered: March 2008
Location: Calgary
Leecher
Alright sounds good. I will wipe out EVERYTHING from the server and try fresh. If it fails, I will wait for your new version and try that. Thanks yet again!
Re: setup [message #1867 is a reply to message #1862] Wed, 19 March 2008 22:49 Go to previous messageGo to next message
titanstorm is currently offline titanstorm  Canada
Messages: 6
Registered: March 2008
Location: Calgary
Leecher
Okay, I wiped the server and uploaded the files from a fresh download. First of all, people, make sure you change the permissions on the folder! That was my first mistake :S But, I still get this error without changing anything. I will try your fix for step 4 to see if it makes any difference but I don't think it will. I will wait for the new version and try it.


Step 5: phpMyBitTorrent Configuration

Error executing SQL Query

INSERT INTO cdntorrent_config (sitename, siteurl, cookiedomain, admin_email, language, welcome_message, announce_text, allow_html, torrent_prefix, torrent_per_page, onlysearch, max_torrent_size, announce_interval, announce_interval_min, dead_torrent_interval, minvotes, time_tracker_update, best_limit, down_limit, torrent_complaints, torrent_global_privacy, disclaimer_check, gfx_check, upload_level, download_level, announce_level, max_num_file, max_share_size, global_min_ratio, autoscrape, min_num_seed_e, min_size_seed_e, allow_backup_tracker, stealthmode, upload_dead, invites_open, invite_only, max_members, auto_clean, free_dl, addprivate, GIGSA, RATIOA, WAITA, GIGSB, RATIOB, WAITB, GIGSC, RATIOC, WAITC, GIGSD, RATIOD, WAITD, version) VALUES ('Canadian Bittorrent', 'http://canadiantorrent.com', 'canadiantorrent.com', 'webmaster@canadiantorrent.com', 'english', '', '', 'true', '', '10', 'false', '0', '300', '0', '1500', '0', '3600', '0', '0', 'false', 'false', 'true', 'true', 'user', 'all', 'all', '0', '0', '0.00', 'true', '0', '0', 'true', 'false', 'false', 'false', 'false', '50000', '600', 'false', 'false', '0', '0.00', '0', '0', '0.00', '0', '0', '0.00', '0', '0', '0.00', '0', '1.2.1');

Error ID: 1054
Error Message: Unknown column 'torrent_prefix' in 'field list'

Notice: Use of undefined constant _admresetbtn - assumed '_admresetbtn' in /home/cdntorr/public_html/setup/steps/5.php on line 409

[Updated on: Wed, 19 March 2008 22:52]

Report message to a moderator

Re: setup [message #1868 is a reply to message #1431] Fri, 21 March 2008 03:40 Go to previous messageGo to next message
titanstorm is currently offline titanstorm  Canada
Messages: 6
Registered: March 2008
Location: Calgary
Leecher
People, if you are having the same issue that I was having make sure you pay attention to step 5! Some values are by default blank and they MUST be filled in (Torrent Prefix and Tracker Message). Once I did this everything is working fine.

Re: setup [message #1881 is a reply to message #1868] Tue, 25 March 2008 00:25 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
I well fix this on next release

http://a.imageshack.us/img831/5562/mybikes.png
Re: setup [message #2118 is a reply to message #1431] Wed, 18 June 2008 10:36 Go to previous messageGo to next message
brunix is currently offline brunix  Italy
Messages: 2
Registered: June 2008
Leecher
(Escuse me for my english, I'm italian...)
Hi, I have these error on step 4, when the automatic setup attempt to installing the database (all setup are OK...).
I have installed the Mod Pack "phpMyBitTorrent-hacks.rar" but this is the result:


Notice: Undefined property: query_result in c:\program files\easyphp1-8\www\brunix-bt\setup\udl\mysql.php on line 206

Controllo file...OK

Creazione della tabella addedrequests...OK

Creazione della tabella admin_forum...OK

Creazione della tabella avps...OK

Creazione della tabella bans...OK

Creazione della tabella blackjack...OK

Creazione della tabella bonus...OK

Creazione della tabella cards...OK

Creazione della tabella casino...OK

Creazione della tabella casino_bets...OK

Creazione della tabella casino_config...OK

Creazione della tabella categories...OK

Creazione della tabella comments...OK

Creazione della tabella comments_notify...OK

Creazione della tabella complaints...OK

Creazione della tabella config...OK

Creazione della tabella countries...OK

Creazione della tabella download_completed...OK

Creazione della tabella faq...OK

Creazione della tabella files...OK

Creazione della tabella filter...OK

Creazione della tabella flashscores...OK

Creazione della tabella lottery_config...OK

Creazione della tabella offers...OK

Creazione della tabella offervotes...OK

Creazione della tabella offres_config...OK

Creazione della tabella online_users...OK

Creazione della tabella paypal...OK

Creazione della tabella peers...OK

Creazione della tabella pollanswers...OK

Creazione della tabella polls...OK

Creazione della tabella privacy_backup...OK

Creazione della tabella privacy_file...OK

Creazione della tabella privacy_global...OK

Creazione della tabella private_messages...OK

Creazione della tabella private_messages_blacklist...OK

Creazione della tabella private_messages_bookmarks...OK

Creazione della tabella ratings...OK

Creazione della tabella ratiowarn...OK

Creazione della tabella ratiowarn_config...OK

Creazione della tabella requests...OK

Creazione della tabella requist_config...OK

Creazione della tabella rules...OK

Creazione della tabella search_text...OK

Creazione della tabella seeder_notify...OK

Creazione della tabella shouts...OK

Creazione della tabella smiles...OK

Creazione della tabella snatched...OK

Creazione della tabella thanks...OK

Creazione della tabella tickets...OK

Creazione della tabella torrents...OK

Creazione della tabella trackers...OK

Creazione della tabella users...OK

Installazione emoticon predefinite...OK

Installazione emoticon predefinite...OK

Creazione delle categorie predefinite...OK

Creating default Offers ConfigsOK

Creating Bonuse SettingsOK

Creating Black Jack CardsOK

Creating default Casino ConfigsOK

Creating Country FlagsOK

Creating default Forum ConfigsOK

Creating default Lottery ConfigsOK

Creating default FAQ'sOK

Creating default RulesOK

L'installazione del database è stata completata con successo. Adesso puoi configurare il tuo tracker in base alle tue preferenze.




Notice: Undefined property: query_result in c:\program files\easyphp1-8\www\brunix-bt\setup\udl\mysql.php on line 206

Notice: Undefined property: query_result in c:\program files\easyphp1-8\www\brunix-bt\setup\udl\mysql.php on line 154



I have this configuration:
Apache 1.3.33 - PHP 4.3.10 - MySQL 4.1.9 - phpMyAdmin 2.6.1
(I've used EasyPHP 1.8 for Windows)

Thanks for anyone help me!

[Updated on: Wed, 18 June 2008 10:45]

Report message to a moderator

Re: setup [message #2119 is a reply to message #2118] Wed, 18 June 2008 23:03 Go to previous messageGo to next message
brunix is currently offline brunix  Italy
Messages: 2
Registered: June 2008
Leecher
I have solved the problem of step 4, I've selected PHP version up to 4.1.

Now I have another problem on step 5 (there are errors in all settings page):


Warning: constant(): Couldn't find constant _admpminupload_file_size in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpfree_dlexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpfree_dl in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpfree_dl in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpaddprivateexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpaddprivate in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpaddprivate in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpwait_timeexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpwait_time in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpwait_time in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpGIGSAexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpGIGSA in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpGIGSA in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpRATIOAexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpRATIOA in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpRATIOA in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpWAITAexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpWAITA in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpWAITA in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpGIGSBexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpGIGSB in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpGIGSB in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpRATIOBexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpRATIOB in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpRATIOB in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpWAITBexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpWAITB in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpWAITB in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpGIGSCexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpGIGSC in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpGIGSC in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpRATIOCexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpRATIOC in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpRATIOC in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpWAITCexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpWAITC in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpWAITC in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpGIGSDexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpGIGSD in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpGIGSD in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpRATIODexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpRATIOD in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpRATIOD in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 60

Warning: constant(): Couldn't find constant _admpWAITDexplain in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58

Warning: constant(): Couldn't find constant _admpWAITD in c:\program files\easyphp1-8\www\brunix-bt\setup\steps\5.php on line 58


Help me!! Sad
Re: setup [message #2120 is a reply to message #2119] Thu, 19 June 2008 07:14 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
where did you down load the version you are installing??

http://a.imageshack.us/img831/5562/mybikes.png
Re: setup [message #2138 is a reply to message #1431] Sun, 13 July 2008 14:47 Go to previous message
Revan is currently offline Revan  Czech Republic
Messages: 125
Registered: April 2007
Super-Seeder
try to install in english, i think that might be the problem Smile
Previous Topic:mysql persistent connections
Next Topic:Torrent File Contents
Goto Forum:
  


Current Time: Wed Feb 08 12:06:57 GMT 2012

Total time taken to generate the page: 0.00998 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software