Updating 4.5.8 to 4.6.2

[jules54]

Keep getting this error when trying to update the database-
 Error: Upgrade DB to 4.6.alpha1]
Type   DB_Error
Code   -19
Message   DB Error: no such field
Mode   16
UserInfo   ALTER TABLE civicrm_action_schedule ADD used_for VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Used for repeating entity' AFTER sms_provider_id [nativecode=1054 ** Unknown column 'sms_provider_id' in 'civicrm_action_schedule']
DebugInfo   ALTER TABLE civicrm_action_schedule ADD used_for VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Used for repeating entity' AFTER sms_provider_id [nativecode=1054 ** Unknown column 'sms_provider_id' in 'civicrm_action_schedule']
PEAR_Exception: DB Error: no such field in unknown on line unknown
- DB_Error: DB Error: no such field in unknown on line unknown

I have disabled the sms provider as it appears to be breaking this update.  Do I need to delete it??

[jules54]

Tried deleting the sms provider and get the same behavior.

[Hershel]

The issue is not your SMS provider, it's a problem with your database schema. I don't know why you have this problem, and it's not even clear to me if this is a problem with your database or a bug in the upgrader.

Is your current CiviCRM one that was upgraded previously? If so, can you try the Ensuring Schema Integrity on Upgrades procedure?

[jules54]

Thanks for  your information Hershel!  I rebuilt my database as instructed in the schema documentation and was able to upgrade successfully! 

Thanks! 

Julie