CiviCRM Community Forums (archive)

Enabled debugging and when I run the update db utility, this is the result. Rendering of CiviCRM dashboard is messed up, too. Menus missing, graphics missing, etc.

#0 /home/soar/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/soar/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/soar/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_field...")
#4 /home/soar/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_field...")
#5 /home/soar/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_field...", "DB_Error", TRUE)
#6 /home/soar/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "1059 ** Identifier name 'civicrm_value_soar_membership_application_custom_fie...")
#7 /home/soar/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/soar/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_field...")
#9 /home/soar/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_field...")
#10 /home/soar/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_field...")
#11 /home/soar/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_field...")
#12 /home/soar/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(917): CRM_Core_DAO->query("DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_field...", TRUE)
#13 /home/soar/public_html/administrator/components/com_civicrm/civicrm/CRM/Logging/Schema.php(138): CRM_Core_DAO::executeQuery("DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_field...")
#14 /home/soar/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1578): CRM_Logging_Schema->dropTriggers(NULL)
#15 /home/soar/public_html/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php(151): CRM_Core_DAO::dropTriggers()
#16 /home/soar/public_html/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php(71): CRM_Upgrade_Page_Upgrade->runBegin()
#17 /home/soar/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(292): CRM_Upgrade_Page_Upgrade->run((Array:2), NULL)
#18 /home/soar/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:3))
#19 /home/soar/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#20 /home/soar/public_html/administrator/components/com_civicrm/admin.civicrm.php(116): CRM_Core_Invoke::invoke((Array:2))
#21 /home/soar/public_html/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#22 /home/soar/public_html/libraries/joomla/application/component/helper.php(383): require_once("/home/soar/public_html/administrator/components/com_civicrm/admin.civicrm.php")
#23 /home/soar/public_html/libraries/joomla/application/component/helper.php(351): JComponentHelper::executeComponent("/home/soar/public_html/administrator/components/com_civicrm/admin.civicrm.php")
#24 /home/soar/public_html/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#25 /home/soar/public_html/administrator/index.php(46): JAdministrator->dispatch()
#26 {main}
Sorry but we are not able to provide this at the moment.
DB Error: unknown error
Error Details
Database Error Code: Identifier name 'civicrm_value_soar_membership_application_custom_fields_1_before_insert' is too long, 1059
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_fields_1_before_insert [nativecode=1059 ** Identifier name 'civicrm_value_soar_membership_application_custom_fields_1_before_insert' is too long]
    [type] => DB_Error
    [user_info] => DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_fields_1_before_insert [nativecode=1059 ** Identifier name 'civicrm_value_soar_membership_application_custom_fields_1_before_insert' is too long]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="DROP TRIGGER IF EXISTS civicrm_value_soar_membership_application_custom_fields_1_before_insert [nativecode=1059 ** Identifier name 'civicrm_value_soar_membership_application_custom_fields_1_before_insert' is too long]"]
)
Return to home page.

I've successfully dropped the custom data table and fields that caused this error

How did you drop them? Via SQL or via the CiviCRM web interface?

administrator/?option=com_civicrm&task=civicrm/upgrade/queue/runner&reset=1&qrid=CRM_Upgrade

page is blank with just the reset and skip buttons (both unresponsive)

Can you look at the page with Firebug for Firefox? Odds are you have a JS error and removing cached template files may help.

I turned on firebug, dumped the cache and this is the errors I'm getting when I try to run the db upgrade:

TypeError: CRM.url is not a function
[Break On This Error]    

....url('init', '/administrator/?option=com_civicrm&task=civicrm/example&placeholde...

?optio...Upgrade (line 125)
ReferenceError: cj is not defined
[Break On This Error]    

cj(function() {

OK. Anyhow your previous error is hard to know what it is--it's clearly a JS issue but you would have had to debug why using Firebug.