Logging problem after upgrade to 4.4.4

[CatorgHans]

Logging problem after upgrade from 4.2.x to 4.4.4
---
I the logfile I see the following

Code: [Select]

Apr 09 14:20:54  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>
FROM civicrm_temp_civireport_logsummary entity_log_civireport
WHERE (1)
GROUP BY log_civicrm_entity_log_date, log_civicrm_entity_log_type_label, log_civicrm_entity_log_conn_id, log_civicrm_entity_log_user_id, log_civicrm_entity_altered_contact_id
ORDER BY log_civicrm_entity_log_date DESC  LIMIT 0, 50 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM civicrm_temp_civireport_logsummary entity_log_civireport
WHERE (1)
GROUP BY' at line 1]
    [type] => DB_Error
    [user_info] =>
FROM civicrm_temp_civireport_logsummary entity_log_civireport
WHERE (1)
GROUP BY log_civicrm_entity_log_date, log_civicrm_entity_log_type_label, log_civicrm_entity_log_conn_id, log_civicrm_entity_log_user_id, log_civicrm_entity_altered_contact_id
ORDER BY log_civicrm_entity_log_date DESC  LIMIT 0, 50 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM civicrm_temp_civireport_logsummary entity_log_civireport
WHERE (1)
GROUP BY' at line 1]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
FROM civicrm_temp_civireport_logsummary entity_log_civireport
WHERE (1)
GROUP BY log_civicrm_entity_log_date, log_civicrm_entity_log_type_label, log_civicrm_entity_log_conn_id, log_civicrm_entity_log_user_id, log_civicrm_entity_altered_contact_id
ORDER BY log_civicrm_entity_log_date DESC  LIMIT 0, 50 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM civicrm_temp_civireport_logsummary entity_log_civireport
WHERE (1)
GROUP BY' at line 1]"]
)


Apr 09 14:20:54  [info] $backTrace = #0 /var/www/test/sites/all/modules/civicrm/CRM/Core/Error.php(197): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/test/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/test/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: syntax error", -2, 16, (Array:2), "\nFROM civicrm_temp_civireport_logsummary entity_log_civireport\nWHERE (1)\nG...")
#4 /var/www/test/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-2, 16, (Array:2), "\nFROM civicrm_temp_civireport_logsummary entity_log_civireport\nWHERE (1)\nG...")
#5 /var/www/test/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -2, NULL, NULL, "\nFROM civicrm_temp_civireport_logsummary entity_log_civireport\nWHERE (1)\nG...", "DB_Error", TRUE)
#6 /var/www/test/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-2, NULL, NULL, NULL, "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 /var/www/test/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /var/www/test/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("\nFROM civicrm_temp_civireport_logsummary entity_log_civireport\nWHERE (1)\nG...")
#9 /var/www/test/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("\nFROM civicrm_temp_civireport_logsummary entity_log_civireport\nWHERE (1)\nG...")
#10 /var/www/test/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("\nFROM civicrm_temp_civireport_logsummary entity_log_civireport\nWHERE (1)\nG...")
#11 /var/www/test/sites/all/modules/civicrm/CRM/Core/DAO.php(160): DB_DataObject->query("\nFROM civicrm_temp_civireport_logsummary entity_log_civireport\nWHERE (1)\nG...")
#12 /var/www/test/sites/all/modules/civicrm/CRM/Core/DAO.php(907): CRM_Core_DAO->query("\nFROM civicrm_temp_civireport_logsummary entity_log_civireport\nWHERE (1)\nG...", TRUE)
#13 /var/www/test/sites/all/modules/civicrm/CRM/Report/Form.php(2286): CRM_Core_DAO::executeQuery("\nFROM civicrm_temp_civireport_logsummary entity_log_civireport\nWHERE (1)\nG...")
#14 /var/www/test/sites/all/modules/civicrm/CRM/Logging/ReportSummary.php(326): CRM_Report_Form->buildRows("\nFROM civicrm_temp_civireport_logsummary entity_log_civireport\nWHERE (1)\nG...", (Array:0))
#15 /var/www/test/sites/all/modules/civicrm/CRM/Report/Form.php(620): CRM_Logging_ReportSummary->postProcess()
#16 /var/www/test/sites/all/modules/civicrm/CRM/Core/Form.php(351): CRM_Report_Form->preProcess()
#17 /var/www/test/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(93): CRM_Core_Form->buildForm()
#18 /var/www/test/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Report_Form_Contact_LoggingSummary), "display")
#19 /var/www/test/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Contact_LoggingSummary), "display")
#20 /var/www/test/sites/all/modules/civicrm/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("display")
#21 /var/www/test/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
#22 /var/www/test/sites/all/modules/civicrm/CRM/Report/Page/Instance.php(103): CRM_Utils_Wrapper->run("CRM_Report_Form_Contact_LoggingSummary", NULL, NULL)
#23 /var/www/test/sites/all/modules/civicrm/CRM/Core/Invoke.php(323): CRM_Report_Page_Instance->run((Array:4), NULL)
#24 /var/www/test/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:14))
#25 /var/www/test/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#26 /var/www/test/sites/all/modules/civicrm/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:4))
#27 [internal function](): civicrm_invoke("report", "instance", "64")
#28 /var/www/test/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:3))
#29 /var/www/test/index.php(21): menu_execute_active_handler()
#30 {main}



The weird thing imo is that the SQL statement seems to start with FROM

A clean install with 4.4.4 (on another server) works.

[CiviTeacher.com]

Did you turn off the Logging feature in Administer before attempting your upgrade?

[CatorgHans]

I've done the upgrade twice. Certainly with the first, test upgrade I know I switched it off before upgrade.
There it also does not work.

If I'm mistaken and I did that wrong, how can I check and is there a way to restore?

[CatorgHans]

I switched off logging, made a DB dump without log_ files, deleted the DB, created the DB again with the DUMP, enabled logging and got the SAME problem.

So, it has not to do with the logging being switched off or not during upgrade, because log tables where recreated after enabling logging again.