cngp Posted January 16, 2019 Report Share Posted January 16, 2019 Hallo, Ich bekomme folgende Fehlermeldung: [ERROR] Executing query: UPDATE `xt_feed` SET feed_date_from_orders = NULL WHERE `feed_date_from_orders` < '1000-01-01 00:00:00';Failed to execute Executing query: UPDATE `xt_feed` SET feed_date_from_orders = NULL WHERE `feed_date_from_orders` < '1000-01-01 00:00:00';Failed to execute Executing query: UPDATE `xt_feed` SET feed_date_from_orders = NULL WHERE `feed_date_from_orders` < '1000-01-01 00:00:00'; Die relevante Query in der update.sql lautet: UPDATE `##_feed` SET feed_date_from_orders = NULL WHERE `feed_date_from_orders` < '1000-01-01 00:00:00'; ALTER TABLE `##_feed` CHANGE COLUMN `feed_date_from_orders` `feed_date_from_orders` datetime NULL DEFAULT NULL, CHANGE COLUMN `feed_date_to_orders` `feed_date_to_orders` datetime NULL DEFAULT NULL; Wenn ich diese separat ausführe erhalte ich folgende Fehlermeldung: #1048 - Feld 'feed_date_from_orders' darf nicht NULL sein Woran könnte das liegen? LG cngp Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.