CiviCRM Community Forums (archive)

Hi,

Quite new with CiviCRM and Drupal7 so not sure how to ask right question but  I'll try. Recentl I've been asked to perform CiviCRM security update up to 4.4.0. All went fine as far as quick test  shows but two things which might be unrelated though.

First: message in Drupal Watchdog Ignoring exception thrown by nullHandler: -2, DB Error: syntax errorSecond: Contacts table located at top of Full-Search page ( /civicrm/contact/search/custom?csid=15&reset=1&force=1&table=Contact&text= ) loose contact profiles link (both from user name and "view") : link is actually there but format is broken:  <ahref=" details"="" view?reset="1&amp;cid=130&amp;context=fulltext&amp;key=d60c1d332422c1cb457c380ff1451de4_9784&quot;title=&quot;View" contact="" civicrm="" 440update="">234, 234</ahref=">
Here is an error backtrace, makes no sense for me at all but hope someone more knowledgeable will be able to shed some light on this.

Thank you!

$backTrace = #0 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/Error.php(771): CRM_Core_Error::backtrace("backTrace", TRUE) #1 [internal function](): CRM_Core_Error::nullHandler(Object(DB_Error)) #2 /dev/httpdocs/440update/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error)) #3 /dev/httpdocs/440update/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: syntax error", -2, 16, (Array:2), "1 [nativecode=1064 ** You have an error in your SQL syntax; check the manual ...") #4 /dev/httpdocs/440update/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-2, 16, (Array:2), "1 [nativecode=1064 ** You have an error in your SQL syntax; check the manual ...") #5 /dev/httpdocs/440update/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -2, NULL, NULL, "1 [nativecode=1064 ** You have an error in your SQL syntax; check the manual ...", "DB_Error", TRUE) #6 /dev/httpdocs/440update/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 /dev/httpdocs/440update/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError() #8 /dev/httpdocs/440update/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("1") #9 /dev/httpdocs/440update/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("1") #10 /dev/httpdocs/440update/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("1") #11 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/DAO.php(158): DB_DataObject->query("1") #12 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/DAO.php(905): CRM_Core_DAO->query("1", TRUE) #13 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Contact/Selector.php(922): CRM_Core_DAO::executeQuery("1") #14 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Contact/Selector.php(803): CRM_Contact_Selector->fillupPrevNextCache(Object(CRM_Utils_Sort), "civicrm search d60c1d332422c1cb457c380ff1451de4_7638", 0, 500) #15 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Contact/Selector/Custom.php(352): CRM_Contact_Selector->buildPrevNextCache(Object(CRM_Utils_Sort)) #16 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php(402): CRM_Contact_Selector_Custom->getRows(4, 0, 50, Object(CRM_Utils_Sort), 1, NULL) #17 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php(340): CRM_Core_Selector_Controller->getRows(Object(CRM_Contact_Selector_Controller)) #18 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Contact/Form/Search.php(961): CRM_Core_Selector_Controller->run() #19 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom.php(135): CRM_Contact_Form_Search->postProcess() #20 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Contact/Form/Search.php(798): CRM_Contact_Form_Search_Custom->postProcess() #21 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Contact/Form/Search/Custom.php(80): CRM_Contact_Form_Search->preProcess() #22 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/Form.php(351): CRM_Contact_Form_Search_Custom->preProcess() #23 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(93): CRM_Core_Form->buildForm() #24 /dev/httpdocs/440update/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contact_Form_Search_Custom), "display") #25 /dev/httpdocs/440update/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Search_Custom), "display") #26 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("display") #27 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/Invoke.php(323): CRM_Core_Controller->run((Array:4), (Array:0)) #28 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:12)) #29 /dev/httpdocs/440update/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4)) #30 /dev/httpdocs/440update/sites/all/modules/civicrm/drupal/civicrm.module(436): CRM_Core_Invoke::invoke((Array:4)) #31 [internal function](): civicrm_invoke("contact", "search", "custom") #32 /dev/httpdocs/440update/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:3)) #33 /dev/httpdocs/440update/index.php(21): menu_execute_active_handler() #34 {main}