vbtt3 error any help please

[dj_slim]

hi all ive setup vbtt3 and now if i click the links on the navbar i get this

Invalid SQL:
SELECT SUM(ulspeed) as ulspeedtot ,SUM(dlspeed) as dlspeedtot FROM 3peers WHERE peers.info_hash = 'af23ffe83f8c10d5ef8c08195a61f70b0cb36f9e';

MySQL Error  : Unknown table 'peers' in where clause
Error Number : 1109
Date         : Sunday, October 28th 2007 @ 12:43:45 PM
Script       : http://www.mysite.co.uk/torrents.php?
Referrer     : http://www.mysite.co.uk/forum.php
IP Address   : ********
Username     : brian
Classname    : vb_database

any help with this please thanks in advance

 

[sendog]

try to uninstall and install again

 

[dj_slim]

hi mate ive done this its no help its still the same

 

[sendog]

have you been installed VBTT3 or VBTT3 RC1?
beacuse... i can't remember... but i think i had installed VBTT3 RC1 and the same error was appeared

 

[dj_slim]

no mate VBTT3 from the start

 

[iCafe]

in torrents.php

line ~214 add prefix if you db have it.

$uspeeds = $db->query("SELECT SUM(ulspeed) as ulspeedtot ,SUM(dlspeed) as dlspeedtot FROM ". TABLE_PREFIX ."peers WHERE info_hash = '".$attach['info_hash']."'");

 

[dj_slim]

lol ive just removed the prefix from my config php and my sql dump working fine now thanks for the replys