Fragment

Step by step to finding what's wrong.

So after catching a few of the other caches (views, locale) that were running too much for different reasons, we still have a MySQL frenzy on our hands.

The query I see over and over again in Agaric's logs on the WSF2008 site is "INSERT INTO cache (cid, data, created, expire, headers) VALUES ('locale:pt-br', 'a:3757:{s:2\"MB\".....

And "UPDATE cache SET data = 'a:4334:{s:2\"MB\"

By the way, in vi to go to the previous occurrence of a search, to search backwards, it's capital N (shift+N) instead of just n.

The APress book on google maps and AJAX looks like the best reference.

"Hacking Google Maps and Google Earth" is out of date.

http://googlemapsapi.blogspot.com/2007/11/calling-all-phpmysql-developers-come.html

JavaScript Debugger 0.9.87 Homepage
by James Ross, Robert Ginda

Setting up a new site into Agaric's system.

Some standard new site stuff

ben@server:/var/www/drupal-5_3-live/profiles$ sudo svn co file:///srv/svn/agaric/agaric-profiles/agaric_recipes agaric_recipes

[and a bunch of similar checkouts I failed to record]
[Including for the site itself into the sites/ directory]

Note: the agaric installation profile hit an error on a call to a token module function, but seemed to do everything anyway.

Stolen from Dwees in this comment:

  $city = $node->location['city'];
  $province = $node->location['province'];
  $country = $node->location['country'];

  $address = str_replace(" ", "+", $city .",". $province .",". $country);
  $google_key = variable_get('googlemap_api_key', '');

The following modules have been modified from their original and we have to

Major impact on how site works:

Organic groups (just slightly to allow our form_alter subform nodeapi craziness, can beg for patch)

Minor (in terms of impact on the site if we screw up and fail to bring forward our changes on an update):

Nodeprofile (hid menu tabs, should supply patch)
Core (for l10n_client, this patch is part of Drupal 6)

Resolution

Installed by Drush PM on Drupal 5

http://drupal.org/project/util
The utility module is a module that contains a bunch of utilities that are simple to code, everyone wants, but nobody actually codes them.
Right now, we have:
System module fieldset closer- This utility closes all the fieldsets at admin/build/modules

http://drupal.org/project/feedbuttons

Groups.Drupal.org just switched to Date + Calendar
http://groups.drupal.org/node/7084

We're with Event for now.

Resolution

http://drupal.org/project/suggestedterms

This module provides "suggested terms" for free-tagging Taxonomy fields based on terms already submitted. It replaces the description field on free-tagging fields with a clickable list of previously entered terms. If javascript is not enabled the list will still appear but not be clickable. It provides the best of both worlds between a pre-existing list of terms and the ability to add new terms on the fly as needed.

This problem caused white screens after form submission (not exactly white screens of death, as the form submitted successfully and you could keep browsing by reloading, but a tad annoying and disconcerting all the same) and also made our Captcha image disappear.

And of course the mean red Drupal warning that told us exactly where the problem lay.

Here's bits and pieces of the error message:

warning: Cannot modify header information - headers already sent by (output started at
.module:1)
common.inc on line 141.

rconstantine is a Drupal god

http://drupal.org/node/151844

Now that's documenting a bug!

Resolution