Closed Bug 464580 Opened 17 years ago Closed 17 years ago

Spreadthunderbird primary menu links are pointing at stage server

Categories

(Mozilla Messaging Graveyard :: Server Operations, defect)

Product:
Mozilla Messaging Graveyard
Component:
Server Operations
Platform:
x86
macOS
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: paul, Assigned: paul)

References

(
URL
)

Details

Hi Gozer The primary menu links are pointing at stage even though the links are configured correctly to point at production and the drupal cache has been cleared and the menu router table rebuilt. Is is there a caching proxy server in front of the spreadthunderbird webhead that could be causing this problem ? -Paul
Summary: The primary menu links are pointing at stage → Spreadthunderbird primary menu links are pointing at stage server
Yup, there is a caching reverse-proxy in front of this stuff, and it's default cache time for some static content is 5 minutes, so this is possible behaviour when switching major content around. Shouldn't persist however, and forcible reloads (shift-reload) should force a refresh.
drupal records and uses a lot of full URLs in various database tables, instead of relative urls, so these all need fixing: here all the tables that contain the string stage.spreadthunderbird.com 987 watchdog 54 accesslog 14 affiliates_ads 10 cache_form 5 cache_page 5 boxes 4 cache_filter 3 node_revisions 2 menu_links 1 variable 1 cache_menu 1 cache
Assignee: gozer → paul
Thanks, watchdog and accesslog need not worry us. affiliate_ads should now be corrected. all the cache tables have been cleared following correction to affiliate links and footer so that should leave us with boxes, node_revisions (which i don't think we to worry about) and variable
Doesn't look like the cache tables have been cleared correctly: $> mysqldump --skip-opt drupal | grep stage.spread | perl -nle'print $1 if /INSERT INTO `([^`]+)`.*/' | sort | uniq -c | sort -n -k1 -r 987 watchdog 55 accesslog 10 cache_form 5 cache_page 5 boxes 4 cache_filter 3 node_revisions 2 menu_links 1 cache_menu 1 cache
variable looks like it's been fixed. Do you want me to truncate all cache_* tables ? How about menu_links ? $> mysqldump --skip-opt drupal | grep stage.spread | grep menu_links INSERT INTO `menu_links` VALUES ('primary-links',318,317,'http://stage.spreadthunderbird.com/companyinfo ','','Company Info ','a:1:{s:10:\"attributes\";a:1:{s:5:\"title\";s:13:\"Company Info \";}}','menu',1,1,0,0,-47,2,1,317,318,0,0,0,0,0,0,0,0); INSERT INTO `menu_links` VALUES ('primary-links',319,317,'http://stage.spreadthunderbird.com/pressroom','','Press Room ','a:1:{s:10:\"attributes\";a:1:{s:5:\"title\";s:11:\"Press Room \";}}','menu',1,1,0,0,-48,2,1,317,319,0,0,0,0,0,0,0,0);
Thanks again. I have corrected those disabled primary-link menu links , rebuilt the menu_router table and cleared the drupal cache . Is that looking better ?
Looks still like boxes is still a problem: # mysqldump --skip-opt drupal | grep stage.spread | perl -nle'print $1 if /INSERT INTO `([^`]+)`.*/' | sort | uniq -c | sort -n -k1 -r 902 watchdog 62 accesslog 10 cache_form 5 cache_page 5 boxes 4 cache_filter 3 node_revisions 1 cache_menu 1 cache
Any better Mr Gozer ?
Better, but still contains some: $> mysqldump --skip-opt drupal | grep stage.spread | perl -nle'print $1 if /INSERT INTO `([^`]+)`.*/' | sort | uniq -c | sort -n -k1 -r 902 watchdog 62 accesslog 10 cache_form 5 cache_page 4 cache_filter 3 node_revisions 3 boxes 1 cache_menu 1 cache $> mysqldump --skip-opt drupal boxes | grep stage.spreadthunderbird INSERT INTO `boxes` VALUES (7,'<p align=\"center\">New Thunderbird T-Shirt Contest</p>\r\n<p align=\"center\"><a href=\"http://stage.spreadthunderbird.com/node/26\"><img src=\"http://stage.spreadthunderbird.com/sites/default/files/images/stb-t-shirt-contest-block.png\" alt=\"Thunderbird T Shirt Contest\" width=\"210\" height=\"131\"></a></p>\r\n<p align=\"center\"><a href=\"http://stage.spreadthunderbird.com/?q=node/add/image\">Upload your design</a> <br>\r\n</p>\r\n<p align=\"center\"><a href=\"http://stage.spreadthunderbird.com/image/tid/13\">View Submission</a> - <a href=\"http://stage.spreadthunderbird.com/node/26\">Guidelines</a> </p>','T-Shirt Contest',2); INSERT INTO `boxes` VALUES (8,'Welcome to Spread Thunderbird Beta, it\'s time to fly! You are our marketing department -- a diverse community of people tired of email overload, spam, viruses, identity theft, and software that just doesn\'t work. Put a link to <a href=\"http://stage.spreadthunderbird.com/affiliates\">Thunderbird</a> in your signature, \r\n<a href=\"http://archive-sfx.spreadfirefox.com/?q=affiliates/homepage\">Become a Thunderbird affiliate</a>: Once you sign up as a SpreadThunderbird member, add a <a href=\"http://stage.spreadthunderbird.com/affiliates\">Thunderbird button</a> to your website and a link to your e-mail','Welcome to SpreadThunderbird',2); INSERT INTO `boxes` VALUES (10,'Calling all Thunderbird users <br>\r\nwhat would you like to see on Spreadthunderbird<br>\r\n<ul><li><a href=\"http://stage.spreadthunderbird.com/node/16\">Suggestion &amp; Comments</a></li> \r\n<ul><li><a href=\"http://stage.spreadthunderbird.com/drupal/?q=forum\">Get Involved</a></li> \r\n<ul><li><a href=\"http://stage.spreadthunderbird.com/drupal/?q=contact\">Volunteer</a></li> ','Calling all Thunderbird Users',2);
And now ?
Better: $> mysqldump --skip-opt drupal | grep stage.spread | perl -nle'print $1 if /INSERT INTO `([^`]+)`.*/' | sort | uniq -c | sort -n -k1 -r 908 watchdog 74 accesslog 10 cache_form 5 cache_page 4 cache_filter 3 node_revisions 1 cache_menu 1 cache
Truncated the remaining cache_* tables directly. $> mysqldump --skip-opt drupal | grep stage.spread | perl -nle'print $1 if /INSERT INTO `([^`]+)`.* /' | sort | uniq -c | sort -n -k1 -r 102 accesslog 39 watchdog 3 node_revisions Think we are good now.
Status: NEW → RESOLVED
Closed: 17 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.