class mysqli question

Worker Joined: Sep 28, 2006 Posts: 241

I moved to a new server and tried to install 2.5 with error reporting on and the install went flawlessly. When i try to go to my site after a good install and zero errors i get the following error.

Code:

Fatal error: Class 'mysqli' not found in /home/alteredn/public_html/db/mysqli.php on line 41

I contacted my host and the following is installed.

mysql 5.1.56
PHP 5.2.17

The also assured me that mysqli is installed and activated on the server so i am at a loss. I did install a test file for the php info and did not see any reference to mysqli being installed at all.

I should see it in the php info correct ?

Posted: Sat May 12, 2012 8:30 am

try this code in a file:

Code:




if (!function_exists('mysqli_init') && !extension_loaded('mysqli')) {


    echo 'We don\'t have mysqli!!!';


} else {


    echo 'Phew we have it!';


}

You should also have a section in phpinfo() that looks something like this.

Posted: Tue May 22, 2012 12:46 pm

I just finished a fresh install of rn 2.5 and I'm getting the same above error after successfully completing setup.php.
Fatal error: Class 'mysqli' not found in /home/*****/public_html/db/mysqli.php on line 41

phpinfo() shows no mysqli table, only mysql.
I have several other RN sites on this server, all running rn2.4 and they work just great. What's up with mysqli and RN 2.5?

Thanks for the new ver! and thanks for the help.
Cody

registered · Posted: Tue May 22, 2012 1:20 pm

If you are running a current version of php, 5.1+, it should have mysqli enabled. If not, have your host compile php with mysqli. Mysqli has several benefits over mysql. Support for an object-oriented interface, prepared statements, multiple statements and several other improvements.

Posted: Tue May 22, 2012 9:24 pm

I'm running php ver 5.3+. I'll look into the upgrade, thanks.