Install Fails without mysqli enabled

dbltoe · 2014-07-12T06:39:41+00:00

# 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...

12 Jul 2014, 6:39 AM

#1

dbltoe

Totally Zenned

Join Date:: Jan 2004
Location:: N of San Antonio TX
Posts:: 9,851
Plugin Contributions:: 18

Install Fails without mysqli enabled


# 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.

:frusty:

Suggestions?

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

12 Jul 2014, 6:46 AM

#2

lhungil

Totally Zenned

Join Date:: Feb 2012
Location:: mostly harmless
Posts:: 1,818
Plugin Contributions:: 4

Re: Install Fails without mysqli enabled

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

The glass is not half full. The glass is not half empty. The glass is simply too big!
Where are the Zen Cart Debug Logs? Where are the HTTP 500 / Server Error Logs?
Zen Cart related projects maintained by lhûngîl : Plugin / Module Tracker

12 Jul 2014, 7:08 AM

#3

dbltoe

Totally Zenned

Join Date:: Jan 2004
Location:: N of San Antonio TX
Posts:: 9,851
Plugin Contributions:: 18

Re: Install Fails without mysqli enabled

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

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

12 Jul 2014, 7:35 AM

#4

lhungil

Totally Zenned

Join Date:: Feb 2012
Location:: mostly harmless
Posts:: 1,818
Plugin Contributions:: 4

Re: Install Fails without mysqli enabled

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.

The glass is not half full. The glass is not half empty. The glass is simply too big!
Where are the Zen Cart Debug Logs? Where are the HTTP 500 / Server Error Logs?
Zen Cart related projects maintained by lhûngîl : Plugin / Module Tracker

12 Jul 2014, 3:24 PM

#5

dbltoe

Totally Zenned

Join Date:: Jan 2004
Location:: N of San Antonio TX
Posts:: 9,851
Plugin Contributions:: 18

Re: Install Fails without mysqli enabled

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.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

12 Jul 2014, 4:21 PM

#6

lhungil

Totally Zenned

Join Date:: Feb 2012
Location:: mostly harmless
Posts:: 1,818
Plugin Contributions:: 4

Re: Install Fails without mysqli enabled

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

The glass is not half full. The glass is not half empty. The glass is simply too big!
Where are the Zen Cart Debug Logs? Where are the HTTP 500 / Server Error Logs?
Zen Cart related projects maintained by lhûngîl : Plugin / Module Tracker

13 Jul 2014, 1:43 AM

#7

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: Install Fails without mysqli enabled

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

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

13 Jul 2014, 6:04 PM

#8

dbltoe

Totally Zenned

Join Date:: Jan 2004
Location:: N of San Antonio TX
Posts:: 9,851
Plugin Contributions:: 18

Re: Install Fails without mysqli enabled

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

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

13 Jul 2014, 7:27 PM

#9

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: Install Fails without mysqli enabled

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-Is-your-plugin-code-safe-for-PHP-5-4-and-5-5-and-5-6

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

14 Jul 2014, 11:12 AM

#10

lat9

Administrator

Join Date:: Sep 2009
Location:: Stuart, FL
Posts:: 14,111
Plugin Contributions:: 56

Re: Install Fails without mysqli enabled

DrByte:

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-Is-your-plugin-code-safe-for-PHP-5-4-and-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!

My website

14 Jul 2014, 10:01 PM

#11

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: Install Fails without mysqli enabled

Done .

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.