I have a backup file from a V6 instance that I’d like to restore and subsequently update to the current version
Any ideas on how to achieve this would be greatly appreciated
Rsstore backup database to current instance then run bench migrate
Trust you’re doing well. Do you mean I can restore a V6 backup file on a V10 instance directly?
Yes…after restore run bench migrate
Ran into the error below after running bench migrate
pymysql.err.InternalError: (1054, u"Unknown column 'submit_on_creation' in 'field list'")
How best to proceed?
Any help here please?
Okay, so I found out one way to get past this is by directly creating a column in the database
ALTER TABLE tabDocType ADD COLUMN submit_on_creation VARCHAR(40)
Is this recommended or is there another (better) way?
@noetico recently migrated from v6 to v9. It wasn’t the most straight forward but he did it.
Thanks a lot for the response. The approach to overcome this issue is exactly what was done here
@noetico could you please confirm if there were any side effects of directly creating the columns in the database?
Hello @wale I had no side effects doing this. It was the only way as a matter of fact.
Do bench migrate, fix these columns (you’ll find 1 or 2 more), after each fix, run bench migrate.
Many thanks for the feedback. Will proceed accordingly
Trust you’re doing great. I tried this approach but it doesn’t seem to have made much difference. The error message is still the same. When I try creating the column again, I get a duplicate error ERROR 1060 (42S21): Duplicate column name 'submit_on_creation'
ERROR 1060 (42S21): Duplicate column name 'submit_on_creation'
Did you getting above error on bench migrate command? Can you share complete traceback of an error?