Jump to content

Edit History

Paulwfc

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]

Paulwfc

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]

×
×
  • Create New...