GX-Bug #45627
Von Till Tepelmann vor fast 9 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 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;
alter TABLE `customers` change customers_last_modified customers_last_modified datetime NOT NULL DEFAULT '1000-01-01 00:00:00';
alter TABLE `customers` change customers_dob customers_dob datetime NOT NULL DEFAULT '1000-01-01 00:00:00';
alter TABLE `customers` change customers_date_added customers_date_added datetime NOT NULL DEFAULT '1000-01-01 00:00:00';
alter table `customers_info` change customers_info_date_of_last_logon customers_info_date_of_last_logon datetime DEFAULT '1000-01-01 00:00:00';
alter table `customers_info` change customers_info_date_account_created customers_info_date_account_created datetime DEFAULT '1000-01-01 00:00:00';
alter table `customers_info` change customers_info_date_account_last_modified customers_info_date_account_last_modified datetime DEFAULT '1000-01-01 00:00:00';
alter table orders change gm_order_txt gm_order_txt mediumtext;
alter table orders change shipping_method shipping_method text;