CiviCRM Community Forums (archive)

I'm having a lot of database issues upgrading from CiviCRM 1.9 stable to 2 beta 5 to 2 stable. It appears that not all of the fields in a clean CiviCRM 2 stable install are in my upgraded database. Specifically, I am finding that if someone checks the pay at the door option, then I get a validation error that billing address is required.

I am going to roll-back to 1.9 stable, but in the meantime, I thought that it might be useful for others to post a diff file of my database schema compared to the one in 2 stable. My diff file can found here because it is too large to upload:
http://pastebin.com/fda5d39a

The diff file compares the schema of my database after running the upgrades (pjournal_civicrm), and the schema of 2 stable on a clean install (drupal_civicrm_civicrm).

Please let me know if you know if any scripts that I might have overlooked running during the upgrade process.

Thanks,
Julia

Solved the problem. It actually was not a database issue.

I had created an additional CiviCRM profile named "Billing Address." As part of that profile, I had a category for state. On the credit card form, state information is collected as an abbreviation (NC). On my form, it was being collected as a full name (North Carolina). Somehow, the billing address was resetting the Authorize.NET billing address.

Once I changed the name of the profile to Business Address, all of the problems that I had thought were database-released were solved.