CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Updating 4.5.8 to 4.6.2
Pages: [1]

Author Topic: Updating 4.5.8 to 4.6.2  (Read 876 times)

jules54

  • I’m new here
  • *
  • Posts: 12
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.5.34
  • PHP version: 5
Updating 4.5.8 to 4.6.2
April 16, 2015, 07:31:10 pm
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

  • I’m new here
  • *
  • Posts: 12
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.5.34
  • PHP version: 5
Re: Updating 4.5.8 to 4.6.2
April 16, 2015, 07:38:18 pm
Tried deleting the sms provider and get the same behavior.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Updating 4.5.8 to 4.6.2
April 19, 2015, 10:41:01 am
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?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

jules54

  • I’m new here
  • *
  • Posts: 12
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.5.34
  • PHP version: 5
Re: Updating 4.5.8 to 4.6.2
April 20, 2015, 11:47:28 am
Thanks for  your information Hershel!  I rebuilt my database as instructed in the schema documentation and was able to upgrade successfully! 

Thanks!  :)

Julie
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Updating 4.5.8 to 4.6.2

This forum was archived on 2017-11-26.