CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Logging problem after upgrade to 4.4.4
Pages: [1]

Author Topic: Logging problem after upgrade to 4.4.4  (Read 594 times)

CatorgHans

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.4
  • CMS version: drupal
Logging problem after upgrade to 4.4.4
April 09, 2014, 06:08:08 am
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

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Logging problem after upgrade to 4.4.4
April 09, 2014, 03:07:00 pm
Did you turn off the Logging feature in Administer before attempting your upgrade?
Try CiviTeacher: the online video tutorial CiviCRM learning library.

CatorgHans

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.4
  • CMS version: drupal
Re: Logging problem after upgrade to 4.4.4
April 10, 2014, 12:15:22 am
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 post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.4
  • CMS version: drupal
Re: Logging problem after upgrade to 4.4.4
April 14, 2014, 03:26:23 am
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.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Logging problem after upgrade to 4.4.4

This forum was archived on 2017-11-26.