CiviCRM Community Forums (archive)

3.4.beta1

When I visit /civicrm/admin/setting/misc?reset=1 and try to enable logging, I get the following error ...

Mar 27 22:46:05  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [ 0 ] => CRM_Core_Error
            [ 1 ] => handle
        )

    [ code ] => a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] =>  [nativecode=1065 ** Query was empty]
    [type] => DB_Error
    [user_info] =>  [nativecode=1065 ** Query was empty]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info=" [nativecode=1065 **
 Query was empty]"]
)


Mar 27 22:46:05  [info] $backTrace = //sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 205
, handle,
//sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
//sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 971
//sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
//sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
//sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
//sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
//sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
//sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2420
//sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1606
//sites/all/modules/civicrm/CRM/Core/DAO.php, query, 145
//sites/all/modules/civicrm/CRM/Core/DAO.php, query, 868
//sites/all/modules/civicrm/CRM/Logging/Schema.php, executeQuery, 243
//sites/all/modules/civicrm/CRM/Logging/Schema.php, createLogTableFor, 103
//sites/all/modules/civicrm/CRM/Admin/Form/Setting/Miscellaneous.php, enableLogging, 96
//sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 250
//sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 167
//sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 64
//sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
//sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
//sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 284
//sites/all/modules/civicrm/CRM/Utils/Wrapper.php, run, 115
//sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 195
//sites/all/modules/civicrm/drupal/civicrm.module, invoke, 355
, civicrm_invoke,
//includes/menu.inc, call_user_func_array, 348
//index.php, menu_execute_active_handler, 18

Ken

It is failing on the view civicrm_domain_view. I guess the code should ignore views?

The line ...
$query = $dao->Create_Table;
... sets $query to NULL, leading to the exception. The CREATE VIEW code is stored in $dao->Create_View

Lobo,

It's not multi-lingual. Can I just delete this view? (I can't see any reference to it in the code.)

The view is defined by the following SQL ...
select `civicrm_domain`.`id` AS `id`,`civicrm_domain`.`name` AS `name`,`civicrm_domain`.`description` AS `description`,`civicrm_domain`.`config_backend` AS `config_backend`,`civicrm_domain`.`version` AS `version`,`civicrm_domain`.`loc_block_id` AS `loc_block_id`,`civicrm_domain`.`locales` AS `locales`,`civicrm_domain`.`locale_custom_strings` AS `locale_custom_strings` from `civicrm_domain`
Ken

Just to close the loop, after removing the extraneous view I've successfully turned on logging and am playing with it!