2024-08-31 17:42:44,354 ERROR frappe New Exception collected in error log Site: riwollis-shop.tcp4.me Form Dict: {'start': '0', 'page_length': '120', 'price_list': 'VK Preise', 'item_group': 'Alle Artikelgruppen', 'search_term': '', 'pos_profile': 'Kassen Profil', 'cmd': 'erpnext.selling.page.custom_point_of_sale.custom_point_of_sale.get_items'} 2024-08-31 17:46:28,737 ERROR frappe Error while inserting deferred Error Log record: Error Log 0j2e4q6qku: 'Title' ((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 'FROM\n\t\t\t`tabItem` item \n\t\tWHERE\n\t\t\titem.disabled = 0\n\t\t\tAND item.has_variants...' at line 10")) will get truncated, as max characters allowed is 140 Site: riwollis-shop.tcp4.me Form Dict: {} 2024-08-31 17:46:28,743 ERROR frappe Error while inserting deferred Error Log record: Error Log 0j2fb2r772: 'Title' ((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 'FROM\n\t\t\t`tabItem` item \n\t\tWHERE\n\t\t\titem.disabled = 0\n\t\t\tAND item.has_variants...' at line 10")) will get truncated, as max characters allowed is 140 Site: riwollis-shop.tcp4.me Form Dict: {} 2024-08-31 17:46:28,750 ERROR frappe Error while inserting deferred Error Log record: Error Log 0j2fp25l53: 'Title' ((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 'FROM\n\t\t\t`tabItem` item \n\t\tWHERE\n\t\t\titem.disabled = 0\n\t\t\tAND item.has_variants...' at line 10")) will get truncated, as max characters allowed is 140 Site: riwollis-shop.tcp4.me Form Dict: {} 2024-09-02 14:59:04,794 ERROR frappe Could not take error snapshot: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)") Site: riwollis-shop.tcp4.me Form Dict: {'doctype': 'Item', 'fields': '["`tabItem`.`name`","`tabItem`.`owner`","`tabItem`.`creation`","`tabItem`.`modified`","`tabItem`.`modified_by`","`tabItem`.`_user_tags`","`tabItem`.`_comments`","`tabItem`.`_assign`","`tabItem`.`_liked_by`","`tabItem`.`docstatus`","`tabItem`.`idx`","`tabItem`.`item_name`","`tabItem`.`item_group`","`tabItem`.`opening_stock`","`tabItem`.`image`","`tabItem`.`stock_uom`","`tabItem`.`has_variants`","`tabItem`.`end_of_life`","`tabItem`.`disabled`"]', 'filters': '[["Item","name","like","%201-%"]]', 'order_by': '`tabItem`.`item_name` asc', 'start': '0', 'page_length': '2500', 'view': 'List', 'group_by': '', 'with_comment_count': '1', 'cmd': 'frappe.desk.reportview.get'} Traceback (most recent call last): File "/disk/service/web/home/erp/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py", line 649, in connect sock = socket.create_connection( File "/usr/lib/python3.10/socket.py", line 845, in create_connection raise err File "/usr/lib/python3.10/socket.py", line 833, in create_connection sock.connect(sa) ConnectionRefusedError: [Errno 111] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/app.py", line 114, in application response = frappe.api.handle(request) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/api/__init__.py", line 49, in handle data = endpoint(**arguments) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/api/v1.py", line 36, in handle_rpc_call return frappe.handler.handle() File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/handler.py", line 49, in handle data = execute_cmd(cmd) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/handler.py", line 85, in execute_cmd return frappe.call(method, **frappe.form_dict) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/__init__.py", line 1768, in call return fn(*args, **newargs) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/utils/typing_validations.py", line 31, in wrapper return func(*args, **kwargs) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/__init__.py", line 921, in wrapper_fn retval = fn(*args, **get_newargs(fn, kwargs)) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 32, in get data = compress(execute(**args), args=args) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 78, in execute return DatabaseQuery(doctype).execute(*args, **kwargs) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/model/db_query.py", line 191, in execute result = self.build_and_run() File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/model/db_query.py", line 232, in build_and_run return frappe.db.sql( File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/database.py", line 211, in sql self.connect() File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/database.py", line 117, in connect self._conn: "MariadbConnection" | "PostgresConnection" = self.get_connection() File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 107, in get_connection conn = self._get_connection() File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 113, in _get_connection return self.create_connection() File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 116, in create_connection return pymysql.connect(**self.get_connection_settings()) File "/disk/service/web/home/erp/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py", line 361, in __init__ self.connect() File "/disk/service/web/home/erp/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py", line 716, in connect raise exc pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)") During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/disk/service/web/home/erp/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py", line 649, in connect sock = socket.create_connection( File "/usr/lib/python3.10/socket.py", line 845, in create_connection raise err File "/usr/lib/python3.10/socket.py", line 833, in create_connection sock.connect(sa) ConnectionRefusedError: [Errno 111] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/utils/error.py", line 86, in log_error_snapshot log_error(title=str(exception), defer_insert=True) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/utils/error.py", line 61, in log_error error_log = frappe.get_doc( File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/__init__.py", line 1333, in get_doc doc = frappe.model.document.get_doc(*args, **kwargs) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/model/document.py", line 83, in get_doc controller = get_controller(doctype) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/model/base_document.py", line 70, in get_controller site_controllers[doctype] = import_controller(doctype) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/model/base_document.py", line 81, in import_controller doctype_info = frappe.db.get_value("DocType", doctype, fieldname="*") File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/database.py", line 519, in get_value result = self.get_values( File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/database.py", line 623, in get_values out = self._get_values_from_table( File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/database.py", line 896, in _get_values_from_table return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck) File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/query_builder/utils.py", line 87, in execute_query result = frappe.db.sql(query, params, *args, **kwargs) # nosemgrep File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/database.py", line 211, in sql self.connect() File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/database.py", line 117, in connect self._conn: "MariadbConnection" | "PostgresConnection" = self.get_connection() File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 107, in get_connection conn = self._get_connection() File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 113, in _get_connection return self.create_connection() File "/disk/service/web/home/erp/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 116, in create_connection return pymysql.connect(**self.get_connection_settings()) File "/disk/service/web/home/erp/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py", line 361, in __init__ self.connect() File "/disk/service/web/home/erp/frappe-bench/env/lib/python3.10/site-packages/pymysql/connections.py", line 716, in connect raise exc pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)") 2024-09-05 16:23:07,926 ERROR frappe New Exception collected in error log Site: riwollis-shop.tcp4.me Form Dict: {'doctype': 'State', 'cmd': 'frappe.client.get'} 2024-09-13 10:08:34,880 ERROR frappe New Exception collected in error log Site: riwollis-shop.tcp4.me Form Dict: {'report_name': 'Stock Ledger', 'filters': '{"company":"Riwollis","from_date":"2021-01-01","to_date":"2024-09-13","valuation_field_type":"Currency"}', 'ignore_prepared_report': 'false', 'are_default_filters': 'false', 'cmd': 'frappe.desk.query_report.run'} 2024-09-13 12:23:20,914 ERROR frappe New Exception collected in error log Site: riwollis-shop.tcp4.me Form Dict: {'doctype': 'POS Invoice', 'fieldname': '{"from_date":"2024-01-01"}', 'cmd': 'frappe.client.set_value'} 2024-09-14 13:43:03,573 ERROR frappe New Exception collected in error log Site: riwollis-shop.tcp4.me Form Dict: {'search_term': 'c', 'status': 'Paid', 'cmd': 'erpnext.selling.page.custom_point_of_sale.custom_point_of_sale.get_past_order_list'} 2024-09-14 13:46:41,380 ERROR frappe New Exception collected in error log Site: riwollis-shop.tcp4.me Form Dict: {'search_term': 'c', 'status': 'Paid', 'cmd': 'erpnext.selling.page.custom_point_of_sale.custom_point_of_sale.get_past_order_list'} 2024-09-14 14:03:58,975 ERROR frappe New Exception collected in error log Site: riwollis-shop.tcp4.me Form Dict: {'search_term': 'Catania', 'status': 'Paid', 'cmd': 'erpnext.selling.page.custom_point_of_sale.custom_point_of_sale.get_past_order_list'}