0

I'm using php bin/magento install to install a fresh DB (i've achieved this successfully several times with Magento 2.1.8)

Everything goes smoothly untill step 538. I get the following

[Progress: 538 / 913]
Module 'Magento_GiftCardAccount':
Installing data... Upgrading data... 

  [Zend_Db_Statement_Exception]                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sales_order.gift_cards' in 'field   
  list', query was: SELECT MAX(entity_id) as max, COUNT(*) as cnt FROM (SELECT `sales_order`  
  .`entity_id`, `sales_order`.`gift_cards` FROM `sales_order` WHERE (gift_cards IS NOT NULL)  
   AND (`sales_order`.`entity_id` > 0) ORDER BY `sales_order`.`entity_id` ASC                 
   LIMIT 50000) AS `t`                                                                        



  [PDOException]                                                                              
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sales_order.gift_cards' in 'field   
  list'                                   

Any tips?

  • Your table sales_order has a missing column gift_cards ... – André Ferraz Mar 8 '18 at 15:27
0

Cleaned cache and generated folder manually. It worked.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.