1292:Incorrect date value when trying to add a special with expiry date

[Doomm]

Hi, guys,

not a question of life and death here, but it seems interesting to me:

when trying to add a new special with an expiry date, I recieve this error log:

Request URI: /admin/specials.php?page=1&action=update
#1 trigger_error() called at [/home/site/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/site/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/site/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/site/public_html/admin/specials.php:103]
--> PHP Fatal error: 1292:Incorrect date value: '20292301' for column 'expires_date' at row 1 :: UPDATE specials
SET specials_new_products_price = '13.0833',
specials_last_modified = now(),
expires_date = '20292301',
specials_date_available = '0001-01-01'
WHERE specials_id = 263 ==> (as called by) /home/site/public_html/zoe/specials.php on line 103 <== in /home/site/public_html/includes/classes/db/mysql/query_factory.php on line 171.

file specials.php is unchanged (1.5.6c)
table specials seems to be unchanged too...

I can easily run on specials without expiry date, but does anybody know, what is triggering this problem?

[swguy]

what value are you putting in the expiry date field when you create the special?

[Doomm]

Tried multiple dates - mainly 2026 to 2028. Not happening all the time, though

[swguy]

What is the *exact value* that goes into the expiry date field? You should be entering MM/DD/YYYY assuming you have made no other changes.
So for Dec. 31, 2026, enter 12/31/2026.

[Doomm]

So, for example, I use a value like this: 01.11.2029

I don´t add these dates manually - they are added by the table on the right side of the row