Post by lovethatreview » Tue Mar 15, 2016 5:22 am

I am not an expert, somewhat a novice. My store takes roughly 20 seconds to load (every page). After thoroughly going over EVERYTHING with GoDaddy and determining 100% that it is NOT the server, using many tests including the fact that the rest of the website including the admin panel works lightning fast EXCEPT the store.I found the ERROR log and it is MASSIVE.

I tried to connecting it here but it was literally too big. I exported it to notepad.

Please I need help. How do I expect people to access my store if it takes 20 seconds?

The ERROR LOG is so massive that when I go to put it on here, I get blocked - it states that there is some sort of SQL and other errors worthy of an "attack".

The response I received from Opencart guy after giving him the full ERROR LOG in email was this: "it seem like your store is working.Thanks."

Please - My store is mega mega slow. It is NOT the server. It DID work lightning fast. And the rest of my site works very fast as well. Just the store is extreme slow. The admin panel works very quick too.

PLEASE HELP. How can I load my ERROR LOG if the forum wont take it?


Posts

Joined
Tue Apr 21, 2015 11:19 pm

Post by artcore » Tue Mar 15, 2016 5:51 am

I'd say rename the log to error.log_ (FTP) and wait for the new one, which is automatically generated, to fill up again.
I'm guessing something is causing loads of errors and every one f them is written to the log causing memory problems eventually. This should have been spotted by your host though.

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands

Post by budgetneon » Tue Mar 15, 2016 7:28 am

You don't need to post the entire log, just the last 50 or 100 lines or so.

Maybe copy and paste it into http://pastebin.com/ if the forum isn't allowing you to post it here? Then you can just a link to it here.

Personally, if you need shared hosting (vs a vps, etc), you might have much better luck getting a host that has specific expertise with OpenCart. The one listed on the OpenCart partner page seems to know what they are doing.

New member

Posts

Joined
Sat Sep 20, 2014 11:32 pm


Post by lovethatreview » Tue Mar 15, 2016 9:53 pm

HERE IS LAST SEVERAL LINES:
2016-03-08 9:08:18 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '0' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /home/content/18/5882818/html/store/system/library/db/mysqli.php on line 41
2016-03-08 9:08:18 - PHP Notice: Trying to get property of non-object in /home/content/18/5882818/html/store/catalog/model/catalog/category.php on line 12
2016-03-08 9:08:18 - PHP Warning: Invalid argument supplied for foreach() in /home/content/18/5882818/html/store/catalog/controller/common/header.php on line 97
2016-03-08 9:08:18 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_extension WHERE `type` = 'total' in /home/content/18/5882818/html/store/system/library/db/mysqli.php on line 41
2016-03-08 9:08:18 - PHP Notice: Trying to get property of non-object in /home/content/18/5882818/html/store/catalog/model/extension/extension.php on line 6
2016-03-08 9:08:18 - PHP Warning: Invalid argument supplied for foreach() in /home/content/18/5882818/html/store/catalog/controller/common/cart.php on line 19
2016-03-08 9:08:18 - PHP Warning: array_multisort(): Argument #3 is expected to be an array or a sort flag in /home/content/18/5882818/html/store/catalog/controller/common/cart.php on line 23
2016-03-08 9:08:18 - PHP Warning: Invalid argument supplied for foreach() in /home/content/18/5882818/html/store/catalog/controller/common/cart.php on line 25
2016-03-08 9:08:18 - PHP Notice: Undefined index: USD in /home/content/18/5882818/html/store/system/library/currency.php on line 55
2016-03-08 9:08:18 - PHP Notice: Undefined index: USD in /home/content/18/5882818/html/store/system/library/currency.php on line 56
2016-03-08 9:08:18 - PHP Notice: Undefined index: USD in /home/content/18/5882818/html/store/system/library/currency.php on line 57
2016-03-08 9:08:18 - PHP Notice: Undefined index: USD in /home/content/18/5882818/html/store/system/library/currency.php on line 65
2016-03-09 17:35:17 - PHP Notice: Undefined index: URL in /home/content/18/5882818/html/store/catalog/view/theme/default/template/module/invitereferralsV2.tpl on line 33
2016-03-09 17:42:57 - PHP Warning: Invalid argument supplied for foreach() in /home/content/18/5882818/html/store/admin/controller/module/featured.php on line 124


Posts

Joined
Tue Apr 21, 2015 11:19 pm

Post by artcore » Tue Mar 15, 2016 10:14 pm

That means the database connection failed for a number of reasons. Probably an overworked server or you maxed out the host's settings for max_questions, or...
Probably time to move like budgetneon already suggested.

BTW, All other errors are because of the failed connection to sql

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands

Post by Burt65 » Tue Mar 15, 2016 10:20 pm

server has gone away
Is he coming back???

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by EvolveWebHosting » Tue Mar 15, 2016 11:01 pm

lovethatreview wrote:HERE IS LAST SEVERAL LINES:
2016-03-08 9:08:18 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '0' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /home/content/18/5882818/html/store/system/library/db/mysqli.php on line 41
2016-03-08 9:08:18 - PHP Notice: Trying to get property of non-object in /home/content/18/5882818/html/store/catalog/model/catalog/category.php on line 12
2016-03-08 9:08:18 - PHP Warning: Invalid argument supplied for foreach() in /home/content/18/5882818/html/store/catalog/controller/common/header.php on line 97
2016-03-08 9:08:18 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_extension WHERE `type` = 'total' in /home/content/18/5882818/html/store/system/library/db/mysqli.php on line 41
2016-03-08 9:08:18 - PHP Notice: Trying to get property of non-object in /home/content/18/5882818/html/store/catalog/model/extension/extension.php on line 6
2016-03-08 9:08:18 - PHP Warning: Invalid argument supplied for foreach() in /home/content/18/5882818/html/store/catalog/controller/common/cart.php on line 19
2016-03-08 9:08:18 - PHP Warning: array_multisort(): Argument #3 is expected to be an array or a sort flag in /home/content/18/5882818/html/store/catalog/controller/common/cart.php on line 23
2016-03-08 9:08:18 - PHP Warning: Invalid argument supplied for foreach() in /home/content/18/5882818/html/store/catalog/controller/common/cart.php on line 25
2016-03-08 9:08:18 - PHP Notice: Undefined index: USD in /home/content/18/5882818/html/store/system/library/currency.php on line 55
2016-03-08 9:08:18 - PHP Notice: Undefined index: USD in /home/content/18/5882818/html/store/system/library/currency.php on line 56
2016-03-08 9:08:18 - PHP Notice: Undefined index: USD in /home/content/18/5882818/html/store/system/library/currency.php on line 57
2016-03-08 9:08:18 - PHP Notice: Undefined index: USD in /home/content/18/5882818/html/store/system/library/currency.php on line 65
2016-03-09 17:35:17 - PHP Notice: Undefined index: URL in /home/content/18/5882818/html/store/catalog/view/theme/default/template/module/invitereferralsV2.tpl on line 33
2016-03-09 17:42:57 - PHP Warning: Invalid argument supplied for foreach() in /home/content/18/5882818/html/store/admin/controller/module/featured.php on line 124
Error: MySQL server has gone away

This is an issue with the server. Your hosting company should address this for you.

Image
https://www.evolvewebhost.com
$10.49 .com Registration and $9.99 .com Transfers in now
Guaranteed top level opencart performance and support. Risk free 30 day money back guarantee & free transfers.
Image


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA
Who is online

Users browsing this forum: Maxidays and 53 guests