[d8tabyte]

Originally Posted by christianb

This link, along with the link in the installation text file, both give me a database error

Database error in vBulletin 3.6.3:

Invalid SQL:
SELECT user.userid,user.username,user.ambportval, user.ambportgainamt, user.ambportgainper FROM vb_user WHERE (user.ambportval > 0) ORDER BY user.ambportgainamt desc LIMIT 20;;

MySQL Error  : Unknown column 'user.userid' in 'field list'
Error Number : 1054
Date         : Sunday, January 14th 2007 @ 07:44:55 PM
Script       : mywebsite /vbtrade.php?do=topportfolios
Referrer     : 
IP Address   : nope
Username     : sorry
Classname    : vB_Database

I am using MySQL 5.0.20. Playing around with it and removing the user. in the field list and in the WHERE and ORDER BY temporarily issues a fix, but nothing is displayed for users.

Second, I just purchased stocks yet it shows a change - even though no change is displayed. Screenshot for clarification.

Third, just trivial, but why 3 digit decimal places?

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT user.userid,user.username,user.ambportval, user.ambportgainamt, user.ambportgainper FROM vb3_user WHERE (user.ambportval > 0) ORDER BY user.ambportgainamt desc LIMIT 20;;

MySQL Error : Unknown table 'user' in field list
Error Number : 1109
Date : Monday, January 15th 2007 @ 01:20:50 AM
Script : http://digitalet.net/forum/vbtrade.php?do=topportfolios
Referrer : http://digitalet.net/forum/vbtrade.php?do=main
IP Address : ....
Username : ...
Classname : vb_database

Yup me too cept I am running PHP Version 4.4.4 and VB 3.6.4