Column 'id_product' in where clause is ambiguous

[bodhidharma.es]

Hola tengo un problema que no se como resolver, despues de haber hecho testes de compra he borrado clientes y pedidos com el limpiador de prestashop, despues de eso no consigo hacer pedidos que me aparece lo que pongo abajo

 

alguien p¡me puede ayudar?

gracias

 

[PrestaShopDatabaseException]

Column 'id_product' in where clause is ambiguous
 

                SELECT image_shop.id_image
                FROM ps_image i INNER JOIN ps_image_shop image_shop
        ON (image_shop.id_image = i.id_image AND image_shop.id_shop IN (1, 2) AND image_shop.cover=1)
                WHERE id_product = 1 LIMIT 1
at line 646 in file classes/db/Db.php

 

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

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642.         }
643.         elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644.         {
645.             if ($sql)
646.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647.             throw new PrestaShopDatabaseException($this->getMsgError());
648.         }
649.     }
650.
651.     /**

• DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 558 - classes/db/Db.php] - [1 Arguments]
• DbCore->getRow - [line 583 - classes/db/Db.php] - [2 Arguments]
• DbCore->getValue - [line 677 - classes/order/Order.php] - [1 Arguments]
• OrderCore->setProductImageInformations - [line 588 - classes/order/Order.php] - [1 Arguments]
• OrderCore->getProducts - [line 2606 - controllers/admin/AdminOrdersController.php]
• AdminOrdersControllerCore->getProducts - [line 1589 - controllers/admin/AdminOrdersController.php] - [1 Arguments]
• AdminOrdersControllerCore->renderView - [line 1839 - classes/controller/AdminController.php]
• AdminControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

 

 

[tplmika]

Hi i also face the same issue here. Is there is a bug or is due to other things? Any suggestion solution to this issue ?
 

[PrestaShopDatabaseException]
Column 'id_product' in where clause is ambiguous
 
                SELECT image_shop.id_image
                FROM ps_image i INNER JOIN ps_image_shop image_shop
        ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
                WHERE id_product = 141 LIMIT 1
at line 646 in file classes/db/Db.php
 
 
 
 
641.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642.         }
643.         elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644.         {
645.             if ($sql)
646.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647.             throw new PrestaShopDatabaseException($this->getMsgError());

[ReactionCode]

A lo mejor me equivoco, pero creo que esa consulta es incorrecta.

 

El tema está en que la tabla ps_image_shop y ps_image Tienen el campo id_product y en la consulta no especifica a que tabla se refiere ese id_product, por eso es ambiguo.

 

Debería de ser WHERE image_shop.id_product = x

 

¿Qué version de PS tienes?

[pattila01]

https://www.prestashop.com/forums/topic/550892-order-impossible/?p=2389542