bench new-site erp.local
command showing below error.
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘is_calendar_and_gantt’ in ‘INSERT INTO’”)
Please do share the entire output you got.
bench new-site erp.local
MySQL root password:
Installing frappe…
Traceback (most recent call last):
File “”, line 198, in _run_module_as_main
File “”, line 88, in _run_code
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 114, in
main**()**
\~\~\~\~**^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 20, in main
click.Group(commands=commands)**(prog_name="bench")**
\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^^^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/click/core.py”, line 1442, in _call_
return self.main**(\*args, \*\*kwargs)**
\~\~\~\~\~\~\~\~\~**^^^^^^^^^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/click/core.py”, line 1363, in main
rv = self.invoke(ctx)
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/click/core.py”, line 1830, in invoke
return \_process_result(sub_ctx.command.invoke**(sub_ctx)**)
\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/click/core.py”, line 1830, in invoke
return \_process_result(sub_ctx.command.invoke**(sub_ctx)**)
\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/click/core.py”, line 1226, in invoke
return ctx.invoke**(self.callback, \*\*ctx.params)**
\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^^^^^^^^^^^^^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/click/core.py”, line 794, in invoke
return callback(\*args, \*\*kwargs)
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/commands/site.py”, line 105, in new_site
\_new_site**(**
\~\~\~\~\~\~\~\~\~**^**
**db_name,**
**^^^^^^^^**
...<14 lines>...
**mariadb_user_host_login_scope=mariadb_user_host_login_scope,**
**^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^**
**)**
**^**
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/installer.py”, line 117, in _new_site
install_app**(app, verbose=verbose, set_as_patched=not source_sql, force=False)**
\~\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/installer.py”, line 306, in install_app
out = frappe.get_attr(before_install)()
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/utils/install.py”, line 11, in before_install
frappe.reload_doc**("core", "doctype", "doctype_state")**
\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/_init_.py”, line 1417, in reload_doc
return frappe.modules.reload_doc**(module, dt, dn, force=force, reset_permissions=reset_permissions)**
\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/modules/utils.py”, line 217, in reload_doc
return import_files(module, dt, dn, force=force, reset_permissions=reset_permissions)
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 57, in import_files
return import_file(
module, dt, dn, force=force, pre_process=pre_process, reset_permissions=reset_permissions
)
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 65, in import_file
return import_file_by_path(path, force, pre_process=pre_process, reset_permissions=reset_permissions)
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 146, in import_file_by_path
import_doc**(**
\~\~\~\~\~\~\~\~\~\~**^**
**docdict=doc,**
**^^^^^^^^^^^^**
...<4 lines>...
**path=path,**
**^^^^^^^^^^**
**)**
**^**
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 239, in import_doc
doc.insert**()**
\~\~\~\~\~\~\~\~\~\~**^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/model/document.py”, line 320, in insert
self.db_insert**(ignore_if_duplicate=ignore_if_duplicate)**
\~\~\~\~\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 576, in db_insert
frappe.db.sql**(**
\~\~\~\~\~\~\~\~\~\~\~\~\~**^**
**"""INSERT INTO \`tab{doctype}\` ({columns})**
**^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^**
...<6 lines>...
**list(d.values()),**
**^^^^^^^^^^^^^^^^^**
**)**
**^**
File “/Users/abubakar/Desktop/Code/frappe-bench/apps/frappe/frappe/database/database.py”, line 230, in sql
self.\_cursor.execute**(query, values)**
\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/pymysql/cursors.py”, line 153, in execute
result = self.\_query(query)
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/pymysql/cursors.py”, line 322, in _query
conn.query**(q)**
\~\~\~\~\~\~\~\~\~\~**^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/pymysql/connections.py”, line 563, in query
self.\_affected_rows = self.\_read_query_result**(unbuffered=unbuffered)**
\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^^^^^^^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/pymysql/connections.py”, line 825, in _read_query_result
result.read**()**
\~\~\~\~\~\~\~\~\~\~\~**^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/pymysql/connections.py”, line 1199, in read
first_packet = self.connection.\_read_packet()
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/pymysql/connections.py”, line 775, in _read_packet
packet.raise_for_error**()**
\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~**^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/pymysql/protocol.py”, line 219, in raise_for_error
err.raise_mysql_exception**(self.\_data)**
\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~\~**^^^^^^^^^^^^**
File “/Users/abubakar/Desktop/Code/frappe-bench/env/lib/python3.13/site-packages/pymysql/err.py”, line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘is_calendar_and_gantt’ in ‘INSERT INTO’”)
Hi ,
It may help to describe the operating environment and if other sites have been created or if this is the first attempt .
Try: bench —site erp.local reinstall