1054, u"Unknown column 'tabEvent.status' in 'where clause

iteerstech · July 31, 2019, 4:13pm

Hi Folks,

I have upgraded my erpnext version-11 to version-12 and am getting this error on signing in.

Kindly assist

Regards

trentmu · July 31, 2019, 4:54pm

Try a bench migrate to sync the DB schemas

iteerstech · August 1, 2019, 3:04am

Hi Trentmu,

THanks for your response. I have tried bench migrate and attached is the error that I got
My server has an Internal Server Error Message Now.

trentmu · August 1, 2019, 7:08am

It is a permissions error. What user are you running the commands as?

iteerstech · August 1, 2019, 7:13am

Root…

iteerstech · August 1, 2019, 8:18am

Have also tried with frappe user and still the same problem.

trentmu · August 1, 2019, 8:30am

OK - generally, you should not run updates etc as root user, but the problem is not just that it seems.
You can try commenting out the particular patch that is failing and running the update again

trentmu · August 1, 2019, 4:54pm

Looks like one of your updates was run as user root, which then changed the ownership of the updated files to user=root. Subsequent updates then fail because of permissions. The fix is relatively simple… log in as the frappe user

cd ~/frappe-bench
sudo chown -R frappe:frappe ./
bench --site all migrate
bench update --reset

iteerstech · August 1, 2019, 5:09pm

Thank alot for your support.Everything is back again.