ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Erpnext v11 installation error


#1

Hello,

I’m using erpnext easy install method to install it on ubuntu 16.04.

After I run (python install.py --production --user frappe) command I’m getting the below error.

Can anyone help me?

Thanks & Regards,
Sujay


#2

installation is successfull with erpnext & frappe framework with version 12.

Itried to switch to master branch and on using command bench update --patch I’m getting the below error.


#3

You are running the commands as user root - this is not advised. Rather use user frappe, and add a sudo where necessary.


#4

i have used bench update --patch command as non root user and i’m getting this error.


#5

Similar problem here…
you are running commands as user ubuntu…but on files that are owned by user frappe.
login and run commands as user frappe, and the permissions problems will probably go away


#6

Do I need to login as user frappe after login as ubuntu?


#7

How did you overcome this ?


#8

I’m still getting same errors.


#9

didn’t find any solution


#10

When you login as ubuntu or as root, Try

su - frappe
Or
sudo su - frappe


#11

use below command

sudo bench update --patch

or

Login as frappe/root user


#12

It is saying you should not run as this command as root


#13

Asking for a password, when I tried login as frappe user


#14

It is saying you should not run as this command as root


#15

then run below command

sudo bench update --patch


#16

File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 97, in
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/python3.5/site-packages/click/core.py”, line 764, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/lib/python3.5/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/python3.5/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/python3.5/site-packages/click/core.py”, line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py”, line 555, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python3.5/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 227, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 38, 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 81, in execute_patch
exec(patchmodule.split(“execute:”)[1],globals())
File “”, line 1, in
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 210, in sql
self._cursor.execute(query)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 170, in execute
result = self._query(query)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 328, in _query
conn.query(q)
File “/home/frappe/frappe-bench/env/lib/python3.5/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/python3.5/site-packages/pymysql/connections.py”, line 732, in _read_query_result
result.read()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 1075, in read
first_packet = self.connection._read_packet()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 684, in _read_packet
packet.check_error()
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1054, “Unknown column ‘comment’ in ‘field list’”)
ubuntu@ubuntu:/home/frappe/frappe-bench$ ^C
ubuntu@ubuntu:/home/frappe/frappe-bench$

I got this error after using that command


#17

#18

@Sujay

Please login as frappe user or by using su frappe from ubuntu user. Then cd to frappe-bench folder and run bench update again. Please post the output from the beginning i.e from bench update command.


#19

You can set the frappe password with:
sudo passwd frappe

Then you can switch to the frappe user with
su frappe
(It will ask for the password you created.)

Then you can run bench update (from the frappe-bench folder) using
bench update