Bench new-site --verbose erpnext.local throwing error and installation stuck at 8%

Mohit_Rakhade · September 15, 2023, 5:06am

When I am running

bench new-site --verbose erpnext.local

It’s throwing errors and warnings too.
And the installation stuck at 8%

Terminal

(env) 
[2023-09-14 15:06:32] mohitrakhade@Mohits-MacBook-Air /Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench
> bench new-site --verbose erpnext.local14
MySQL root password: 
Created user _f215ba8789edf5e2
Created database _f215ba8789edf5e2
Granted privileges to user _f215ba8789edf5e2 and database _f215ba8789edf5e2
Warning: MariaDB version ['8.1', '0'] is less than 10.6 which is not supported by Frappe
Starting database import...
Imported from database /Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/database/mariadb/framework_mariadb.sql

Installing frappe...
Updating DocTypes for frappe        : [===                                     ] 8%

There was an issue while migrating the DocType: Workspace

Traceback (most recent call last):
  File "/opt/homebrew/Cellar/python@3.10/3.10.11/Frameworks/Python.framework/Versions/3.10/lib/python3.10/runpy.py", line 196, in _run_module_as_main
    return _run_code(code, main_globals, None,
  File "/opt/homebrew/Cellar/python@3.10/3.10.11/Frameworks/Python.framework/Versions/3.10/lib/python3.10/runpy.py", line 86, in _run_code
    exec(code, run_globals)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 114, in <module>
    main()
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 20, in main
    click.Group(commands=commands)(prog_name="bench")
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1157, in __call__
    return self.main(*args, **kwargs)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1434, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/commands/site.py", line 76, in new_site
    _new_site(
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/installer.py", line 107, in _new_site
    install_app(app, verbose=verbose, set_as_patched=not source_sql, force=False)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/installer.py", line 296, in install_app
    sync_for(name, force=force, reset_permissions=True)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/model/sync.py", line 109, in sync_for
    import_file_by_path(
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 148, in import_file_by_path
    import_doc(
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 245, in import_doc
    doc.insert()
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 307, in insert
    self.run_post_save_methods()
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 1110, in run_post_save_methods
    self.run_method("on_update")
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 937, in run_method
    out = Document.hook(fn)(self, *args, **kwargs)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 1308, in composer
    return composed(self, method, *args, **kwargs)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 1290, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 934, in fn
    return method_object(*args, **kwargs)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 501, in on_update
    raise e
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 498, in on_update
    frappe.db.updatedb(self.name, Meta(self))
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 427, in updatedb
    db_table.sync()
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/database/schema.py", line 41, in sync
    self.create()
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/database/mariadb/schema.py", line 63, in create
    frappe.db.sql(query)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/apps/frappe/frappe/database/database.py", line 217, in sql
    self._cursor.execute(query, values)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py", line 558, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py", line 822, in _read_query_result
    result.read()
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py", line 1200, in read
    first_packet = self.connection._read_packet()
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py", line 772, in _read_packet
    packet.raise_for_error()
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/Users/mohitrakhade/Desktop/BterAI/erpnext/frappe-bench/env/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1101, "BLOB, TEXT, GEOMETRY or JSON column 'content' can't have a default value")

Aniket_Shinde1 · October 21, 2023, 9:44am

Is this issue solved ?
I am facing same issue on my mac

real_deals · November 6, 2023, 4:21pm

Same issue for Mac as well: M1

Installing frappe…
Updating DocTypes for frappe : [=== ] 8%

There was an issue while migrating the DocType: Workspace

Traceback (most recent call last):
File “”, line 198, in _run_module_as_main
File “”, line 88, in _run_code
File “/Users/xxx/Documents/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 114, in
main()
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 20, in main
click.Group(commands=commands)(prog_name=“bench”)
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 1157, in call
return self.main(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 1078, in main
rv = self.invoke(ctx)
^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/click/core.py”, line 783, in invoke
return __callback(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/commands/site.py”, line 76, in new_site
_new_site(
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/installer.py”, line 107, in _new_site
install_app(app, verbose=verbose, set_as_patched=not source_sql, force=False)
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/installer.py”, line 296, in install_app
sync_for(name, force=force, reset_permissions=True)
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/model/sync.py”, line 111, in sync_for
import_file_by_path(
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 148, in import_file_by_path
import_doc(
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 245, in import_doc
doc.insert()
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 310, in insert
self.run_post_save_methods()
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 1118, in run_post_save_methods
self.run_method(“on_update”)
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 950, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 1316, in composer
return composed(self, method, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 1298, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 947, in fn
return method_object(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”, line 504, in on_update
raise e
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”, line 501, in on_update
frappe.db.updatedb(self.name, Meta(self))
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/database/mariadb/database.py”, line 441, in updatedb
db_table.sync()
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/database/schema.py”, line 41, in sync
self.create()
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/database/mariadb/schema.py”, line 63, in create
frappe.db.sql(query)
File “/Users/xx/Documents/erpnext/frappe-bench/apps/frappe/frappe/database/database.py”, line 217, in sql
self._cursor.execute(query, values)
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/pymysql/cursors.py”, line 153, in execute
result = self._query(query)
^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/pymysql/cursors.py”, line 322, in _query
conn.query(q)
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py”, line 558, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py”, line 822, in _read_query_result
result.read()
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py”, line 1200, in read
first_packet = self.connection._read_packet()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py”, line 772, in _read_packet
packet.raise_for_error()
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “/Users/xx/Documents/erpnext/frappe-bench/env/lib/python3.11/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1101, “BLOB, TEXT, GEOMETRY or JSON column ‘content’ can’t have a default value”)

tonancheta · November 15, 2023, 1:43am

I, too, am facing the same issue on my MacBook Pro. I’ve tried uninstalling and installing MySQL and MariaDB@10.6 in various chronological orders. The main issue seems to be that Bench isn’t recognizing MariaDB and trying to run the SQL commands using MySQL.

Please help!

Pershanthen · January 10, 2024, 5:54am

Hi Everyone,

I am installing this on Ubuntu 20.04.6 LTS and have encountered the same issue. Any ideas on how we resolve this?

RobyCigar · January 11, 2024, 10:14am

well according to phpmyadmin - Mysql error BLOB, TEXT, GEOMETRY or JSON colum cant have default value - Stack Overflow

you should downgrade mysql, i also encounter same problem

Ali_Abdalkreem · March 15, 2024, 2:52pm

Any update regarding this issues