408832 - top 250 affiliates not right

Status: RESOLVED FIXED

(Websites Graveyard :: spreadfirefox.com, defect)

Description

[Asa Dotzler [:asa]]

Something's wrong with the top 250 affiliates at
http://newsfx.spreadfirefox.com/affiliates/top_250
it's not showing up like the top 250 at old site.

Comment 1

[Paul Booker]

Illl be back online in a couple of hours to have a look at this 

Comment 2

[Paul Booker]

Hello,

We will need a to populate the affiliates_referrals table on SFX2 with the records that are currently on SFX right now and then run  cron.php to generate the "Top 250 Affilaites",.. 

Some notes :

All of the information that is used to generate  "Top 250 Affilaites",.. . is stored in the affilates_referrals table.

Each day the affilates_referrals tables should be updated by running cron.php which updates the affiliates_referrals tables by pulling in new information from the affilaites tables which captures all referrals events is detail

Please let me know if you need any further assistance in updating these affiliate tables and the user table as discussed over at https://bugzilla.mozilla.org/show_bug.cgi?id=407770

Thanks Paul