ReflectionException Error after Module Installation

[2SurvivalGuys]

So here is the problem...

Had a crash and complete data loss on tuesday. could not be restored at that time.

Startetd a new install and set everything up new. 

Imported databank tables for products, stock,  etc. and everything was working.

But everytime we try to install ANY module we run into an error 500 on the backoffice login. The shop is in maintenance mode right now but no errors there. It loads fine.

 

Whoops, looks like something went wrong.

(1/1) ReflectionException

The autoloader expected class "PrestaShopBundle\Controller\Admin\Sell\index" to be defined in file "clickandbuilds/PrestaShop/2Survivalguys_DE/vendor/composer/../../src/PrestaShopBundle/Controller/Admin/Sell/index.php". The file was found but the class was not in it, the class name or namespace probably has a typo.

in ClassExistenceResource.php line 72

at ClassExistenceResource->isFresh(0)in ContainerBuilder.php line 371

at ContainerBuilder->getReflectionClass('PrestaShopBundle\\Controller\\Admin\\Sell\\index')in RegisterControllerArgumentLocatorsPass.php line 67

at RegisterControllerArgumentLocatorsPass->process(object(ContainerBuilder))in Compiler.php line 140

at Compiler->compile(object(ContainerBuilder))in ContainerBuilder.php line 789

at ContainerBuilder->compile()in Kernel.php line 643

at Kernel->initializeContainer()in Kernel.php line 135

at Kernel->boot()in Kernel.php line 195

at Kernel->handle(object(Request), 1, false)in index.php line 82

 

 

Problem is i can´t even find this directory 

clickandbuilds/PrestaShop/2Survivalguys_DE/vendor/composer/../../src/PrestaShopBundle/Controller/Admin/Sell/index.php

i can find this directory 

clickandbuilds/PrestaShop/2Survivalguys_DE/src/PrestaShopBundle/Controller/Admin/Sell/index.php

but the index.php file is empty

 

Prestashop 1.7.7.

PHP7.3

MySQL5.7

Edited December 13, 2020 by 2SurvivalGuys (see edit history)

[endriu107]

At first, max php version for prestashop 1.7.7 is 7.3.

[2SurvivalGuys]

1 hour ago, endriu107 said:

At first, max php version for prestashop 1.7.7 is 7.3.

Yes, it's 7.3

Provider always tried to set it up with recommended 7.4 but we changed it to 7.3 before install

Edited December 12, 2020 by 2SurvivalGuys (see edit history)

[2SurvivalGuys]

Anyone any ideas how it could be fixed?

 

[PrestaShopDatabaseException]

Unknown column 'pa.mpn' in 'field list'<br /><br /><pre>SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, cu.`id_customization`, cu.`quantity` AS customization_quantity, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IF (IFNULL(pa.`mpn`, '') = '', p.`mpn`, pa.`mpn`) AS mpn, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price , image_shop.`id_image` id_image, il.`legend` FROM `fvx9_cart_product` cp LEFT JOIN `fvx9_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `fvx9_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `fvx9_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = cp.id_shop LEFT JOIN `fvx9_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = cp.id_shop LEFT JOIN `fvx9_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN `fvx9_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN fvx9_stock_available stock ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `fvx9_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 1 LEFT JOIN `fvx9_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `fvx9_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `fvx9_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `fvx9_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 2 WHERE (cp.`id_cart` = 1) AND (p.`id_product` IS NOT NULL) GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization` ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC </pre>
at line 769 in file classes/db/Db.php

764. if ($webservice_call && $errno) { 765. $dbg = debug_backtrace(); 766. WebserviceRequest::getInstance()->setError(500, '

 ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); 767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 768. if ($sql) { 769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); 770. } 771. 772. throw new PrestaShopDatabaseException($this->getMsgError()); 773. } 774. }

DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments]

DbCore->query - [line 613 - classes/db/Db.php] - [1 Arguments]

DbCore->executeS - [line 760 - classes/Cart.php] - [1 Arguments]

CartCore->getProducts - [line 320 - src/Adapter/Presenter/Cart/CartPresenter.php] - [1 Arguments]

PrestaShop\PrestaShop\Adapter\Presenter\Cart\CartPresenter->present - [line 501 - classes/controller/FrontController.php] - [1 Arguments]

FrontControllerCore->assignGeneralPurposeVariables - [line 567 - classes/controller/FrontController.php]

FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php]

IndexControllerCore->initContent - [line 306 - classes/controller/Controller.php]

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

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

[endriu107]

You have missing column "mpn" in some table.

[2SurvivalGuys]

1 hour ago, endriu107 said:

You have missing column "mpn" in some table.

Yeah that shouldn`t be the main problem though. It`s cause we imported the whole tables from the old database from 1.6.7. or whatever it was.

The frontend of the shop seems to be  working ok so far (its in maintanance mode), just the backoffice login does not.

[2SurvivalGuys]

OK added the column mpn to the tables product and product_attribute. 

It loads the frontend normal now in debug mode. no more error messages there.

Backoffice login is another problem.

 

 

Edited December 13, 2020 by 2SurvivalGuys (see edit history)