The points assigned are still suspect. My account, for instance, shows a couple of thousand points more that before the upgrade. Other accounts seem to have less points and show incorrect status. Unless the point count and ACE status displayed in the old system was incorrect, I'd say it still fairly broken. User 3004 is out, but is there any other change? I agree with you on the lack of feedback. It appears OTN personnel has disappeared.
I took a few screenshots of forums that I frequently visit just a couple of days before the OTN upgrade.
The order in which top participants appear is ok, but the points displayed are obviously the total points according to a user's profile and not points achieved in a specific forum. I don't know the total number of points of each user, but the point shown are way off. Previous ACE director and Guru status of people are not shown according to the previous version, e.g. Oracle Linux forum.
I can post the screenshots, but I would not want to spoil anyone's luck. I just realized that I lost a couple of thousand points during the last few hours and I hope this is not because I mentioned it, but because the system is still adjusting.
When did the script finish? Sorry I'm astonished that I lost exactly 2000 points after mentioning that I still have a couple of thousand points more than before the upgrade. Where my points adjusted manually or was the script still running? As a matter for fairness this would not be a good idea. Also, the list of top participants shows a user's total number of points, but not the amount accumulated in a forum. Can this be fixed too?
The script was probably done by 11 pm, however, there are a bunch of caches that had to be cleared, so you may have seen differing totals while that was in process.
There was no manual fix of points, there's no mechanism in Jive for that.
We are looking at various options for top participants per forum, however, it's part of a longer term project
If you need help with a SQL update statement, I'm sure there are plenty of people here who could help you with that. Which backend did you say Jive was using?
Wouldn't it be a hoot if the backend were SQL Server or DB2 (or worse, sybase) because that was what Jive required?
Wouldn't be the first time a major rdbms vendor had to use a competing product on some internal app. But would be even more embarrassing for Oracle. At least for MS and IBM, while their rdbms's are major products, they aren't the core product around which the entire business is built.
Jive is db-blind, I suppose. Jive Software - Jive Forums: Database Setup
I have the impression the old one was mysql and guess the new one ought to be Oracle, but haven't seen any clues to be sure. Maybe after everything is copacetic they'll give an OOW presentation, I think many people would love to know how to make such a beast work.