Project

General

Profile

Actions

Bug #389

closed

Error creating a new item

Added by Carsten Stanusch over 2 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
12/16/2021
Due date:
% Done:

100%

Estimated time:

Description

The error probably occurs when the text in the comment field (notes) is too long ...
Current version 4.4.1

@
Started POST "/wkproductitem/update" for 127.0.0.1 at 2021-12-16 08:32:10 +0000
Processing by WkproductitemController#update as HTML
Parameters: {"utf8"=>"✓", "authenticity_token"=>"xxx==", "product_item_id"=>"", "inventory_item_id"=>"", "product_type"=>"I", "product_id"=>"25", "brand_id"=>"4", "product_model_id"=>"413", "part_number"=>"Diverse", "serial_number"=>"E16122101", "running_sn"=>"", "item_total_quantity"=>"1", "currency"=>"€", "cost_price"=>"", "over_head_price"=>"", "selling_price"=>"", "available_quantity"=>"1", "uom_id"=>"4", "product_attribute_id"=>"45", "location_id"=>"34", "project_id"=>"9", "notes"=>"Garantielieferung aus Brasilien 12/21\r\nBestehend aus:\r\n3x Ringdichtung mit Feder: 85x110x14 MCN/Freud 23.01.0189\r\n1x Ringdichtung mit Feder: 85x105x11 ECN/Freud 23.01.0212\r\n1x Ringdichtung mit Feder: 45x62x10 ECN/Freud 23.01.0193\r\n2x Verschlusskappe 80x10 23.03.0006\r\n", "commit"=>"Speichern"}
Current user: technik (id=5)
Completed 500 Internal Server Error in 1196ms (ActiveRecord: 785.5ms)

ActiveRecord::ValueTooLong (Mysql2::Error: Data too long for column 'notes' at row 1: INSERT INTO `wk_inventory_items` (`product_item_id`, `product_attribute_id`, `notes`, `cost_price`, `selling_price`, `over_head_price`, `currency`, `total_quantity`, `available_quantity`, `uom_id`, `serial_number`, `location_id`, `created_at`, `updated_at`, `is_loggable`, `project_id`, `running_sn`, `lock_version`) VALUES (431, 45, 'Garantielieferung aus Brasilien 12/21\r\nBestehend aus:\r\n3x Ringdichtung mit Feder: 85x110x14 MCN/Freud 23.01.0189\r\n1x Ringdichtung mit Feder: 85x105x11 ECN/Freud 23.01.0212\r\n1x Ringdichtung mit Feder: 45x62x10 ECN/Freud 23.01.0193\r\n2x Verschlusskappe 80x10 23.03.0006\r\n', 0.0, 0.0, 0.0, '€', 1.0, 1.0, 4, 'E16122101', 34, '2021-12-16 08:32:11', '2021-12-16 08:32:11', NULL, 9, '', 0)):

plugins/redmine_wktime/app/controllers/wkproductitem_controller.rb:319:in `updateInventoryItem'
plugins/redmine_wktime/app/controllers/wkproductitem_controller.rb:178:in `update'
lib/redmine/sudo_mode.rb:61:in `sudo_mode'
plugins/redmine_dmsf/lib/redmine_dmsf/webdav/custom_middleware.rb:56:in `call'@

Actions #1

Updated by Dhanasingh Krishnapandian over 2 years ago

  • Assignee set to Arun T
  • Target version set to 4.5
Actions #2

Updated by dhanalakshmi c over 2 years ago

ok, we will take a look

Actions #3

Updated by Arun T about 2 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Completed

Actions

Also available in: Atom PDF