Warning: mysqli_error()

[biologyben]

I just installed CiviCRM 4.5.2 on a fully up-to-date wordpress.  Things are going well, but anytime I search from the navagation bar in the back end I recieve this message.

Code: [Select]

Warning: mysqli_error() expects parameter 1 to be mysqli, resource given in /webroot/b/g/bgcpa001/primary/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php on line 224

I can search just fine from the 'Search > Contacts" link however.  Any advice?

[biologyben]

I see there are no replys - Is this that odd of an error message, too simple to solve, or did I not explain this well enough?

[JonGold]

It's well-explained, but I've never seen that before, and I work with lots of Civi installs - so I'm guessing it's a pretty rare/odd issue, which is why you haven't seen responses. Sorry!

[biologyben]

I have not installed any admin theme that would likely be impacting this & I double checked that none of my plug-ins are on the known conflict list.  Odd that most everything seems to work still - the the search dropdown box has odd formatting that I assumed was a just CSS conflict, but now I assume they are inter-related.

It also had this error after the mysqli error message:

     Sorry but we are not able to provide this at the moment.
     QuickForm Error: nonexistent html element

I thought I'd share a code snippet from the indicated line.  This is on a Wordpress 4.0 Multisite install with CiviCrm 4.5.2.  I marked the line that is indicated in the error message.

Code: [Select]

    elseif (function_exists('mysqli_error')) {
      $dao = new CRM_Core_DAO();

      // we do it this way, since calling the function
      // getDatabaseConnection could potentially result
      // in an infinite loop
      global $_DB_DATAOBJECT;
      if (isset($_DB_DATAOBJECT['CONNECTIONS'][$dao->_database_dsn_md5])) {
        $conn = $_DB_DATAOBJECT['CONNECTIONS'][$dao->_database_dsn_md5];
        $link = $conn->connection;

        if (mysqli_error($link))                                                                          <---- (THIS IS LINE 224 mentioned in the error)
          $mysql_error = mysqli_error($link) . ', ' . mysqli_errno($link);
          $template->assign_by_ref('mysql_code', $mysql_error);

          // execute a dummy query to clear error stack
          mysqli_query($link, 'select 1');
        }
      }
    }


[Dan C]

Are you getting any errors in your browser console.  I don't think the mysqli error is the root of the problem, the problem is something else and that is just the end result because of another error.  But it seems to be something specific to your environment, not a bug in Civi, so it is hard to guess what might be the cause without looking at your site specifically.  Do you have any customizations in place on your Civi install?

[biologyben]

No - using chrome locally and have tried ie - same problem.  In chrome, the console log doesn't show any errors related to this.

I do have the same issue with the CiviCRM News dashlet  that you see on the WP Demo site though.  The demo searches correctly however.  (I was able to simply remove these)

I'll turn error logging on with CC but that didn't capture any concerns on the webpage and there is no indication in the wiki or book on the log file location on WordPress sites - I've searched for any path including "ConfigAndLog" in the Civicrm plug-in directory, but no luck yet - if I find it, I'll post any logs it shows.

I'll also start turning off plugins and see if it changes...

[biologyben]

plugins had no change...

There was an additional error message with logging turned on: 

Code: [Select]

Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => QuickForm Error: nonexistent html element
    [mode] => 16
    [debug_info] => Element 'country' does not exist in HTML_QuickForm::getElementValue()
    [type] => HTML_QuickForm_Error
    [user_info] => Element 'country' does not exist in HTML_QuickForm::getElementValue()
    [to_string] => [html_quickform_error: message="nonexistent html element" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="QuickForm Error: " info="Element 'country' does not exist in HTML_QuickForm::getElementValue()"]
)

So, using this information, I turned on the 'country' checkbox in admin>admin console>address settings>address editing and now it works fine.  This is very strange - I tried to replicate in the demo with no luck.

[Dan C]

The demo site is currently on 4.5.3, I wonder if there was something fixed that resolved this issue and that is why you can't recreate it.  I don't have a 4.5.2 site that I can test on right now othrewise I would see.  I'm glad that you were able to resolve it though.

[philiphart]

Our site has just been upgraded (by CiviHosting) to 4.5.6 and we now experience exactly the same pair of error messages.

The mysqli error when saving an event settings page, and the QuickForm html error when I try to register for the event.

In our case, the State/Province setting is already turned on in Administer-Address Settings and the error does not change whether it is turned on or off.

[Hershel]

philiphart, I looked at your site with debugging enabled and the full error message is:

Code: [Select]

Element 'state_province-Primary' does not exist in HTML_QuickForm::getElement()

I also noticed that if I visit the URL

 /civicrm/event/manage/settings?reset=1&action=update&id=21

on your site and click on Online Registration I see this message:

Code: [Select]

The selected profile is using a custom field which is not assigned to the "Event" being configured.
I don't know if that's related however.