mysql support off

**mohsenalam** · 10 Dec 2016, 06:30 PM

[Note: remember to include site URL, ZC version, list of plugins, PHP version, etc ... read the Posting Tips shown above for information to include in your post here. And, remove this comment before actually posting!]

hello, I've installed zen-cart in past without issues. but recently I'm getting this error, Mysql Support off.
I searched around this forum and other places, so far I found that I need to use "Extensions = mysqli.so"
I can connect to database in a regular php file using mysqli_connect function. but zen-cart is still showing the mysql support off.

Ubuntu 16.04
Apache 2.4.18
PHP 7.0.8
Mysqld 5.7.16
Zen-cart 1.5.1

**DrByte** · 11 Dec 2016, 06:18 AM

You'll need to use a newer version of Zen Cart. The old 1.5.1 version you mentioned doesn't recognize or support "mysqli_" (it only supports the now-obsolete "mysql_" modules).

**mohsenalam** · 11 Dec 2016, 10:29 PM

thanks for your reply.
actually i have a website running zencart 1.5.0, i needed to update it to 1.5.5b
so I was thinking if I needed to update by one step at a time or I can update to directly 1.5.5b.

as 1.5.1 not working, I tried to modify my all files as version 1.5.5b, zc_installer gave me option for upgrade but after upgrading browser showing HTTP error 500

**DrByte** · 11 Dec 2016, 10:52 PM

For many years, while PHP has been declaring that they will remove the old mysql_xxxxx set of functions, they have been co-compiling support for both mysql_xxxxx and mysqli_xxxxxx .... and in that circumstance, Zen Cart can operate fine.

You could ask your hosting company server administrator to recompile PHP with support for --with-mysql and --with-mysqli

**mohsenalam** · 12 Dec 2016, 12:55 AM

Thanks for your reply .
Actually I'm testing out this installations in my own demo server.
I was looking for a way to upgrade zencart from 1.5.0 to 1.5.5, I'm confused about the upgrade procedure.
Can i do direct upgrade to 1.5.5, is it possible or do i need to upgrade each version one by one?

Please help. Thanks in advance.

**dbltoe** · 12 Dec 2016, 03:39 AM

https://www.zen-cart.com/entry.php?3...d-of-upgrading Just follow the steps

**DrByte** · 12 Dec 2016, 05:04 PM

Originally Posted by mohsenalam

Can i do direct upgrade to 1.5.5, is it possible or do i need to upgrade each version one by one?

99% of the time it's best to go directly to the latest version.

**mohsenalam** · 18 Dec 2016, 06:34 AM

Thanks for your nice help. I tried to go through the procedures. I could upgrade the database. and installer said that it upgraded successfully. But when I tried to visit store or admin area, its just giving me error 500. any known problem or bugs?

**mc12345678** · 18 Dec 2016, 07:22 AM

Originally Posted by mohsenalam

Thanks for your nice help. I tried to go through the procedures. I could upgrade the database. and installer said that it upgraded successfully. But when I tried to visit store or admin area, its just giving me error 500. any known problem or bugs?

Check your logs folder to see what if any recent errors were generated. The errors get logged in myDebugxxxx files. If not then perhaps there is an error log associated with the server that could provide more information about the area of code causing a problem.

Beyond that, need more explanation of how to recreate the problem. Much of that is through answering the posting tip's questions.