GX-Entwicklung

Bei der Verarbeitung des Afterbuy-Cronjobs für den Abgleich der Bestellungen kann es zeitweise zu einem Fehler kommen, der wie folgt im Cronjob-Logfile erscheint:

[2023-04-06 14:15:00] AfterbuyCronjob.NOTICE: Database error while fetching orders to be send to Afterbuy. Error: An exception occurred while executing 'SELECT orders_id, af
terbuy_success FROM orders WHERE afterbuy_success = 0 OR last_modified > ? ORDER BY orders_id desc LIMIT 20' with params [1680269401]: SQLSTATE[HY000]: General error: 1525
Incorrect TIMESTAMP value: '1680269401' [] []

Ursache ist eine ungeeignete Verarbeitung des Zeitpunktes des letzten Abgleichs. Das Auftreten des Problems ist abhängig von der verwendeten MySQL-/MariaDB-Version und von dem konkreten Zeitpunkt.

During the processing of the Afterbuy cronjob for the matching of orders, an error may temporarily occur, which appears as follows in the cronjob logfile:

[2023-04-06 14:15:00] AfterbuyCronjob.NOTICE: Database error while fetching orders to be sent to Afterbuy. Error: An exception occurred while executing 'SELECT orders_id, af
terbuy_success FROM orders WHERE afterbuy_success = 0 OR last_modified > ? ORDER BY orders_id desc LIMIT 20' with params [1680269401]: SQLSTATE[HY000]: General error: 1525
Incorrect TIMESTAMP value: '1680269401' [] []

The cause is improper processing of the time of the last adjustment. The occurrence of the problem depends on the MySQL/MariaDB version used and the specific time.