SQL error - Bad SQL query

[ilan316]

When generating images on ps 1.5.4.1

im getting SQL error -

• Bad SQL query
  MySQL server has gone away
  

how do i fix it?

[vekia]

turn on error reporting in your store and try again. if any other error will appear - please paste the error code here

[ilan316]

how do i turn error reporting on my store?

[vekia]

read this: how to turn error reporting on

[ilan316]

[PrestaShopDatabaseException]

 

MySQL server has gone away

 

SELECT * FROM `ps_image_type`WHERE 1 AND stores = 1 ORDER BY `name` ASC

 

at line 607 in file classes/db/Db.php

 

 

601. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

602. }

603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

604. {

605. if ($sql)

[color=#F20000][b]606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');[/b][/color]

607. throw new PrestaShopDatabaseException($this->getMsgError());

608. }

609. }

610.

611. /**[/size][/font][/color]

• [b]DbCore->displayError[/b] - [line 307 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->query[/b] - [line 482 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->executeS[/b] - [line 101 - classes/ImageType.php] - [1 Arguments]
  
• [b]ImageTypeCore::getImagesTypes[/b] - [line 604 - controllers/admin/AdminImagesController.php] - [1 Arguments]
  
• [b]AdminImagesControllerCore->_regenerateThumbnails[/b] - [line 347 - controllers/admin/AdminImagesController.php] - [2 Arguments]
  
• [b]AdminImagesControllerCore->postProcess[/b] - [line 158 - classes/controller/Controller.php] - [size=3][0 Argument][/size]
  
• [b]ControllerCore->run[/b] - [line 349 - classes/Dispatcher.php] - [size=3][0 Argument][/size]
  
• [b]DispatcherCore->dispatch[/b] - [line 50 - admin111/index.php] - [size=3][0 Argument][/size]
  

[vekia]

MySQL server has gone away

it looks like server restrictions related to the max query time / script max execution time

[ilan316]

i need to set sql query time higher?

[vekia]

that's right, increase the value of mysql query execution time

[ilan316]

that wasnt the problem, according to my provider they increased the value

but im still getting errors