Dear All,
Trying to migrate from Odoo 15.0 to 16.0 CE.
I still have this error message and can't find if openupgrade module needs to be fixed or I missed something.
Logs eroor : psycopg2.errors.InvalidDatetimeFormat: invalid input syntax for type timestamp: ""
2025-03-04T22:43:56.120755+01:00 odoo16 Odoo Server 16.0:myodoo.com:ERROR:odoo.modules.registry:Failed to load registry#012Traceback (most recent call last):#12 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^#012psycopg2.errors.InvalidDatetimeFormat: invalid input syntax for type timestamp: ""
2025-03-04T22:43:56.122995+01:00 odoo16 Odoo Server 16.0:myodoo.com:INFO:odoo.service.server:Stopping gracefully
Thanks if you could help me
Best Regards,
The error message "invalid input syntax for type timestamp: """ indicates that Odoo 16 is encountering empty or invalid date/time strings during migration. This suggests an Odoo 15 database issue. Check your database tables for date/time fields. Search for empty or incorrect date/time values. Clean or fix these entries before upgrading. Consider querying and updating affected records with a database tool. Double-check any custom modules or data import processes that may have caused this issue. https://googledoodlebaseball.io/