can you check the following:
cd /home/frappe/frappe-bench/apps/erpnext
git log
Can you paste the output of the git log command?
and also do git status just to make sure there are no unexpected changes
not sure, i am using the virtual image for this with virtual box, so whatever was pre-loaded on that image, i haven’t done any custom changes apart from the updates that you release…
@ermalc I think I got the problem. Your ERPNext app is in master branch while your frappe app is in develop branch. The develop branch is the ongoing branch for version 7. So the framework is new and your erpnext app is old and hence the mess. The VM was misconfigured from our end from the start. But you didn’t face any problem till now because the gap between master and develop was negligible before this month.
The way ahead for you is to move to develop branch. This should fix your problems:
cd /home/frappe/bench-repo
git checkout develop
git fetch origin develop
git reset --hard origin/develop
cd /home/frappe/frappe-bench
bench switch-to-develop
bench update
bench setup redis
bench setup supervisor
sudo supervisorctl reread
sudo supervisorctl update
What is the migration error above that trace? When upgrading and an error occurs in migrate you get back two traces.
i get the same errors as @applepipe has described or shown on here, when trying to follow your steps…
also, if i go to the end and do all your steps, and try to access the system via the web interface, i get the below errors
Traceback (most recent call last): File "/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py", line 25, in render data = render_page_by_language(path) File "/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py", line 91, in render_page_by_language return render_page(path) File "/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py", line 107, in render_page return build(path) File "/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py", line 114, in build return build_page(path) File "/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py", line 127, in build_page context = get_context(path) File "/home/frappe/frappe-bench/apps/frappe/frappe/website/context.py", line 16, in get_context context = build_context(context) File "/home/frappe/frappe-bench/apps/frappe/frappe/website/context.py", line 64, in build_context ret = module.get_context(context) File "/home/frappe/frappe-bench/apps/frappe/frappe/templates/pages/desk.py", line 21, in get_context boot = frappe.sessions.get() File "/home/frappe/frappe-bench/apps/frappe/frappe/sessions.py", line 107, in get bootinfo["notification_info"] = get_notification_info_for_boot() File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/notifications.py", line 133, in get_notification_info_for_boot out = get_notifications() File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/notifications.py", line 26, in get_notifications "open_count_doctype": get_notifications_for_doctypes(config, notification_count), File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/notifications.py", line 92, in get_notifications_for_doctypes filters=condition, limit_page_length = 21, as_list=True)) File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1016, in get_list return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 72, in execute result = self.build_and_run() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 92, in build_and_run return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug) File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 147, in sql self._cursor.execute(query) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1054, "Unknown column 'tabSupplier.status' in 'where clause'")
That screenshot didnt have the full traceback. Can you share the full output of the bench update step.
I am facing the issue of not being able to see the Developer and Setup module (but able to access it from the awesome bar) after changing the frappe branch from develop to master. Now, looks like you have recommended us to move to develop branch for both erpnext and frappe. Is it soon going to be merged? Else I can see that we will face more of such issues.
1 Like
Hi @anand
Sorry to pester you with this , but we need a solution for this. As it stands the system is unusable and we are stuck with these errors and no working solution so far…
I would appreciate it if you could please find a fix for this or suggest an alternative solution…
Many Thanks
Here is the full output:
So apparently it was the locale setting, but I did what was discussed in the topic Bench update throwing an error - #5 by sunilsrikumar
The result is still an error, but a different one now:
I updated again the VM that was still in master branch, same locale error, fixed this issue and the update ran perfectly. Opened the browser with hope that everything was fixed, “ImportError: No module named buying”.
on top of all of the above issues, my one now comes up with INTERNAL SERVER ERROR , so can’t even access the web interface at all…
see attached print screen after update
Please send me full trace and not just print screen of part of the trace.
i would happily send you the whole log if i knew how to copy this from the virtual box window or how to export it…
if you know a way , please share
I already read this topic, I even posted the link… Now I’m having another issue, also in the same post.