Hello,
I am looking for someone to upgrade my OC. My website is down as my hosting service changed mysql. They said
I needed to update my OC.
I have a Journal theme installed on OC.
Please contact me with costs and experience.
Thanks
Nancy
I am looking for someone to upgrade my OC. My website is down as my hosting service changed mysql. They said
I needed to update my OC.
I have a Journal theme installed on OC.
Please contact me with costs and experience.
Thanks
Nancy
Last edited by ardragifts on Thu Nov 30, 2017 3:40 am, edited 1 time in total.
Well, you don't have to update your Shop because of this, you
just have to change this Line Content:
define('DB_DRIVER', 'mysql');
to look like this:
define('DB_DRIVER', 'mysqli');
in your both config.php files, to make it work with mysqli.
And if your Shop Version does NOT YET contain a
/system/database/mysqli.php File,
just download a Version-matching mysqli-driver from the extension section,
and upload it into the Shop /system/database/... Subdirectory:
https://www.opencart.com/index.php?rout ... rch=mysqli
Good Luck !
Ernie
just have to change this Line Content:
define('DB_DRIVER', 'mysql');
to look like this:
define('DB_DRIVER', 'mysqli');
in your both config.php files, to make it work with mysqli.
And if your Shop Version does NOT YET contain a
/system/database/mysqli.php File,
just download a Version-matching mysqli-driver from the extension section,
and upload it into the Shop /system/database/... Subdirectory:
https://www.opencart.com/index.php?rout ... rch=mysqli
Good Luck !
Ernie
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.
Thanks so much for your reply.. very much appreciated.
OK, so I am a tad confused... Did my hosting service changed my existing database file to a different type or do I have to change my database files to a different version?
Also I cant find the database folder.. should it already exist of is that extension add the folder then the file? Under my system there is NO database folder at all.
Sorry I sound so ditzy.. this had totally confused me and my webstie AND admin have been down since the hosting service did this change.
Thanks again
Nancy
OK, so I am a tad confused... Did my hosting service changed my existing database file to a different type or do I have to change my database files to a different version?
Also I cant find the database folder.. should it already exist of is that extension add the folder then the file? Under my system there is NO database folder at all.
Sorry I sound so ditzy.. this had totally confused me and my webstie AND admin have been down since the hosting service did this change.
Thanks again
Nancy
Well, if my above comment is unclear to you, then better get professional support.
Good Luck!
Ernie
Good Luck!
Ernie
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.
lol I hear ya. I have NO clue what the mysql change was and how it affects my site.
I installed opencart and a theme all myself and had it working for the last 5 years or so.. made it all pretty lol
BUT I have no clue how to fix this issue that the hosting service caused. My admin and website just stopped working even though
the day before I was adding new products.
I dont know if my existing sql database in my hosting service is the old format or the new. Totally lost lol
If you noticed my other topic, I am giving up I think... I am moving to a new hosting service as the original hostbig service didnt even give me a warning or email about this major changed.
Thanks for your patience
Nancy
I installed opencart and a theme all myself and had it working for the last 5 years or so.. made it all pretty lol
BUT I have no clue how to fix this issue that the hosting service caused. My admin and website just stopped working even though
the day before I was adding new products.
I dont know if my existing sql database in my hosting service is the old format or the new. Totally lost lol
If you noticed my other topic, I am giving up I think... I am moving to a new hosting service as the original hostbig service didnt even give me a warning or email about this major changed.
Thanks for your patience
Nancy
Ok... I downloaded MySQLiz - MySQLi support.
The first thing that doesnt look right is you told me to change mysql to mysqli .. but when I went into the file it already was mysqli.
THEN I downloaded MySQLiz - MySQLi support and it says to change it to mysqliz . with a z... ack.
When I go to my site now..at least I get new error roflmao...Error: Could not load database driver mysqliz!
Soooo is the z supposed to be there or not?
I went to https://www.opencart.com/index.php?rout ... rch=mysqli and I have no clue which to get if MySQLiz - MySQLi is wrong? Can you be more specific on which extension I should get please?
Thanks again
Nancy
The first thing that doesnt look right is you told me to change mysql to mysqli .. but when I went into the file it already was mysqli.
THEN I downloaded MySQLiz - MySQLi support and it says to change it to mysqliz . with a z... ack.
When I go to my site now..at least I get new error roflmao...Error: Could not load database driver mysqliz!
Soooo is the z supposed to be there or not?
I went to https://www.opencart.com/index.php?rout ... rch=mysqli and I have no clue which to get if MySQLiz - MySQLi is wrong? Can you be more specific on which extension I should get please?
Thanks again
Nancy
I clearly wrote:
And if your Shop Version does NOT YET contain a
/system/database/mysqli.php File,
just download a Version-matching mysqli-driver from the extension section,
And if your Shop Version does NOT YET contain a
/system/database/mysqli.php File,
just download a Version-matching mysqli-driver from the extension section,
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.
Yup sorry if I misunderstood you. I did not have the database folder in system nor that file.
Being in a panic doesnt help me focus I guess... I did the steps you said.. and no change.
THEN I get a call from my sister that the site is MAGICALLY up and working???
Its been down nearly a week.. my admin and estore.
I am grateful it just fixed itself... and I am backing up everything and moving to a new hosting service.
Thanks sooooo much for your help... I truly appreciate it.. hugssss
Nancy
Being in a panic doesnt help me focus I guess... I did the steps you said.. and no change.
THEN I get a call from my sister that the site is MAGICALLY up and working???
Its been down nearly a week.. my admin and estore.
I am grateful it just fixed itself... and I am backing up everything and moving to a new hosting service.
Thanks sooooo much for your help... I truly appreciate it.. hugssss
Nancy
Well, if you don't have this mysqli.php File in the system/database/... Subdirectory,
then you don't use an OpenCart v.1.5.6.x either. But anyway, good Luck, you will need it badly, I assume...
Ernie
then you don't use an OpenCart v.1.5.6.x either. But anyway, good Luck, you will need it badly, I assume...
Ernie
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.
Thanks,
Team Pamtechsolutions
dev@pamtechsolutions.com
View All My Extensions
Who is online
Users browsing this forum: No registered users and 21 guests