Host Upgraded PHP to 7.3 - Now need to Update ZC 1.5.6A to B

[Webskipper]

I searched and didn't find this question.


Host says php 7.3 is now available for my account.


Fresh install this Spring of zc 1.5.6a and imported previous db.


Should I go ahead and export the DB, create a new db, and do a fresh install of zc 1.5.6b?


OR use the whole SQL patch /sql/updates/mysql_upgrade_zencart_156.sql ?




Thanks so much!


-Philip




Server OS: Linux 3.10.0-693.17.1.2.ELK.el6.x86_64
Server Date: 07/02/2019 12:59:06
Server Up Time: 12:59:06 up 149 days, 13:49, 0 users, load average: 0.02, 0.00, 0.00
HTTP Server: Apache
PHP Version: 7.1.14 (Zend: 3.1.0)
PHP File Uploads: On
Upload Max Size: 256M
PHP Memory Limit: 256M
POST Max Size: 260M
Database Engine: MySQL 5.6.41-84.1
Database Date: 07/02/2019 12:59:06
Database Data Size: 605 kB
Database Index Size: 532 kB
MySQL Slow Query Log Status: On
MySQL Mode: NO_ENGINE_SUBSTITUTION

[swguy]

You don't need to export your db. The database changes for 1.5.6b are really just fixes to the original upgrade. See

https://www.zen-cart.com/showthread....11#post1357911

"IS THERE A DATABASE UPGRADE STEP FROM v156a to v156b?"

[Webskipper]

Yes, thats the patch I was quoting except that my Database Engine: MySQL 5.6.41-84.1 and the patch references mysql 8.

[swguy]

Use the patch and you will be ready for MySQL 8.