Jump to content
xt:Commerce Community Forum

SQL Fehler bei update 4.2.0 zu 5.0.08


cngp

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
  • Create New...