Executing frappe.patches.v12_0.move_timeline_links_to_dynamic_links in site1.local
1064, u’You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'THE UMMED"", “2017-07-29 18:56:16.963489”, “2017-07-29 19:43:00.007752”, "Admini' at line 4’)
Do you have any custom apps/modules installed?
If not, you can just comment out the particular patch (frappe.patches.v12_0.move_timeline_links_to_dynamic_links) and run the update/migrate again. The file is normally approximately here…
apps/frappe/frappe/patches.txt
yes i do have a custom app installed .
If you uninstall the custom app, do the update+migrate, and then reinstall the custom app, it usually helps
Hi,
I too have an error as below
HEY! USE SCREEN root@SERP-FEDRN:/home/frappe/frappe-bench# bench update --reset
INFO:bench.utils:updating bench
INFO:bench.utils:git pull
Already up to date.
INFO:bench.utils:./env/bin/pip install Pillow
Requirement already satisfied: Pillow in ./env/lib/python3.6/site-packages (6.1.0)
Backing up sites…
INFO:bench.app:pulling frappe
INFO:bench.utils:git fetch --all
Fetching upstream
INFO:bench.utils:git reset --hard upstream/version-12
HEAD is now at 175818675 Merge branch ‘develop’ into version-12
INFO:bench.utils:find . -name “.pyc" -delete
INFO:bench.app:pulling erpnext
INFO:bench.utils:git fetch --all
Fetching upstream
INFO:bench.utils:git reset --hard upstream/version-12
HEAD is now at 7ff82fccf3 Merge branch ‘develop’ into version-12
INFO:bench.utils:find . -name ".pyc” -delete
INFO:bench.app:pulling fpo_mgmt
INFO:bench.utils:git fetch --all
Fetching upstream
INFO:bench.utils:git reset --hard upstream/master
HEAD is now at 29a0b15 update on production details
INFO:bench.utils:find . -name “*.pyc” -delete
Updating Python libraries…
INFO:bench.utils:./env/bin/pip install --upgrade pip
Requirement already up-to-date: pip in ./env/lib/python3.6/site-packages (19.2.3)
INFO:bench.utils:./env/bin/pip install -q -r /home/frappe/.bench/requirements.txt
INFO:bench.app:installing frappe
INFO:bench.utils:./env/bin/pip install -q -e ./apps/frappe
INFO:bench.app:installing erpnext
INFO:bench.utils:./env/bin/pip install -q -e ./apps/erpnext
INFO:bench.app:installing fpo_mgmt
INFO:bench.utils:./env/bin/pip install -q -e ./apps/fpo_mgmt
Updating node packages…
INFO:bench.utils:yarn install
yarn install v1.17.3
[1/4] Resolving packages…
success Already up-to-date.
Done in 0.40s.
INFO:bench.utils:yarn install
yarn install v1.17.3
[1/4] Resolving packages…
[2/4] Fetching packages…
[3/4] Linking dependencies…
warning " > bootstrap@4.3.1" has unmet peer dependency “jquery@1.9.1 - 3”.
warning " > bootstrap@4.3.1" has unmet peer dependency “popper.js@^1.14.7”.
error An unexpected error occurred: “EACCES: permission denied, unlink ‘/home/frappe/frappe-bench/apps/frappe/node_modules/.bin/JsBarcode.js’”.
info If you think this is a bug, please open a bug report with the information provided in “/home/frappe/frappe-bench/apps/frappe/yarn-error.log”.
info Visit yarn install | Yarn for documentation about this command.
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 11, in
load_entry_point(‘bench’, ‘console_scripts’, ‘bench’)()
File “/home/frappe/.bench/bench/cli.py”, line 40, in cli
bench_command()
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 764, in call
return self.main(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 555, in invoke
return callback(*args, **kwargs)
File “/home/frappe/.bench/bench/commands/update.py”, line 61, in update
_update(pull, patch, build, bench, auto, restart_supervisor, restart_systemd, requirements, no_backup, force=force, reset=reset)
File “/home/frappe/.bench/bench/commands/update.py”, line 85, in _update
update_node_packages(bench_path=bench_path)
File “/home/frappe/.bench/bench/utils.py”, line 454, in update_node_packages
update_yarn_packages(bench_path)
File “/home/frappe/.bench/bench/utils.py”, line 467, in update_yarn_packages
exec_cmd(‘yarn install’, cwd=app_path)
File “/home/frappe/.bench/bench/utils.py”, line 161, in exec_cmd
raise CommandFailedError(cmd)
bench.utils.CommandFailedError: yarn install
HEY! USE SCREEN root@SERP-FEDRN:/home/frappe/frappe-bench#
I have a custom app, but the same app is in another instance also which has been updated without errors
seems directory permissions issue
Looks like you’re running commands as root - not advised. Rather login as user frappe
su -l frappe
cd ~/frappe-bench
#COMMANDS
Thank you… this worked…