Codeigniter CI_DB_mysqli_result Problem

Codeigniter CI_DB_mysqli_result Problem - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Codeigniter CI_DB_mysqli_result Problem (/showthread.php?tid=34854)

Codeigniter CI_DB_mysqli_result Problem - El Forum - 10-11-2010

[eluser]adhardy213[/eluser]
Ok

I'm on a cpanel host and it may be a problem there but has anyone come across this problem:

Code:
Fatal error: Class 'CI_DB_mysqli_result' not found in /home/XXXXXX/public_html/system/database/DB_driver.php on line 367

its being triggered from a line in a model like this:

Code:
$this->db->select("userid");

        $query = $this->db->get_where('user',array('username'=>$name,'password'=>$pass));

I think it may be to do with my connection config which is something like (private details (XX'd out)

Code:
$active_group = "default";

<tumbleweed></tumbleweed>

$active_record = TRUE;

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

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

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

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

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

$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";

Strangely if I select mysql over mysqli I cant connect. But phpmyadmin is reporting use of mysql not mysqli. Is this something to do with it.

Am I missing something simple, should I contact my host?

Any help much appreciated

Codeigniter CI_DB_mysqli_result Problem - El Forum - 10-11-2010

[eluser]adhardy213[/eluser]
tumbleweed!!

Codeigniter CI_DB_mysqli_result Problem - El Forum - 10-11-2010

[eluser]Bart v B[/eluser]
Did you also check your phpinfo(); ?
Is your hosting supporting mysqli?

so when is not why don't you use mysql instead?

Codeigniter CI_DB_mysqli_result Problem - El Forum - 10-11-2010

[eluser]InsiteFX[/eluser]
You also need to check that your php.ini is setup
to use MySQLI.

InsiteFX

Codeigniter CI_DB_mysqli_result Problem - El Forum - 10-12-2010

[eluser]adhardy213[/eluser]
Yeah Im looking into these things.

I think its my hosting personally, Its wierd though that I can only get CI to connect to the database if I say

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

yet phpmyadmin says mysql dont you think?

Codeigniter CI_DB_mysqli_result Problem - El Forum - 10-12-2010

[eluser]adhardy213[/eluser]
Ok Ive been in touch with my host and mysqli is definently enabled: I've read php.ini and its there.

I'm now totally stumped

Anyone shed any light?