Details
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
- civicase-enable-error.PNG
- 7 kB
- Chris Weinhaupl
Activity
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
[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
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
}}}
This site has multi-lingual turned on which I'm guessing is the reason you could not replicate it.
Could not reproduce this issue locally. Can you please post on forum so we can debug/diagnose there