okay, it seems, it upgraded frappe, but not erpnext fully
Output
bench version
erpnext 11.1.48
frappe 12.0.0
fatal: not a git repository (or any of the parent directories): .gitPreformatted text
Thank you for your help… We have mixed it up with the previous dashboard app that we were exploring.
Run bench update again. Your ERPNext app should be on v12 for the modules to work.
Thank you kennethsequeira and @flexy2ky , both of you are correct. We had our ERPNext at v11.1.46. Problem is solved now
After bench update, it shows me that im already up to date
sudo bench update
[sudo] password for vaditajs:
INFO:bench.utils:updating bench
INFO:bench.utils:git pull
Already up to date.
master branch is renamed to version-11 and develop to version-12. Please switch to new branches to get future updates.
To switch to version 11, run the following commands: bench switch-to-branch version-11
How can I switch branch for erpnext to version-12?
sudo bench switch-to-branch version-12 erpnext
Branch version-12 does not exist in Upstream for erpnext
Switched to version-12
Please run `bench update --patch` to be safe from any differences in database schema
vaditajs@v65-6426-40:/home/erpnext/frappe-bench$ sudo bench update --patch
master branch is renamed to version-11 and develop to version-12. Please switch to new branches to get future updates.
To switch to version 11, run the following commands: bench switch-to-branch version-11
Try this:
Cant move erpnext to v12 but frappe. ?
root@ip-172-31-33-103:/home/frappe/frappe-bench# bench switch-to-branch version-12 --upgrade
Switching for frappe
INFO:bench.utils:git config --unset-all remote.upstream.fetch
INFO:bench.utils:git config --add remote.upstream.fetch ‘+refs/heads/:refs/remotes/upstream/’
INFO:bench.utils:git fetch upstream
INFO:bench.utils:git checkout version-12
Already on ‘version-12’
Your branch is up-to-date with ‘upstream/version-12’.
INFO:bench.utils:git merge upstream/version-12
Already up-to-date.
Branch version-12 does not exist in Upstream for erpnext
Successfully switched branches for:
frappe
Switched to version-12
Please run bench update --patch to be safe from any differences in database schema
root@ip-172-31-33-103:/home/frappe/frappe-bench#
Regards.
Mark.
@markgates Try also this
Thank you very much, its doing something finally!
It started to do it with following commands:
vaditajs@v65-6426-40:/home/erpnext/frappe-bench$ cd apps/erpnext/
vaditajs@v65-6426-40:/home/erpnext/frappe-bench/apps/erpnext$ sudo git config --unset-all remote.upstream.fetch
vaditajs@v65-6426-40:/home/erpnext/frappe-bench/apps/erpnext$ sudo git config --add remote.upstream.fetch ‘+refs/heads/:refs/remotes/upstream/’
vaditajs@v65-6426-40:/home/erpnext/frappe-bench/apps/erpnext$ sudo git fetch upstream
remote: Enumerating objects: 30410, done.
remote: Counting objects: 100% (23323/23323), done.
remote: Compressing objects: 100% (7146/7146), done.
remote: Total 20937 (delta 16911), reused 17538 (delta 13714), pack-reused 0
Receiving objects: 100% (20937/20937), 65.29 MiB | 12.70 MiB/s, done.
Resolving deltas: 100% (16911/16911), completed with 1101 local objects.
From GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)
- [new branch] develop → upstream/develop
- [new branch] v10.x.x → upstream/v10.x.x
- [new branch] v4.x.x → upstream/v4.x.x
- [new branch] v5.x.x → upstream/v5.x.x
- [new branch] v6.x.x → upstream/v6.x.x
- [new branch] v7.0.x → upstream/v7.0.x
- [new branch] v7.x.x → upstream/v7.x.x
- [new branch] v8.x.x → upstream/v8.x.x
- [new branch] v9.x.x → upstream/v9.x.x
- [new branch] version-11 → upstream/version-11
- [new branch] version-11-hotfix → upstream/version-11-hotfix
- [new branch] version-12 → upstream/version-12
- [new branch] version-12-hotfix → upstream/version-12-hotfix
- [new tag] v12.0.0 → v12.0.0
- [new tag] v6.27.28 → v6.27.28
- [new tag] v6.27.27 → v6.27.27
vaditajs@v65-6426-40:/home/erpnext/frappe-bench/apps/erpnext$ sudo git checkout version-12
Checking out files: 100% (1318/1318), done.
Branch ‘version-12’ set up to track remote branch ‘version-12’ from ‘upstream’.
Switched to a new branch ‘version-12’
vaditajs@v65-6426-40:/home/erpnext/frappe-bench/apps/erpnext$ cd …/…
vaditajs@v65-6426-40:/home/erpnext/frappe-bench$ sudo bench update
My bad, the * gets automatically deleted from the post if not in preformatted text. the command should be
git config remote.upstream.fetch "+refs/heads/*:refs/remotes/upstream/*"
I’ll update the original post as well.
Thank you everybody very much!!!
In Version 12 on section “Accounting Dimensions” first sentence is
You can now create you own configurable …
I believe it should be
You can now create your own configurable …
1 Like
Just a litlle bug, quotes in translations are displayed with HTML code
Exemple in french : label Facture d'achat
3 Likes
Please how did you get past this error?
pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)")
Full traceback:
Traceback (most recent call last):
File “/usr/lib/python3.6/runpy.py”, line 193, in _run_module_as_main
“main”, mod_spec)
File “/usr/lib/python3.6/runpy.py”, line 85, in _run_code
exec(code, run_globals)
File “/home/octo5/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 97, in
main()
File “/home/octo5/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 764, in call
return self.main(*args, **kwargs)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 555, in invoke
return callback(*args, **kwargs)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/octo5/frappe-bench/apps/frappe/frappe/commands/init.py”, line 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/octo5/frappe-bench/apps/frappe/frappe/commands/site.py”, line 250, in run_patch
frappe.modules.patch_handler.run_single(module, force=context.force)
File “/home/octo5/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 62, in run_single
if force or method or not executed(patchmodule):
File “/home/octo5/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 109, in executed
done = frappe.db.get_value(“Patch Log”, {“patch”: patchmodule})
File “/home/octo5/frappe-bench/apps/frappe/frappe/database/database.py”, line 400, in get_value
order_by, cache=cache)
File “/home/octo5/frappe-bench/apps/frappe/frappe/database/database.py”, line 444, in get_values
out = self._get_values_from_table(fields, filters, doctype, as_dict, debug, order_by, update)
File “/home/octo5/frappe-bench/apps/frappe/frappe/database/database.py”, line 591, in _get_values_from_table
as_dict=as_dict, debug=debug, update=update)
File “/home/octo5/frappe-bench/apps/frappe/frappe/database/database.py”, line 122, in sql
self.connect()
File “/home/octo5/frappe-bench/apps/frappe/frappe/database/database.py”, line 75, in connect
self._conn = self.get_connection()
File “/home/octo5/frappe-bench/apps/frappe/frappe/database/mariadb/database.py”, line 90, in get_connection
local_infile = frappe.conf.local_infile)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/pymysql/init.py”, line 94, in Connect
return Connection(*args, **kwargs)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py”, line 325, in init
self.connect()
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py”, line 599, in connect
self._request_authentication()
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py”, line 861, in _request_authentication
auth_packet = self._read_packet()
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/pymysql/connections.py”, line 684, in _read_packet
packet.check_error()
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/pymysql/protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, “Access denied for user ‘root’@‘localhost’ (using password: NO)”)
I have searched for and tried all possible solutions i found online but the error refuses to go away.
Hi,
I did not come across this error seems like there is a permission issue in SQL, in the past I have reinstalled MariaDB in some cases that worked in other severe scenarios had to revert to last erpnext back up on a fresh server
Hi,
when running bench switch-to-branch version-12 --upgrade and bench update --patch, I get the following error -
main()
File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
click.Group(commands=commands)(prog_name='bench')
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 764, in __call__
return self.main(*args, **kwargs)
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 717, in main
rv = self.invoke(ctx)
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/click/core.py", line 555, in invoke
return callback(*args, **kwargs)
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 233, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File "/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py", line 48, in migrate
frappe.modules.patch_handler.run_all()
File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 29, in run_all
if not run_single(patchmodule = patch):
File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in run_single
return execute_patch(patchmodule, method, methodargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 83, in execute_patch
frappe.get_attr(patchmodule.split()[0] + ".execute")()
File "/home/frappe/frappe-bench/apps/erpnext/erpnext/patches/v12_0/update_pricing_rule_fields.py", line 33, in execute
""".format(child_doctype= child_doctype))
File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 171, in sql
self._cursor.execute(query)
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1054, u"Unknown column 'pricing_rules' in 'field list'")
Does anyone know how I can get through it?
1 Like
Hi all!
Thank you for all your effort developers!
BUG:
IOS app emails list
you can’t delete emails
delete function does not work
Did it! Thanks!!!
I was able to overcome the permission challenge and ran the patch but i am still getting the error. I then abandoned my attempt at direct upgrade and setup a fresh instance. While migrating after a successful backup restore, The error came up again:
Executing erpnext.patches.v12_0.move_item_tax_to_item_tax_template in erp.oceanbaycommunity.com (_7ac0bf1eac7575cd)
Traceback (most recent call last):
File “/usr/lib/python3.6/runpy.py”, line 193, in _run_module_as_main
“main”, mod_spec)
File “/usr/lib/python3.6/runpy.py”, line 85, in _run_code
exec(code, run_globals)
File “/home/octo5/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 97, in
main()
File “/home/octo5/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 764, in call
return self.main(*args, **kwargs)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/core.py”, line 555, in invoke
return callback(*args, **kwargs)
File “/home/octo5/frappe-bench/env/lib/python3.6/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/octo5/frappe-bench/apps/frappe/frappe/commands/init.py”, line 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/octo5/frappe-bench/apps/frappe/frappe/commands/site.py”, line 233, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/octo5/frappe-bench/apps/frappe/frappe/migrate.py”, line 48, in migrate
frappe.modules.patch_handler.run_all()
File “/home/octo5/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 29, in run_all
if not run_single(patchmodule = patch):
File “/home/octo5/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 63, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/octo5/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 83, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/octo5/frappe-bench/apps/erpnext/erpnext/patches/v12_0/move_item_tax_to_item_tax_template.py”, line 44, in execute
item.save()
File “/home/octo5/frappe-bench/apps/frappe/frappe/model/document.py”, line 271, in save
return self.save(*args, **kwargs)
File “/home/octo5/frappe-bench/apps/frappe/frappe/model/document.py”, line 305, in save
self.validate_higher_perm_levels()
File “/home/octo5/frappe-bench/apps/frappe/frappe/model/document.py”, line 572, in validate_higher_perm_levels
high_permlevel_fields = frappe.get_meta(df.options).meta.get_high_permlevel_fields()
File “/home/octo5/frappe-bench/apps/frappe/frappe/init.py”, line 759, in get_meta
return frappe.model.meta.get_meta(doctype, cached=cached)
File “/home/octo5/frappe-bench/apps/frappe/frappe/model/meta.py”, line 37, in get_meta
meta = Meta(doctype)
File “/home/octo5/frappe-bench/apps/frappe/frappe/model/meta.py”, line 84, in init
super(Meta, self).init(“DocType”, doctype)
File “/home/octo5/frappe-bench/apps/frappe/frappe/model/document.py”, line 104, in init
self.load_from_db()
File “/home/octo5/frappe-bench/apps/frappe/frappe/model/meta.py”, line 89, in load_from_db
super(Meta, self).load_from_db()
File “/home/octo5/frappe-bench/apps/frappe/frappe/model/document.py”, line 147, in load_from_db
frappe.throw((“{0} {1} not found”).format((self.doctype), self.name), frappe.DoesNotExistError)
File “/home/octo5/frappe-bench/apps/frappe/frappe/init.py”, line 360, in throw
msgprint(msg, raise_exception=exc, title=title, indicator=‘red’)
File “/home/octo5/frappe-bench/apps/frappe/frappe/init.py”, line 346, in msgprint
_raise_exception()
File “/home/octo5/frappe-bench/apps/frappe/frappe/init.py”, line 315, in _raise_exception
raise raise_exception(msg)
frappe.exceptions.DoesNotExistError: DocType Item Manufacturer not found
I have run the patch several times without errors but keep getting this error when i try to migrate. Anything else i can do to fix this?
I ran this script which the user cliffalbert suggested which is
bench run-patch erpnext.patches.v12_0.make_item_manufacturer
then ran
bench update --patch
for after this I had an issue with the front end the CSS and JS had issues, for which I ran
bench update
which fixed those issues and so far v12 is running smoothly, although I am still digging around for bugs
No login box after upgrade to v12. Some advice?
1 Like