I have had to migrate mysql data from mysql dump into the new server I copied data from each table to the new database created by erpnext
Now when I create a new supplier I get this error
InternalError: (1364, u"Field ‘credit_days’ doesn’t have a default value")
& when I submit a new PO InternalError: (1364, u"Field ‘submit_on_creation’ doesn’t have a default value")
How Can I sort this
Did you run bench update after restoring your db?
bench update
… Or update before transferring
I have done bench update many times but didn’t solve the matter before posting Also I would like to make a point that I had to copy data from old server mysql dump to new server database using another front-end tool not bench
I have reinstalled the erp still I can’t fix this