{"action":"created","issue":{"url":"https://api.github.com/repos/jekkos/opensourcepos/issues/167","labels_url":"https://api.github.com/repos/jekkos/opensourcepos/issues/167/labels{/name}","comments_url":"https://api.github.com/repos/jekkos/opensourcepos/issues/167/comments","events_url":"https://api.github.com/repos/jekkos/opensourcepos/issues/167/events","html_url":"https://github.com/jekkos/opensourcepos/issues/167","id":107427216,"number":167,"title":"Database error on suspend sale","user":{"login":"nhooverapg","id":14485895,"avatar_url":"https://avatars.githubusercontent.com/u/14485895?v=3","gravatar_id":"","url":"https://api.github.com/users/nhooverapg","html_url":"https://github.com/nhooverapg","followers_url":"https://api.github.com/users/nhooverapg/followers","following_url":"https://api.github.com/users/nhooverapg/following{/other_user}","gists_url":"https://api.github.com/users/nhooverapg/gists{/gist_id}","starred_url":"https://api.github.com/users/nhooverapg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nhooverapg/subscriptions","organizations_url":"https://api.github.com/users/nhooverapg/orgs","repos_url":"https://api.github.com/users/nhooverapg/repos","events_url":"https://api.github.com/users/nhooverapg/events{/privacy}","received_events_url":"https://api.github.com/users/nhooverapg/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jekkos/opensourcepos/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-09-21T00:36:08Z","updated_at":"2015-09-22T02:24:47Z","closed_at":null,"body":"When suspending a sale, the following database error occurred:\r\n\r\nA Database Error Occurred\r\n\r\nError Number: 1406\r\n\r\nData too long for column 'description' at row 1\r\n\r\nINSERT INTO `ospos_sales_suspended_items` (`sale_id`, `item_id`, `line`, `description`, `serialnumber`, `quantity_purchased`, `discount_percent`, `item_cost_price`, `item_unit_price`, `item_location`) VALUES (1, '1', 1, 'Douglas Fir Cut Your Own Christmas tree', '', 1, '0', '25.00', '41.00', '1')\r\n\r\nFilename: /~/models/sale_suspended.php\r\n\r\nLine Number: 98"},"comment":{"url":"https://api.github.com/repos/jekkos/opensourcepos/issues/comments/142160822","html_url":"https://github.com/jekkos/opensourcepos/issues/167#issuecomment-142160822","issue_url":"https://api.github.com/repos/jekkos/opensourcepos/issues/167","id":142160822,"user":{"login":"nhooverapg","id":14485895,"avatar_url":"https://avatars.githubusercontent.com/u/14485895?v=3","gravatar_id":"","url":"https://api.github.com/users/nhooverapg","html_url":"https://github.com/nhooverapg","followers_url":"https://api.github.com/users/nhooverapg/followers","following_url":"https://api.github.com/users/nhooverapg/following{/other_user}","gists_url":"https://api.github.com/users/nhooverapg/gists{/gist_id}","starred_url":"https://api.github.com/users/nhooverapg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nhooverapg/subscriptions","organizations_url":"https://api.github.com/users/nhooverapg/orgs","repos_url":"https://api.github.com/users/nhooverapg/repos","events_url":"https://api.github.com/users/nhooverapg/events{/privacy}","received_events_url":"https://api.github.com/users/nhooverapg/received_events","type":"User","site_admin":false},"created_at":"2015-09-22T02:24:47Z","updated_at":"2015-09-22T02:24:47Z","body":"seems to me that if the description field accepts a certain length during the create item process, the suspend sale module should be able to handle that same length, especially since it's a temporary structure- shouldn't have that many records in the suspend sales database at one time.\r\n\r\nor, conversely, if the description field should be limited due to fitting in the item overview on the receipt, then it should be restricted on item creation (and this bug would be moot).\r\n\r\nin any case, the length of the database fields for the same information should be the same."}}