CiviCRM Community Forums (archive)

I am upgrading my Drupal 6.28 testserver from CiviCRM 3.4.1 to 4.1.6
At first I didn't see any activities or cases at all on the dashboard, but that was resolved by disabling the devel (6.x-1.27) module. The next problem now is that 0 (zero) activities are shown on the dashboard but I know there are activities. In the watchdog log I get a lot of these errors: Invalid argument supplied for foreach() in C:\...\htdocs\sites\all\modules\civicrm\CRM\Case\XMLProcessor\Process.php on line 168. , the referrer is civicrm/dashlet/allCases?reset=1&snippet=5.
I read a direct upgrade to 4.2 or 4.3 from 3.x series will probably fail. What should I do, try to solve this error (is it a known error or did I perhaps miss something in the upgrade process?) or upgrade to a newer version (normally it's my idea to go to the newest release, but in this case it is suggested that maybe it doesn't work at all for Drupal 6...), thanks in advance for your reply.

I read that post too, and at first I thought it was something else, because on my dashboard I do see my all my cases. But checking the search page I saw I also get errors there, so it might be related. I can find activities and cases there, but not all of them. So I guess I also have to try to upgrade to a newer version, thanks for your fast reply!

Ok, but that was easier said than done!

Upgrading to 4.3 at once, resulted in a DB Error civicrm_extensions not found, should that table be existing after my 4.1.6 upgrade?

So first trying to upgrade from 4.2:
This resulted in:
- "[Executed: Upgrade DB to 4.2.alpha1]" but the status bar just waits and waits indefinitely.
- In my apache log I get a fatal error: index CRM_upgrade not found
- in my webconsole: Error: SyntaxError: JSON.parse: unexpected character (think this is after the fatal error..)
Source File: .../sites/all/modules/civicrm/packages/jquery/jquery.min.js in line 2

In my Config.IDS.ini I can see some strange slashes and a double slash in te middle, can that cause problems?
In the civicrm.xxx999.log file I get several errors and warnings, is a backtrace helpfull here?

Tried upgrades to 4.2.9 (I also tried this with commenting out several SQL-statements from the file '/CRM/Upgrade/Incremental/sql/4.2.alpha1.mysql.tpl'), 4.2.2, 4.2.1 but they all resulted in the same errors.

Also tried this with en/disabling jquery and jquery ui, but also no effect

By the way, my Drupal installaton is on a Windows NT server, so I didn't try Drush (as suggested sometimes) yet...

Anyone an idea?

Tried several updates again.
Started with a fresh copy of my production 3.4.1 database, upgrade to 4.1.6 was successful with jquery update disabled (but still no activities and search is not correct).
Upgrade to 4.3.2 resulted in a DB error: no such tabel and an error/warning to clear the cache first.

Logfile:
May 11 21:28:14  [info] $Fatal Error Details = Array
(
    [message] => Please reset the Drupal cache (Administer => Site Configuration => Performance => Clear cached data))
    [code] =>
)
May 11 21:28:14  [info] $backTrace = #0 C:\..\sites\all\modules\civicrm\CRM\Core\Error.php(315): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 C:\..\sites\all\modules\civicrm\CRM\Upgrade\Incremental\php\FourThree.php(73): CRM_Core_Error::fatal("Please reset the Drupal cache (Administer => Site Configuration => Performanc...")
#2 C:\..\sites\all\modules\civicrm\CRM\Upgrade\Form.php(656): CRM_Upgrade_Incremental_php_FourThree->setPreUpgradeMessage(NULL, "4.3.beta4", "4.1.6")
#3 C:\..\sites\all\modules\civicrm\CRM\Upgrade\Page\Upgrade.php(108): CRM_Upgrade_Form->setPreUpgradeMessage(NULL, "4.1.6", "4.3.2")
#4 C:\..\sites\all\modules\civicrm\CRM\Upgrade\Page\Upgrade.php(67): CRM_Upgrade_Page_Upgrade->runIntro()
#5 C:\..\sites\all\modules\civicrm\CRM\Core\Invoke.php(292): CRM_Upgrade_Page_Upgrade->run((Array:2), NULL)
#6 C:\..\sites\all\modules\civicrm\CRM\Core\Invoke.php(70): CRM_Core_Invoke::runItem((Array:13))
#7 C:\..\sites\all\modules\civicrm\CRM\Core\Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#8 C:\..\sites\all\modules\civicrm\drupal\civicrm.module(354): CRM_Core_Invoke::invoke((Array:2))
#9 [internal function](): civicrm_invoke("upgrade")
#10 C:\..\includes\menu.inc(350): call_user_func_array("civicrm_invoke", (Array:1))
#11 C:\..\index.php(17): menu_execute_active_handler()
#12 {main}
May 11 21:29:20  [info] $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 'mytestsite.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 'mytestsite.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 'mytestsite.civicrm_extension' doesn't exist]"]
)
May 11 21:29:20  [info] $backTrace = #0 C:\..\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 C:\..\sites\all\modules\civicrm\packages\PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 C:\..\sites\all\modules\civicrm\packages\DB.php(969): 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 C:\..\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 C:\..\sites\all\modules\civicrm\packages\DB\common.php(1905): PEAR->raiseError(NULL, -18, NULL, NULL, "\n        SELECT full_name, file\n        FROM civicrm_extension\n        WHE...", "DB_Error", TRUE)
#6 C:\..\sites\all\modules\civicrm\packages\DB\mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'mytestsite.civicrm_extension' doesn't exist")
#7 C:\..\sites\all\modules\civicrm\packages\DB\mysql.php(327): DB_mysql->mysqlRaiseError()
#8 C:\..\sites\all\modules\civicrm\packages\DB\common.php(1216): DB_mysql->simpleQuery("\n        SELECT full_name, file\n        FROM civicrm_extension\n        WHE...")
#9 C:\..\sites\all\modules\civicrm\packages\DB\DataObject.php(2421): DB_common->query("\n        SELECT full_name, file\n        FROM civicrm_extension\n        WHE...")
#10 C:\..\sites\all\modules\civicrm\packages\DB\DataObject.php(1613): DB_DataObject->_query("\n        SELECT full_name, file\n        FROM civicrm_extension\n        WHE...")
#11 C:\..\sites\all\modules\civicrm\CRM\Core\DAO.php(155): DB_DataObject->query("\n        SELECT full_name, file\n        FROM civicrm_extension\n        WHE...")
#12 C:\..\sites\all\modules\civicrm\CRM\Core\DAO.php(917): CRM_Core_DAO->query("\n        SELECT full_name, file\n        FROM civicrm_extension\n        WHE...", TRUE)
#13 C:\..\sites\all\modules\civicrm\CRM\Extension\Mapper.php(276): CRM_Core_DAO::executeQuery("\n        SELECT full_name, file\n        FROM civicrm_extension\n        WHE...")
#14 C:\..\sites\all\modules\civicrm\CRM\Core\PseudoConstant.php(2105): CRM_Extension_Mapper->getActiveModuleFiles(FALSE)
#15 C:\..\sites\all\modules\civicrm\CRM\Utils\Hook.php(180): CRM_Core_PseudoConstant::getModuleExtensions()
#16 C:\..\sites\all\modules\civicrm\CRM\Utils\Hook\Drupal6.php(84): CRM_Utils_Hook->requireCiviModules((Array:0))
#17 C:\..\sites\all\modules\civicrm\CRM\Utils\Hook\Drupal6.php(63): CRM_Utils_Hook_Drupal6->buildModuleList()
#18 C:\..\sites\all\modules\civicrm\CRM\Utils\Hook.php(740): CRM_Utils_Hook_Drupal6->invoke(1, Object(CRM_Core_Config), NULL, NULL, NULL, NULL, "civicrm_config")
#19 C:\..\sites\all\modules\civicrm\CRM\Core\Config.php(227): CRM_Utils_Hook::config(Object(CRM_Core_Config))
#20 C:\..\sites\all\modules\civicrm\drupal\civicrm.module(258): CRM_Core_Config::singleton()
#21 C:\..\sites\all\modules\civicrm\drupal\civicrm.module(138): civicrm_initialize()
#22 [internal function](): civicrm_block("list")
#23 C:\..\includes\module.inc(476): call_user_func_array("civicrm_block", (Array:1))
#24 C:\..\modules\block\block.module(252): module_invoke("civicrm", "block", "list")
#25 C:\..\modules\block\block.module(324): _block_rehash("acquia_prosper")
#26 [internal function](): block_flush_caches()
#27 C:\..\includes\module.inc(497): call_user_func_array("block_flush_caches", (Array:0))
#28 C:\..\sites\all\modules\admin_menu\admin_menu.inc(416): module_invoke_all("flush_caches")
#29 [internal function](): admin_menu_flush_cache("cache")
#30 C:\..\includes\menu.inc(350): call_user_func_array("admin_menu_flush_cache", (Array:1))
#31 C:\..\index.php(17): menu_execute_active_handler()
#32 {main}

Next I tried an upgrade to 4.2.9:
- first I disabled some extra modules: memcache and javascript aggregator
- removed extra slash in Config.IDS.ini
- then I cleared the cache (drupal and civicrm)

- the upgrade resulted in the same errors as before: (hanging after [Executed: Upgrade DB to 4.2.alpha1] + fatal error in apache: Undefined index: CRM_Upgrade)

Logfile:
May 13 10:49:39  [info] $CRM_Queue_Page_AJAX_runNext_error = Exception: "PHP Error 256 at C:\..\sites\all\modules\civicrm\packages\Smarty\Smarty.class.php:1093: Smarty error: [plugin] fetch cannot read file 'C:\..\sites\all\modules\civicrm\packages\Smarty\/../../CRM/Upgrade/4.2.alpha1.msg_template/message_templates/contribution_recurring_cancelled_subject.tpl'"
#0 [internal function](): CRM_Queue_ErrorPolicy->onError(256, "Smarty error: [plugin] fetch cannot read file 'C:\Program Files\BitNami Drupa...", "C:\..\sites\all\modules\...", 1093, (Array:2))
#1 C:\..\sites\all\modules\civicrm\packages\Smarty\Smarty.class.php(1093): trigger_error("Smarty error: [plugin] fetch cannot read file 'C:\Program Files\BitNami Drupa...", 256)
#2 C:\..\sites\all\modules\civicrm\packages\Smarty\Smarty.class.php(1854): Smarty->trigger_error("[plugin] fetch cannot read file 'C:\Program Files\BitNami Drupal 6 Stack\apps...", 256)
#3 C:\..\sites\all\modules\civicrm\packages\Smarty\plugins\function.fetch.php(204): Smarty->_trigger_fatal_error("[plugin] fetch cannot read file 'C:\Program Files\BitNami Drupal 6 Stack\apps...")
#4 C:\..\sites\my.testsite.nl\files\civicrm\templates_c\en_US\nl_NL\%%9F\9FD\9FD029AE%%civicrm_msg_template.tpl.php(105): smarty_function_fetch((Array:2), Object(CRM_Core_Smarty))
#5 C:\..\sites\all\modules\civicrm\packages\Smarty\Smarty.class.php(1906): include("C:\..\sites\my.test...")
#6 C:\..\sites\my.testsite.nl\files\civicrm\templates_c\en_US\nl_NL\%%98\98C\98C193FA%%4.2.alpha1.mysql.tpl.php(6): Smarty->_smarty_include((Array:2))
#7 C:\..\sites\all\modules\civicrm\packages\Smarty\Smarty.class.php(1263): include("C:\..\sites\my.test...")
#8 C:\..\sites\all\modules\civicrm\CRM\Core\Smarty.php(186): Smarty->fetch("C:\..\sites\all\modules\...", NULL, NULL, FALSE)
#9 C:\..\sites\all\modules\civicrm\CRM\Upgrade\Form.php(292): CRM_Core_Smarty->fetch("C:\..\sites\all\modules\...")
#10 C:\..\sites\all\modules\civicrm\CRM\Upgrade\Form.php(316): CRM_Upgrade_Form->processLocales("C:\..\sites\all\modules\...", "4.2.alpha1")
#11 C:\..\sites\all\modules\civicrm\CRM\Upgrade\Incremental\php\FourTwo.php(416): CRM_Upgrade_Form->processSQL("4.2.alpha1")
#12 [internal function](): CRM_Upgrade_Incremental_php_FourTwo::task_4_2_x_runSql(Object(CRM_Queue_TaskContext), "4.2.alpha1")
#13 C:\..\sites\all\modules\civicrm\CRM\Queue\Task.php(79): call_user_func_array((Array:2), (Array:2))
#14 C:\..\sites\all\modules\civicrm\CRM\Queue\Runner.php(187): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#15 C:\..\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(44): CRM_Queue_Runner->runNext(TRUE)
#16 C:\..\sites\all\modules\civicrm\CRM\Queue\ErrorPolicy.php(80): {closure}()
#17 C:\..\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(47): CRM_Queue_ErrorPolicy->call(Object(Closure))
#18 [internal function](): CRM_Queue_Page_AJAX::runNext((Array:5))
#19 C:\..\sites\all\modules\civicrm\CRM\Core\Invoke.php(187): call_user_func((Array:2), (Array:5))
#20 C:\..\sites\all\modules\civicrm\CRM\Core\Invoke.php(51): CRM_Core_Invoke::_invoke((Array:5))
#21 C:\..\sites\all\modules\civicrm\drupal\civicrm.module(382): CRM_Core_Invoke::invoke((Array:5))
#22 [internal function](): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
#23 C:\..\includes\menu.inc(350): call_user_func_array("civicrm_invoke", (Array:4))
#24 C:\..\index.php(17): menu_execute_active_handler()
#25 {main} 

Maybe someone can tell something seeing these logfiles, thanks in advance

I agree, but the problem is that the upgrade to 4.1.6 is OK and most of the things work, except for showing the correct amount of activities and showing the right activities and cases in the search option. And the solution for the related issue (see Hershel's reply) is upgrading...

Yikes! It's important to find out if the zip file was messed up or if the extraction method was to blame. Please post back with that info asap.

todays update ... looks like I am running into every error on this forum, but ok ...
My upgrade to 4.2.9 went ok, except for having to change my extension resource url (and add a directory for those extensions on the server)
and change the default ssl setting and some extra rights for civicrm (ajax-api and add case).
But still not all activities were shown, tried an update to 4.3.3 right away.
First got the error that I had to clear the caches.
Also had to change some slashes in Config.IDS.ini and remove my templates_c directory.
After clearing the cache I got the screen to start the upgrade.
However, next I got a php-error and a js function that didn't work (upgrade didn't start).
I had to disable the Drupal modules "js aggregator" and "menu-item-container". Then the upgrade really started...
First I thought it stopped again, but some steps just took a long time (a lot of changes in the database..?).
In the end I got a screen that the update was successful! But I still had an error again in my CiviCRM-log:
May 16 14:20:38  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact FOR EACH ROW BEGIN 
SET NEW.created_date = CURRENT_TIMESTAMP;
 END [nativecode=1054 ** Unknown column 'created_date' in 'NEW']
    [type] => DB_Error
    [user_info] => CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact FOR EACH ROW BEGIN 
SET NEW.created_date = CURRENT_TIMESTAMP;
 END [nativecode=1054 ** Unknown column 'created_date' in 'NEW']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact FOR EACH ROW BEGIN 
SET NEW.created_date = CURRENT_TIMESTAMP;
 END [nativecode=1054 ** Unknown column 'created_date' in 'NEW']"]
)

Backtrace:
May 16 14:20:38  [info] $backTrace = #0 C:\..\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 C:\..\sites\all\modules\civicrm\packages\PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 C:\..\sites\all\modules\civicrm\packages\DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#4 C:\..\sites\all\modules\civicrm\packages\PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#5 C:\..\sites\all\modules\civicrm\packages\DB\common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...", "DB_Error", TRUE)
#6 C:\..\sites\all\modules\civicrm\packages\DB\mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'created_date' in 'NEW'")
#7 C:\..\sites\all\modules\civicrm\packages\DB\mysql.php(327): DB_mysql->mysqlRaiseError()
#8 C:\..\sites\all\modules\civicrm\packages\DB\common.php(1216): DB_mysql->simpleQuery("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#9 C:\..\sites\all\modules\civicrm\packages\DB\DataObject.php(2421): DB_common->query("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#10 C:\..\sites\all\modules\civicrm\packages\DB\DataObject.php(1613): DB_DataObject->_query("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#11 C:\..\sites\all\modules\civicrm\CRM\Core\DAO.php(155): DB_DataObject->query("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#12 C:\..\sites\all\modules\civicrm\CRM\Core\DAO.php(917): CRM_Core_DAO->query("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...", FALSE)
#13 C:\..\sites\all\modules\civicrm\CRM\Core\DAO.php(1683): CRM_Core_DAO::executeQuery("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...", (Array:0), TRUE, NULL, FALSE, FALSE)
#14 C:\..\sites\all\modules\civicrm\CRM\Core\DAO.php(1563): CRM_Core_DAO::createTriggers((Array:6))
#15 C:\..\sites\all\modules\civicrm\CRM\Core\Invoke.php(469): CRM_Core_DAO::triggerRebuild()
#16 C:\..\sites\all\modules\civicrm\drupal\civicrm.module(874): CRM_Core_Invoke::rebuildMenuAndCaches(TRUE)
#17 C:\..\includes\form.inc(786): _civicrm_rebuild((Array:30), (Array:5))
#18 C:\..\includes\form.inc(426): form_execute_handlers("submit", (Array:30), (Array:5))
#19 C:\..\includes\form.inc(120): drupal_process_form("system_modules", (Array:30), (Array:5))
#20 [internal function](): drupal_get_form("system_modules")
#21 C:\..\includes\menu.inc(350): call_user_func_array("drupal_get_form", (Array:1))
#22 C:\..\index.php(17): menu_execute_active_handler()
#23 {main}
 
1. On the forum I read that the mysql version could be the problem, but that is not the case I think, I can see a lot of new triggers in the database now and also the column "created_date" in "civicrm_contact" (giving the error) is present.
(Lobo says that this version is not suited for Drupal6, but Coleman has it running fine, so I still want to try this..)
Can I somehow check if there is still something wrong now..? As far as I can see I don't get any errors, but I am going to test for a while before updating my production environment... (so many things can go wrong..).

2. Also in this version not all activities can be found.
But I think I found the reason for that problem.
In my search-results there is a column "With" (at least I think it has that name on an English site because on my site it is translated in Dutch; it is the fourth column) and when that column is empty the activity is not shown.
In all my upgraded versions that was exactly the same, so can it be that a view has been changed after version 3.4.1., checking this value and not showing the activity when it is empty?
I've got two activities that are identical (except for the date): one is shown and the other not. (I can find it when I select the owner!) So it must be a field / value in another table, related to the contact somehow (but I don't know the meaning of the field).

So I think it is in fact a "wrong" view after version 3.4.1., or do you have another opinion?