Skip to content

Instantly share code, notes, and snippets.

@JoeMurray
Created February 27, 2019 22:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JoeMurray/ec6eb90a42a78a5d9fd2b242739178af to your computer and use it in GitHub Desktop.
Save JoeMurray/ec6eb90a42a78a5d9fd2b242739178af to your computer and use it in GitHub Desktop.
Feb 27 14:07:02 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => ALTER TABLE civicrm_value_lead_repair_investment_62
MODIFY `lead_repair_amount_265` decimal(20,2) DEFAULT 'null' [nativecode=1067 ** Invalid default value for 'lead_repair_amount_265']
[type] => DB_Error
[user_info] => ALTER TABLE civicrm_value_lead_repair_investment_62
MODIFY `lead_repair_amount_265` decimal(20,2) DEFAULT 'null' [nativecode=1067 ** Invalid default value for 'lead_repair_amount_265']
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info=" ALTER TABLE civicrm_value_lead_repair_investment_62
MODIFY `lead_repair_amount_265` decimal(20,2) DEFAULT 'null' [nativecode=1067 ** Invalid default value for 'lead_repair_amount_265']"]
)
Feb 27 14:07:02 [info] $backTrace = #0 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(232): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), " ALTER TABLE civicrm_value_lead_repair_investment_62\n MODIFY `...")
#3 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), " ALTER TABLE civicrm_value_lead_repair_investment_62\n MODIFY `...")
#4 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), " ALTER TABLE civicrm_value_lead_repair_investment_62\n MODIFY `...", "DB_Error", TRUE)
#5 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, " ALTER TABLE civicrm_value_lead_repair_investment_62\n MODIFY `...", "1067 ** Invalid default value for 'lead_repair_amount_265'")
#7 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery(" ALTER TABLE civicrm_value_lead_repair_investment_62\n MODIFY `...")
#9 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2415): DB_common->query(" ALTER TABLE civicrm_value_lead_repair_investment_62\n MODIFY `...")
#10 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query(" ALTER TABLE civicrm_value_lead_repair_investment_62\n MODIFY `...")
#11 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(438): DB_DataObject->query(" ALTER TABLE civicrm_value_lead_repair_investment_62\n MODIFY `...")
#12 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1413): CRM_Core_DAO->query(" ALTER TABLE civicrm_value_lead_repair_investment_62\n MODIFY `...", FALSE)
#13 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/SchemaHandler.php(339): CRM_Core_DAO::executeQuery(" ALTER TABLE civicrm_value_lead_repair_investment_62\n MODIFY `...", (Array:0), TRUE, NULL, FALSE, FALSE)
#14 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomField.php(1891): CRM_Core_BAO_SchemaHandler::alterFieldSQL((Array:7), "1", TRUE)
#15 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomField.php(318): CRM_Core_BAO_CustomField::createField(Object(CRM_Core_DAO_CustomField), "modify", "1", TRUE)
#16 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Custom/Form/Field.php(1016): CRM_Core_BAO_CustomField::create((Array:36))
#17 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(489): CRM_Custom_Form_Field->postProcess()
#18 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Done.php(75): CRM_Core_Form->mainProcess()
#19 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Done->perform(Object(CRM_Custom_Form_Field), "done")
#20 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Custom_Form_Field), "done")
#21 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("done")
#22 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
#23 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(282): CRM_Utils_Wrapper->run("CRM_Custom_Form_Field", "Custom Field - Edit", (Array:0))
#24 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
#25 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:6))
#26 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm.php(121): CRM_Core_Invoke::invoke((Array:6))
#27 /home/example.org/htdocs/administrator/components/com_civicrm/civicrm.php(40): civicrm_invoke()
#28 /home/example.org/htdocs/libraries/src/Component/ComponentHelper.php(402): require_once("/home/example.org/htdocs/administrator/components/com_civicrm/civ...")
#29 /home/example.org/htdocs/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent("/home/example.org/htdocs/administrator/components/com_civicrm/civ...")
#30 /home/example.org/htdocs/libraries/src/Application/AdministratorApplication.php(101): Joomla\CMS\Component\ComponentHelper::renderComponent("com_civicrm")
#31 /home/example.org/htdocs/libraries/src/Application/AdministratorApplication.php(159): Joomla\CMS\Application\AdministratorApplication->dispatch()
#32 /home/example.org/htdocs/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\AdministratorApplication->doExecute()
#33 /home/example.org/htdocs/administrator/index.php(51): Joomla\CMS\Application\CMSApplication->execute()
#34 {main}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment