problem backend from 1.7.3 to 1.7.8.7

[GtaBK]

Hello,

I have made an update in my prestashop from 1.7.3 to 1.7.8.7, but after I tried to enter the backend, I have no CSS data there, and when I click something, I get this info:

 

An exception occurred while executing 'SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.filter_id = ? LIMIT 1' with params [1, 1, "order"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list'

[Doctrine\DBAL\Exception\InvalidFieldNameException 0]

Best Regards

[GtaBK]

OHH the problem is already solved:

After this: 

ALTER TABLE `ps_admin_filter` ADD `filter_id` INT NOT NULL ;

 

it works again.

 

OK it's not solved...

 

After I try do deactivate as example a module, I get this error:

 

Ausnahmefehler im Modul st_testimonialblock bei disable: An exception occurred while executing 'SELECT t0.id_tab AS id_tab_1, t0.id_parent AS id_parent_2, t0.position AS position_3, t0.module AS module_4, t0.class_name AS class_name_5, t0.route_name AS route_name_6, t0.active AS active_7, t0.enabled AS enabled_8, t0.hide_host_mode AS hide_host_mode_9, t0.icon AS icon_10, t0.wording AS wording_11, t0.wording_domain AS wording_domain_12 FROM ps_tab t0 WHERE t0.module = ?' with params ["st_testimonialblock"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.route_name' in 'field list'

Edited October 12, 2022 by GtaBK (see edit history)

[juanrojas]

hello, look in the modules folder via ftp and rename this module st_testimonialblock to see if it lets you work

[GtaBK]

Hello,

I see now I have a lot of more problems in backend...

Sometimes I get an error, but it is saved. As exmaple for a module upgrade. Or deactivate and activate module.

And template modules I can just deactivate or activate, but I can't make changes on them.

Than I can't activate another template as example...

I think there is some incompleted with the upgrade or another problem. But I have not enough experience on it.

Is there maybe someone, they can solve all the problems for me?

Best Regards

[JBW]

It looks like the DB updates were not done properly in your upgrade, it might have crashed before (you can see this in the upgrade logs). If only DB updates are missing you have to do these manually or restore the previous backup.