Please help with error MySLQ Error in back office

[cheap gaming pcs]

Hi Everyone

 

Thanks for your inadvance, Im using ps 1.5.4

 

I turn on dev mode to shows any errors and i get the message below

 

I have a fresh install of prestashop, I added a few products and category's, then i deleted 2 catgegorys and the error message come up when i tried to view the products

 

Thanks so much for your help

 

[PrestaShopDatabaseException]

Unknown column 'cp.position' in 'field list'

 

SELECT SQL_CALC_FOUND_ROWS

a.`id_product`,b.name as name,`reference`,a.price as price,a.active as active,cp.position as position

, MAX(i.id_image) id_image,cl.name `name_category` , i.`id_image`, a.`price`, 0 AS price_final, sav.`quantity` as sav_quantity, a.`active`

FROM `ps_product` a

LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)

LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product` AND i.cover=1)LEFT JOIN `ps_category_lang` cl ON (a.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = 1)

LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0

AND sav.id_shop = 1 )

 

WHERE 1

GROUP BY a.id_product

 

ORDER BY cp.`position` ASC LIMIT 0,50

 

 

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)

606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

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

608. }

609. }

610.

611. /**

 

DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments]

DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments]

DbCore->executeS - [line 2198 - classes/controller/AdminController.php] - [1 Arguments]

AdminControllerCore->getList - [line 337 - controllers/admin/AdminProductsController.php] - [6 Arguments]

AdminProductsControllerCore->getList - [line 1531 - classes/controller/AdminController.php] - [1 Arguments]

AdminControllerCore->renderList - [line 2260 - controllers/admin/AdminProductsController.php] - [0 Argument]

AdminProductsControllerCore->renderList - [line 1440 - classes/controller/AdminController.php] - [0 Argument]

AdminControllerCore->initContent - [line 2252 - controllers/admin/AdminProductsController.php] - [0 Argument]

AdminProductsControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]

ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument]

DispatcherCore->dispatch - [line 50 - admin123/index.php] - [0 Argument]

[JayLab]

Did you find a solution, i have the same problem.

[cedricfontaine]

Is it an upgrade ?