Members   Search      Help    Register    Login    Home
Home » Support Forums for PMBT 1.X » General Help » Torrent File Contents(SQL Database Error)
Torrent File Contents [message #2130] Tue, 01 July 2008 18:47 Go to next message
apease11 is currently offline apease11  United States
Messages: 3
Registered: June 2008
Leecher
When you go on my torrent site, http://tracker.peaseenterprises.com/ and click on a torrent and go down to Files you get an sql error. The error is:

Error executing SQL Query SELECT A.id as id, A.seeders, A.banned, A.leechers, A.info_hash, A.filename, UNIX_TIMESTAMP() - UNIX_TIMESTAMP(A.last_action) AS lastseed, A.numratings, A.name, IF(A.numratings < '0', NULL, ROUND(A.ratingsum / A.numratings, 1)) AS rating, A.save_as, A.descr, A.visible, A.size, A.added, A.views, A.downloaded, A.completed, A.type, A.numfiles, A.owner, A.ownertype, A.complaints, A.evidence, A.tracker, B.name AS cat_name, IF(C.name IS NULL, C.username, C.name) as ownername, A.tracker_update, IF(A.tracker_update>(sysdate()-INTERVAL 15 MINUTE), 0, 1) as can_tracker_update FROM torrent_torrents A LEFT JOIN torrent_categories B ON A.category = B.id LEFT JOIN torrent_users C ON A.owner = C.id WHERE A.id = '10';
Error ID: 0
Error Message: 


Can anyone help? My sql version is 4.0.45 comunity version. Thank you.
Re: Torrent File Contents [message #2139 is a reply to message #2130] Sun, 13 July 2008 14:49 Go to previous message
Revan is currently offline Revan  Czech Republic
Messages: 125
Registered: April 2007
Super-Seeder
can you check the table in database to see if there are data in it?
if so can you run this sql query in phpmyadmin or somewhere and see if it returns something or gives error?
Previous Topic:setup
Next Topic:PHP Issue
Goto Forum:
  


Current Time: Wed Feb 08 11:37:32 GMT 2012

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

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