Error regenerating thumbnails

[zeki893]

[PrestaShopDatabaseException]
MySQL server has gone away

        SELECT m.`name` FROM `module` m
        LEFT JOIN `hook_module` hm ON hm.`id_module` = m.`id_module`
        LEFT JOIN `hook` h ON hm.`id_hook` = h.`id_hook`
        WHERE h.`name` = 'actionWatermark' AND m.`active` = 1
at line 635 in file classes/db/Db.php

629.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$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]319.         if ($sql instanceof DbQuery)
320.             $sql = $sql->build();
321.
322.         $this->result = $this->_query($sql);
323.         if (_PS_DEBUG_SQL_)
324.             $this->displayError($sql);
325.         return $this->result;
326.     }
327.
328.     /**
329.      * Execute an INSERT queryDbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]495.         {
496.             $this->last_cached = true;
497.             return $result;
498.         }
499.
500.         $this->result = $this->query($sql);
501.
502.         if (!$this->result)
503.             $result = false;
504.         else
505.         {DbCore->executeS - [line 571 - controllers/admin/AdminImagesController.php] - [1 Arguments]565.     {
566.         $result = Db::getInstance()->executeS('
567.         SELECT m.`name` FROM `'._DB_PREFIX_.'module` m
568.         LEFT JOIN `'._DB_PREFIX_.'hook_module` hm ON hm.`id_module` = m.`id_module`
569.         LEFT JOIN `'._DB_PREFIX_.'hook` h ON hm.`id_hook` = h.`id_hook`
570.         WHERE h.`name` = \'actionWatermark\' AND m.`active` = 1');
571.
572.         if ($result && count($result))
573.         {
574.             $productsImages = Image::getAllImages();
575.             foreach ($productsImages as $image)

max_execution_time=900

max_input_time=300

memory_limit=512M

 

I ran the same query in the database and came up fine

 

 

mysql> SELECT m.`name` FROM `module` m
    ->                 LEFT JOIN `hook_module` hm ON hm.`id_module` = m.`id_module`
    ->                 LEFT JOIN `hook` h ON hm.`id_hook` = h.`id_hook`
    ->                 WHERE h.`name` = 'actionWatermark' AND m.`active` = 1;
Empty set (0.00 sec)

Edited August 22, 2014 by zeki893 (see edit history)

[zeki893]

The site was cloned and I guess the image locations aren't the same or something so I re-added the images to theme configurator and regenerated. That fixed the problem.