Can't edit profiles

This is my first bug report – be gentle with me. I was able to reproduce it on the demo site – and in the process, might have broken it . Here's how:

1) Create some custom data fields.
2) Create a profile that uses those custom data fields.
3) Delete one of those custom data fields
4) Attempt to view/edit fields in that profile.

The error occurs at this point. Unfortunately, debugging wasn't turned on on the demo site, so I didn't capture a backtrace

However, the errors just keep on coming! I then tried this:

1) Delete the problematic profile.
2) Try to create a new profile
3) You'll get another error – here's its backtrace. (Report continues after backtrace.)

--BEGIN--

backTrace

/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Error.php, backtrace, 260
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/DAO.php, fatal, 708
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/UF/Form/Field.php, getFieldValue, 309
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Form.php, buildQuickForm, 320
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 98
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Controller.php, handle, 232
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/UF/Page/Field.php, run, 204
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/UF/Page/Field.php, edit, 243
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Invoke.php, run, 197
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/drupal/civicrm.module, invoke, 315
, civicrm_invoke,
/var/www/drupal-6.civicrm.org/public/includes/menu.inc, call_user_func_array, 346
/var/www/drupal-6.civicrm.org/public/index.php, menu_execute_active_handler, 18

unrecoverable error
Sorry. A non-recoverable error has occurred.

--END--

But wait, there's more! Now go to that newly created profile and try to add fields. It fails with the following backtrace (which is probably the same as the one I missed the first time).

--BEGIN--

backTrace

/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Error.php, backtrace, 260
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/DAO.php, fatal, 708
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/UF/Form/Field.php, getFieldValue, 309
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Form.php, buildQuickForm, 320
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 98
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Controller.php, handle, 232
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/UF/Page/Field.php, run, 204
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/UF/Page/Field.php, edit, 243
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Invoke.php, run, 197
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/drupal/civicrm.module, invoke, 315
, civicrm_invoke,
/var/www/drupal-6.civicrm.org/public/includes/menu.inc, call_user_func_array, 346
/var/www/drupal-6.civicrm.org/public/index.php, menu_execute_active_handler, 18

--END--

So I'm guessing that some profile-checking code is needed whenever one deletes a custom data field.

Good luck with this, and please let me know if it's fixed – my DB's broken!

Cheers,

--Tom