Здравствуйте уважаемые специалисты. При обновлении ядра возникли сообщения об ошибке. Прошу у вас помощи. У меня был установлен друпал 8.5.10, также был установлен модуль drupal commerce 2. При обновлении ядра на последнюю версию 8.6.7 от системы пришло сообщение об ошибке:
Получено сообщение от следующих обновлений:
Модуль taxonomy
Обновить #8502
Неудача:
Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '9-0-0-uk' for key 'PRIMARY': INSERT INTO {taxonomy_term__parent} (bundle, entity_id, revision_id, langcode, delta, parent_target_id) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5), (:db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11), (:db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17), (:db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23), (:db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29), (:db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35), (:db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41), (:db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47), (:db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53), (:db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59), (:db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65), (:db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71), (:db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77), (:db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83), (:db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89), (:db_insert_placeholder_90, :db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95), (:db_insert_placeholder_96, :db_insert_placeholder_97, :db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101), (:db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104, :db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107), (:db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111, :db_insert_placeholder_112, :db_insert_placeholder_113), (:db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118, :db_insert_placeholder_119), (:db_insert_placeholder_120, :db_insert_placeholder_121, :db_insert_placeholder_122, :db_insert_placeholder_123, :db_insert_placeholder_124, :db_insert_placeholder_125), (:db_insert_placeholder_126, :db_insert_placeholder_127, :db_insert_placeholder_128, :db_insert_placeholder_129, :db_insert_placeholder_130, :db_insert_placeholder_131), (:db_insert_placeholder_132, :db_insert_placeholder_133, :db_insert_placeholder_134, :db_insert_placeholder_135, :db_insert_placeholder_136, :db_insert_placeholder_137), (:db_insert_placeholder_138, :db_insert_placeholder_139, :db_insert_placeholder_140, :db_insert_placeholder_141, :db_insert_placeholder_142, :db_insert_placeholder_143), (:db_insert_placeholder_144, :db_insert_placeholder_145, :db_insert_placeholder_146, :db_insert_placeholder_147, :db_insert_placeholder_148, :db_insert_placeholder_149), (:db_insert_placeholder_150, :db_insert_placeholder_151, :db_insert_placeholder_152, :db_insert_placeholder_153, :db_insert_placeholder_154, :db_insert_placeholder_155); Array ( [:db_insert_placeholder_0] => originalni_podarunki [:db_insert_placeholder_1] => 9 [:db_insert_placeholder_2] => 9 [:db_insert_placeholder_3] => uk [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => originalni_podarunki [:db_insert_placeholder_7] => 10 [:db_insert_placeholder_8] => 10 [:db_insert_placeholder_9] => uk [:db_insert_placeholder_10] => 0 [:db_insert_placeholder_11] => 9 [:db_insert_placeholder_12] => originalni_podarunki [:db_insert_placeholder_13] => 11 [:db_insert_placeholder_14] => 11 [:db_insert_placeholder_15] => uk [:db_insert_placeholder_16] => 0 [:db_insert_placeholder_17] => 9 [:db_insert_placeholder_18] => originalni_podarunki [:db_insert_placeholder_19] => 12 [:db_insert_placeholder_20] => 12 [:db_insert_placeholder_21] => uk [:db_insert_placeholder_22] => 0 [:db_insert_placeholder_23] => 9 [:db_insert_placeholder_24] => originalni_podarunki [:db_insert_placeholder_25] => 13 [:db_insert_placeholder_26] => 13 [:db_insert_placeholder_27] => uk [:db_insert_placeholder_28] => 0 [:db_insert_placeholder_29] => 9 [:db_insert_placeholder_30] => originalni_podarunki [:db_insert_placeholder_31] => 14 [:db_insert_placeholder_32] => 14 [:db_insert_placeholder_33] => uk [:db_insert_placeholder_34] => 0 [:db_insert_placeholder_35] => 9 [:db_insert_placeholder_36] => originalni_podarunki [:db_insert_placeholder_37] => 15 [:db_insert_placeholder_38] => 15 [:db_insert_placeholder_39] => uk [:db_insert_placeholder_40] => 0 [:db_insert_placeholder_41] => 0 [:db_insert_placeholder_42] => originalni_podarunki [:db_insert_placeholder_43] => 16 [:db_insert_placeholder_44] => 16 [:db_insert_placeholder_45] => uk [:db_insert_placeholder_46] => 0 [:db_insert_placeholder_47] => 0 [:db_insert_placeholder_48] => originalni_podarunki [:db_insert_placeholder_49] => 17 [:db_insert_placeholder_50] => 17 [:db_insert_placeholder_51] => uk [:db_insert_placeholder_52] => 0 [:db_insert_placeholder_53] => 0 [:db_insert_placeholder_54] => originalni_podarunki [:db_insert_placeholder_55] => 18 [:db_insert_placeholder_56] => 18 [:db_insert_placeholder_57] => uk [:db_insert_placeholder_58] => 0 [:db_insert_placeholder_59] => 0 [:db_insert_placeholder_60] => originalni_podarunki [:db_insert_placeholder_61] => 19 [:db_insert_placeholder_62] => 19 [:db_insert_placeholder_63] => uk [:db_insert_placeholder_64] => 0 [:db_insert_placeholder_65] => 0 [:db_insert_placeholder_66] => originalni_podarunki [:db_insert_placeholder_67] => 20 [:db_insert_placeholder_68] => 20 [:db_insert_placeholder_69] => uk [:db_insert_placeholder_70] => 0 [:db_insert_placeholder_71] => 0 [:db_insert_placeholder_72] => originalni_podarunki [:db_insert_placeholder_73] => 21 [:db_insert_placeholder_74] => 21 [:db_insert_placeholder_75] => uk [:db_insert_placeholder_76] => 0 [:db_insert_placeholder_77] => 0 [:db_insert_placeholder_78] => originalni_podarunki [:db_insert_placeholder_79] => 22 [:db_insert_placeholder_80] => 22 [:db_insert_placeholder_81] => uk [:db_insert_placeholder_82] => 0 [:db_insert_placeholder_83] => 0 [:db_insert_placeholder_84] => originalni_podarunki [:db_insert_placeholder_85] => 23 [:db_insert_placeholder_86] => 23 [:db_insert_placeholder_87] => uk [:db_insert_placeholder_88] => 0 [:db_insert_placeholder_89] => 0 [:db_insert_placeholder_90] => originalni_podarunki [:db_insert_placeholder_91] => 24 [:db_insert_placeholder_92] => 24 [:db_insert_placeholder_93] => uk [:db_insert_placeholder_94] => 0 [:db_insert_placeholder_95] => 0 [:db_insert_placeholder_96] => originalni_podarunki [:db_insert_placeholder_97] => 25 [:db_insert_placeholder_98] => 25 [:db_insert_placeholder_99] => uk [:db_insert_placeholder_100] => 0 [:db_insert_placeholder_101] => 0 [:db_insert_placeholder_102] => originalni_podarunki [:db_insert_placeholder_103] => 26 [:db_insert_placeholder_104] => 26 [:db_insert_placeholder_105] => uk [:db_insert_placeholder_106] => 0 [:db_insert_placeholder_107] => 0 [:db_insert_placeholder_108] => originalni_podarunki [:db_insert_placeholder_109] => 27 [:db_insert_placeholder_110] => 27 [:db_insert_placeholder_111] => uk [:db_insert_placeholder_112] => 0 [:db_insert_placeholder_113] => 16 [:db_insert_placeholder_114] => originalni_podarunki [:db_insert_placeholder_115] => 28 [:db_insert_placeholder_116] => 28 [:db_insert_placeholder_117] => uk [:db_insert_placeholder_118] => 0 [:db_insert_placeholder_119] => 16 [:db_insert_placeholder_120] => originalni_podarunki [:db_insert_placeholder_121] => 29 [:db_insert_placeholder_122] => 29 [:db_insert_placeholder_123] => uk [:db_insert_placeholder_124] => 0 [:db_insert_placeholder_125] => 16 [:db_insert_placeholder_126] => originalni_podarunki [:db_insert_placeholder_127] => 30 [:db_insert_placeholder_128] => 30 [:db_insert_placeholder_129] => uk [:db_insert_placeholder_130] => 0 [:db_insert_placeholder_131] => 17 [:db_insert_placeholder_132] => originalni_podarunki [:db_insert_placeholder_133] => 31 [:db_insert_placeholder_134] => 31 [:db_insert_placeholder_135] => uk [:db_insert_placeholder_136] => 0 [:db_insert_placeholder_137] => 0 [:db_insert_placeholder_138] => originalni_podarunki [:db_insert_placeholder_139] => 32 [:db_insert_placeholder_140] => 32 [:db_insert_placeholder_141] => uk [:db_insert_placeholder_142] => 0 [:db_insert_placeholder_143] => 0 [:db_insert_placeholder_144] => originalni_podarunki [:db_insert_placeholder_145] => 33 [:db_insert_placeholder_146] => 33 [:db_insert_placeholder_147] => uk [:db_insert_placeholder_148] => 0 [:db_insert_placeholder_149] => 0 [:db_insert_placeholder_150] => originalni_podarunki [:db_insert_placeholder_151] => 34 [:db_insert_placeholder_152] => 34 [:db_insert_placeholder_153] => uk [:db_insert_placeholder_154] => 0 [:db_insert_placeholder_155] => 0 ) in Drupal\Core\Database\Connection->handleQueryException() (line 683 of /home/r/raufkul/store/public_html/core/lib/Drupal/Core/Database/Connection.php).
Подскажите - что надо делать.
Комментарии
Сайт собран на composer, раз commerce есть, верно?
Пишите как обновляете, что делаете
Commerce я установил без composer. Обновление произвожу в файлообменнике хостинга. В крневом каталоге сайта полностью обновляю папку - core, затем полностью обновляю папку - vendor, затем другие файлы, которые находятся не в папках. Затем через админпанель сайта произвожу обновление базы данных. Так всегда обновляю другие сайты - все проходит нормально. Я думаю, что это из-за модуля - commerce.
Вот, собственно, ошибка: Duplicate entry '9-0-0-uk' for key 'PRIMARY': INSERT INTO {taxonomy_term__parent}
пытается записать ID родительского термина, которое уже есть в таблице.
Вряд ли тут проблема в коммерце.
Как вариант - попробовать сделать все дочерние термины термина с ID=9 кореневыми (чтобы у них не было родителя), обновить и вернуть иерархию обратно.
Попробовал сделать так, как вы сказали с терминами с id="taxonomy_term-9". Попытался сделать данные термины без родителей, то есть перенес мышкой, нажал сохранить - получил белый экран и сообщение в экране: На сайте произошла неожиданная ошибка. Пожалуйста, повторите попытку позже.
Термины не сдвинулись и в журнале появились две ошибки
1-ая ошибка типа taxonomy_term
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'field list': INSERT INTO {taxonomy_term_field_data} (tid, vid, langcode, status, name, description__value, description__format, weight, changed, default_langcode) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 33 [:db_insert_placeholder_1] => originalni_podarunki [:db_insert_placeholder_2] => uk [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => Популярні [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => 1 [:db_insert_placeholder_8] => 1548422915 [:db_insert_placeholder_9] => 1 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->saveToSharedTables() (line 937 of /home/r/raufkul/store/public_html/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
2-ая ошибка типа php
Drupal\Core\Entity\EntityStorageException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'field list': INSERT INTO {taxonomy_term_field_data} (tid, vid, langcode, status, name, description__value, description__format, weight, changed, default_langcode) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 33 [:db_insert_placeholder_1] => originalni_podarunki [:db_insert_placeholder_2] => uk [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => Популярні [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => 1 [:db_insert_placeholder_8] => 1548422915 [:db_insert_placeholder_9] => 1 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 783 of /home/r/raufkul/store/public_html/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Если надо могу сделать скрин ошибок.
Ошибка одна и та же:
Column not found: 1054 Unknown column 'status' in 'field list': INSERT INTO {taxonomy_term_field_data}
похоже, что побилась база, как минимум - таблицы, связанные с таксономией.
Бэкап базы есть?
Тогда сделаю откат до версии ядра 8.5.10. А потом как быть? Обновления же все равно необходимо будет делать?
Известная проблема - https://www.drupal.org/project/drupal/issues/2997960
Предлагаю изучить комментарии по ссылке выше.