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
Anyone able to get past this point? Encountered the same glitch?
I got similar response when I try to run bench update
frappe@instance-1:~/frappe-bench$ bench update
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
frappe@instance-1:~/frappe-bench$
then
frappe@instance-1:~/frappe-bench$ bench switch-to-branch version-11
Username for 'https://github.com': sanath2020
Password for 'https://sanath2020@github.com':
Branch version-11 does not exist in Upstream for sanath_so
Branch version-11 does not exist in Upstream for bench_manager
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-11
Already on 'version-11'
Your branch is up-to-date with 'upstream/version-11'.
INFO:bench.utils:git merge upstream/version-11
Already up-to-date.
Password for 'https://sanath1978@bitbucket.org':
remote: Counting objects: 7, done.
remote: Compressing objects: 100% (7/7), done.
remote: Total 7 (delta 6), reused 0 (delta 0)
Unpacking objects: 100% (7/7), done.
From https://bitbucket.org/sanath1978/hire_purchase
3b5424c..68b39e3 master -> upstream/master
Branch version-11 does not exist in Upstream for hire_purchase
Branch version-11 does not exist in Upstream for erpnext
Successfully switched branches for:
frappe
Switched to version-11
Please run `bench update --patch` to be safe from any differences in database schema
frappe@instance-1:~/frappe-bench$
I need to get updates from my custom apps, but not success.
