"Please set a location type of Billing"

[michaels23]

Hi all,

Can anyone suggest where I should begin debugging a "Please set a location type of Billing" error? It doesn't seem to be obvious in the code or tables.

I think I've botched a CiviCRM 1.5 - 1.7 upgrade. I did it a week or so ago, but I'm just now getting around to examining my CiviContribute pages. I'm getting this as non-recoverable error on all of my CiviContribute pages.

TIA

[Donald Lobo]

michael:

this is part of the upgrade script, where we create a billing location type

        SELECT @domain_id := id from civicrm_domain;
    INSERT INTO `civicrm_location_type` ( `domain_id`, `name`, `vcard_name`, `description`, `is_reserved`, `is_active` )
    VALUES
        ( @domain_id, 'Billing', NULL, 'Billing Address location', 1, 1 );

You could emulate this by clicking on Location Type under Administer CiviCRM

lobo

[michaels23]

Thanks! That did the trick.