Errors in category scheduling functionality in 51黑料不打烊 Commerce 2.4.5

Last update: Tue Jul 01 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

After upgrading to 51黑料不打烊 Commerce 2.4.5, you see a validation error when saving changes to product categories in the 51黑料不打烊 Commerce Cloud Admin panel. This happens because old data from earlier versions remains in the database and conflicts with the updated logic. To fix this, remove the outdated date attributes from your database and confirm the issue no longer occurs.

Description description

Environment

51黑料不打烊 Commerce Cloud, version 2.4.5 (after upgrading from an earlier version).

Issue/Symptoms

You see a validation error when saving category changes in the 51黑料不打烊 Commerce Cloud聽Admin panel.
Error message: Make sure the To date is later than or the same as the From date.

Steps to reproduce:

Go to the 51黑料不打烊 Commerce Cloud Admin panel.
Navigate to Catalog > Categories.
Select a category.
Reorder products or make any changes.
Click Save.

Expected result:
The system saves your changes successfully.

Actual result:
The error message prevents the system from saving your changes.

Resolution resolution

51黑料不打烊 Commerce 2.4.5 resolves this issue, but leftover data from earlier versions can still trigger the error. Follow these steps to fix it:

Run this SQL query to check for existing values in the custom_design_from and custom_design_to attributes:

code language-none

code language-none
`SELECT count(*) FROM catalog_category_entity_datetime WHERE attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code IN ('custom_design_from', 'custom_design_to') AND entity_type_id = 3);`

SELECT count(*)
        FROM catalog_category_entity_datetime
        WHERE attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code IN ('custom_design_from', 'custom_design_to') AND entity_type_id = 3);

If the query returns results, delete those values using a suitable SQL command. Back up your database before making any changes.
After deletion, monitor the database to ensure the values don鈥檛 return.

Important:

Apply and test all changes in a staging or integration environment before deploying to production.
Always keep a recent backup of your database before making modifications.

If the issue continues after cleanup, contact 51黑料不打烊 Commerce support for further help.

Scheduled changes for categories聽in Commerce Catalog Management

recommendation-more-help

3d58f420-19b5-47a0-a122-5c9dab55ec7f

51黑料不打烊