can anyone help me with this
Hey i am running erpnext in two sites in same ubuntu machine and i tried to host the two sites and i am able to succeed in that but while using after some time one of the site is going blank
any help or suggestions is appreciated
Im trying to install hrms app into my site called hrms.site, i have installed it before but due to verision issues i uninstalled it but when i try reinstalling the correct version im getting this error
App erpnext already installed
Installing hrms...
Updating DocTypes for hrms : [========================================] 100%
Setting up Frappe HR...
Installation for Frappe HR app failed due to an error. Please try re-installing the app or report the issue on https://github.com/frappe/hrms/issues/new if not resolved.
An error occurred while installing hrms: ('Role Profile', 'HR', IntegrityError(1062, "Duplicate entry 'HR' for key 'PRIMARY'"))
Traceback (most recent call last):
File "apps/frappe/frappe/model/base_document.py", line 517, in db_insert
frappe.db.sql(
File "apps/frappe/frappe/database/database.py", line 220, in sql
self._cursor.execute(query, values)
File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read
first_packet = self.connection._read_packet()
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "env/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "env/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.IntegrityError: (1062, "Duplicate entry 'HR' for key 'PRIMARY'")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "apps/frappe/frappe/commands/site.py", line 415, in install_app
_install_app(app, verbose=context.verbose, force=force)
File "apps/frappe/frappe/installer.py", line 307, in install_app
frappe.get_attr(after_install)()
File "apps/hrms/hrms/install.py", line 21, in after_install
raise e
File "apps/hrms/hrms/install.py", line 9, in after_install
setup()
File "apps/hrms/hrms/setup.py", line 22, in after_install
create_default_role_profiles()
File "apps/hrms/hrms/setup.py", line 712, in create_default_role_profiles
role_profile.insert(ignore_permissions=True)
File "apps/frappe/frappe/model/document.py", line 272, in insert
self.db_insert(ignore_if_duplicate=ignore_if_duplicate)
File "apps/frappe/frappe/model/base_document.py", line 544, in db_insert
raise frappe.DuplicateEntryError(self.doctype, self.name, e)
frappe.exceptions.DuplicateEntryError: ('Role Profile', 'HR', IntegrityError(1062, "Duplicate entry 'HR' for key 'PRIMARY'"))
Please help me resolve the issue
Bench version is :
erpnext 14.43.0
frappe 14.51.0
payments 0.0.1
I want hrms 14.13.0
bench get-app hrms --branch version-14
is there any mistake
do the following things:
- Turn on Developer Mode (if you are on a production server)
bench remove-app hrmsbench --site [your site] uninstall-app hrmsbench clear-cachebench clear-website-cachebench update --migratebench get-app --branch version-14 hrmsbench --site [your site] install-app hrms
If you have not setup the production mode of your setup, then your must keep the bench running in another terminal. Make sure that the bench is not stopped during the installation of hrms app or you will keep facing an error.
Moreover, you may refer to this video for step by step guidance of Installing ERPNext on Ubuntu Server:
For me installation worked when collation_server was updated in file /etc/mysql/mariadb.conf.d/50-server.cnf
I tried the steps in the video in another directory, even installed the packages again so that i dont miss out, but after installation of the bench if i start it to create new site its stoping immediately
bench start
11:34:36 system | redis_cache.1 started (pid=54810)
11:34:36 system | redis_queue.1 started (pid=54814)
11:34:36 system | web.1 started (pid=54818)
11:34:36 system | socketio.1 started (pid=54819)
11:34:36 system | watch.1 started (pid=54826)
11:34:36 system | schedule.1 started (pid=54827)
11:34:36 redis_queue.1 | 54817:C 10 Oct 2023 11:34:36.423 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
11:34:36 system | worker.1 started (pid=54832)
11:34:36 redis_cache.1 | 54813:C 10 Oct 2023 11:34:36.423 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
11:34:36 redis_queue.1 | 54817:C 10 Oct 2023 11:34:36.423 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
11:34:36 redis_cache.1 | 54813:C 10 Oct 2023 11:34:36.423 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
11:34:36 redis_queue.1 | 54817:C 10 Oct 2023 11:34:36.423 * Redis version=7.2.1, bits=64, commit=00000000, modified=0, pid=54817, just started
11:34:36 redis_cache.1 | 54813:C 10 Oct 2023 11:34:36.423 * Redis version=7.2.1, bits=64, commit=00000000, modified=0, pid=54813, just started
11:34:36 redis_queue.1 | 54817:C 10 Oct 2023 11:34:36.423 * Configuration loaded
11:34:36 redis_cache.1 | 54813:C 10 Oct 2023 11:34:36.423 * Configuration loaded
11:34:36 redis_queue.1 | 54817:M 10 Oct 2023 11:34:36.424 * Increased maximum number of open files to 10032 (it was originally set to 1024).
11:34:36 redis_queue.1 | 54817:M 10 Oct 2023 11:34:36.424 * monotonic clock: POSIX clock_gettime
11:34:36 redis_cache.1 | 54813:M 10 Oct 2023 11:34:36.424 * Increased maximum number of open files to 10032 (it was originally set to 1024).
11:34:36 redis_cache.1 | 54813:M 10 Oct 2023 11:34:36.424 * monotonic clock: POSIX clock_gettime
11:34:36 redis_queue.1 | 54817:M 10 Oct 2023 11:34:36.424 * Running mode=standalone, port=11000.
11:34:36 redis_queue.1 | 54817:M 10 Oct 2023 11:34:36.424 # Warning: Could not create server TCP listening socket 127.0.0.1:11000: bind: Address already in use
11:34:36 redis_queue.1 | 54817:M 10 Oct 2023 11:34:36.424 # Failed listening on port 11000 (tcp), aborting.
11:34:36 redis_cache.1 | 54813:M 10 Oct 2023 11:34:36.424 * Running mode=standalone, port=13000.
11:34:36 redis_cache.1 | 54813:M 10 Oct 2023 11:34:36.424 # Warning: Could not create server TCP listening socket 127.0.0.1:13000: bind: Address already in use
11:34:36 redis_cache.1 | 54813:M 10 Oct 2023 11:34:36.424 # Failed listening on port 13000 (tcp), aborting.
11:34:36 system | redis_queue.1 stopped (rc=1)
11:34:36 system | sending SIGTERM to redis_cache.1 (pid 54810)
11:34:36 system | sending SIGTERM to web.1 (pid 54818)
11:34:36 system | sending SIGTERM to socketio.1 (pid 54819)
11:34:36 system | sending SIGTERM to watch.1 (pid 54826)
11:34:36 system | sending SIGTERM to schedule.1 (pid 54827)
11:34:36 system | sending SIGTERM to worker.1 (pid 54832)
11:34:36 system | redis_cache.1 stopped (rc=1)
11:34:36 system | watch.1 stopped (rc=-15)
11:34:36 system | web.1 stopped (rc=-15)
11:34:36 system | schedule.1 stopped (rc=-15)
11:34:36 system | worker.1 stopped (rc=-15)
11:34:36 system | socketio.1 stopped (rc=-15)
any help from your side would be appreciated, Im not able to detect the error why is my bench suddenly stopping this way
Are you executing the commands from root user???
if so, them you need to do the following…
- Create a fresh Ubuntu Virtual Server
- Set your timezone correctly.
- Create a user named “frappe”
- Give this user the sudo privileges.
- login to server using this user
- execute all the commands one by one in same sequence as explained in the video.
- I am sure you won’t have any errors after following these steps…
Yes! I did that sir now its working fine, Thanks for the video helped me a lot
In such case, you should mark the support as a solution…
The original poster can do that.
And the original post was not a question to begin with.
In such cases the solution marking doesn’t work as a reward or end of thread system.
Maybe the solution for such threads could only be a change in the software, a change which obsoletes the questions and difficulties the original post (a guide) tries to be a solution for.
Assuring an accurate assesment in this sense would not be easy to do with some single click.
The latest major version of Frappe & ERPNext v15 is released and this guide continues to work with a few minor tweaks to the version numbers.
Here’s the v15 installation guide: [Guide] How to install ERPNext v15 on Linux Ubuntu (step-by-step instructions)
Looks like your development server is running just fine.
Try to access it at http://172.31.87.184:8000 or http://127.0.0.1:8000 (= http://localhost:8000)
Did you create a site yet? If so, try that name, like http://your-site-name:8000
This looks like you accessed your server, but you didn’t create a site yet.
You can confirm this if the log on the bench (or server) screen (like the one you showed further above) shows some entry when you access it (an error in this case). That means that the server is running, serves the error as it should, because you didn’t configure a site yet.
So I think you should continue from here:
https://frappeframework.com/docs/user/en/tutorial/create-a-site
and once you created a site, like for instance “my-frappe.localhost”, try to access it at this name, e.g. http://my-frappe.localhost:8000
There should be a login form with which you can access the frappe framework.
Once this works, you can install an app, depending on what you want installed on your site.
From what i can see, you installed a development environment in a cloud VPS. and i suspect that the port 8000 is not open in your vps. Check to see if that port is open and if not, open the port.
Yes better to switch to Version 15 because many installs fail on 14 as I also noticed.
I am using docker now because the scripting got over the top as over 250 posts on this thread show.
On Docker you can also integrate your custom apps or any other public available frappe apps:
Good luck. The start will not be easy and you really need to understand and read about what is going on.
Not necessarily. This script installs Versions 13, 14 or 15 successfully with very minimal interaction.
You can try it out.