Ralph Northcott Posted June 16, 2014 Share Posted June 16, 2014 When customers choose to pay by bank wire at checkout, they get the following error. What do I need to fix? [PrestaShopDatabaseException]MySQL server has gone away SELECT *FROM `ps_orders` aWHERE (a.id_order = 181)LIMIT 1at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. }631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. {633. if ($sql)634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. throw new PrestaShopDatabaseException($this->getMsgError());636. }637. }638.639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 547 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 212 - classes/ObjectModel.php] - [1 Arguments] ObjectModelCore->__construct - [line 259 - classes/order/Order.php] - [2 Arguments] OrderCore->__construct - [line 370 - classes/order/OrderHistory.php] - [1 Arguments] OrderHistoryCore->addWithemail - [line 703 - classes/PaymentModule.php] - [2 Arguments] PaymentModuleCore->validateOrder - [line 64 - modules/bankwire/controllers/front/validation.php] - [9 Arguments] BankwireValidationModuleFrontController->postProcess - [line 171 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] My site is cactus-shop.co.uk Can anyone help? Thanks, Ralph Link to comment Share on other sites More sharing options...
tuk66 Posted June 17, 2014 Share Posted June 17, 2014 What is you PrestaShop and/or bankwire module version? Link to comment Share on other sites More sharing options...
vekia Posted June 17, 2014 Share Posted June 17, 2014 mysql gone away means that query was stopped, usually because of limits on your hosting account. you've got this problem only with bankwire? Link to comment Share on other sites More sharing options...
Ralph Northcott Posted June 23, 2014 Author Share Posted June 23, 2014 My Prestashop version is 1.6.0.6. I get the error MySQL server has gone away every time I save a change in the back end Link to comment Share on other sites More sharing options...
Ralph Northcott Posted June 24, 2014 Author Share Posted June 24, 2014 I have checked with my hosting company. No other clients are having SQL issues. They tell me the problems must be with the Prestashop scripts Link to comment Share on other sites More sharing options...
vekia Posted June 25, 2014 Share Posted June 25, 2014 hello no matter what kind of page in back office you're trying to save? even simple settings in preferences ? Link to comment Share on other sites More sharing options...
Recommended Posts