413145 - fixes to affiliates homepage on SFx

Status: RESOLVED FIXED

(Websites Graveyard :: spreadfirefox.com, defect)

Description

[Paul Kim]

1) I see:
"no data"
displayed under the headline for this page.

2) Can you also add back in the following text above the buttons:

Spread Firefox offers a simple affiliates program that enables members to support Firefox and earn fame.

Spread Firefox's Affiliate Program is not the only program to help drive Firefox downloads. Google, with the full support of Mozilla, and through its brand new AdSense Referral Program offers participants the opportunity to earn money for driving Firefox with the Google Toolbar downloads. If you're an Adsense publisher, you may wish to participate in Google's Firefox Referral Program.

We're also interested in seeing more of these kinds of affiliate programs and if you're interested in starting a similar program, please contact [e-mail].

To participate in the Spread Firefox Affiliate Program, simply copy and paste the source below to link to us and get affiliate credit. Make sure to register or sign in to get credit for each time someone clicks on your Firefox buttons.

3) Can you add back in the Foxkeh banners? See them here:
http://archive-sfx.spreadfirefox.com/?q=affiliates/homepage

Comment 1

[Paul Booker]

I have addressed 1 and 2 .

Would you please push the changes to 
sfx/sfx_affiliates/sfx_affiliates.module
to the production server
(Committed revision 9723.)

I'll post some SQL instructions shortly for 3. 

Comment 2

[Paul Booker]

Here are the records that need to be added to our "spreadfirefox" table. 

Please ensure that that the values for affiliates_weights.cat_id match the value 
of affiliates_cats.id .

INSERT INTO `spreadfirefox`.`affiliates_cats` (`id` ,`label` ,`active`) VALUES (NULL , 'Foxkeh banners for Firefox 2', 'Y');


INSERT INTO `affiliates_weights` VALUES (0000000220, 'foxkeh-fx2-120x60: 1', 1, 'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-120x60.png', 'image', 011, 108, NULL, 'Active');
INSERT INTO `affiliates_weights` VALUES (0000000221, 'foxkeh-fx2-125x125: 1', 1, 'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-125x125.png', 'image', 011, NULL, NULL, 'Active');
INSERT INTO `affiliates_weights` VALUES (0000000222, 'foxkeh-fx2-180x60: 1', 1, 'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-180x60.png', 'image', 011, NULL, NULL, 'Active');
INSERT INTO `affiliates_weights` VALUES (0000000223, 'foxkeh-fx2-300x250: 1', 1, 'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-300x250.png', 'image', 011, NULL, NULL, 'Active');

I am going to do some work on the affiliates module tomorrow so that it is easy for an administrator to setup affiliates banners and to adjust their position on the affiliates page 

Comment 3

[Paul Booker]

Committed revision for sfx/sfx_affiliates/sfx_affiliates.module
is now 9726.

Comment 4

[Justin Fitzhugh]

waiting on approval from webdev.

Comment 5

[Michael Morgan [:morgamic]]

Looking at diff.

Comment 6

[Michael Morgan [:morgamic]]

http://viewvc.svn.mozilla.org/vc/projects/spreadfirefox.com/trunk/modules/sfx/sfx_affiliates/sfx_affiliates.module?r1=9723&r2=9726&pathrev=9726

Simple change, it's fine.

Comment 7

[matthew zeier [:mrz]]

Looks like the SQL was already run - got a bunch of duplicate entries.

Content updated.

[root@mradm01 www.spreadfirefox.com]# svn up
U    modules/sfx/sfx_affiliates/sfx_affiliates.module
U    modules/search/search.module
Updated to revision 9753.

Comment 8

[Paul Booker]

When you executed ...

INSERT INTO `spreadfirefox`.`affiliates_cats` (`id` ,`label` ,`active`) VALUES
(NULL , 'Foxkeh banners for Firefox 2', 'Y');

what was the 'id' that was generated for that record ?

Comment 9

[matthew zeier [:mrz]]

mysql> select * from affiliates_cats where label = 'Foxkeh banners for Firefox 2';
+-----+------------------------------+--------+
| id  | label                        | active |
+-----+------------------------------+--------+
| 011 | Foxkeh banners for Firefox 2 | Y      |
| 012 | Foxkeh banners for Firefox 2 | Y      |
+-----+------------------------------+--------+
2 rows in set (0.00 sec)

Comment 10

[Paul Booker]

lets work with the last one (we only need the record once), would you execute these  ...


INSERT INTO `affiliates_weights` VALUES (0000000220, 'foxkeh-fx2-120x60: 1', 1,
'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-120x60.png',
'image', 012, 108, NULL, 'Active');
INSERT INTO `affiliates_weights` VALUES (0000000221, 'foxkeh-fx2-125x125: 1',
1,
'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-125x125.png',
'image', 012, NULL, NULL, 'Active');
INSERT INTO `affiliates_weights` VALUES (0000000222, 'foxkeh-fx2-180x60: 1', 1,
'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-180x60.png',
'image', 012, NULL, NULL, 'Active');
INSERT INTO `affiliates_weights` VALUES (0000000223, 'foxkeh-fx2-300x250: 1',
1,
'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-300x250.png',
'image', 012, NULL, NULL, 'Active');

Comment 11

[matthew zeier [:mrz]]

mysql> INSERT INTO `affiliates_weights` VALUES (0000000220, 'foxkeh-fx2-120x60: 1', 1,
    -> 'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-120x60.png',
    -> 'image', 012, 108, NULL, 'Active');
ERROR 1062 (23000): Duplicate entry '0000000220' for key 1
mysql> INSERT INTO `affiliates_weights` VALUES (0000000221, 'foxkeh-fx2-125x125: 1',
    -> 1,
    -> 'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-125x125.png',
    -> 'image', 012, NULL, NULL, 'Active');
ERROR 1062 (23000): Duplicate entry '0000000221' for key 1
mysql> INSERT INTO `affiliates_weights` VALUES (0000000222, 'foxkeh-fx2-180x60: 1', 1,
    -> 'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-180x60.png',
    -> 'image', 012, NULL, NULL, 'Active');
ERROR 1062 (23000): Duplicate entry '0000000222' for key 1
mysql> INSERT INTO `affiliates_weights` VALUES (0000000223, 'foxkeh-fx2-300x250: 1',
    -> 1,
    -> 'http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/foxkeh-fx2-300x250.png',
    -> 'image', 012, NULL, NULL, 'Active');
ERROR 1062 (23000): Duplicate entry '0000000223' for key 1

Comment 12

[Michael Morgan [:morgamic]]

Hold on, Paul what are you trying to do?  Do it on your stage instance first, we can get you a copy of the db if necessary.

Comment 13

[Michael Morgan [:morgamic]]

Also, looks like you probably want to do updates not inserts.  Either that or use replace instead.

Comment 14

[Paul Booker]

I have a copy of everthing on my local machine .

I have patched the affiliates.module (i sent two patches are you using the latter)
and inserted the new records into 'affiliate' tables and it worked

I'll investigate why its not working on the sandbox now ...

Paul

Comment 15

[Paul Booker]

would you please run the same SQL statements on the spreadfirefox sandbox database, thanks

Comment 16

[Paul Booker]

its ok i can do it ..

Comment 17

[Paul Booker]

I have inserted the records into the spreadfirefox table on willow-vm without any problems but i can't see the new banners like i can on my local machine so it looks as though the changes that have been commited to  subversion R.9726 and R.9723 are not checked out into the stage environment .

http://viewvc.svn.mozilla.org/vc/projects/spreadfirefox.com/trunk/modules/sfx/sfx_affiliates/sfx_affiliates.module?view=log


Would you please take a copy of the spreadfirefox database and set it up on willow and make it available for download and ill look into this some more tomorrow.


Thanks Paul

Comment 18

[Paul Booker]

Would you please clarify how i can connect to the sfx.stage.mozilla.com database so that i can add the affilaite records (i can't currently do this) and be able to empty tables quickly like the drupal cache

Thanks Paul

Comment 19

[matthew zeier [:mrz]]

Punting to oremj, not familiar with how the staging enviro is setup to know.

Comment 20

[Jeremy Orem [:oremj]]

I dropped a backup on willow:/tmp/sfx_v2.2008.02.02.sql.gz

Comment 21

[Paul Booker]

I can't download this file as the file has root ownership

-rwx------   1 root root 65844371 Feb  4 13:40 sfx_v2.2008.02.02.sql.gz

Comment 22

[Jeremy Orem [:oremj]]

Sorry, thought you had root on that box.  You have access now.

Comment 23

[Paul Booker]

Thanks Jeremy.