it is installed turned out to be a different version of mysql didnt like the rand() see member of the day thread for fix.
but the problem i have now is that the userid numbers dont match the username.
http://www.golden-springs.com/forums/index.php
you will see the top poster and top thread starter show userid 1 and userid 2 from the database but the names arent userid 1 and userid 2
can this be fixed?