Opencart MySQL problem ili problem hostinga?

Dakle jedan web dućan koji do sada nije ima većih problema, imao je sitne greške no radi već godinama.
I sada odjednom baca 504 server pogrešku.

I ekipa nam tupi da je do stranice jer vraća ovo u error logu opencarta:

  2015-01-12 10:10:29 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:10:45 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:11:10 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:11:10 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:11:10 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:11:57 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:50:15 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:53:55 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:56:28 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:58:07 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:58:07 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:58:07 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 10:58:07 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 11:02:28 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 11:03:31 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 11:05:44 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50
2015-01-12 11:08:53 - PHP Notice:  Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/uslu/public_html/oc/system/database/mysql.php on line 50

No ima li to veze sa serverom ili web stranicom?
Najbolje je što stranica sada sporadično radi, a mora se riješiti što prije, dućan je posjećen.

Da li je to stranica ili hosting?

To ti ima veze do hostinga :slight_smile: Ocito je iz logova da je MySQL server pao … ili je iz nekog razloga zatvorio konekciju. Vrijeme ti je za promjenu hostinga. Mi smo vec pricali na PM o tome … pogledja jos jednom PM … nisi mi nista odgovorio …

Najbolja stvar je što ovaj hosting nije kod mene.
Već kod plus hostinga.

Gužva mi je totalna, i pokušavam dogovoriti si još 3 veća hostinga ovaj mjesec pa da onda idem na predloženu opciju.
Bez brige, ponudu još uvijek imam na prvom mjestu što se tiče hostinga.
Još jednom hvala!

SItuacija slijedeća, povećali su a hotstingu timeout scripte i memory limit, no eto ista stvar i sada svaljuju a nas.

NIšta nije mijenjano na sajtu dodan je cookie law preko vqmd, koji ne radi upite na bazu tipa iz primjera, a takvi upiti dešavali su se i prije.

Uopće ne shvaćam što da radim, dućan ima skoro 3 tisuće artikala, online plaćanje i ne pada mi na pamet sada seliti taj dućan.

Neki savjet?

Probaj napraviti backup tog ducana i sve to staviti na neki drugi hosting i vidi hoceli ti se isto to dogadjati.

Baš to!

Sada mičem neke stvari, tipa product count, category da stavim u neki cash itd.

ne znam, čudno da ništa bitno nije mijenjano no prije nekih 7-8 dana drastični pad u performansama, čak često stranica nedostupna…

Sada sam pričao sa hosting providerom, objasnili su sve, kužim priču, možda je naša skripta zahtjevna, ali čudno da se događa tako odejdnom. A broj artikala i posejta se nije promijenio…

Idem prvo sa nekim cache alatom, a nakon toga ako ne bude bolje stavljam test kopiju na drugi hosting.

TNx


Copyright © 2020 WM Forum - AboutContact - Sponsored by: Mydataknox & Profit Monkey