CodeIgniter Forums
Error: num_rows() on a non-object - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Error: num_rows() on a non-object (/thread-23131.html)



Error: num_rows() on a non-object - El Forum - 10-01-2009

[eluser]ThaMy[/eluser]
Hi,

im using php 5.2.9 and mysql 5

in the file application/config/database.php
im using:
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = FALSE;
$db['default']['cache_on'] = FALSE;

if I change the value of $db['default']['db_debug'] = TRUE I get this error:

A Database Error Occurred

Unable to connect to your database server using the provided settings.

if the value of $db['default']['db_debug'] = FALSE, the page index.php open, but when I try make the login I get this error:

Call to a member function num_rows() on a non-object in /home/storage/a/dc/97/abor/public_html/sistema_abor/system/application/libraries/redux_auth.php on line 252

can anyone help me?


Error: num_rows() on a non-object - El Forum - 10-01-2009

[eluser]rogierb[/eluser]
Your database setting are not correct. Check them, then double check them:-) The rerror will go away once CI can connect.

Leave the db_debug to true while you are in development.
If you have a problem with either the database or a query, you will notice imediately.

Edit: The error is probably not related to redux.


Error: num_rows() on a non-object - El Forum - 10-01-2009

[eluser]ThaMy[/eluser]
[quote author="rogierb" date="1254421170"]Your database setting are not correct. Check them, then double check them:-) The rerror will go away once CI can connect.

Leave the db_debug to true while you are in development.
If you have a problem with either the database or a query, you will notice imediately.

Edit: The error is probably not related to redux.[/quote]

I checked the setting to my database and it is ok, but if I leave db_debug to false, I cant connect.

This application was working in another server, I'm just migrating the server and the domain

Any idea?


Error: num_rows() on a non-object - El Forum - 10-01-2009

[eluser]rogierb[/eluser]
Did you create a database user that has rights to your database?
Everyting points to CI not being able to connect to the database.

So check your setting, on both CI and the database side. Is the hostname IP based or localhost?


Error: num_rows() on a non-object - El Forum - 10-01-2009

[eluser]ThaMy[/eluser]
[quote author="rogierb" date="1254422025"]Did you create a database user that has rights to your database?
Everyting points to CI not being able to connect to the database.

So check your setting, on both CI and the database side. Is the hostname IP based or localhost?[/quote]


Thanks a lot, i change the value the hostname and it works

I change the value to hostname IP

Big Grin