frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
20.98k stars 7.2k forks source link

Error Log snpsdek3th: 'Title' #42924

Closed YasserMounir closed 1 month ago

YasserMounir commented 1 month ago

Information about bug

i have error prevent me from save from any doctype Error Log snpsdek3th: 'Title' will get truncated, as max characters allowed is 140

Module

accounts, stock, buying, selling

Version

cheques_management 0.0.1 custom_reports 0.0.1 erpnext 15.33.5 frappe 15.39.0 hrms 15.27.0 lending 0.0.1 maintenance_system 0.0.1 payments 0.0.1 qr_code_app 0.0.1 techstation_item_control 0.0.1 techstation_theme 0.0.1

Installation method

easy-install

Relevant log output / Stack trace / Full Error Message.

Value too big
Error Log snpsdek3th: 'Title' ({'name': 'SAL-ORD-2024-00035', 'owner': 'Administrator', 'creation': '2024-08-26 18:45:35.336009', 'modified': '2024-08-26 18:45:35.336009', 'modified_by': 'Administrator', 'docstatus': 0, 'idx': 0, 'title': '{customer_name}', 'naming_series': 'SAL-ORD-.YYYY.-', 'customer': '00040', 'customer_name': 'معمل ساريدار', 'tax_id': None, 'order_type': 'Sales', 'transaction_date': '2024-08-26', 'delivery_date': '2024-08-28', 'po_no': None, 'po_date': None, 'company': 'Miralab CAI', 'skip_delivery_note': 0, 'amended_from': None, 'cost_center': 'رئيسي - MC', 'project': None, 'currency': 'EGP', 'conversion_rate': 1.0, 'selling_price_list': 'Standard Selling', 'price_list_currency': 'EGP', 'plc_conversion_rate': 1.0, 'ignore_pricing_rule': 0, 'scan_barcode': None, 'set_warehouse': None, 'reserve_stock': 0, 'total_qty': 1.0, 'total_net_weight': 0.0, 'base_total': 200.0, 'base_net_total': 200.0, 'total': 200.0, 'net_total': 200.0, 'tax_category': '', 'taxes_and_charges': None, 'shipping_rule': None, 'incoterm': None, 'named_place': None, 'base_total_taxes_and_charges': 0.0, 'total_taxes_and_charges': 0.0, 'base_grand_total': 200.0, 'base_rounding_adjustment': 0.0, 'base_rounded_total': 0.0, 'base_in_words': 'EGP Two Hundred only.', 'grand_total': 200.0, 'rounding_adjustment': 0.0, 'rounded_total': 0.0, 'in_words': 'EGP Two Hundred only.', 'advance_paid': 0.0, 'disable_rounded_total': 1, 'apply_discount_on': 'Grand Total', 'base_discount_amount': 0.0, 'coupon_code': None, 'additional_discount_percentage': 0.0, 'discount_amount': 0.0, 'other_charges_calculation': None, 'customer_address': None, 'address_display': None, 'customer_group': 'معمل خاص', 'territory': 'القاهرة', 'contact_person': None, 'contact_display': None, 'contact_phone': None, 'contact_mobile': None, 'contact_email': None, 'shipping_address_name': None, 'shipping_address': None, 'dispatch_address_name': None, 'dispatch_address': None, 'company_address': 'Miralab Cai-الفواتير', 'company_address_display': 'Address :
\nCity/Town :
\nStreet :
\nCountry : Egypt
\nPostal Code :
\nHouse Number :
\nApartment Number :
\nFloor :
\nWay to Climb :
\nSpecial Marque :
', 'payment_terms_template': None, 'tc_name': 'مستحق فورى', 'terms': '

', 'status': 'Draft', 'delivery_status': 'Not Delivered', 'per_delivered': 0.0, 'per_billed': 0.0, 'per_picked': 0.0, 'billing_status': 'Not Billed', 'sales_partner': None, 'amount_eligible_for_commission': 200.0, 'commission_rate': 0.0, 'total_commission': 0.0, 'loyalty_points': 0, 'loyalty_amount': 0.0, 'from_date': None, 'to_date': None, 'auto_repeat': None, 'letter_head': 'ميرالاب', 'group_same_items': 0, 'select_print_heading': None, 'language': 'ar', 'is_internal_customer': 0, 'represents_company': None, 'source': None, 'inter_company_order_reference': None, 'campaign': None, 'party_account_currency': 'EGP', 'doctype': 'Sales Order', 'sales_team': [], 'pricing_rules': [], 'taxes': [], 'packed_items': [], 'payment_schedule': [{'name': None, 'owner': None, 'creation': None, 'modified': None, 'modified_by': None, 'docstatus': 0, 'idx': 1, 'payment_term': None, 'description': None, 'due_date': '2024-08-26', 'mode_of_payment': None, 'invoice_portion': 100.0, 'discount_type': None, 'discount_date': None, 'discount': 0.0, 'payment_amount': 200.0, 'outstanding': 200.0, 'paid_amount': 0.0, 'discounted_amount': 0.0, 'base_payment_amount': 200.0, 'parent': 'SAL-ORD-2024-00035', 'parentfield': 'payment_schedule', 'parenttype': 'Sales Order', 'doctype': 'Payment Schedule', '__islocal': 1}], 'items': [{'name': 'snpqqo6cot', 'owner': 'Administrator', 'creation': '2024-08-26 18:45:35.336009', 'modified': '2024-08-26 18:45:35.336009', 'modified_by': 'Administrator', 'docstatus': 0, 'idx': 1, 'item_code': '19', 'customer_item_code': None, 'ensure_delivery_based_on_produced_serial_no': 0, 'is_stock_item': 1, 'reserve_stock': 0, 'delivery_date': '2024-08-28', 'item_name': 'ALL IN ONE PC TOUCH', 'description': 'ALL IN ONE PC TOUCH', 'item_group': 'SPERMOLYZER COMPONENTS', 'brand': None, 'image': '', 'qty': 1.0, 'stock_uom': 'BOX', 'uom': 'BOX', 'conversion_factor': 1.0, 'stock_qty': 1.0, 'stock_reserved_qty': 0.0, 'price_list_rate': 0.0, 'base_price_list_rate': 0.0, 'margin_type': '', 'margin_rate_or_amount': 0.0, 'rate_with_margin': 0.0, 'discount_percentage': 0.0, 'discount_amount': 0.0, 'base_rate_with_margin': 0.0, 'rate': 200.0, 'amount': 200.0, 'item_tax_template': None, 'base_rate': 200.0, 'base_amount': 200.0, 'pricing_rules': '', 'stock_uom_rate': 200.0, 'is_free_item': 0, 'grant_commission': 1, 'net_rate': 200.0, 'net_amount': 200.0, 'base_net_rate': 200.0, 'base_net_amount': 200.0, 'billed_amt': 0.0, 'valuation_rate': 14392.9824, 'gross_profit': -14192.9824, 'delivered_by_supplier': 0, 'supplier': None, 'weight_per_unit': 0.0, 'total_weight': 0.0, 'weight_uom': None, 'warehouse': 'القاهرة - MC', 'target_warehouse': None, 'prevdoc_docname': None, 'quotation_item': None, 'against_blanket_order': 0, 'blanket_order': None, 'blanket_order_rate': 0.0, 'bom_no': None, 'projected_qty': 7.0, 'actual_qty': 7.0, 'ordered_qty': 0.0, 'planned_qty': 0.0, 'production_plan_qty': 0.0, 'work_order_qty': 0.0, 'delivered_qty': 0.0, 'produced_qty': 0.0, 'returned_qty': 0.0, 'picked_qty': 0.0, 'additional_notes': None, 'page_break': 0, 'item_tax_rate': '{}', 'transaction_date': '2024-08-26', 'warranty_status': 'Enabled', 'warranty_template': 'Warranty 12 Months', 'material_request': None, 'purchase_order': None, 'material_request_item': None, 'purchase_order_item': None, 'parent': 'SAL-ORD-2024-00035', 'parentfield': 'items', 'parenttype': 'Sales Order', 'doctype': 'Sales Order Item', '__islocal': 1, '__unsaved': 1}], '__islocal': True, '__unsaved': 1}) will get truncated, as max characters allowed is 140
Nihantra-Patel commented 1 month ago

We tested it locally and also on the frappe cloud side, and everything is working fine. No problems were encountered in the latest versions 14 and 15.

Please check the reference in the Frappe Forum:

https://discuss.frappe.io/t/value-too-big-error-in-tag-in-todo/54328/2?u=ncp

https://discuss.frappe.io/t/error-value-too-big-maximum-character-allowed-is-140/66766/2?u=ncp

YasserMounir commented 1 month ago

so can you indicate why this error arise when saving i have checked there are no scrips working on the site

Nihantra-Patel commented 1 month ago

Please check the reference, that i provided. if field level issue.

YasserMounir commented 1 month ago

the field Title is the problem and the length on the From is 0 i tried to change the length to 255 but with same error and i can change the Standard Filed from Data Type to another Type like long text

YasserMounir commented 1 month ago

Sorry i can not change the standard Field from Data type to Long or small text

Nihantra-Patel commented 1 month ago

snpsdek3th

Such an error has not happened till today. But the issue of field length may occur. and also remove the unnecessary custom app and migrate the site. which doctype you faced this issue?

YasserMounir commented 1 month ago

i have removed all custom app and made Bench update and bench migrate but same error so can you suggest how to solve such error

YasserMounir commented 1 month ago

i am facing of Doctyps ( Sales Order, Sales Invoice , , Delivery Order , Purchase Order & Purchase Invoice )