Bench Update/Migrate error in_global_search

ERPNext
1

Hi,

We tried to restore the data on a production environment from a previous backup. After doing the restore, when the bench migrate was run, we were getting this issue:

mysql exceptions operational error(1048, column in_global_search cannot be null)

I referred to the previous posts on the discussion forum which talks about issuing a command of

Alter Table tabDocType drop column in_global_search…

but when the command is run, it says that this column doesn’t exist. What could be the issue? Any ideas?

Regards
Uma

2

@UmaG,

In Global Search field was recently added in doctype. You should try to run the bench update command.

Thanks, Makarand

3

Even the bench update command is getting stuck up and giving this same error.

Regards
Uma

4

Have you tried with the “–migrate” option?

5

what is the command with --migrate? We ran

bench --site sitename migrate

or just

bench migrate

6

bench update --migrate

Sorry :slight_smile:

7

Thanks for the response but there is no such command for bench update --migrate. :frowning:

Looks like the bench version and the database version are in a mismatch. Is there a way to go back to the previous version?

Regards
Uma

8

I know that, We download previous version like :https://github.com/frappe/erpnext/archive/v7.2.19.tar.gz
But I don’t know how to install it.