PHP Fatal error: Call to a member function num_rows() on a non-object

Question

I am working with MySQL in conjunction with ExpressionEngine 2.2.1. This version of ExpressionEngine automatically comes with a Query Module, which I am using to filter and display entry results from a module called Freeform. I am using Freeform version 3.1.1. All of these elements are working well together and displaying the desired results on my local setup. However when I push my code to production, I am receiving this error:

Fatal error: Call to a member function num_rows() on a non-object in /var/www/vhosts/xxxxxxxxx.com/systemxxx/expressionengine/modules/query/mod.query.php on line 183

Here is this section of the code beginning on line 183 of mod.query.php (I did not code this php, nor have I ever coded php, this was already included with the site that I am working on.):

183          if ($query->num_rows() == 0)
184          {
185          return $this->return_data = $this->EE->TMPL->no_results();
186          }

Here is how I am using the Query Module in my HTML Template:

{exp:query sql="SELECT first_name, last_name, email, city FROM exp_freeform_entries WHERE city = 'New York'"}
    <tr>
        <td>{first_name}</td>
        <td>{last_name}</td>
        <td>{email}</td>
        <td>{city}</td>
    </tr>
{/exp:query}

Does anyone know why this error is occurring? Why would it be occurring on production but not locally?

Any help would be greatly appreciated!

Welcome to Stack Overflow! You are probably not doing any error checking in your query. You need to check whether the `mysql_query()` call actually succeeded. Otherwise, your script will break if the query fails. How to do this is outlined in the manual on `mysql_query()` or in [this reference question.](http://stackoverflow.com/questions/6198104/reference-what-is-a-perfect-code-sample-using-the-mysql-extension) — Pekka, Jan 05 '12 at 14:27
probably you missing uploading some files on production check — Dau, Jan 05 '12 at 14:28

score 0 · Answer 1 · answered Jan 05 '12 at 14:29

0

You probably got different database content on production and local systems so the statement fails on the production system producing an error.

You should try executing the statement in phpmyadmin or something like that to see if your sql statement is error-free and doesn't have any conflicts with naming.

answered Jan 05 '12 at 14:29

bardiir

14,556
9
41
66

How can I try executing my statement to see if it is error free? Actually diving into phpmyadmin is the part of our site that I am still very vague on. – jennetcetera Jan 05 '12 at 15:26
Look around phpmyadmin, there's a possibility to execute raw SQL, just paste your statement there. – bardiir Jan 05 '12 at 15:28
Ans yes, if your database is missing some fields on your production server that's most likely causing this issue and you will need to create them. Maybe the best solution for that would be to give the control panel another try. – bardiir Jan 05 '12 at 15:28
Cool, I found where to execute the raw SQL. I pasted my statement and it actually returned results. The webpage is still not working in a browser though... – jennetcetera Jan 05 '12 at 15:53

score 0 · Answer 2 · answered Jan 05 '12 at 14:35

0

Seems that your $query object has no valid connection. Control your username, password and database configuration.

answered Jan 05 '12 at 14:35

Daniel

3,726
4
26
49

Could you explain this further? As far as I know, my username, password, & database configuration is all correct – jennetcetera Jan 05 '12 at 15:49

score 0 · Answer 3 · answered Jan 05 '12 at 21:43

Enable debugging in your config.php and database.php to see detailed error messages:

/system/expressionengine/config/config.php

$config['debug'] = '1';

/system/expressionengine/config/database.php

$db['expressionengine']['db_debug'] = TRUE;

It also wouldn't hurt to:

Verify your MySQL database credentials
Check Apache's and/or PHP's error_log

Hopefully, these steps will allow you to get more insight into your problem.

score 0 · Accepted Answer · answered Jan 05 '12 at 21:54

Check to make sure the database in Production has the same structure as your Local environment.

Perform the following steps from phpMyAdmin or your favorite MySQL GUI client:

Select your ExpressionEngine database
Execute the following SQL Statements:
DESCRIBE exp_freeform_fields;
SELECT name FROM exp_freeform_fields;

Compare the results from your Local MySQL Database to your Production MySQL Database.

PHP Fatal error: Call to a member function num_rows() on a non-object

4 Answers4