search

shopware / production

Shopware 6 production template
https://shopware.com
177 stars 151 forks source link

database:migrate-destructive not executed on system:update:finish #27

Closed bestit-ewieser closed 2 years ago

bestit-ewieser commented 4 years ago

When updating a Shopware System, the SystemUpdateFinishCommand is called as post-install-cmd. This subsequently calls the database:migrate Command, but not the database:migrate-destructive.

But then this Migration is not executed: shopware/vendor/shopware/core/Migration/Migration1566293076AddAutoIncrement.php which leads to the following error:

> [ ! -f install.lock ] || bin/console system:update:finish
Run Post Update
Get collection from directories
migrate Migrations
  0/87 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0%
  4/87 [=░░░░░░░░░░░░░░░░░░░░░░░░░░░]   4%
  9/87 [==░░░░░░░░░░░░░░░░░░░░░░░░░░]  10%
 15/87 [====░░░░░░░░░░░░░░░░░░░░░░░░]  17%
 18/87 [=====░░░░░░░░░░░░░░░░░░░░░░░]  20%
 27/87 [========░░░░░░░░░░░░░░░░░░░░]  31%
 32/87 [==========░░░░░░░░░░░░░░░░░░]  36%
 35/87 [===========░░░░░░░░░░░░░░░░░]  40%
 40/87 [============░░░░░░░░░░░░░░░░]  45%
 44/87 [==============░░░░░░░░░░░░░░]  50%
 48/87 [===============░░░░░░░░░░░░░]  55%
 51/87 [================░░░░░░░░░░░░]  58%
 53/87 [=================░░░░░░░░░░░]  60%
 58/87 [==================░░░░░░░░░░]  66%
 61/87 [===================░░░░░░░░░]  70%
 66/87 [=====================░░░░░░░]  75%
 70/87 [======================░░░░░░]  80%
 73/87 [=======================░░░░░]  83%
 79/87 [=========================░░░]  90%
 87/87 [============================] 100%
 ---------- ---------------------- 
  Action     Number of migrations  
 ---------- ---------------------- 
  Migrated   87 out of 87          
 ---------- ---------------------- 
all migrations executed
cleared the shopware cache
In AbstractMySQLDriver.php line 60:

  An exception occurred while executing 'SELECT `category`.`id` as `category.  
  id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id  
  ` as `category.parentId`, `category`.`parent_version_id` as `category.paren  
  tVersionId`, `category`.`after_category_id` as `category.afterCategoryId`,   
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`  
  , `category`.`media_id` as `category.mediaId`, `category`.`display_nested_p  
  roducts` as `category.displayNestedProducts`, `category`.`auto_increment` a  
  s `category.autoIncrement`, `category`.`level` as `category.level`, `catego  
  ry`.`path` as `category.path`, `category`.`child_count` as `category.childC  
  ount`, `category`.`type` as `category.type`, `category`.`visible` as `categ  
  ory.visible`, `category`.`active` as `category.active`, `category`.`cms_pag  
  e_id` as `category.cmsPageId`, `category`.`created_at` as `category.created  
  At`, `category`.`updated_at` as `category.updatedAt`, `category.translation  
  `.`name` as `category.translation.name`, `category.translation`.`name` as `  
  category.name`, `category.translation`.`breadcrumb` as `category.translatio  
  n.breadcrumb`, `category.translation`.`breadcrumb` as `category.breadcrumb`  
  , `category.translation`.`slot_config` as `category.translation.slotConfig`  
  , `category.translation`.`slot_config` as `category.slotConfig`, `category.  
  translation`.`external_link` as `category.translation.externalLink`, `categ  
  ory.translation`.`external_link` as `category.externalLink`, `category.tran  
  slation`.`description` as `category.translation.description`, `category.tra  
  nslation`.`description` as `category.description`, `category.translation`.`  
  meta_title` as `category.translation.metaTitle`, `category.translation`.`me  
  ta_title` as `category.metaTitle`, `category.translation`.`meta_description  
  ` as `category.translation.metaDescription`, `category.translation`.`meta_d  
  escription` as `category.metaDescription`, `category.translation`.`keywords  
  ` as `category.translation.keywords`, `category.translation`.`keywords` as   
  `category.keywords`, `category.translation`.`custom_fields` as `category.tr  
  anslation.customFields`, `category.translation`.`custom_fields` as `categor  
  y.customFields`, `category.translation`.`created_at` as `category.translati  
  on.createdAt`, `category.translation`.`updated_at` as `category.translation  
  .updatedAt`, `category.translation`.`category_id` as `category.translation.  
  categoryId`, `category.translation`.`language_id` as `category.translation.  
  languageId`, `category.translation`.`category_version_id` as `category.tran  
  slation.categoryVersionId` FROM `category` LEFT JOIN `category_translation`  
   `category.translation` ON `category.translation`.`category_id` = `category  
  `.`id` AND `category.translation`.`language_id` = ? AND `category.translati  
  on`.`category_version_id` = `category`.`version_id` WHERE (`category`.`vers  
  ion_id` = ?) AND (`category`.`id` IN (?, ?, ?, ?, ?, ?, ?))' with params ["  
  \x2f\xbb\x5f\xe2\xe2\x9a\x4d\x70\xaa\x58\x54\xce\x7c\xe3\xe2\x0b", "\x0f\xa  
  9\x1c\xe3\xe9\x6a\x4b\xc2\xbe\x4b\xd9\xce\x75\x2c\x34\x25", "\x26\x23\x0e\x  
  fc\x8c\x0a\x48\x32\xbf\x0a\xd9\x14\x34\x68\x81\x8c", "\xb8\x26\xb4\xcc\xb1\  
  xac\x4b\x2e\x85\x0c\x02\x90\x23\x80\x3d\x79", "\xc1\x5f\x40\xe7\x20\x27\x40  
  \x24\xa9\x12\x3d\x52\x0c\x1c\x8f\xa3", "\x70\x55\xd7\x96\x32\x97\x4c\x02\xa  
  0\x76\x76\x53\x8b\xf0\x67\xf6", "\xb0\x47\x8d\x41\x40\xcd\x41\xeb\x85\xb8\x  
  fc\x51\x35\x47\x3f\x72", "\x07\xb1\xdf\x38\xe0\x3c\x46\x6a\x80\x57\x72\x72\  
  x7c\x08\x49\x35", "\xfe\x28\x34\x10\x79\x73\x48\xbf\xad\xff\xc7\xdd\x59\x13  
  \x84\xa5"]:                                                                  

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category.auto_incre  
  ment' in 'field list'                                                        

In PDOStatement.php line 123:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category.auto_incre  
  ment' in 'field list'                                                        

In PDOStatement.php line 121:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category.auto_incre  
  ment' in 'field list'                                                        

system:update:finish [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command>
Script [ ! -f install.lock ] || bin/console system:update:finish handling the post-install-cmd event returned with error code 1
shyim commented 2 years ago

The migrations are executed in the newest version