Ok, Sorry I am totally lost now.
You would need to contact the person who installed ERPNext for you.
Do you really need to upgrade if your ERPNext instance is working?
If so there are few options:
1: Install a fresh new development copy on your local machine which is available here.
Then manually enter in your changes.
2:
If I understand correctly, You have one copy located on a remotly hosted VM server that works perfectly. And you have another completely separate copy running on your local computer.
If this is correct then you could just try this on your local computer:
cd ~/frappe-bench/
bench update
After this completes
bench --help
and see if bench export-fixtures command is now available.
If not then
bench switch-to-master
bench --help
and see if bench export-fixtures command is now available.
Sorry I don’t think I can help any further.
Best Of Luck
@System19,thankz yeah…
ikhlas@ikhlas:~$ cd frappe-bench
ikhlas@ikhlas:~/frappe-bench$ bench --help
Usage: [OPTIONS] COMMAND [ARGS]…
Bench manager for Frappe
Options:
–help Show this message and exit.
Commands:
backup backup site
backup-all-sites backup all sites
config change bench configuration
download-translations Download latest translations
get-app clone an app from the internet and set it up…
init Create a new bench
new-app start a new app
new-site Create a new site in the bench
release Release app (internal to the Frappe team)
restart Restart supervisor processes
retry-upgrade
set-default-site Set default site for bench
set-mariadb-host Set MariaDB host for bench
set-nginx-port Set nginx port for site
set-ssl-certificate Set ssl certificate path for site
set-ssl-key Set ssl certificate private key path for site
set-url-root Set url root for site
setup Setup bench
shell
start Start Frappe development processes
switch-to-develop Switch frappe and erpnext to develop branch
switch-to-master Switch frappe and erpnext to master branch
switch-to-v4 Switch frappe and erpnext to v4 branch
switch-to-v5 Switch frappe and erpnext to v4 branch
update Update bench
Framework commands:
add-system-manager Add a new system manager to a site
backup Backup
build Minify + concatenate JS and CSS files, build…
build-docs Setup docs in target folder of target app
build-message-files Build message files for translation
build-website Sync statics and clear cache
bulk-rename Rename multiple records via CSV file
clear-cache Clear cache, doctype cache and defaults
clear-website-cache Clear website cache
console Start ipython console for a site
destroy-all-sessions Clear sessions of all users (logs them out)
disable-scheduler Disable scheduler
doctor Get diagnostic info about background workers
drop-site
dump-queue-status Dump detailed diagnostic infomation for task…
enable-scheduler Enable scheduler
execute execute a function
export-csv Dump DocType as csv
export-doc Export a single document to csv
export-fixtures export fixtures
export-json Export doclist as json to the given path, use…
get-untranslated Get untranslated strings for language
import-csv Import CSV using data import tool
import-doc Import (insert/update) doclist.
import-translations Update translated strings
install-app Install a new app to site
list-apps Reinstall site ie.
make-app
make-docs Setup docs in target folder of target app
migrate Run patches, sync schema and rebuild…
mysql Start Mariadb console for a site
new-language Create lang-code.csv for given app
new-site Install a new site
purge-jobs Purge any pending periodic tasks, if event…
reinstall Reinstall site ie.
reload-doc Reload schema for a DocType
remove-from-installed-apps
request Run a request as an admin
reset-perms Reset permissions for all doctypes
restore Restore site database from an sql file
run-patch Run a particular patch
run-tests Run tests
schedule
serve Start development web server
set-admin-password Set Administrator password for a site
set-config
show-pending-jobs Get diagnostic info about background workers
sync-docs Sync docs from /docs folder into the database…
sync-www Sync files from static pages from www…
trigger-scheduler-event Trigger a scheduler event
uninstall-app
update-translations Update translated strings
use
version
watch Watch and concatenate JS and CSS files as and…
worker
write-docs Setup docs in target folder of target app
ikhlas@ikhlas:~/frappe-bench$ bench export-fixtures
Exporting Web Form app erpnext filters None
Exporting Custom Field app mandrill_integration filters None
Exporting Custom Field app erpnext_shopify filters None
ikhlas@ikhlas:~/frappe-bench$ bench update
INFO:bench.utils:updating bench
Already up-to-date.
Requirement already satisfied (use --upgrade to upgrade): Pillow in ./env/lib/python2.7/site-packages
/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/util/ssl.py:315: SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause validation failures. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#snimissingwarning.
SNIMissingWarning
/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/util/ssl.py:120: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
InsecurePlatformWarning
INFO:bench.app:pulling frappe
From GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript
- branch develop → FETCH_HEAD
Already up-to-date.
INFO:bench.app:pulling erpnext
remote: Counting objects: 7, done.
remote: Compressing objects: 100% (1/1), done.
remote: Total 7 (delta 6), reused 7 (delta 6), pack-reused 0
Unpacking objects: 100% (7/7), done.
From GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)
- branch develop → FETCH_HEAD
Updating ed3c012…0fa7b7c
Fast-forward
…/stock/doctype/stock_entry/stock_entry_utils.py | 5 +++±
1 file changed, 4 insertions(+), 1 deletion(-)
INFO:bench.app:pulling schools
From GitHub - frappe/schools: Merged with frappe/erpnext - this repo is deprecated
- branch develop → FETCH_HEAD
Already up-to-date.
INFO:bench.app:pulling s3_backup
remote: Counting objects: 4, done.
remote: Total 4 (delta 3), reused 3 (delta 3), pack-reused 1
Unpacking objects: 100% (4/4), done.
From GitHub - ccfiel/s3_backup: Repo is transfer to our Bai Web and Mobile Labs. The new repo site https://github.com/bailabs/s3_backup
- branch master → FETCH_HEAD
Updating 8c8812a…2ef2c98
Fast-forward
s3_backup/hooks.py | 6 ++±–
1 file changed, 3 insertions(+), 3 deletions(-)
INFO:bench.app:pulling mandrill_integration
From GitHub - frappe/mandrill_integration: Set Communication status from Mandrill via webhooks
- branch master → FETCH_HEAD
Already up-to-date.
INFO:bench.app:pulling paypal_integration
From GitHub - frappe/paypal_integration: Paypal API Integrations
- branch master → FETCH_HEAD
Already up-to-date.
INFO:bench.app:pulling erpnext_shopify
From GitHub - frappe/erpnext_shopify: [Deprecated] Shopify connector for ERPNext
- branch master → FETCH_HEAD
Already up-to-date.
INFO:bench.app:pulling civil_contracting
From GitHub - revant/civil_contracting: Frappe App for use in Civil Contracting Business
- branch master → FETCH_HEAD
Already up-to-date.
/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/util/ssl.py:315: SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause validation failures. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#snimissingwarning.
SNIMissingWarning
/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/util/ssl.py:120: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
InsecurePlatformWarning
Requirement already up-to-date: pip in ./env/lib/python2.7/site-packages
/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/util/ssl.py:315: SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause validation failures. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#snimissingwarning.
SNIMissingWarning
/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/util/ssl.py:120: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
InsecurePlatformWarning
Migrating civil
Updating frappe : [========================================]
Updating civil_contracting : [========================================]
Migrating erp
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘doctype’, force=True) #2016-04-04 in erp (44ea05c927)
Success
Executing frappe.patches.v6_20x.set_allow_draft_for_print in erp (44ea05c927)
Success
Executing frappe.patches.v6_20x.remove_roles_from_website_user in erp (44ea05c927)
Success
Executing frappe.patches.v7_0.set_user_fullname in erp (44ea05c927)
Success
Executing frappe.patches.v7_0.desktop_icons_hidden_by_admin_as_blocked in erp (44ea05c927)
Success
Updating frappe : [========================================]
Migrating sunerp
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘doctype’, force=True) #2016-04-04 in sunerp (8f16163e62)
Success
Executing frappe.patches.v5_0.style_settings_to_website_theme in sunerp (8f16163e62)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, in _run_module_as_main
“main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/commands.py”, line 29, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/commands.py”, line 220, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/migrate.py”, line 27, in migrate
frappe.modules.patch_handler.run_all()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 25, in run_all
if not run_single(patchmodule = patch):
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 52, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 68, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/patches/v5_0/style_settings_to_website_theme.py”, line 10, in execute
migrate_style_settings()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/patches/v5_0/style_settings_to_website_theme.py”, line 28, in migrate_style_settings
website_theme.use_theme()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/website/doctype/website_theme/website_theme.py”, line 55, in use_theme
use_theme(self.name)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/website/doctype/website_theme/website_theme.py”, line 62, in use_theme
website_settings.save()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/model/document.py”, line 247, in save
self.run_before_save_methods()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/model/document.py”, line 639, in run_before_save_methods
self.run_method(“validate”)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/model/document.py”, line 600, in run_method
return Document.hook(fn)(self, *args, **kwargs)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/model/document.py”, line 764, in composer
return composed(self, method, *args, **kwargs)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/model/document.py”, line 747, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/model/document.py”, line 594, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/website/doctype/website_settings/website_settings.py”, line 17, in validate
self.validate_home_page()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/website/doctype/website_settings/website_settings.py”, line 22, in validate_home_page
if self.home_page and not resolve_route(self.home_page):
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/website/router.py”, line 46, in resolve_route
return get_generator_route(path)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/website/router.py”, line 57, in get_generator_route
generator_routes = get_generator_routes()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/website/router.py”, line 84, in get_generator_routes
{2}“”".format(route_column_name, doctype, condition), as_dict=True):
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/database.py”, line 147, in sql
self._cursor.execute(query)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, “Unknown column ‘page_name’ in ‘field list’”)
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 9, in
load_entry_point(‘bench==2.0.0’, ‘console_scripts’, ‘bench’)()
File “/home/ikhlas/bench-repo/bench/cli.py”, line 40, in cli
bench_command()
File “/usr/local/lib/python2.7/dist-packages/click-6.4-py2.7.egg/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/click-6.4-py2.7.egg/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/usr/local/lib/python2.7/dist-packages/click-6.4-py2.7.egg/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python2.7/dist-packages/click-6.4-py2.7.egg/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python2.7/dist-packages/click-6.4-py2.7.egg/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/home/ikhlas/bench-repo/bench/commands/update.py”, line 60, in update
_update(pull, patch, build, bench, auto, restart_supervisor, requirements, no_backup, upgrade, force=force)
File “/home/ikhlas/bench-repo/bench/commands/update.py”, line 90, in _update
patch_sites(bench=bench_path)
File “/home/ikhlas/bench-repo/bench/utils.py”, line 131, in patch_sites
run_frappe_cmd(‘–site’, ‘all’, ‘migrate’, bench=bench)
File “/home/ikhlas/bench-repo/bench/utils.py”, line 454, in run_frappe_cmd
raise CommandFailedError(args)
bench.utils.CommandFailedError: (‘–site’, ‘all’, ‘migrate’)
ikhlas@ikhlas:~/frappe-bench$
bench update error…If u hav any soln for it…
Looks all good to me. Ignore the last error message.
To see if frappe is running. enter
bench doctor
This will show the services that are currently running. Then enter ctrl C to escape back to what-ever/frappe-bench/ and then enter
sudo service nginx reload
sudo supervisorctl reload
If bench is not already running then enter
bench start
bench should start up
open a new terminal window and navigate to what-ever/frappe-bench/ and enter
bench update
Well done. It looks like you got it to update successfully.
ikhlas@ikhlas:~/frappe-bench$ bench doctor
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, in _run_module_as_main
“main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/ikhlas/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/commands.py”, line 852, in doctor
return _doctor(site=site)
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/utils/doctor.py”, line 96, in doctor
workers_online = check_number_of_workers()
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/utils/doctor.py”, line 85, in check_number_of_workers
return len(get_workers())
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/utils/doctor.py”, line 10, in get_workers
with Connection(get_redis_conn()):
File “/home/ikhlas/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 136, in get_redis_conn
raise Exception(‘You need to call frappe.init’)
Exception: You need to call frappe.init
ikhlas@ikhlas:~/frappe-bench$