[SOLVED] [PrestaShopException] - 500 Error page on categories

[Paulwfc]

Hi All

I have searched through and not found a specific answer to this one.

I wonder if anyone can help with the following error I get when selecting categories from the home page.

----------------

 

[PrestaShopException]

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'controller' in 'where clause'
at line 151 in file classes/db/DbPDO.php

146.     protected function _query($sql)

147.     {

148.         try {

149.             return $this->link->query($sql);

150.         } catch (\PDOException $exception) {

151.             throw new PrestaShopException($exception->getMessage(), (int) $exception->getCode(), $exception);

152.         }

153.     }

154. 

155.     /**

156.      * Returns the next row from the result set.

 

DbPDOCore->_query - [line 377 - classes/db/Db.php]

DbCore->query - [line 614 - classes/db/Db.php]

DbCore->executeS - [line 61 - modules/ps_facetedsearch/src/Filters/Provider.php]

PrestaShop\Module\FacetedSearch\Filters\Provider->getFiltersForQuery - [line 258 - modules/ps_facetedsearch/src/Filters/Converter.php]

PrestaShop\Module\FacetedSearch\Filters\Converter->createFacetedSearchFiltersFromQuery - [line 155 - modules/ps_facetedsearch/src/Product/SearchProvider.php]

PrestaShop\Module\FacetedSearch\Product\SearchProvider->runQuery - [line 335 - classes/controller/ProductListingFrontController.php]

ProductListingFrontControllerCore->getProductSearchVariables - [line 613 - classes/controller/ProductListingFrontController.php]

ProductListingFrontControllerCore->doProductSearch - [line 137 - controllers/front/listing/CategoryController.php]

CategoryControllerCore->initContent - [line 319 - classes/controller/Controller.php]

ControllerCore->run - [line 510 - classes/Dispatcher.php]

DispatcherCore->dispatch - [line 28 - index.php]

Edited April 17, 2023 by Paulwfc (see edit history)

[Paulwfc]

In the end updating modules fixed this issue.

[prestaotop]

Hi @Paulwfc,

Could you mark this post as closed.

Well done BTW.

Regards,

[Paulwfc]

9 minutes ago, prestaotop said:

Hi @Paulwfc,

Could you mark this post as closed.

Well done BTW.

Regards,

Hi

how do you do that?

[prestaotop]

Hi,

Like this :

 

Topic [Solved]
If, after posting in a topic, you find a solution to your problem, please report it and describe this solution.
In addition, if you are the author of the topic for which a solution has been provided, edit the first post and add the mention [Solved] at the beginning of the title.

To mark a topic as [Solved]:
- Edit the first post of the topic by clicking on the "Edit" button,
- Click on the "Use full editor" button,
- Add the mention "[Solved]" at the beginning of the title of your topic and click on the button "Send the modified message".

Regards,