Hello,
Most of the invoices my site generates with this module work. But 1 in 5 do not and return an error page. I believe its because the customer's address or "building-number" are too long. SO first of all thank you for this awesome module. It saves us so much time not having to fill out all of the information for our commercial invoices manually.

So my request is can you show me what exactly i need to change in the code and in what file to allow unlimited characters in the "building-number" field? I've had success customizing the invoice from Sites/all/modules/invoice/templates/default.inc

But i have not been able to fix this error from there. Below is the error report. Thank you!

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'building_number' at row 1: INSERT INTO {invoice_customers} (customer_number, company_name, firstname, lastname, street, building_number, zipcode, city, state, country, coc_number, vat_number, description, invoice_id) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13); Array ( [:db_insert_placeholder_0] => 64 [:db_insert_placeholder_1] => Customer# 10043 [:db_insert_placeholder_2] => YAZEED [:db_insert_placeholder_3] => ALDOBAYAN [:db_insert_placeholder_4] => Bader [:db_insert_placeholder_5] => Al eskan1 , 1117 [:db_insert_placeholder_6] => 51431 [:db_insert_placeholder_7] => BURAYDAH [:db_insert_placeholder_8] => Alqassim [:db_insert_placeholder_9] => Saudi Arabia [:db_insert_placeholder_10] => 571594612173 [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => [:db_insert_placeholder_13] => 134 ) in invoice_insert() (line 819 of /var/www/wwwships/data/www/www.shipsterusa.com/sites/all/modules/invoice/invoice.module).

Comments

pfrenssen’s picture

Priority: Critical » Normal