Bench Update error - pymysql.err.InternalError: (1292, u"Incorrect datetime value: '24.10.2018'")

ERPNext
21

` did the trick. I could now see it. Will dig in and see if i can find any issue. Thanks a lot mate.

22

I checked all the datetime values Sales invoice item and Sales Invoice but couldn’t find any null values. Took 2 days to check the data.

Nevertheless i got fed up with it and used the following commands to change the time stamp using the codes

SET sql_mode = '';
SET GLOBAL sql_mode = '';

I was then able to proceed and everything went smooth to be updated to V 13.16.0

1 Like
23

You da man!

Congratulations! Your technical journey to understand the innards of ERPNext is off to a rocking start.

Thanks

Jay

24

Yeah it has been good one to say. Thanks to guys like you who help the Erpnext community and makes it easier for us.