X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fpurchasing_db.inc;h=fbef5291d574d23415c026b317b298d455830eb3;hb=316007a1fa9cb1fd6d11460326160d4a60a0d943;hp=fe174800d495ebfbf19e2c0ee5dc07df44c7973f;hpb=b2a9c105e368f6e4fdb35477665edeff13fb574b;p=fa-stable.git diff --git a/purchasing/includes/purchasing_db.inc b/purchasing/includes/purchasing_db.inc index fe174800..fbef5291 100644 --- a/purchasing/includes/purchasing_db.inc +++ b/purchasing/includes/purchasing_db.inc @@ -95,6 +95,8 @@ function get_purchase_data($supplier_id, $stock_id) function add_or_update_purchase_data($supplier_id, $stock_id, $price, $description="", $uom="") { $data = get_purchase_data($supplier_id, $stock_id); + + $description = substr($description, 0, 50); // FIXME: temporary constraint to avoid db errors on long descriptions, see [0005170] if ($data === false) { $sql = "INSERT INTO ".TB_PREF."purch_data (supplier_id, stock_id, price, suppliers_uom,