Problems with your MySQL (mysqli) support

[Jacques Smit]

HI

Trying to install Zencart onto my domain and not getting past the following.

Any idea what to do?

ISP / Host says that my hosting platform does support musqli


System Inspection
TIP: For some errors and warnings below, more information may be available by clicking on the error/warning title.
Some problems that need fixing before we continue
Problems with your MySQL (mysqli) support

[lat9]

You might ask your current web-host why they've chosen not to support mysqli, given that the mysql support in PHP has been removed starting with PHP 7.0.

It they're not bendable on that, you'll need to find a new web-host for your later-than-v1.5.2 Zen Cart.

[mc12345678]

Perhaps you could generate the php settings to see what is currently seen by your ZC site area.

Create a file with a "random" name of your choosing with the extension .php and store it at a location accessible by your store's url (ie. In the root of your store) with the following contents:

<?php echo phpinfo(); ?>

Then point your browser to that file, copy and paste the result then remove the file.

[Jacques Smit]

I have asked them and they said it is supported. Will confirm again, and that in fact my domain has feature.

as per myphp

Web server

cpsrvd 11.54.0.21
Database client version: libmysql - 5.1.73
PHP extension: mysqli Documentation

[pixodaros]

I am also getting this error when I try to create a new install at MYDOMAIN/1.5.8 I set that folder to use PHP version: 8.2.13 whereas the root folder (which is still running Zen Cart 1.5.4) still has PHP version: 5.6.40

in cPanel > Select PHP Version I see mysqli enabled. Running phpinfo(); in MYDOMAIN/1.5.8 throws hundreds of lines of content. The Configure Command section does have:

'./configure' '--prefix=/usr' ... '--without-mysqli'

I will keep exploring Stack Overflow and the PHP and MySQL documentation.

[swguy]

There was a time when you had to run the PHP Configuration tool in cPanel and check a box that you wanted mysqli. Perhaps your hoster has something similar.

[mc12345678]

Additionally, may want to consider setting up this additional store using a sub domain. The sub domain could still be in this sub directory off your main site, but the alternate php configuration may play better.

[pixodaros]

cPanel shows mysqli as enabled with the default PHP version. The host is tweaking some things and they may have a recommended fix.

Zen Cart seems to expect that a few files like favicon.io are in specific places relative to the root.

Creating a site in a subdomain like store.DOMAINNAME.TLD is kind of trendy.

[pixodaros]

The host seems to have set it up so that nd_mysqli overrides mysqli. "nd_pdo_mysql appears to be a custom plugable extension provided by the cPanel hosting platform in order to opt-in the MySQL Native Driver in run-time. " (Stack Overflow) Nobody on the ZC support forum seems to have had trouble with a host using nd_mysqli instead of the basic mysqli extension until now so I am talking to the host.

The Zen Cart 1.5.4 install seems to still work with PHP 7.4 but we have not tried moving all the way to 8.2 since the language changed so much.

[pixodaros]

When we remove the .htaccess rule trying to enable a different PHP version than the server default, the errors about missing PHP extensions go away, and there is just a warning "For maximum security and compatibility you should be using PHP 8.0 or newer. " (Currently the default is PHP 7.4 so that the ZC 1.5.4 install continues to work).