phpMyBitTorrent Project Forums: General Help

Members

Help

Home

Home » Support Forums for PMBT 1.X » General Help » Error creating tables

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

Error creating tables [message #1430]

Thu, 25 October 2007 10:44

easyups

Messages: 4
Registered: October 2007

Leecher

I've uploaded all files to my server, and tried to install the script, it went well till i got to installing database

something is wrong, but i can't get my hands on it

now the database is new, and it's embty

Checking PHP Version - 5.2.3 - OK
Checking Zlib - OK
Checking MySQL - OK - 5.0.15
Checking installed DOM XML - OK
Testing outgoing connections - OK
Checking Operating System - Linux

but i get this error

Step 4: Installing Database

 


Notice: Undefined property: sql_db::$query_result in /****/setup/udl/mysql.php on line 206

Checking files...OK

Creating table bans...
Error executing SQL Query CREATE TABLE `torrent_bans` ( `id` int
(11) unsigned NOT NULL auto_increment, `ipstart` int(10) 
unsigned NOT NULL default '0', `ipend` int(10) unsigned NOT 
NULL default '0', `reason` varchar(255) NOT NULL default '', 
`date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY 
KEY (`id`), UNIQUE KEY `ip_unique` (`ipstart`,`ipend`) ) 
TYPE=MyISAM;
Error ID: 1050
Error Message: Table 'torrent_bans' already exists
Notice: Undefined property: sql_db::$query_result in /****/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 /****/setup/udl/mysql.php on line 206

Notice: Undefined property: sql_db::$query_result in /****/setup/udl/mysql.php on line 154

any ideas?

[Updated on: Thu, 25 October 2007 10:45]

Report message to a moderator

Re: Error creating tables [message #1434 is a reply to message #1430]

Thu, 25 October 2007 11:57

joeroberts

Messages: 1971
Registered: June 2006
Location: U.S.A

Releaser
Da HacKer

Error Message: Table 'torrent_bans' already exists

this meens that the table is already created have you set this up or tried to more then one time?

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

Report message to a moderator

Re: Error creating tables [message #1435 is a reply to message #1434]

Thu, 25 October 2007 12:29

easyups

Messages: 4
Registered: October 2007

Leecher

Yes, i've tried to set it up on a previous database and it didn't work out

so i created a new database and tried it again.. but it didn't work

Report message to a moderator

Re: Error creating tables [message #1436 is a reply to message #1435]

Thu, 25 October 2007 12:35

joeroberts

Messages: 1971
Registered: June 2006
Location: U.S.A

Releaser
Da HacKer

Please try and delete bot data bases!
It seems that it is trying to cross over or you may have mistakenly used the same data base. Are you knowledgeable in data base functions? (just do a data base dump of all PMBT tables)

Report message to a moderator

Re: Error creating tables [message #1437 is a reply to message #1430]

Thu, 25 October 2007 13:23

easyups

Messages: 4
Registered: October 2007

Leecher

Sorry for your time m8, i've got it fixed Smile

but now there is another problem Sad

whenever i try to upload a torrent i get this message:

Fatal error: Uncaught exception 'DOMException' with 
message 'Invalid Character Error' 
in /****/include/extensions/domxml-php4-to-php5.php:87 Stack 
trace: #0 /****/include/extensions/domxml-php4-to-php5.php(87): 
DOMDocument->createElement('1de88f97cf728e8...') #1 /****/include/bencoder/bdecoder-domxml.php(151): 
php4DOMDocument->create_element('1de88f97cf728e8...') 
#2 /****/include/bencoder/bdecoder-domxml.php(72): 
BDec_dictionary(Object(php4DOMElement), 'd8:completei18e...') 
#3 /****/include/bencoder/bdecoder-domxml.php(159): BDec(Object
(php4DOMElement), 'd8:completei18e...') 
#4 /****/include/bencoder/bdecoder-domxml.php(72): 
BDec_dictionary(Object(php4DOMElement), 'd8:completei18e...') 
#5 /****/incl in /****/include/extensions/domxml-php4-to-
php5.php on line 87

what's that about?

thx for your help Smile

[Updated on: Thu, 25 October 2007 13:24]

Report message to a moderator

Re: Error creating tables [message #1438 is a reply to message #1437]

Thu, 25 October 2007 13:34

joeroberts

Messages: 1971
Registered: June 2006
Location: U.S.A

Releaser
Da HacKer

Are you using php>=5 and trying to upload a external torrent? (If so it well not work as PMBT does not support this at this time.)
PMBT only supports local torrents for this at this time as xml does not support the text generated by the scrape.

php>=5 uses xml
php4 uses dom xml

if you can down grade to php4

[Updated on: Thu, 25 October 2007 13:37]

Report message to a moderator

Re: Error creating tables [message #1439 is a reply to message #1430]

Thu, 25 October 2007 13:48

easyups

Messages: 4
Registered: October 2007

Leecher

yes, i'm using PHP >= 5, but what do you mean by ubloading XML?

i tried upliading a .torrent file

sorry, i'm new at this Embarassed

Report message to a moderator

Re: Error creating tables [message #1440 is a reply to message #1439]

Thu, 25 October 2007 13:56

joeroberts

Messages: 1971
Registered: June 2006
Location: U.S.A

Releaser
Da HacKer

Is the annouce for the torrent for your site or is it from another site?

this is what it should be for php >= 5

Quote:

www.yoursite.com/announce.php

not this

Quote:

www.mininova.org/announce.php

the later well only work on php < 5

Report message to a moderator

Re: Error creating tables [message #2131 is a reply to message #1430]

Wed, 02 July 2008 15:29

Shadow of Wishes

Messages: 1
Registered: July 2008

Leecher

Hey, i get this error and i don't know how to fix it:

Installing default smileys...OK

Installing default smileys...
Error executing SQL Query INSERT INTO `torrent_paypal` VALUES('http://www.yoursite.net','you@youraddy.com','0','0','0','','');...
Error ID: 1265
Error Message: Data truncated for column 'donation_block' at row 1

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

Report message to a moderator

Re: Error creating tables [message #3349 is a reply to message #1430]

Tue, 15 December 2009 10:24

raziq

Messages: 3
Registered: December 2009
Location: malaysia

Leecher

Checking files...OK

Creating table addedrequests...
Error executing SQL Query -- phpMyAdmin SQL Dump -- version 2.11.9.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 16, 2009 at 03:22 PM -- Server version: 5.0.75 -- PHP Version: 5.2.6-3ubuntu4.1 -- -- Database: `phpMyBitTorrent` -- -- -------------------------------------------------------- -- -- Table structure for table `torrent_addedrequests` -- CREATE TABLE `torrent_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`) ) ENGINE=MyISAM ;
Error ID:
Error Message:

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

Any ideas..

Report message to a moderator

Re: Error creating tables [message #3352 is a reply to message #3349]

Tue, 15 December 2009 13:33

joeroberts

Messages: 1971
Registered: June 2006
Location: U.S.A

Releaser
Da HacKer

what MySql version are you using? and which one did you select on setup?

Report message to a moderator

Re: Error creating tables [message #3353 is a reply to message #3352]

Wed, 16 December 2009 03:06

raziq

Messages: 3
Registered: December 2009
Location: malaysia

Leecher

i'm using mysql version 5. Anyway thanks for helping me..

This problem had solved..I delete the old database and create a new database.

The problem had fixed.Thanks for helping me. Smile

Report message to a moderator

Previous Topic:	How Many Simultaneous Users can phpMyBittorrent Handle
Next Topic:	Cant get past Stage 4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Feb 08 10:54:22 GMT 2012

Total time taken to generate the page: 0.00798 seconds

.:: Contact :: Home ::.