Post by burley » Tue Dec 11, 2018 10:01 pm

So as the title already says, my host is migrating from php 5.6 to 7.1. Which for me, as I'm running a shop on 1.5.6.4 creates problems, eventhough I'm using the basic theme and am really only using the admin side of the shop. Which for us (adding wholesale orders) is essential!

I read some other threads as well, and as far as I understood the main issue is that php 5.6 is using msql and this will no longer be supported, so my shop has to be updated to using mysqli.

I found some patches for it too, but not sure what they do exactly (as there is no readme file) but they claim to easy fix the issues. Patches

Anybody here who can help me with some additional information?

Thanks!!

User avatar
Active Member

Posts

Joined
Sun Oct 09, 2011 3:30 pm

Post by IP_CAM » Tue Dec 11, 2018 11:28 pm

Well, MySqli is already built into OC v.1.5.6.4, but you need a new encryption.php File,
to make PHP-7 work with v.1.5.6.4.
Ernie
https://www.opencart.com/index.php?rout ... n_id=34428
viewtopic.php?f=202&t=206794&p=733801#p733629

My Github OC Site: https://github.com/IP-CAM
5'200 + 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 burley » Wed Dec 12, 2018 12:09 am

Oooh, if that is all it would be great! Thanks for the quick answer!!

User avatar
Active Member

Posts

Joined
Sun Oct 09, 2011 3:30 pm

Post by burley » Wed Dec 12, 2018 12:27 am

Hmm, if only :)

Uploaded the new encryption file, but when swithched to php 7.1 it gives a blank screen (I did have cpanel repair the database). But there is no error in the log or anything.

However, without the new encryption file the log shows:

[11-Dec-2018 13:03:33 Europe/Berlin] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /public_html/retail/system/database/mysql.php on line 6

Any clues?

User avatar
Active Member

Posts

Joined
Sun Oct 09, 2011 3:30 pm

Post by IP_CAM » Wed Dec 12, 2018 7:20 am

Well, you did not yet switch the Database configuration
in your both config.php files to:
define('DB_DRIVER', 'mysqli');

My Github OC Site: https://github.com/IP-CAM
5'200 + 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 burley » Wed Dec 12, 2018 5:10 pm

Boy, do I feel dumb. Haha. So thanks for me making me feel stupid ;D ;D
But seriously, thanks for this!!! All problems seem to be solved!

You sir, just earned yourself a beer!

User avatar
Active Member

Posts

Joined
Sun Oct 09, 2011 3:30 pm

Post by johnp » Wed Dec 12, 2018 5:51 pm

We've all done it at some point. Doh! :)

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by IP_CAM » Thu Dec 13, 2018 5:34 am

Well, unfortunately, I don't drink Beer, nor other alcoholic Beverages,
for the past 40 Years already, your therefore have to settle with a Coke,
or a Glass of Milk.
Good Luck! Image
Ernie
---
PS. I now have to add Smilies by Image-link, since someone obviously
played around with unknown Code again, for what reason ever ...

My Github OC Site: https://github.com/IP-CAM
5'200 + 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 116 guests