Can you post the fulll error code on that?

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT username FROM precisi_forums.user WHERE referrerid = '1' AND referrerid > 0
mysql error: Table 'precisi_forums.user' doesn't exist

mysql error number: 1146

Date: Friday 21st of May 2004 12:27:15 AM
Script: http://www.precisionmuscle.org/testv...s/referals.php
Referer: http://www.precisionmuscle.org/testvb/forums/index.php?
Username: armani1072
IP Address: 205.201.132.83

Try this - If u used vb3 as the prefix, put in either:

SELECT username FROM vb3.user WHERE referrerid = '1' AND referrerid > 0

or

SELECT username FROM precisi_forums.vb3.user WHERE referrerid = '1' AND referrerid > 0

Because we got past the first query, so now it's only hanging up on the last query... BOOFO if you have any suggestions, please post them... :)

What is the actual table_prefix in the config.php?

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'precisi_forums';



// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = 'vB3';

Try chnage the user table name in the query to this:

vb3user

and see if it runs that way.

if were to change in config.php to not have a prefix and upload it will that update everything? this is too much trouble i should have never put a prefix.

NO that wouldn't change everything. Since you installed vbulletin with a prefix, you would have to completely reinstall it with no prefix to never use one again. :( But try like BOOFO said it is really easy.

Try vB3.user for the table in the query
or try vb3.user depending on the cap locks if you used them or not
or last try vb3user in that last query... :)

That should make it work

I got the same problem, white screen. I've redo everything but still get the empty screen. I'm using vb 3.0.3. Please help...

ETASLIM,

Please re-download the zip file, I have updated the coding to work with people who are using databases with prefix's. Try this, if it still doesn't work please let me know. Sorry I have been out of town for the past few days...

Thanks,
GSPOT