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

[clive@hmd]

Just upgraded from Prestashop 1.7.8.9 to 8.1.1 and Using PHP 8.2 (also tried 8.1)

All migrated well but when we come to update any product we get SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unit_price' in 'field list' and are not able to save the product with updates... We reverted back th PHP 7.4 and this error goes away.

 

Are there any suggestions to overcome this using PHP8.x?

[AddWeb Solution]

Hi,

Compare the database schema between Prestashop 1.7.8.9 and 8.1.1. Look for any differences in table structure, specifically the table related to product information. Make sure the 'unit_price' column exists in the new schema.

When upgrading Prestashop, there might be database update scripts that need to be run to ensure the database is properly upgraded

Clear the cache in Prestashop to ensure that any cached database information is updated to match the new schema.

Thanks!

[musicmaster]

The field "unit_price" was added to ps_product and ps_product_shop in version 8.0.

[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 Stack trace: #0 /home/edallsys/edallstore.com/classes/db/DbPDO.php(149): PDO->query('SELECT `id_imag...') #1 /home/edallsys/edallstore.com/classes/db/Db.php(377): DbPDOCore->_query('SELECT `id_imag...') #2 /home/edallsys/edallstore.com/classes/db/Db.php(664): 

 

I am getting this error in my website. anyone know what's causing this error ?