GX-Bug #45627
Von Till Tepelmann vor etwa 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 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;