SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id_employee' in 'field list'

[DARKF3D3]

On my shop I just get this error. Website recently upgraded from PS1.7 to PS8.1.

Into server log I can't find additional informations.

 

I don't understand from what it caused.

 

 

[musicmaster]

Without more information this is rather useless. There is a query that caused this error. And only when we know the query can we do some guess which table caused the problem.

[DARKF3D3]

I don't know which query caused that error.
That's the only information showed, also with debug mode enabled.

[prestaotop]

Hi,

here is the solution : 

https://github.com/PrestaShop/PrestaShop/issues/33238

 

How to fix it :

ALTER TABLE `ps_order_payment` ADD `id_employee` INT NULL AFTER `date_add`;

Regards,

[DARKF3D3]

@prestaotop Thanks!

[jinojames]

Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'jpg' in 'where clause' in /home/edallsys/edallstore.com/classes/db/DbPDO.php:149 i am getting this error on my homepage. what's causing this ?

Website : https://edallstore.com

Edited June 5, 2024 by jinojames (see edit history)