Install Fails without mysqli enabled

[dbltoe]

Server Information
Server Host: host.myzencarthostDOTcom (###.###.###.###)	Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.32-431.17.1.el6.x86_64	Database: MySQL 5.5.37-cll
Server Date: 07/12/2014 06:18:31	Database Date: 07/12/2014 01:18:31
Server Up Time: 01:18:31 up 1:39, 0 users, load average: 0.11, 0.77, 0.81	HTTP Server: Apache/2.2.27 (Unix) mod_ssl/2.2.27 OpenSSL/1.0.1e-fips mod_bwlimited/1.4
PHP Version: 5.4.28 (Zend: 2.4.0) PHP Memory Limit: 32M	PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M	POST Max Size: 8M
Database Data Size: 7,459 kB	Database Index Size: 1,286 kB

PROBLEM: Taking russianradiantsaDOTcom to 1.5.3 by creating a new DB and loading latest 1.5.3 zip to the server. Then, extract the zip and rename the folder to something like test. This gives a clean upload and database to work with. When we do the zc_install, we're told (on the System Inspection page) that MySQL Support = OFF. Hard to believe since all databases are functional on the root and all other sites on the server.

Doing the same exact procedure with a copy of 1.5.0 results in the System Information page telling us that MySQL Support = ON.

With the exception of gzip and php version, all other items are green checked. gzip is not on in either scenario and 1.5.0 shows an expected concern with the PHP version.



Suggestions?

[lhungil]

Is mysqli available? On a side note, 32M seems a bit on the low side for memory...

[dbltoe]

Don't see any ref to mysqli anywhere. 32M is temp setting that can be changed. A better value would be...?

[lhungil]

Zen Cart 1.5.0 uses mysql to connect to the database, Zen Cart 1.5.1+ uses mysqli to connect to the database. If not seeing mysqli in phpinfo(), this is the most likely cause of the symptoms you are describing.

[dbltoe]

Interesting.... Server Info showed mysqli as on but did not allow connect until ran cP/DEDI root@##.###.###.### [~]# php -m |grep mysqli
mysqli

Working now. Thanx for the help.

[lhungil]

Strange... But glad you were able to get back in business.

[DrByte]

When you titled your post using "Install Fails", did you really just mean "MySQL Support = OFF" ?

[dbltoe]

Wasn't sure what to use as 1.5.0 was working but in hindsight I agree that it was a poor choice. Please change to help others better in the future.
THANX
John

[DrByte]

No worries. I just wanted to be sure I understood the issue correctly.

I'd thought we'd addressed the issue of drawing attention to the need for mysqli at install-time. Perhaps we can make it more obvious. The challenge is that mysqli has been available for many years, built-in to PHP by default, so the expectation is that it should be available by default for pretty much everyone.

NOTE: The mysql() functions are obsoleted in PHP 5.5, and you'll be forced to use mysqli() instead ... hence the change. http://www.zen-cart.com/entry.php?6-...nd-5-5-and-5-6

[lat9]

NOTE: The mysql() functions are obsoleted in PHP 5.5, and you'll be forced to use mysqli() instead ... hence the change. http://www.zen-cart.com/entry.php?6-...nd-5-5-and-5-6

Great article! You might want to update it to reflect that the changes are also covered by Zen Cart v1.5.3!