Unknown column 'product_type' in 'field list'<br /><br /><pre>INSERT INTO `ps_product` AFTER MANUAL UPGRADE from 1.7.8.10 to 1.7.8.11 about prestashop HOT 12 CLOSED

Your original error says:
Unknown column 'product_type' in 'field list'

And the product_type column should be added in 1.7.8.0 upgrade:

https://github.com/PrestaShop/autoupgrade/blob/dev/upgrade/sql/1.7.8.0.sql#L172-L180

This means that you had a broken database structure before this upgrade or did something unexpected in one of the previous attempts to upgrade PrestaShop.

from prestashop.

from prestashop.

Also related to this issue:
product_type field, after manual creating it, are not update for "standard":

Virtual

Pack

Standard

value are not changed

on first save value is empty:

from prestashop.

Hi @matteolavaggi

Thank for your report,
This issue is too technical for me, ping @PrestaShop/tech-council , can someone please reproduce this issue ?

Thanks

from prestashop.

Hello @matteolavaggi

Something went wrong during your manual upgrade. The product_type field is only used by the new product page, which was enabled for PrestaShop 8.1. On PrestaShop 1.7.8, it was in the early experimental phase.

A few other things to remember:

• there was no need to upgrade database between 1.7.8.10 and 1.7.8.11, see that there's no SQL upgrade available https://github.com/PrestaShop/autoupgrade/tree/dev/upgrade/sql
• Unfortunately, the manual upgrade method doesn't work correctly anymore, it's recommended to use CLI upgrade as described in the newer version of the documentation

I suggest reverting your shop to 1.7.8.10 and applying only the changed files if you want to do the upgrade manually.

from prestashop.

Hello @kpodemski thanks for your reply, i need some more information because i cant really understand well your suggestion.

When you say "The product_type field is only used by the new product page, which was enabled for PrestaShop 8.1" , and "Something went wrong during your manual upgrade" there is a lack of information, i've downloaded the official 1.7.8.11 zip package from official web page reposistory and extracted it, how its possible that in this package there are core modification for a future version of PS (8.1) ?!

When you say "there was no need to upgrade database between 1.7.8.10 and 1.7.8.11" i agree, the upgrade procedure say there is nothing to upgrade but the zip package released from prestashop.com contain file that NEED a database upgrade, so i'm a bit confused.

When you say "Unfortunately, the manual upgrade method doesn't work correctly" , where this is explained? I can find a online official guide here "https://devdocs.prestashop-project.org/1.7/basics/keeping-up-to-date/upgrade/" that explain exactly how to do a manual upgrade, without any information or alert on the deprecation of this procedure.

When you say "it's recommended to use CLI upgrade as described in the newer version of the documentation" , i CANT find any support on CLI with ps lower than 8.0 , there is no cli script at all , so i dont think we can upgrade 1.7.8.10 to 1.7.8.11 with CLI.

At least, 1.7.8.11 is a security update, but...

There is no way to upgrade it using manual upgrade
There is no way to upgrade using CLI

So how we can apply the patch to 1.7.8.10 ?

from prestashop.

Any more information? it is very serious that the last release of a project before the transition to a new version is not updatable

from prestashop.

@matteolavaggi it is upgradable, you can use autoupgrade module or as I mentioned you can only replace the files manually and that will be enough

from prestashop.

from prestashop.

Some file MODIFIED from .10 to .11 (so the One you Say me to manually Copy)
contain dev code that can not be run with original database schema.

That's not true. In the link I provided you:
1.7.8.10...1.7.8.11

There are no changes related to the product_type. Product type has been added way back in 1.7.8.0.

from prestashop.

I don't think upgrading your store with Redis enabled is wise :)

from prestashop.

from prestashop.