CiviCRM Community Forums (archive)

When I do a search (Search ...Custom Searches ... Basic Search) and I get a list of contacts that is more than 1 page, trying to use the "select all rows" check box  prevents use of any search actions.  ( the search box is frozen, and the count of selected records remains at 0)

I turned on Firebug, and I am seeing errors such as

SyntaxError: test for equality (==) mistyped as assignment (=)?
while (ch = stream.next()) {
javascript.js (line 142, col 29

I have already cleared the CiviCRM cache and the Drupal cache but no luck so far. Any suggestions on how I can troubleshoot this?

(I am running version 4.5.6, which was upgraded from 4.5.5 which was upgraded from 4.4.7)

I did some more investigation with Firebug, and when I check the checkbox for "select all rows" the following URL call is made:

http://mygroup.org/civicrm/ajax/markSelection?qfKey=civicrm+search+0e6ce642c0e52c092ce6a00a51fda2f3_3063&variableType=multiple&name=mark_x_3892-mark_x_4479-mark_x_3363-mark_x_4487-mark_x_4281-mark_x_37-mark_x_2898-mark_x_3666-mark_x_4726-mark_x_4733-mark_x_4734-mark_x_698-mark_x_3521-mark_x_1729-mark_x_1775-mark_x_39-mark_x_2471-mark_x_4460-mark_x_40-mark_x_760-mark_x_1341-mark_x_4688-mark_x_2935-mark_x_41-mark_x_893-mark_x_3812-mark_x_1416-mark_x_42-mark_x_1406-mark_x_1409-mark_x_4209-mark_x_4727-mark_x_4728-mark_x_4729-mark_x_653-mark_x_4349-mark_x_19377-mark_x_2945-mark_x_2794-mark_x_661-mark_x_2188-mark_x_4298-mark_x_1521-mark_x_2723-mark_x_1418-mark_x_2095-mark_x_4211-mark_x_3010-mark_x_894-mark_x_2884

Unfortunately the response is an HTML stack trace, which prevents the search actions from working:

<p>backTrace</p><p><pre>#0 /home/dev1/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(191): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/dev1/public_html/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/dev1/public_html/sites/all/modules/civicrm/packages/DB.php(975): PEAR_Error-&gt;PEAR_Error(&quot;DB Error: unknown error&quot;, -1, 16, (Array:2), &quot; [nativecode=1065 ** Query was empty]&quot;)
#4 /home/dev1/public_html/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error-&gt;DB_Error(-1, 16, (Array:2), &quot; [nativecode=1065 ** Query was empty]&quot;)
#5 /home/dev1/public_html/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR-&gt;raiseError(NULL, -1, NULL, NULL, &quot; [nativecode=1065 ** Query was empty]&quot;, &quot;DB_Error&quot;, TRUE)
#6 /home/dev1/public_html/sites/all/modules/civicrm/packages/DB/mysql.php(899): DB_common-&gt;raiseError(-1, NULL, NULL, NULL, &quot;1065 ** Query was empty&quot;)
#7 /home/dev1/public_html/sites/all/modules/civicrm/packages/DB/mysql.php(328): DB_mysql-&gt;mysqlRaiseError()
#8 /home/dev1/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql-&gt;simpleQuery(&quot;&quot;)
#9 /home/dev1/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(2442): DB_common-&gt;query(&quot;&quot;)
#10 /home/dev1/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(1634): DB_DataObject-&gt;_query(&quot;&quot;)
#11 /home/dev1/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(325): DB_DataObject-&gt;query(&quot;&quot;)
#12 /home/dev1/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(1116): CRM_Core_DAO-&gt;query(&quot;&quot;, TRUE)
#13 /home/dev1/public_html/sites/all/modules/civicrm/CRM/Core/BAO/PrevNextCache.php(397): CRM_Core_DAO::executeQuery(NULL, (Array:0))
#14 /home/dev1/public_html/sites/all/modules/civicrm/CRM/Contact/Page/AJAX.php(1023): CRM_Core_BAO_PrevNextCache::markSelection(&quot;civicrm search 0e6ce642c0e52c092ce6a00a51fda2f3_3063&quot;, &quot;select&quot;)
#15 [internal function](): CRM_Contact_Page_AJAX::selectUnselectContacts()
#16 /home/dev1/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(300): call_user_func((Array:2))
#17 /home/dev1/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(79): CRM_Core_Invoke::runItem((Array:12))
#18 /home/dev1/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#19 /home/dev1/public_html/sites/all/modules/civicrm/drupal/civicrm.module(457): CRM_Core_Invoke::invoke((Array:3))
#20 [internal function](): civicrm_invoke(&quot;ajax&quot;, &quot;markSelection&quot;)
#21 /home/dev1/public_html/includes/menu.inc(517): call_user_func_array(&quot;civicrm_invoke&quot;, (Array:2))
#22 /home/dev1/public_html/index.php(21): menu_execute_active_handler()
#23 {main}


Any ideas on why the query seems to be empty?