CRM-10837 When enabling CiviCase there is an error

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.2.1
    • Fix Version/s: 4.2.2
    • Component/s: CiviCase
    • Labels:
      None

      Description

      When enabling Civicase under "Settings - Enable Components" after pressing "Save" the next page has an error:

      Sorry but we are not able to provide this at the moment.
      DB Error: no such field
      Return to home page.

        Attachments

          Activity

          [CRM-10837] When enabling CiviCase there is an error
          Donald A. Lobo added a comment -

          Could not reproduce this issue locally. Can you please post on forum so we can debug/diagnose there

          Chris Weinhaupl added a comment -

          backTrace

          #0 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
          #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
          #2 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
          #3 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `n...")
          #4 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `n...")
          #5 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -19, NULL, NULL, "INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `n...", "DB_Error", TRUE)
          #6 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'label' in 'field list'")
          #7 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
          #8 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `n...")
          #9 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/CRM/Admin/Form/Setting/Component.php(160): DB_common->query("INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `n...")
          #10 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/CRM/Admin/Form/Setting/Component.php(124): CRM_Admin_Form_Setting_Component->loadCaseSampleData("mysql://XXXXX:XXXXX@localhost/c1civicrm?new_link=true", "/var/www/t6.workdesk.ca/web/sites/all/modules/civicrm/sql/case_sample.mysql")
          #11 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/CRM/Core/Form.php(246): CRM_Admin_Form_Setting_Component->postProcess()
          #12 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/CRM/Core/StateMachine.php(159): CRM_Core_Form->mainProcess()
          #13 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_Setting_Component), "next", "Next")
          #14 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_Setting_Component), "next")
          #15 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Setting_Component), "next")
          #16 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/CRM/Core/Controller.php(289): HTML_QuickForm_Page->handle("next")
          #17 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(115): CRM_Core_Controller->run()
          #18 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/CRM/Core/Invoke.php(193): CRM_Utils_Wrapper->run("CRM_Admin_Form_Setting_Component", "Enable CiviCRM Components", NULL)
          #19 /var/www/clients/client1/web37/web/sites/all/modules/civicrm/drupal/civicrm.module(500): CRM_Core_Invoke::invoke((Array:4))
          #20 [internal function](): civicrm_invoke("admin", "setting", "component")
          #21 /var/www/clients/client1/web37/web/includes/menu.inc(516): call_user_func_array("civicrm_invoke", (Array:3))
          #22 /var/www/clients/client1/web37/web/index.php(21): menu_execute_active_handler()
          #23

          {main}
          Chris Weinhaupl added a comment -

          [Fri Sep 21 05:04:36 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 05:10:48 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 06:07:11 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 10:46:43 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 10:53:29 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 12:12:44 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 12:17:27 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 14:09:17 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 14:12:00 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 15:35:49 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 15:42:09 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 16:34:32 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 16:41:59 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl
          [Fri Sep 21 17:18:40 2012] [error] [client 82.136.65.203] File does not exist: /usr/local/ispconfig/interface/web/intl

          Jamie McClelland added a comment -

          I had the same problem after upgrading to 4.3. CiviCase was no longer enabled. WHen I tried to enable it I got:

          {{{
          backTrace

          #0 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Core/Error.php(149): CRM_Core_Error::backtrace()
          #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
          #2 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
          #3 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `n...")
          #4 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `n...")
          #5 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `n...", "DB_Error", TRUE)
          #6 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'label' in 'field list'")
          #7 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
          #8 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `n...")
          #9 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Admin/Form/Setting/Component.php(141): DB_common->query("INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `n...")
          #10 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Case/Info.php(173): CRM_Admin_Form_Setting_Component::loadCaseSampleData("mysql://cjourpowerbase_0:hpMjS92ZT2@rossi.mayfirst.org/cjourpowerbase_0?new_l...", "/var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/sql...")
          #11 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Admin/Form/Setting/Component.php(111): CRM_Case_Info::onToggleComponents((Array:7), (Array:8), NULL)
          #12 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Core/Form.php(261): CRM_Admin_Form_Setting_Component->postProcess()
          #13 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
          #14 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_Setting_Component), "next", "Next")
          #15 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_Setting_Component), "next")
          #16 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Setting_Component), "next")
          #17 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("next")
          #18 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
          #19 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Core/Invoke.php(297): CRM_Utils_Wrapper->run("CRM_Admin_Form_Setting_Component", "Enable CiviCRM Components", NULL)
          #20 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
          #21 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
          #22 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/sites/all/modules/civicrm/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:4))
          #23 [internal function](): civicrm_invoke("admin", "setting", "component")
          #24 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:3))
          #25 /var/aegir/platforms/rossi-ourpowerbase-d7-c4.4/index.php(21): menu_execute_active_handler()
          #26

          {main}

          }}}

          This site has multi-lingual turned on which I'm guessing is the reason you could not replicate it.

            People

            • Assignee:
              Donald A. Lobo
              Reporter:
              Chris Weinhaupl

              Dates

              • Created:
                Updated:
                Resolved: