Emoreira Posted July 17 Share Posted July 17 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 Link to comment Share on other sites More sharing options...
Emoreira Posted July 17 Author Share Posted July 17 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 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 More sharing options...
Emoreira Posted August 1 Author Share Posted August 1 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? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now