Error while making bench migrate

Worked like a charm for me. Although I could not pinpoint the offending column, so I had to use this little morsel of wisdom:

SELECT DISTINCT TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('is_custom')
AND TABLE_SCHEMA='YourDatabase';

I then ranch bench update, and it ran OK, but had trouble with this:

INFO:bench.utils:sudo supervisorctl restart frappe:
unix:///var/run/supervisor.sock no such file

Which I solved with this:

sudo service supervisor restart

Followed by this:
bench restart

FYI I was updating from 7.0.25 to v10!
Worked flawlessly!

1 Like