GX-Bug #45627
Von Daniel Wu vor fast 10 Jahren aktualisiert
Viele Datenbankabfragen sind im Shop nicht MySQL Strict kompatibel und müssten entsprechend angepasst werden. Hier eine Liste mit Änderungen die bereits manuell ausgeführt wurden: ALTER TER TABLE orders change gm_packings_code gm_packings_code varchar(255) NOT NULL DEFAULT '' alter table products change gm_show_weight gm_show_weight int(1) NOT NULL DEFAULT 1; alter table products change products_image_w products_image_w int(11) NOT NULL DEFAULT 0; alter table products change products_image_h products_image_h int(11) NOT NULL DEFAULT 0; alter table products change properties_dropdown_mode properties_dropdown_mode varchar(30) NOT NULL DEFAULT ''; alter table products change properties_show_price properties_show_price varchar(10) NOT NULL DEFAULT ''; alter table products change use_properties_combis_weight use_properties_combis_weight tinyint(1) NOT NULL DEFAULT 0; alter table products change use_properties_combis_shipping_time use_properties_combis_shipping_time tinyint(1) NOT NULL DEFAULT 0; alter table products change use_properties_combis_quantity use_properties_combis_quantity tinyint(1) NOT NULL DEFAULT 0; alter table products change group_permission_4 group_permission_4 tinyint(1) NOT NULL DEFAULT 0; alter table products_item_codes change google_export_availability_id google_export_availability_id int(10) unsigned NOT NULL DEFAULT 0; alter table products_item_codes change brand_name brand_name varchar(128) NOT NULL DEFAULT ''; alter table products_item_codes change expiration_date expiration_date date NULL DEFAULT '0000-00-00 00:00:00'; alter table products change gm_show_image gm_show_image int(1) NOT NULL DEFAULT 1;