Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Version 2.0.1 breaks your shop #28

Closed
bjoern-quast opened this issue Jul 6, 2016 · 3 comments
Closed

Version 2.0.1 breaks your shop #28

bjoern-quast opened this issue Jul 6, 2016 · 3 comments

Comments

@bjoern-quast
Copy link

Reliance on the attribute field 'is_visible_on_checkout' breaks the shop.
The "UpgradeSchema" is missing, thus an update leads to the mentioned problem. Only a fresh install will work.
Also, please consider using tags or releases that can be used with composer.

@tecjam
Copy link

tecjam commented Jul 13, 2016

I can confirm this as it has just happened to me. Products are no longer added to the cart and the exception log states:

CRITICAL: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_visible_on_checkout' in 'where clause'' in /vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228

Exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_visible_on_checkout' in 'where clause', query was: SELECT COUNT(DISTINCT main_table.attribute_id) FROM `eav_attribute` AS `main_table`
 INNER JOIN `eav_entity_type` AS `entity_type` ON main_table.entity_type_id = entity_type.entity_type_id
 LEFT JOIN `eav_entity_attribute` ON main_table.attribute_id = eav_entity_attribute.attribute_id
 INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id WHERE (`entity_type_code` = 'catalog_product') AND (`is_visible_on_checkout` = 1)' in /vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235


Another fix seems to be:

ALTER TABLEcatalog_eav_attributeADDis_visible_on_checkoutSMALLINT(5) NOT NULL DEFAULT '0' COMMENT 'Is Visible On Checkout' AFTERis_filterable_in_grid

But are there other changes elsewhere?

@therouv
Copy link
Member

therouv commented Jul 14, 2016

Hi @bjoern-quast @tecjam the issue should be resolved now (see f198a6a). Can you please check?

@frostblogNet
Copy link
Member

We will close this issue from 2016. Feel free to reopen if it is relevant.

Thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants