sync error

[saeidfeyziniya]

frappe.exceptions.CharacterLengthExceededError: Error Log 901: 'Title' (SELECT `tabItem`.`name`, 
                                     `tabItem`.`item_code`, 
                                     `tabItem`.`item_name`, 
                                     `tabItem`.`item_group`, 
                                     `tabItem`.`description`,
                                     `tabItem`.`woocommerce_description`, 
                                     `tabItem`.`has_variants`, 
                                     `tabItem`.`variant_of`, 
                                     `tabItem`.`stock_uom`, 
                                     `tabItem`.`image`, 
                                     `tabItem`.`woocommerce_product_id`,
                                     `tabItem`.`woocommerce_variant_id`, 
                                     `tabItem`.`sync_qty_with_woocommerce`, 
                                     `tabItem`.`weight_per_unit`, 
                                     `tabItem`.`weight_uom`
        FROM `tabItem`, `tabItem Price`
        WHERE `tabItem Price`.`price_list` = 'Standard Selling' 
          AND `tabItem`.`name` = `tabItem Price`.`item_code`
          AND `tabItem`.`sync_with_woocommerce` = 1 
          AND (`tabItem`.`disabled` IS NULL OR `tabItem`.`disabled` = 0) ) will get truncated, as max characters allowed is 140

why I get these error?
I don't have any fiels in tabItem with more 140 char.

[lasalesi]

It is actually the error log, which is exceeding the limit, not the items themself. If you could post the full error trace, this might help locate the issue.

[sptechcue]

I have the same error, please can you help me.
Regards

Estado
Error
Método
sync_woocommerce_resources
Mensaje
Traceback (most recent call last):
File "apps/woocommerceconnector/woocommerceconnector/api.py", line 50, in sync_woocommerce_resources
sync_products(woocommerce_settings.price_list, woocommerce_settings.warehouse, True if woocommerce_settings.sync_items_from_woocommerce_to_erp == 1 else False)
File "apps/woocommerceconnector/woocommerceconnector/sync_products.py", line 24, in sync_products
sync_erpnext_items(price_list, warehouse, woocommerce_item_list)
File "apps/woocommerceconnector/woocommerceconnector/sync_products.py", line 397, in sync_erpnext_items
for item in get_erpnext_items(price_list):
File "apps/woocommerceconnector/woocommerceconnector/sync_products.py", line 457, in get_erpnext_items
frappe.log_error("{0}".format(item_from_item_price))
File "apps/frappe/frappe/init.py", line 2228, in log_error
return get_doc(
File "apps/frappe/frappe/model/document.py", line 256, in insert
self._validate()
File "apps/frappe/frappe/model/document.py", line 528, in _validate
self._validate_length()
File "apps/frappe/frappe/model/base_document.py", line 907, in _validate_length
self.throw_length_exceeded_error(df, max_length, value)
File "apps/frappe/frappe/model/base_document.py", line 941, in throw_length_exceeded_error
frappe.throw(
File "apps/frappe/frappe/init.py", line 524, in throw
msgprint(
File "apps/frappe/frappe/init.py", line 492, in msgprint
_raise_exception()
File "apps/frappe/frappe/init.py", line 444, in _raise_exception
raise raise_exception(msg)
frappe.exceptions.CharacterLengthExceededError: Error Log 18: 'Title' (SELECT tabItem.name,
tabItem.item_code,
tabItem.item_name,
tabItem.item_group,
tabItem.description,
tabItem.woocommerce_description,
tabItem.has_variants,
tabItem.variant_of,
tabItem.stock_uom,
tabItem.image,
tabItem.woocommerce_product_id,
tabItem.woocommerce_variant_id,
tabItem.sync_qty_with_woocommerce,
tabItem.weight_per_unit,
tabItem.weight_uom
FROM tabItem, tabItem Price
WHERE tabItem Price.price_list = 'Venta estándar'
AND tabItem.name = tabItem Price.item_code
AND tabItem.sync_with_woocommerce = 1
AND (tabItem.disabled IS NULL OR tabItem.disabled = 0) AND tabItem.variant_of NOT IN ('123-159-3697')) will get truncated, as max characters allowed is 140

[Haschtl]

Same issue here
Here is the full error trace:

Traceback (most recent call last):
  File "apps/woocommerceconnector/woocommerceconnector/api.py", line 50, in sync_woocommerce_resources
    sync_products(woocommerce_settings.price_list, woocommerce_settings.warehouse, True if woocommerce_settings.sync_items_from_woocommerce_to_erp == 1 else False)
  File "apps/woocommerceconnector/woocommerceconnector/sync_products.py", line 24, in sync_products
    sync_erpnext_items(price_list, warehouse, woocommerce_item_list)
  File "apps/woocommerceconnector/woocommerceconnector/sync_products.py", line 397, in sync_erpnext_items
    for item in get_erpnext_items(price_list):
  File "apps/woocommerceconnector/woocommerceconnector/sync_products.py", line 457, in get_erpnext_items
    frappe.log_error("{0}".format(item_from_item_price))
  File "apps/frappe/frappe/__init__.py", line 2225, in log_error
    return error_log.insert(ignore_permissions=True)
  File "apps/frappe/frappe/model/document.py", line 258, in insert
    self._validate()
  File "apps/frappe/frappe/model/document.py", line 530, in _validate
    self._validate_length()
  File "apps/frappe/frappe/model/base_document.py", line 908, in _validate_length
    self.throw_length_exceeded_error(df, max_length, value)
  File "apps/frappe/frappe/model/base_document.py", line 942, in throw_length_exceeded_error
    frappe.throw(
  File "apps/frappe/frappe/__init__.py", line 522, in throw
    msgprint(
  File "apps/frappe/frappe/__init__.py", line 490, in msgprint
    _raise_exception()
  File "apps/frappe/frappe/__init__.py", line 442, in _raise_exception
    raise raise_exception(msg)
frappe.exceptions.CharacterLengthExceededError: Error Log 80: 'Title' (SELECT `tabItem`.`name`, 
                                     `tabItem`.`item_code`, 
                                     `tabItem`.`item_name`, 
                                     `tabItem`.`item_group`, 
                                     `tabItem`.`description`,
                                     `tabItem`.`woocommerce_description`, 
                                     `tabItem`.`has_variants`, 
                                     `tabItem`.`variant_of`, 
                                     `tabItem`.`stock_uom`, 
                                     `tabItem`.`image`, 
                                     `tabItem`.`woocommerce_product_id`,
                                     `tabItem`.`woocommerce_variant_id`, 
                                     `tabItem`.`sync_qty_with_woocommerce`, 
                                     `tabItem`.`weight_per_unit`, 
                                     `tabItem`.`weight_uom`
        FROM `tabItem`, `tabItem Price`
        WHERE `tabItem Price`.`price_list` = 'Standard-Vertrieb' 
          AND `tabItem`.`name` = `tabItem Price`.`item_code`
          AND `tabItem`.`sync_with_woocommerce` = 1 
          AND (`tabItem`.`disabled` IS NULL OR `tabItem`.`disabled` = 0) AND `tabItem Price`.`modified` >= '2022-10-04 21:57:00'  AND `tabItem`.`variant_of` NOT IN ('132' ,'133' ,'134' ,'135' ,'136' ,'159' ,'160' ,'187' ,'193' ,'194' ,'200' ,'201' ,'205' ,'206' ,'291' ,'294' ,'297' ,'311' ,'328' ,'351' ,'356' ,'361' ,'371' ,'386' ,'390' ,'400' ,'424' ,'425' ,'426' ,'427' ,'428' ,'429' ,'430' ,'431' ,'468')) will get truncated, as max characters allowed is 140

I think this error can be resolved by simply removing the error_log in document.py
frappe.log_error("{0}".format(item_from_item_price)) is called when there is actually no error, but it's responsible for creating an error