[eoc_Jason]

Yes, one of the changes in this most recent version was the switch from a date field type to the int field type. The dates had to be regenerated in a new column, and the old column dropped, and indexes updated.

Open up the upgrade_traderratings.php file and look at the very very bottom. The script died at the part where it says:

PHP Code:

$DB_site->query("ALTER TABLE ".TABLE_PREFIX."user_rate_trade DROP INDEX rateduser_2"); 


The easiest thing to do would be to run the four SQL commands after it (assuming you do not have the rateduser_3 index) manually. Like in PHPMyAdmin, or I think you can run SQL from the vB control panel (I've never tried it that way though).

That's the reason all your dates are messed up, it's still trying to read the old date column and process it in the new format. If you still have people using the trader ratings script though, the dates will be missing for any new info that is submitted between the time you tried to update and now. If you have some PHP/MySQL skills then you might want to re-do just "Step 3" in the upgrade, but you will have to drop the datetmp column, and also might want to remove the drop's for the indexes which don't exist...

oldfan - Check the first post, there is a paypal donation link.

Originally Posted by Spinball

Jason,
hi mate - glad to see this hack is getting the popularity it deserves!
I have a problem with my installation.
Please see:
http://www.avforums.com/forums/trade...gs.php?u=12711
I.e.. null dates.
I had the first version of this hack for vB3 installed and upgraded vB to 3.0.3.
So I had to upgrade/reinstall the trader rating hack.
It did crash out (see my posting on the previous page).
Do you know where I went wrong and how to fix it?
Thanks.