There something really unclear about the installation instructions for this MOD. I'm using a table prefix of "vb3_" for my forums. I want to maintain that structure for all forum-related tables, for obvious reasons. The instructions on do not explain how to handle prefixes so I created a "vb3_referrals" table rather than simply a "referrals" table.
Now when I load
http://www.bigblueball.com/forums/referrals.php I get the following error:
Code:
Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM vb3_user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 10
mysql error: Table 'bbb.user' doesn't exist
mysql error number: 1146
And yes, I edited line #28 of referrals.php to the correct path already (the readme.txt doesn't cover that either). As I understand this error message, it appears that the forum prefix is not being used for just part of the SQL command.