Jump to content

Recommended Posts

I recently migrated my shop manually to another server. In hindsight, this may not have been the optimal decision, given that I migrated from version 1.7.7 to 8.1.6. I proceeded with the migration and am now experiencing issues with the database and certain modules. I have verified the names of the hooks for the modules in question and they appear to be correct. However, despite this, the errors persist, leading me to temporarily deactivate the modules. Unfortunately, this did not resolve the issue.

The situation with the database is more complex. A table is missing, and even if I attempt to create it, I am unsure of its structure.
Please find attached a screenshot of the errors I have encountered.

Thank you so much in advance

Captura de pantalla 2024-07-17 102421.png

Link to comment
Share on other sites

13 minutes ago, Emoreira said:

I recently migrated my shop manually to another server. In hindsight, this may not have been the optimal decision, given that I migrated from version 1.7.7 to 8.1.6. I proceeded with the migration and am now experiencing issues with the database and certain modules. I have verified the names of the hooks for the modules in question and they appear to be correct. However, despite this, the errors persist, leading me to temporarily deactivate the modules. Unfortunately, this did not resolve the issue.

The situation with the database is more complex. A table is missing, and even if I attempt to create it, I am unsure of its structure.
Please find attached a screenshot of the errors I have encountered.

Thank you so much in advance

Captura de pantalla 2024-07-17 102421.png

Just in case you need the text of the errors:
Deprecated: The hook "Header" is deprecated, please use "displayHeader" instead in module "ps_imageslider". in /var/www/html/wordpress/shop/classes/Hook.php on line 921

Deprecated: The hook "Header" is deprecated, please use "displayHeader" instead in module "ps_searchbar". in /var/www/html/wordpress/shop/classes/Hook.php on line 921

Deprecated: The hook "Header" is deprecated, please use "displayHeader" instead in module "ps_shoppingcart". in /var/www/html/wordpress/shop/classes/Hook.php on line 921

Deprecated: The hook "Header" is deprecated, please use "displayHeader" instead in module "ps_emailalerts". in /var/www/html/wordpress/shop/classes/Hook.php on line 921

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'prestashop.ps_product_attribute_lang' doesn't exist in /var/www/html/wordpress/shop/classes/db/DbPDO.php:149 Stack trace: #0 /var/www/html/wordpress/shop/classes/db/DbPDO.php(149): PDO->query() #1 /var/www/html/wordpress/shop/classes/db/Db.php(377): DbPDOCore->_query() #2 /var/www/html/wordpress/shop/classes/db/Db.php(614): DbCore->query() #3 /var/www/html/wordpress/shop/classes/Product.php(7530): DbCore->executeS() #4 /var/www/html/wordpress/shop/classes/Product.php(5853): ProductCore::getAttributesParams() #5 /var/www/html/wordpress/shop/classes/Product.php(5986): ProductCore::getProductProperties() #6 /var/www/html/wordpress/shop/classes/Category.php(1074): ProductCore::getProductsProperties() #7 /var/www/html/wordpress/shop/src/Adapter/Category/CategoryProductSearchProvider.php(88): CategoryCore->getProducts() #8 /var/www/html/wordpress/shop/src/Adapter/Category/CategoryProductSearchProvider.php(105): PrestaShop\PrestaShop\Adapter\Category\CategoryProductSearchProvider->getProductsOrCount() #9 /var/www/html/wordpress/shop/modules/ps_featuredproducts/ps_featuredproducts.php(297): PrestaShop\PrestaShop\Adapter\Category\CategoryProductSearchProvider->runQuery() #10 /var/www/html/wordpress/shop/modules/ps_featuredproducts/ps_featuredproducts.php(255): Ps_FeaturedProducts->getProducts() #11 /var/www/html/wordpress/shop/modules/ps_featuredproducts/ps_featuredproducts.php(241): Ps_FeaturedProducts->getWidgetVariables() #12 /var/www/html/wordpress/shop/classes/Hook.php(1088): Ps_FeaturedProducts->renderWidget() #13 /var/www/html/wordpress/shop/classes/Hook.php(1019): HookCore::coreRenderWidget() #14 /var/www/html/wordpress/shop/controllers/front/IndexController.php(40): HookCore::exec() #15 /var/www/html/wordpress/shop/classes/controller/Controller.php(319): IndexControllerCore->initContent() #16 /var/www/html/wordpress/shop/classes/Dispatcher.php(510): ControllerCore->run() #17 /var/www/html/wordpress/shop/index.php(28): DispatcherCore->dispatch() #18 {main} Next PrestaShopException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'prestashop.ps_product_attribute_lang' doesn't exist in /var/www/html/wordpress/shop/classes/db/DbPDO.php:151 Stack trace: #0 /var/www/html/wordpress/shop/classes/db/Db.php(377): DbPDOCore->_query() #1 /var/www/html/wordpress/shop/classes/db/Db.php(614): DbCore->query() #2 /var/www/html/wordpress/shop/classes/Product.php(7530): DbCore->executeS() #3 /var/www/html/wordpress/shop/classes/Product.php(5853): ProductCore::getAttributesParams() #4 /var/www/html/wordpress/shop/classes/Product.php(5986): ProductCore::getProductProperties() #5 /var/www/html/wordpress/shop/classes/Category.php(1074): ProductCore::getProductsProperties() #6 /var/www/html/wordpress/shop/src/Adapter/Category/CategoryProductSearchProvider.php(88): CategoryCore->getProducts() #7 /var/www/html/wordpress/shop/src/Adapter/Category/CategoryProductSearchProvider.php(105): PrestaShop\PrestaShop\Adapter\Category\CategoryProductSearchProvider->getProductsOrCount() #8 /var/www/html/wordpress/shop/modules/ps_featuredproducts/ps_featuredproducts.php(297): PrestaShop\PrestaShop\Adapter\Category\CategoryProductSearchProvider->runQuery() #9 /var/www/html/wordpress/shop/modules/ps_featuredproducts/ps_featuredproducts.php(255): Ps_FeaturedProducts->getProducts() #10 /var/www/html/wordpress/shop/modules/ps_featuredproducts/ps_featuredproducts.php(241): Ps_FeaturedProducts->getWidgetVariables() #11 /var/www/html/wordpress/shop/classes/Hook.php(1088): Ps_FeaturedProducts->renderWidget() #12 /var/www/html/wordpress/shop/classes/Hook.php(1019): HookCore::coreRenderWidget() #13 /var/www/html/wordpress/shop/controllers/front/IndexController.php(40): HookCore::exec() #14 /var/www/html/wordpress/shop/classes/controller/Controller.php(319): IndexControllerCore->initContent() #15 /var/www/html/wordpress/shop/classes/Dispatcher.php(510): ControllerCore->run() #16 /var/www/html/wordpress/shop/index.php(28): DispatcherCore->dispatch() #17 {main} Next PrestaShop\PrestaShop\Core\Exception\CoreException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'prestashop.ps_product_attribute_lang' doesn't exist in /var/www/html/wordpress/shop/classes/Hook.php:1092 Stack trace: #0 /var/www/html/wordpress/shop/classes/Hook.php(1019): HookCore::coreRenderWidget() #1 /var/www/html/wordpress/shop/controllers/front/IndexController.php(40): HookCore::exec() #2 /var/www/html/wordpress/shop/classes/controller/Controller.php(319): IndexControllerCore->initContent() #3 /var/www/html/wordpress/shop/classes/Dispatcher.php(510): ControllerCore->run() #4 /var/www/html/wordpress/shop/index.php(28): DispatcherCore->dispatch() #5 {main} thrown in /var/www/html/wordpress/shop/classes/Hook.php on line 1092

Link to comment
Share on other sites

  • 3 weeks later...

After testing the deactivation of several modules, I permanently disabled three modules to resolve the exceptions in PrestaShop: ps_linklist, ps_emailalerts, and ps_facetedsearch. Once these modules were deactivated, I was able to access the shop page and its subdirectories.

I am currently attempting to access the back office with my administrator credentials at the following URL: http://192.168.10.97/shop/admin/index.php?controller=AdminLogin. But even if it appears that I am being redirected to the Admin dashboard (http://192.168.10.97/shop/admin/index.php?controller=AdminLogin&redirect=AdminDashboard), but I am still presented with the login page. I have checked the files "20240801-exception.log" and "dev-2024-08-01.log" inside the directory shop/var/logs/, and there are no errors. I have also inspected the page in the web browser, but I am still unable to find the source of the problem. Could you please advise me on how to resolve this issue?

Captura de pantalla 2024-08-01 171441.png

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...