GX-Bug #45627
Von Daniel Wu vor etwa 8 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;