[Bigj85]

deleted all the old files,uninstalled and installed 2.1.0

everything went fine with setting it up,doing permissions etc.
but then when I try to go to the market I get this error Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT * FROM market_transactions AS mt CROSS JOIN ( SELECT marketid, COUNT(*) AS cnt FROM market_transactions GROUP BY marketid ORDER BY cnt DESC LIMIT 1) AS sq USING (marketid);

MySQL Error : Table 'inv4.market_transactions' doesn't exist
Error Number : 1146
Request Date : Sunday, May 16th 2010 @ 10:04:07 PM
Error Date : Sunday, May 16th 2010 @ 10:04:07 PM
Script : xxxxxxxxxxxxxxx/forum/market.php
Referrer : xxxxxxxxxxxxxxxxx/forum/forum.php
IP Address : xxxxxxxxxxxxxxx
Username : MKZ23
Classname : vB_Database
MySQL Version : 4.1.20

my table prefix is VB,inv4 is the db name,I'm not sure if its using the db name as a prefix or just not using the vb prefix but the table

the table "vbmarket_transactions" exists,any ideas of how I can quick fix this by making it look for the correct table.

btw the product looks great,I havent used it yet but I'm determined this is what I'll be using for my forum,thx


P.S. I took a look at the new main market.php file and noticed that "TABLE_PREFIX ." is missing where it used to be regarding fetching from the market_transactions table but I dont wanna go trying to fix something I know very little about