i am trying to create new site during that i get this error
Installing frappe…
Syntax error in query:
INSERT INTO __global_search (doctype,name,content,published,title,route) VALUES ({‘doctype’: ‘DocType’, ‘name’: ‘DocType State’, ‘content’: ‘Name : DocType State’, ‘published’: 0, ‘title’: ‘DocType State’, ‘route’: None}) ON DUPLICATE KEY UPDATE content=VALUES(content),published=VALUES(published),title=VALUES(title),route=VALUES(route)
Traceback (most recent call last):
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/redis/connection.py”, line 699, in connect
sock = self.retry.call_with_retry(
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/redis/retry.py”, line 46, in call_with_retry
return do()
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/redis/connection.py”, line 700, in
lambda: self._connect(), lambda error: self.disconnect(error)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/redis/connection.py”, line 1002, in _connect
raise err
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/redis/connection.py”, line 990, in _connect
sock.connect(socket_address)
ConnectionRefusedError: [Errno 111] Connection refused
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/utils/global_search.py”, line 429, in sync_value_in_queue
frappe.cache.lpush(“global_search_queue”, json.dumps(value))
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/utils/redis_wrapper.py”, line 152, in lpush
super().lpush(self.make_key(key), value)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/redis/commands/core.py”, line 2706, in lpush
return self.execute_command(“LPUSH”, name, *values)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/redis/client.py”, line 1266, in execute_command
conn = self.connection or pool.get_connection(command_name, **options)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/redis/connection.py”, line 1457, in get_connection
connection.connect()
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/redis/connection.py”, line 705, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to 127.0.0.1:13001. Connection refused.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “/usr/lib/python3.10/runpy.py”, line 196, in _run_module_as_main
return _run_code(code, main_globals, None,
File “/usr/lib/python3.10/runpy.py”, line 86, in _run_code
exec(code, run_globals)
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/utils/bench_helper.py”, line 114, in
main()
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/utils/bench_helper.py”, line 20, in main
click.Group(commands=commands)(prog_name=“bench”)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/click/core.py”, line 1157, in call
return self.main(*args, **kwargs)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/click/core.py”, line 1078, in main
rv = self.invoke(ctx)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/click/core.py”, line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/click/core.py”, line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/click/core.py”, line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/click/core.py”, line 783, in invoke
return __callback(*args, **kwargs)
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/commands/site.py”, line 76, in new_site
_new_site(
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/installer.py”, line 107, in _new_site
install_app(app, verbose=verbose, set_as_patched=not source_sql, force=False)
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/installer.py”, line 286, in install_app
out = frappe.get_attr(before_install)()
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/utils/install.py”, line 11, in before_install
frappe.reload_doc(“core”, “doctype”, “doctype_state”)
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/init.py”, line 1362, in reload_doc
return frappe.modules.reload_doc(module, dt, dn, force=force, reset_permissions=reset_permissions)
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/modules/utils.py”, line 203, in reload_doc
return import_files(module, dt, dn, force=force, reset_permissions=reset_permissions)
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/modules/import_file.py”, line 57, in import_files
return import_file(
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/modules/import_file.py”, line 65, in import_file
return import_file_by_path(
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/modules/import_file.py”, line 148, in import_file_by_path
import_doc(
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/modules/import_file.py”, line 245, in import_doc
doc.insert()
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/model/document.py”, line 310, in insert
self.run_post_save_methods()
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/model/document.py”, line 1133, in run_post_save_methods
update_global_search(self)
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/utils/global_search.py”, line 285, in update_global_search
sync_value_in_queue(value)
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/utils/global_search.py”, line 432, in sync_value_in_queue
sync_values((value,))
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/utils/global_search.py”, line 423, in sync_values
query.run()
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/query_builder/utils.py”, line 87, in execute_query
result = frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
File “/home/jigneshc13/frappee-benchhn/apps/frappe/frappe/database/database.py”, line 217, in sql
self._cursor.execute(query, values)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/pymysql/cursors.py”, line 153, in execute
result = self._query(query)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/pymysql/cursors.py”, line 322, in _query
conn.query(q)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/pymysql/connections.py”, line 558, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/pymysql/connections.py”, line 822, in _read_query_result
result.read()
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/pymysql/connections.py”, line 1200, in read
first_packet = self.connection._read_packet()
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/pymysql/connections.py”, line 772, in _read_packet
packet.raise_for_error()
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “/home/jigneshc13/frappee-benchhn/env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '‘doctype’: ‘DocType’, ‘name’: ‘DocType State’, ‘content’: ‘Name : DocType Sta…’ at line 1”)
