Login

11-16-2010, 03:55 PM

[eluser]Xabi87[/eluser]
Hi,

I've just setup a new codeigniter instance, everything except the database connection is working fine.

I've setup my config as follows (in config/database.php):

Code:
$active_group = 'default';

$active_record = TRUE;

$db['default']['hostname'] = "174.123.123.123";

$db['default']['port'] = "3306";

$db['default']['username'] = "test_user";

$db['default']['password'] = "mypassword";

$db['default']['database'] = "shora_template";

$db['default']['dbdriver'] = "mysql";

$db['default']['dbprefix'] = "";

$db['default']['pconnect'] = TRUE;

$db['default']['db_debug'] = FALSE;

$db['default']['cache_on'] = FALSE;

$db['default']['cachedir'] = "";

$db['default']['char_set'] = "utf8";

$db['default']['dbcollat'] = "utf8_general_ci";

I've setup a query in a test model, and I'm seeing no errors (should I?), only no results:

Code:
$query = $this->db->get('Daemon');

echo "num rows:" . $query->num_rows();

This returns nothing.

The query definitely returns a result, I'm using a mysql query browser session with the exact same connection info, same port, same user, and the same query is returning a result.

I've enabled the profiler on the page and I can see the correct query in the 'DATABASE' section.

Any ideas? I'd appreciate some further troubleshooting steps please!

Thanks,

Xabi