[tjdrico]

Originally Posted by TTG

As listed above .. !?

Got this error when looking at bet statistics

"Database error in vBulletin 3.0.1:

Invalid SQL: SELECT u.username, (p.+0) AS cash FROM AS p LEFT JOIN user AS u ON u.userid=p.userid ORDER BY cash DESC LIMIT 5
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '+0) AS cash FROM AS p LEFT JOIN user AS u ON u.userid=p.userid

mysql error number: 1064

That's nothing to do with installation, sorry. Your phrasing in the last post mis-led me.

The problem here is the "(p.+0)" and "FROM AS p". Those should contain the uCash column and table, e.g. "(p.money+0)" and "FROM user AS p" -- $vboptions['uttpoints_pointsfield'] and $vboptions['uttpoints_pointtable']. Check what these are set to in the Admin control panel.

I can't really suggest what might be wrong as I haven't got 3.0.1, but I can't see that there would be any major changes between 3.0.0 and 3.0.1. If you want to give me FTP and Admin access to your forum, I can take a look for you, but it won't be until Sunday evening at the earliest because I'm away at a wedding this weekend.