Error PrestaShopDatabaseException Query execution was interrupted Tras actualizar a 1.5.6

[Hubmaster]

Buenas tardes, acudo desesperado.

 

He actualizado a la versión 1.5.6 de prestashop y al ir a entrar a los productos, me da este error:

 

[PrestaShopDatabaseException]  

Query execution was interrupted
 

        SELECT SQL_CALC_FOUND_ROWS
        a.`id_product`,b.name as name,`reference`,a.price as price,sa.active as active
        , shop.name as shopname, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, sav.`quantity` as sav_quantity, sa.`active`
        FROM `ps_product` a
        LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 3 AND b.`id_shop` = 1)
        
        LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product`)
        LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0
         AND sav.id_shop = 1 ) JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
                LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)
                LEFT JOIN `ps_shop` shop ON (shop.id_shop = a.id_shop_default)
                LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default)
        
        WHERE 1
        GROUP BY sa.id_product
        
        ORDER BY a.id_product ASC LIMIT 0,50
at line 613 in file classes/db/Db.php

 

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

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608.         }
609.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610.         {
611.             if ($sql)
612.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613.             throw new PrestaShopDatabaseException($this->getMsgError());
614.         }
615.     }
616.
617.     /**

• DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 2292 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->getList - [line 328 - controllers/admin/AdminProductsController.php] - [6 Arguments]
• AdminProductsControllerCore->getList - [line 1604 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->renderList - [line 2294 - controllers/admin/AdminProductsController.php] - [0 Argument]
• AdminProductsControllerCore->renderList - [line 1500 - classes/controller/AdminController.php] - [0 Argument]
• AdminControllerCore->initContent - [line 2286 - controllers/admin/AdminProductsController.php] - [0 Argument]
• AdminProductsControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 53 - administracion/index.php] - [0 Argument]

 

He buscado y buscado sin parar pero no encuentro forma de solucionarlo. Hay alguna forma de ver si esa estructura en BD esta bien??

[Hubmaster]

Nadie tiene alguna idea, aunque sea de bombero?

[durdi]

Hola, lograste resolverlo?.

 

Yo estoy igual que tu, pero me pasa al entrar a la pestaña de modulos

 

 

Saludos

[Hubmaster]

Que va, no hubo forma. En el paso de la actualización fallaron varias tablas, no se hizo correctamente. Al final, hubo que montar una tienda desde cero ya que la 1.4.8 tenia fallos de inicio

[t11n00]

Tambien tengo el mismo problemaaaa por favorrr que alguien nos ilumine el camino.....