CiviCRM Community Forums (archive)

Hi.
I'm trying to upgrade from 4.1.3 to 4.2.6
I first upgraded drupal and al modules to the latest available versions - worked fine. Drupal 7.17 now running
Cleaned up caches, and restarted memcached, just to be safe.

Then, I follow http://wiki.civicrm.org/confluence/display/CRMDOC42/Upgrade+Drupal+Sites+to+4.2+-+Drupal+7 :

backup, etc
disable civicrm module (civicrm theme and civigroup roles sync in our case) and let civicrm enabled
remove /site/all/modules/civicrm
unpack the latest civicrm drupal + l10n (we have english/french/dutch enabled)
change perms
check civicrm.settings.php, and add sections as documented where not present
run upgrade script at http://XXXXXXXXXXXXXXXX/civicrm/upgrade?reset=1

I get the green upgrade dialog, 'Use this utility to upgrade your CiviCRM database from 4.1.3 to 4.2.6.' => 'Upgrade now'

confirmation dialog => Yes

Then all I get is a white screen with mi site name on top, then
 CiviCRM Upgrade Tasks
[]     and buttons labelled 'retry' and 'skip'.

Neither button has any visible effect.

At this point it's stuck, and the crm isn't available anymore.
civicrm/dashboard gives a 'DB error : no such table'

I ave the following errors in the watchdog :

$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle ) [code] => -18 [message] => DB Error: no such table [mode] => 16 [debug_info] => SELECT full_name, file FROM civicrm_extension WHERE is_active = 1 AND type = "module" [nativecode=1146 ** Table 'smart_civicrm.civicrm_extension' doesn't exist] [type] => DB_Error [user_info] => SELECT full_name, file FROM civicrm_extension WHERE is_active = 1 AND type = "module" [nativecode=1146 ** Table 'smart_civicrm.civicrm_extension' doesn't exist] [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info=" SELECT full_name, file FROM civicrm_extension WHERE is_active = 1 AND type = "module" [nativecode=1146 ** Table 'smart_civicrm.civicrm_extension' doesn't exist]"] )

$backTrace = #0 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(196): CRM_Core_Error::backtrace("backTrace", TRUE) #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error)) #2 /var/www/html/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error)) #3 /var/www/html/sites/all/modules/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #4 /var/www/html/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #5 /var/www/html/sites/all/modules/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -18, NULL, NULL, "\n SELECT full_name, file\n FROM civicrm_extension\n WHE...", "DB_Error", TRUE) #6 /var/www/html/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'smart_civicrm.civicrm_extension' doesn't exist") #7 /var/www/html/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError() #8 /var/www/html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #9 /var/www/html/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #10 /var/www/html/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #11 /var/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #12 /var/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php(922): CRM_Core_DAO->query("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...", TRUE) #13 /var/www/html/sites/all/modules/civicrm/CRM/Core/PseudoConstant.php(2056): CRM_Core_DAO::executeQuery("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #14 /var/www/html/sites/all/modules/civicrm/CRM/Utils/Hook.php(169): CRM_Core_PseudoConstant::getModuleExtensions() #15 /var/www/html/sites/all/modules/civicrm/CRM/Utils/Hook/Drupal.php(60): CRM_Utils_Hook->requireCiviModules((Array:40)) #16 /var/www/html/sites/all/modules/civicrm/CRM/Utils/Hook.php(724): CRM_Utils_Hook_Drupal->invoke(1, Object(CRM_Core_Config), NULL, NULL, NULL, NULL, "civicrm_config") #17 /var/www/html/sites/all/modules/civicrm/CRM/Core/Config.php(228): CRM_Utils_Hook::config(Object(CRM_Core_Config)) #18 /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module(337): CRM_Core_Config::singleton() #19 /var/www/html/sites/all/modules/civicrm/drupal/civicrm_user.inc(170): civicrm_initialize() #20 [internal function](): civicrm_user_view(Object(stdClass), "full", "en") #21 /var/www/html/includes/module.inc(857): call_user_func_array("civicrm_user_view", (Array:3)) #22 /var/www/html/modules/user/user.module(2590): module_invoke_all("user_view", Object(stdClass), "full", "en") #23 /var/www/html/modules/user/user.module(2537): user_build_content(Object(stdClass), "full", "en") #24 /var/www/html/modules/user/user.module(2498): user_view(Object(stdClass)) #25 [internal function](): user_view_page(Object(stdClass)) #26 /var/www/html/includes/menu.inc(517): call_user_func_array("user_view_page", (Array:1)) #27 /var/www/html/modules/user/user.pages.inc(549): menu_execute_active_handler(NULL, FALSE) #28 [internal function](): user_page() #29 /var/www/html/includes/menu.inc(517): call_user_func_array("user_page", (Array:0)) #30 /var/www/html/index.php(21): menu_execute_active_handler() #31 {main}

$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle ) [code] => -18 [message] => DB Error: no such table [mode] => 16 [debug_info] => SELECT full_name, file FROM civicrm_extension WHERE is_active = 1 AND type = "module" [nativecode=1146 ** Table 'smart_civicrm.civicrm_extension' doesn't exist] [type] => DB_Error [user_info] => SELECT full_name, file FROM civicrm_extension WHERE is_active = 1 AND type = "module" [nativecode=1146 ** Table 'smart_civicrm.civicrm_extension' doesn't exist] [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info=" SELECT full_name, file FROM civicrm_extension WHERE is_active = 1 AND type = "module" [nativecode=1146 ** Table 'smart_civicrm.civicrm_extension' doesn't exist]"] )

$backTrace = #0 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(196): CRM_Core_Error::backtrace("backTrace", TRUE) #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error)) #2 /var/www/html/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error)) #3 /var/www/html/sites/all/modules/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #4 /var/www/html/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #5 /var/www/html/sites/all/modules/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -18, NULL, NULL, "\n SELECT full_name, file\n FROM civicrm_extension\n WHE...", "DB_Error", TRUE) #6 /var/www/html/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'smart_civicrm.civicrm_extension' doesn't exist") #7 /var/www/html/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError() #8 /var/www/html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #9 /var/www/html/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #10 /var/www/html/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #11 /var/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #12 /var/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php(922): CRM_Core_DAO->query("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...", TRUE) #13 /var/www/html/sites/all/modules/civicrm/CRM/Core/PseudoConstant.php(2056): CRM_Core_DAO::executeQuery("\n SELECT full_name, file\n FROM civicrm_extension\n WHE...") #14 /var/www/html/sites/all/modules/civicrm/CRM/Utils/Hook.php(169): CRM_Core_PseudoConstant::getModuleExtensions() #15 /var/www/html/sites/all/modules/civicrm/CRM/Utils/Hook/Drupal.php(60): CRM_Utils_Hook->requireCiviModules((Array:40)) #16 /var/www/html/sites/all/modules/civicrm/CRM/Utils/Hook.php(724): CRM_Utils_Hook_Drupal->invoke(1, Object(CRM_Core_Config), NULL, NULL, NULL, NULL, "civicrm_config") #17 /var/www/html/sites/all/modules/civicrm/CRM/Core/Config.php(228): CRM_Utils_Hook::config(Object(CRM_Core_Config)) #18 /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module(337): CRM_Core_Config::singleton() #19 /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module(427): civicrm_initialize() #20 [internal function](): civicrm_invoke("dashboard") #21 /var/www/html/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:1)) #22 /var/www/html/index.php(21): menu_execute_active_handler() #23 {main}


Memcache is disabled in civicrm :
/**
 * If you have a memcache server configured and want CiviCRM to make use of it,
 * set the following to 1.  You should only set this once you have your memcache
 * server up and working, because CiviCRM will not start up if your server is
 * unavailable on the host and port that you specify.
 */
define( 'CIVICRM_USE_MEMCACHE', 0 );

And the CIVICRM_UF_BASEURL is defined as the site url, without the /civicrm/part :
define( 'CIVICRM_UF_BASEURL'      , 'http://XXXXXXXXXXXXXX/' );


And memcache was disabled before the upgrade?

Can you try opening firebug see if something is missing? either in the net tab o(missing file) or in the console (javascript error)?

X+

This was eventually traced to a theme problem.
Switching to bartik solved the upgrade issue.