Post by ash_sp99 » Tue Apr 07, 2020 4:39 am

Currently I am using mysql 5.6 using mysqli driver.
And want to know If I upgrade to MySQL 5.7, then i have to make any changes, is this opencart version 2.1.0.2 is compatible or break everything? Because opencart 2.1.0.2 launched in Jan 2016 and mysql 5.7 is launched in oct 2015.

Will I get any performance improvement by upgrading to mysql 5.7 from 5.6

Thanks in advance for your answers.

New member

Posts

Joined
Thu Feb 09, 2017 2:56 am
Location - Usa

Post by IP_CAM » Wed Apr 08, 2020 12:56 am

You will NOT get any performance improvement, by changing to PHP v.5.7,
but you should better move up to PHP 7 anyway. And to make your Version
work with PHP7, you need to add one of those new system/library/encryption.php files:
https://github.com/IP-CAM/Opencart-1.5. ... yption.php
https://www.opencart.com/index.php?rout ... n_id=34060
https://www.opencart.com/index.php?rout ... n_id=34428
https://www.opencart.com/index.php?rout ... n_id=38012
https://gist.github.com/giulianoriccio/ ... 9f11cd82db
Just check them all, one of them will sure work! ;)
Ernie
Last edited by IP_CAM on Wed Apr 08, 2020 1:01 am, edited 1 time in total.

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by ash_sp99 » Wed Apr 08, 2020 1:01 am

Thanks for response. But you read it wrong.... upgrade to mysql 5.7 and not php 5.7

New member

Posts

Joined
Thu Feb 09, 2017 2:56 am
Location - Usa

Post by IP_CAM » Wed Apr 08, 2020 1:05 am

Sorry about this .... :D

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by ash_sp99 » Wed Apr 08, 2020 1:08 am

No issue but you know the answer, compatible with MySQL 5.7 ?

New member

Posts

Joined
Thu Feb 09, 2017 2:56 am
Location - Usa

Post by IP_CAM » Wed Apr 08, 2020 2:52 am

Negative, unfortunately ... ::) I would just try, you can't ruin anything ... ;)

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 9 guests