phpMyBitTorrent Project Forums: Bug Reports » Unknown column 'completed' in 'field list'

Members

Help

Home

Home » Support Forums for PMBT 1.X » Bug Reports » Unknown column 'completed' in 'field list'

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

E-mail to friend

Unknown column 'completed' in 'field list' [message #2220]

Sat, 08 November 2008 22:11

cummie

Messages: 2
Registered: November 2008

Leecher

Hi all,

I installed the pmbt 2.0.2gold on my webspace.
The installation and configuration worked fine without
troubles.

Then I created a new user on the tracker.

After this step, I made with my local bt-client a new torrent which I uploaded to the tracker. Then I downloaded the new torrent and added it to the bt-client.

BUT now an error appeared:

My bt-client (utorrent) shows for the Tracker Status following string: Unknown column 'completed' in 'field list' .

And the tracker didnt show a seeder for this torrent.

How can I solve this?

Thx a lot

cummie

Report message to a moderator

Re: Unknown column 'completed' in 'field list' [message #2221 is a reply to message #2220]

Sun, 09 November 2008 03:07

joeroberts

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

Releaser
Da HacKer

Open announce.php go to line 518 and find

		   if (!$check AND $seeder == "yes")mysql_query("INSERT INTO ".$db_prefix."_snatched (torrent, torrentid, userid, ip, port, startdat, last_action, agent, torrent_name, torrent_category, finished, completed) VALUES ($torrentid, $torrentid, $uid, '".$ip."', $port, NOW(), NOW(), '" . $agent . "' , '" . addslashes($torrentname) . "', $torrentcategory, 'yes', NOW())")or err(mysql_error());

and replace with

		   if (!$check AND $seeder == "yes")mysql_query("INSERT INTO ".$db_prefix."_snatched (torrent, torrentid, userid, ip, port, startdat, last_action, agent, torrent_name, torrent_category, finished, completedat) VALUES ($torrentid, $torrentid, $uid, '".$ip."', $port, NOW(), NOW(), '" . $agent . "' , '" . addslashes($torrentname) . "', $torrentcategory, 'yes', NOW())")or err(mysql_error());