Testing Database connection

[eluser]mrwilson1[/eluser]
I am getting errors that indicate to me that my database is not connecting

<code>Fatal error: Call to a member function select() on a non-object in /home/shivabe1/public_html/ci/system/application/models/twitter_model.php on line 46</code>
Line 46 is simply
<code>$this->db->select('last_message');</code>

I know how to check database connection with regular php, but how do you do it with CI? and where?

Do my settings look correctly filled in as far as the first 5? I was getting an error that the database could not connect with the settings given, but all of a sudden that stopped and now I get the above. I did try an if statement in the model if($db) but that didnt do anything

most names changed to protect the innocent

$active_group = "default";
$active_record = TRUE;

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "twit";
$db['default']['password'] = "password";
$db['default']['database'] = "shivabe1_twitter";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

Thanks

[eluser]wabu[/eluser]
Are you autoloading the database library? If so I'd think you'd see an error before then.

If not, you might need to add a port setting:

Code:

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

[eluser]mrwilson1[/eluser]
Yes, I had taken auto load out and forgot about it. I put it back in and added the port but still cannot connect. I know the password and name i am using are correct

I do now get the early warning cannot connect with provided settings

Is the database setting ($db[‘default’][‘database’] = “shivabe1_twitter”;( correctly formatted like it would be in a normal connection?

Incidentally I have 2 databases and cant connect to either one

[eluser]wabu[/eluser]
Have you already checked the connection settings using regular PHP? If not it might help pinpoint the problem.

[eluser]mrwilson1[/eluser]
Good idea. I will run up some quick stuff and see what happens. thanks for the help

[eluser]mrwilson1[/eluser]
Got this solved, it seems like I had to add "shivebe1 to

original
$db[‘default’][‘username’] = “twit”;

New
$db[‘default’][‘username’] = “shivabe1_twit”;

which is strange because I have 2 other domains with this host and thats not required.

Many thanks to WABU