CiviCRM Community Forums (archive)

This information is too vague to be useful. Please help us help you.

• Turn on debug-backtrace and post the entire trace.
• Post complete steps to reproduce the problem.
• Please try to reproduce the issue on the demo site.

Thank you for the instructions!

When I try to delete a custom field, this is what I get:


backTrace

#0 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: not found", -4, 16, (Array:2), "        ALTER TABLE civicrm_value_atelier_employee_badge_16 DROP COLUMN `badg...")
#4 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-4, 16, (Array:2), "        ALTER TABLE civicrm_value_atelier_employee_badge_16 DROP COLUMN `badg...")
#5 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -4, NULL, NULL, "        ALTER TABLE civicrm_value_atelier_employee_badge_16 DROP COLUMN `badg...", "DB_Error", TRUE)
#6 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-4, NULL, NULL, NULL, "1091 ** Can't DROP 'badge_access_level_46'; check that column/key exists")
#7 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("        ALTER TABLE civicrm_value_atelier_employee_badge_16 DROP COLUMN `badg...")
#9 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("        ALTER TABLE civicrm_value_atelier_employee_badge_16 DROP COLUMN `badg...")
#10 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("        ALTER TABLE civicrm_value_atelier_employee_badge_16 DROP COLUMN `badg...")
#11 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("        ALTER TABLE civicrm_value_atelier_employee_badge_16 DROP COLUMN `badg...")
#12 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/DAO.php(917): CRM_Core_DAO->query("        ALTER TABLE civicrm_value_atelier_employee_badge_16 DROP COLUMN `badg...", FALSE)
#13 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/BAO/SchemaHandler.php(293): CRM_Core_DAO::executeQuery("        ALTER TABLE civicrm_value_atelier_employee_badge_16 DROP COLUMN `badg...", (Array:0), TRUE, NULL, FALSE, FALSE)
#14 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/BAO/CustomField.php(1821): CRM_Core_BAO_SchemaHandler::alterFieldSQL((Array:7), FALSE, TRUE)
#15 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/BAO/CustomField.php(1075): CRM_Core_BAO_CustomField::createField(Object(CRM_Core_DAO_CustomField), "delete")
#16 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Custom/Form/DeleteField.php(114): CRM_Core_BAO_CustomField::deleteField(Object(CRM_Core_DAO_CustomField))
#17 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/Form.php(246): CRM_Custom_Form_DeleteField->postProcess()
#18 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#19 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Custom_Form_DeleteField), "next", "Next")
#20 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Custom_Form_DeleteField), "next")
#21 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Custom_Form_DeleteField), "next")
#22 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/Controller.php(316): HTML_QuickForm_Page->handle("next")
#23 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Custom/Page/Field.php(250): CRM_Core_Controller->run()
#24 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/Invoke.php(292): CRM_Custom_Page_Field->run((Array:5), NULL)
#25 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:14))
#26 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:5))
#27 /mnt/www/html/belcham/docroot/sites/all/modules/civicrm/drupal/civicrm.module(436): CRM_Core_Invoke::invoke((Array:5))
#28 [internal function](): civicrm_invoke("admin", "custom", "group", "field")
#29 /mnt/www/html/belcham/docroot/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:4))
#30 /mnt/www/html/belcham/docroot/index.php(21): menu_execute_active_handler()
#31 {main}
Sorry but we are not able to provide this at the moment.
DB Error: not found

U'll need some sql skills to help debug and fix this

based on the mysql error message, seems like the column badg..... does not exist

might want to take a look and see what columns are rpesent and how they match to the custom group/field description

i suspect they are mis-matched and hence the above issue

lobo

the tables custom_group and custom_fields hold values for a new table and columns that are created in your mysql db

i suspect the values in the custom_* tables do not match the table/column definitions

the custom_* tables are quite easy to understand, so might make sense when u r looking at the db in workbench

lobo