Post by lettertech » Tue Feb 09, 2016 5:00 am

Just recently I have been having issues with my site not releasing the database after inquiries (per hosting company) I haven't done anything other than add a few products in the last few weeks. Nothing has been updated or changed other that that. I have downloaded the error log and it is quite big. (5mb) I am having a hard time viewing orders because I will hit my max db connections, so my site will either time out or come back with an empty store. www.lettertech.com Someone please help me figure this out.

Thank you in advance

Newbie

Posts

Joined
Thu Feb 12, 2015 3:12 am

Post by IP_CAM » Tue Feb 09, 2016 5:41 am

just to prepare for a clean DB Setup first:
Step 1:
config.php Files in SHOP ROOT and ADMIN Section:
if this exists:
// DB
define('DB_DRIVER', 'mysql');
---
change to:
// DB
define('DB_DRIVER', 'mysqli');

Step 2:
Download Atomix legendary turbo.php File, unzip and upload it to your Server ROOT, and
start it by calling it trough your Browser. Then start BOTH ROUTINES,
the first one, changing ALL OC-default MyISAM DB-Engine driven Tables to the one (only) single and even
more efficient INNODB Engine troughout the DB, and second, indexing the full DB:

Atomix OpenCart TURBO OpenCart v.1.5.x - 2.x.x:
viewtopic.php?f=199&t=221103&p=805841#p805841

Then, come back and tell us more about possible errors,
still existing on your System.

Ernie
openshop.li
PS: Atomix is not longer active on Github, that's why I keep the latest ZIP on one of my servers.

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 46 guests