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) »
  • Upgrade to 3.0.1 does not work. Database Error Code: Unknown column 'description
Pages: [1]

Author Topic: Upgrade to 3.0.1 does not work. Database Error Code: Unknown column 'description  (Read 1763 times)

cronix

  • Guest
Upgrade to 3.0.1 does not work. Database Error Code: Unknown column 'description
October 19, 2009, 11:26:04 am
I am trying to upgrade my 2.2.8 installation to 3.0.1. I get the following error during the database upgrade:

Database Error Code: Unknown column 'description' in 'field list', 1054

Error details:
Code: [Select]
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => -- adde new reports
    INSERT INTO `civicrm_report_instance`
        (title, report_id, description, permission, form_values)
    VALUES
        ('Activity Report',                        'activity',                        'Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required)', 'administer CiviCRM', 'a:22:{s:6:"fields"#a:7:{s:14:"contact_source"#s:1:"1"#s:16:"contact_assignee"#s:1:"1"#s:14:"contact_target"#s:1:"1"#s:16:"activity_type_id"#s:1:"1"#s:7:"subject"#s:1:"1"#s:18:"activity_date_time"#s:1:"1"#s:9:"status_id"#s:1:"1"#}s:17:"contact_source_op"#s:3:"has"#s:20:"contact_source_value"#s:0:""#s:19:"contact_assignee_op"#s:3:"has"#s:22:"contact_assignee_value"#s:0:""#s:17:"contact_target_op"#s:3:"has"#s:20:"contact_target_value"#s:0:""#s:27:"activity_date_time_relative"#s:10:"this.month"#s:23:"activity_date_time_from"#a:3:{s:1:"M"#s:0:""#s:1:"d"#s:0:""#s:1:"Y"#s:0:""#}s:21:"activity_date_time_to"#a:3:{s:1:"M"#s:0:""#s:1:"d"#s:0:""#s:1:"Y"#s:0:""#}s:10:"subject_op"#s:3:"has"#s:13:"subject_value"#s:0:""#s:19:"activity_type_id_op"#s:2:"in"#s:22:"activity_type_id_value"#a:0:{}s:12:"status_id_op"#s:2:"in"#s:15:"status_id_value"#a:0:{}s:11:"description"#s:126:"Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required)"#s:13:"email_subject"#s:0:""#s:8:"email_to"#s:0:""#s:8:"email_cc"#s:0:""#s:10:"permission"#s:18:"administer CiviCRM"#s:6:"groups"#s:0:""#}'),
        ('Relationship Report',                    'contact/relationship',            'Gives relationship details between two contacats', 'administer CiviCRM', 'a:27:{s:6:"fields"#a:4:{s:14:"display_name_a"#s:1:"1"#s:14:"display_name_b"#s:1:"1"#s:9:"label_a_b"#s:1:"1"#s:7:"email_a"#s:1:"1"#}s:17:"contact_name_a_op"#s:3:"has"#s:20:"contact_name_a_value"#s:0:""#s:17:"contact_name_b_op"#s:3:"has"#s:20:"contact_name_b_value"#s:0:""#s:6:"id_min"#s:0:""#s:6:"id_max"#s:0:""#s:5:"id_op"#s:3:"lte"#s:8:"id_value"#s:0:""#s:17:"contact_type_a_op"#s:2:"in"#s:20:"contact_type_a_value"#a:0:{}s:17:"contact_type_b_op"#s:2:"in"#s:20:"contact_type_b_value"#a:0:{}s:8:"label_op"#s:2:"eq"#s:11:"label_value"#s:1:" "#s:13:"country_id_op"#s:2:"in"#s:16:"country_id_value"#a:0:{}s:20:"state_province_id_op"#s:2:"in"#s:23:"state_province_id_value"#a:0:{}s:6:"gid_op"#s:2:"in"#s:9:"gid_value"#a:0:{}s:11:"description"#s:48:"Gives relationship details between two contacts"#s:13:"email_subject"#s:0:""#s:8:"email_to"#s:0:""#s:8:"email_cc"#s:0:""#s:10:"permission"#s:18:"administer CiviCRM"#s:6:"groups"#s:0:""#}'),
 ....
)

Does anyone know what is wrong?[/code]

cronix

  • Guest
Re: Upgrade to 3.0.1 does not work. Database Error Code: Unknown column 'description
October 20, 2009, 12:03:41 pm
I found the source of the error, but not the fix. I hope someone here can help me out. I am running a 2.2.8 with multi language support enabled and that is the issue. The database upgrade script expects a column description in table civicrm_report_instance. My installation had column description_en_US and description_nl_NL. So I quess I need another database script to upgrade my database.

So the question is: How do I upgrade a 2.2.8 civicrm with multi language support enabled to 3.0.1?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Upgrade to 3.0.1 does not work. Database Error Code: Unknown column 'description
October 20, 2009, 12:11:41 pm

seems like we dont handle the upgrade nicely for multi language support. I'm not even sure how we can / should handle this. We'll need to think about it

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

cronix

  • Guest
Re: Upgrade to 3.0.1 does not work. Database Error Code: Unknown column 'description
October 20, 2009, 01:22:25 pm
I do hope an upgrade is possible. I guess it's possible. I have upgraded to my 2.2.8 also. Does Piotr Szotkowski how to fix this?

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Upgrade to 3.0.1 does not work. Database Error Code: Unknown column 'description
October 21, 2009, 09:57:56 pm
Quote from: cronix on October 20, 2009, 01:22:25 pm
I do hope an upgrade is possible. I guess it's possible. I have upgraded to my 2.2.8 also. Does Piotr Szotkowski how to fix this?

Good news: We do handle upgrades for multilingual sites (this was one of my GSoC subprojects this year).

Bad news: The upgrade process is broken for CiviCRM 2.2.8, because of a bad mix of schema changes introduced mid-2.2 cycle and some of the columns being turned multilingual when introduced.

Bottom line: I’ll try to fix it for CiviCRM 3.0.2 so that the CiviCRM 2.2.8 multilingual sites upgrade cleanly; I’ll let you all know here once I’m done fixing this.

I created CRM-5270 to track this.
« Last Edit: October 21, 2009, 10:00:28 pm by Piotr Szotkowski »
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

cronix

  • Guest
Re: Upgrade to 3.0.1 does not work. Database Error Code: Unknown column 'description
October 22, 2009, 12:18:19 am
That is great news. I can wait for 3.0.2  :).

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Upgrade to 3.0.1 does not work. Database Error Code: Unknown column 'description
October 26, 2009, 05:39:23 am
I think I managed to fix it with r24517, which will be a part of the CiviCRM 3.0.2 to released later today.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade to 3.0.1 does not work. Database Error Code: Unknown column 'description

This forum was archived on 2017-11-26.