CiviCRM Community Forums (archive)

I am trying to use the merge case function in CiviCase and I am getting a fatal error.

To reproduce the steps open two cases and then select a case to merge from  the Merge Case link.

Sorry. A non-recoverable error has occurred.
DB Error: syntax error

Here is the backtrace

/home/somesite/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 159
, handle,
/home/somesite/public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/home/somesite/public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/home/somesite/public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/home/somesite/public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home/somesite/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/home/somesite/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/somesite/public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/somesite/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2424
/home/somesite/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1610
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 152
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 879
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Case/BAO/Case.php, executeQuery, 2267
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Case/Form/CaseView.php, mergeCases, 482
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 250
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 167
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 64
/home/somesite/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/somesite/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 284
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Case/Page/Tab.php, run, 121
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Case/Page/Tab.php, view, 207
/home/somesite/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 224
/home/somesite/public_html/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 451
, civicrm_invoke,
/home/somesite/public_html/includes/menu.inc, call_user_func_array, 503
/home/somesite/public_html/index.php, menu_execute_active_handler, 21

This site is running
CiviCRM 4.0.8 on Drupal 7.10
MySQL 5.1.56
PHP 5.2.17
Apache 2.2.19

Any help is very much appreciated. 

CiviCase does not appeared to be available. 

I cannot duplicate it.

There is something strange happening with my install. See the attached. There are 9 cases attached to this account and none of them snow on the listing. They also cannot be merged.  I think this is  related.  I am out of ideas on what it could be. 

Thanks,
Steve

No they do not show up when I search.