Skip to Content
Menu
This question has been flagged

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,

Avatar
Discard

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/

Author Best Answer

I fixed my issue.

OpenUpgrade was forced in Branch 17.0 instead of Branch 16.0.

BR

Avatar
Discard
Related Posts Replies Views Activity
1
May 25
647
0
Mar 25
638
5
Jul 25
276
0
Jul 25
1363
2
Nov 24
6079