· 8 years ago · May 26, 2018, 03:28 AM
1php bin/magento indexer:reindex
2
3Design Config Grid index has been rebuilt successfully in 00:00:06
4Customer Grid index has been rebuilt successfully in 00:00:06
5SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs, query was: CREATE TABLE IF NOT EXISTS `catalog_product_flat_1_tmp_indexer` (
6 `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity Id' ,
7 `attribute_set_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Attribute Set ID' ,
8 `type_id` varchar(32) NOT NULL default 'simple' COMMENT 'Type Id' ,
9 `bat_capacite` int NULL COMMENT 'bat_capacite column' ,
10 `bat_capacite_value` varchar(255) NULL COMMENT 'bat_capacite column' ,
11 `bat_type` int NULL COMMENT 'bat_type column' ,
12 `bat_type_value` varchar(255) NULL COMMENT 'bat_type column' ,
13 `bss_admin_preview` smallint NULL COMMENT 'bss_admin_preview column' ,
14 `con_alarme_batterie_elevee` varchar(255) NULL COMMENT 'con_alarme_batterie_elevee' ,
15 `con_alarme_batterie_faible` varchar(255) NULL COMMENT 'con_alarme_batterie_faible' ,
16 `con_arret_batterie_faible` varchar(255) NULL COMMENT 'con_arret_batterie_faible' ,
17 `con_comutateur_transfer` varchar(255) NULL COMMENT 'con_comutateur_transfer' ,
18 `con_cosummation_vide` varchar(255) NULL COMMENT 'con_cosummation_vide' ,
19 `con_cosummation_vide_eco` varchar(255) NULL COMMENT 'con_cosummation_vide_eco' ,
20 `con_courant_dc` varchar(255) NULL COMMENT 'con_courant_dc' ,
21 `con_courant_de_charge` int NULL COMMENT 'con_courant_de_charge column' ,
22 `con_courant_de_charge_value` varchar(255) NULL COMMENT 'con_courant_de_charge column' ,
23 `con_courant_de_charge_demar` varchar(255) NULL COMMENT 'con_courant_de_charge_demar' ,
24 `con_degre_protection` varchar(255) NULL COMMENT 'con_degre_protection' ,
25 `con_detection_batterie_chargee` varchar(255) NULL COMMENT 'con_detection_batterie_chargee' ,
26 `con_efficience_max` varchar(255) NULL COMMENT 'con_efficience_max' ,
27 `con_entre_ac` varchar(255) NULL COMMENT 'con_entre_ac' ,
28 `con_frequence` varchar(255) NULL COMMENT 'con_frequence' ,
29 `con_fusible` varchar(255) NULL COMMENT 'con_fusible' ,
30 `con_humidite` varchar(255) NULL COMMENT 'con_humidite' ,
31 `con_interrupteur_on_off` varchar(255) NULL COMMENT 'con_interrupteur_on_off' ,
32 `con_materau_couleur` varchar(255) NULL COMMENT 'con_materau_couleur' ,
33 `con_mode_stockage` varchar(255) NULL COMMENT 'con_mode_stockage' ,
34 `con_page_tension` varchar(255) NULL COMMENT 'con_page_tension' ,
35 `con_parallele_triphase` varchar(255) NULL COMMENT 'con_parallele_triphase' ,
36 `con_prise_ac` varchar(255) NULL COMMENT 'con_prise_ac' ,
37 `con_prise_usb` varchar(255) NULL COMMENT 'con_prise_usb' ,
38 `con_protection` varchar(255) NULL COMMENT 'con_protection' ,
39 `con_puissance` int NULL COMMENT 'con_puissance column' ,
40 `con_puissance_value` varchar(255) NULL COMMENT 'con_puissance column' ,
41 `con_puissance_40` varchar(255) NULL COMMENT 'con_puissance_40' ,
42 `con_puissance_60` varchar(255) NULL COMMENT 'con_puissance_60' ,
43 `con_puissance_crete` varchar(255) NULL COMMENT 'con_puissance_crete' ,
44 `con_raccordement_bat` varchar(255) NULL COMMENT 'con_raccordement_bat' ,
45 `con_redemar_batterie_faible` varchar(255) NULL COMMENT 'con_redemar_batterie_faible' ,
46 `con_relais_programmable` varchar(255) NULL COMMENT 'con_relais_programmable' ,
47 `con_section_cable` varchar(255) NULL COMMENT 'con_section_cable' ,
48 `con_temp_fonctionnement` varchar(255) NULL COMMENT 'con_temp_fonctionnement' ,
49 `con_temp_trop_elevee` varchar(255) NULL COMMENT 'con_temp_trop_elevee' ,
50 `con_tension_ac` varchar(255) NULL COMMENT 'con_tension_ac' ,
51 `con_tension_charge_absorption` varchar(255) NULL COMMENT 'con_tension_charge_absorption' ,
52 `con_tension_charge_float` varchar(255) NULL COMMENT 'con_tension_charge_float' ,
53 `con_type` int NULL COMMENT 'con_type column' ,
54 `con_type_value` varchar(255) NULL COMMENT 'con_type column' ,
55 `con_type_batteries` varchar(255) NULL COMMENT 'con_type_batteries' ,
56 `con_ve_bus_port` varchar(255) NULL COMMENT 'con_ve_bus_port' ,
57 `cost` decimal(12,4) NULL COMMENT 'cost' ,
58 `created_at` timestamp NULL default NULL COMMENT 'created_at' ,
59 `description` longtext NULL COMMENT 'description' ,
60 `disponibility` varchar(255) NULL COMMENT 'disponibility column' ,
61 `ge_demarage` varchar(255) NULL COMMENT 'ge_demarage column' ,
62 `ge_phase` int NULL COMMENT 'ge_phase column' ,
63 `ge_phase_value` varchar(255) NULL COMMENT 'ge_phase column' ,
64 `ge_puissance_max` int NULL COMMENT 'ge_puissance_max column' ,
65 `ge_puissance_max_value` varchar(255) NULL COMMENT 'ge_puissance_max column' ,
66 `ge_type` int NULL COMMENT 'ge_type column' ,
67 `ge_type_value` varchar(255) NULL COMMENT 'ge_type column' ,
68 `gift_message_available` smallint NULL COMMENT 'gift_message_available column' ,
69 `has_options` smallint NOT NULL default '0' COMMENT 'has_options' ,
70 `icon_type` int NULL COMMENT 'icon_type column' ,
71 `icon_type_value` varchar(255) NULL COMMENT 'icon_type column' ,
72 `image` varchar(255) NULL COMMENT 'image' ,
73 `image_label` varchar(255) NULL COMMENT 'image_label' ,
74 `is_freedelivery` smallint NULL COMMENT 'is_freedelivery column' ,
75 `links_exist` int NULL COMMENT 'links_exist' ,
76 `links_purchased_separately` int NULL COMMENT 'links_purchased_separately' ,
77 `links_title` varchar(255) NULL COMMENT 'links_title' ,
78 `manufacturer` int NULL COMMENT 'manufacturer column' ,
79 `manufacturer_value` varchar(255) NULL COMMENT 'manufacturer column' ,
80 `msrp` decimal(12,4) NULL COMMENT 'msrp' ,
81 `msrp_display_actual_price_type` text NULL COMMENT 'msrp_display_actual_price_type' ,
82 `name` varchar(255) NULL COMMENT 'name' ,
83 `news_from_date` datetime NULL COMMENT 'news_from_date' ,
84 `news_to_date` datetime NULL COMMENT 'news_to_date' ,
85 `ond_ac_courant_max` varchar(255) NULL COMMENT 'ond_ac_courant_max' ,
86 `ond_courant_charge_max` varchar(255) NULL COMMENT 'ond_courant_charge_max' ,
87 `ond_courant_decharge_max` varchar(255) NULL COMMENT 'ond_courant_decharge_max' ,
88 `ond_eps_courant_nominal` varchar(255) NULL COMMENT 'ond_eps_courant_nominal' ,
89 `ond_eps_delai_de_communication` varchar(255) NULL COMMENT 'ond_eps_delai_de_communication' ,
90 `ond_eps_frequence` varchar(255) NULL COMMENT 'ond_eps_frequence' ,
91 `ond_eps_puissance_crete` varchar(255) NULL COMMENT 'ond_eps_puissance_crete' ,
92 `ond_eps_puissance_nom` varchar(255) NULL COMMENT 'ond_eps_puissance_nom' ,
93 `ond_eps_tension_nominal` varchar(255) NULL COMMENT 'ond_eps_tension_nominal' ,
94 `ond_eps_thd` varchar(255) NULL COMMENT 'ond_eps_thd' ,
95 `ond_fonct_parallele` varchar(255) NULL COMMENT 'ond_fonct_parallele' ,
96 `ond_phases` int NULL COMMENT 'ond_phases column' ,
97 `ond_phases_value` varchar(255) NULL COMMENT 'ond_phases column' ,
98 `ond_plage_de_frequences` varchar(255) NULL COMMENT 'ond_plage_de_frequences' ,
99 `ond_plage_de_tension_mpp` varchar(255) NULL COMMENT 'ond_plage_de_tension_mpp' ,
100 `ond_plage_tension` varchar(255) NULL COMMENT 'ond_plage_tension' ,
101 `ond_protect_surcharge` varchar(255) NULL COMMENT 'ond_protect_surcharge' ,
102 `ond_puissance_pv_max` int NULL COMMENT 'ond_puissance_pv_max column' ,
103 `ond_puissance_pv_max_value` varchar(255) NULL COMMENT 'ond_puissance_pv_max column' ,
104 `ond_puissance_sortie_ac` int NULL COMMENT 'ond_puissance_sortie_ac column' ,
105 `ond_puissance_sortie_ac_value` varchar(255) NULL COMMENT 'ond_puissance_sortie_ac column' ,
106 `ond_pv_courant_max` int NULL COMMENT 'ond_pv_courant_max column' ,
107 `ond_pv_courant_max_value` varchar(255) NULL COMMENT 'ond_pv_courant_max column' ,
108 `ond_tension_batterie` varchar(255) NULL COMMENT 'ond_tension_batterie' ,
109 `ond_tension_entre` varchar(255) NULL COMMENT 'ond_tension_entre' ,
110 `ond_tension_entre_ac` varchar(255) NULL COMMENT 'ond_tension_entre_ac' ,
111 `ond_tension_entre_min` varchar(255) NULL COMMENT 'ond_tension_entre_min' ,
112 `ond_topologie` int NULL COMMENT 'ond_topologie column' ,
113 `ond_topologie_value` varchar(255) NULL COMMENT 'ond_topologie column' ,
114 `ond_type` int NULL COMMENT 'ond_type column' ,
115 `ond_type_value` varchar(255) NULL COMMENT 'ond_type column' ,
116 `ond_type_batterie` varchar(255) NULL COMMENT 'ond_type_batterie' ,
117 `panel_type` varchar(255) NULL COMMENT 'panel_type column' ,
118 `price` decimal(12,4) NULL COMMENT 'price' ,
119 `price_type` int NULL COMMENT 'price_type' ,
120 `price_view` int NULL COMMENT 'Bundle Price View price_view column' ,
121 `required_options` smallint UNSIGNED NOT NULL default '0' COMMENT 'required_options' ,
122 `short_description` longtext NULL COMMENT 'short_description' ,
123 `sku` varchar(64) NULL COMMENT 'sku' ,
124 `sku_type` int NULL COMMENT 'sku_type' ,
125 `small_image` varchar(255) NULL COMMENT 'small_image' ,
126 `small_image_label` varchar(255) NULL COMMENT 'small_image_label' ,
127 `special_from_date` datetime NULL COMMENT 'special_from_date' ,
128 `special_price` decimal(12,4) NULL COMMENT 'special_price' ,
129 `special_to_date` datetime NULL COMMENT 'special_to_date' ,
130 `swatch_image` varchar(255) NULL COMMENT 'swatch_image' ,
131 `tax_class_id` int UNSIGNED NULL COMMENT 'tax_class_id tax column' ,
132 `thumbnail` varchar(255) NULL COMMENT 'thumbnail' ,
133 `thumbnail_label` varchar(255) NULL COMMENT 'thumbnail_label' ,
134 `updated_at` timestamp NOT NULL COMMENT 'updated_at' ,
135 `url_key` varchar(255) NULL COMMENT 'url_key' ,
136 `url_path` varchar(255) NULL COMMENT 'url_path' ,
137 `visibility` smallint UNSIGNED NULL COMMENT 'Catalog Product Visibility visibility column' ,
138 `weight` decimal(12,4) NULL COMMENT 'weight' ,
139 `weight_type` int NULL COMMENT 'weight_type' ,
140 PRIMARY KEY (`entity_id`),
141 INDEX `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_TYPE_ID` (`type_id`),
142 INDEX `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
143 INDEX `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_NAME` (`name`),
144 INDEX `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_OND_TENSION_ENTRE` (`ond_tension_entre`),
145 INDEX `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_PRICE` (`price`)
146) COMMENT='Catalog Product Flat (Store 1)' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
147Category Flat Data index has been rebuilt successfully in 00:00:14
148Category Products index has been rebuilt successfully in 00:00:02
149Product Categories index has been rebuilt successfully in 00:00:00
150Product Price index has been rebuilt successfully in 00:00:04
151Product EAV index has been rebuilt successfully in 00:00:05
152Catalog Rule Product index has been rebuilt successfully in 00:00:03
153Catalog Product Rule index has been rebuilt successfully in 00:00:00
154Stock index has been rebuilt successfully in 00:00:01
155Catalog Search index has been rebuilt successfully in 00:00:23