Upgrade Problems from 1.7.8.10 to 8.1.1 SQL Error Category

[fotoserver]

Hello,

I have rebuilt my store a few times now, but always get the same problem.

Since 1.7.8.10 does not support PHP 8.1 I wanted to change to the latest version. I did this via the 1Click Update Tool and the process runs through without errors.

However, after the update I can no longer call category pages, it comes a white page. Debug mode on and this plays me the following error message out:

 

[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 261 - 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 356 - classes/controller/ProductListingFrontController.php]
    ProductListingFrontControllerCore->getProductSearchVariables - [line 634 - 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]

It looks like a column is missing. Or as if the update forgot to create database columns. What can I do?

 

[musicmaster]

I need to see the query to know what goes wrong. And what you show doesn't show the query. Maybe you can make a screendump?