cancel
Showing results for 
Search instead for 
Did you mean: 

Column image in catalog_product_flat

Highlighted

Column image in catalog_product_flat

After upgrade from v2.3.5 to v2.4.0 there is no column "image" in catalog_product_flat tables. In database for v.2.3.5 the column exists but it is not clear if it was created as system attribute.

 

Is it possible to add product attribute "image" into catalog_product_flat table as system attribute? 

 

vendor/magento/module-catalog/etc/catalog_attributes.xml

<group name="unassignable">
<attribute name="image" />
...
</group>

 

1 REPLY 1
Highlighted

Re: Column image in catalog_product_flat

Try this code instead :

$installer = $this;
$installer->startSetup();
$installer->getConnection()
        ->addColumn($installer->getTable('sales/quote_item'), 'customized_product_solitaire', array(
            'type' => Varien_Db_Ddl_Table::TYPE_INTEGER,
            'nullable' => false,
            'length'    => 1
        ));
$installer->getConnection()
          ->addColumn($installer->getTable('sales/order_item'), 'customized_product_solitaire', array(
            'type' => Varien_Db_Ddl_Table::TYPE_INTEGER,
            'nullable' => false,
            'length'    => 1
        ));