Hi,
Suddenly PDFs are not generated anymore and I get this error: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘background_image_id’.
Complete error:
[2018-05-01 07:06:59] production.ERROR: Illuminate\Database\QueryException [42S22] : /home/xxx/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 647] => SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘background_image_id’ in ‘field list’ (SQL: update
accountsset
updated_at= 2018-05-01 07:06:59,
hide_quantity= 0,
hide_paid_to_date= 1,
invoice_labels= {“balance_due”:"",“credit_card”:"",“delivery_note”:"",“description”:"",“discount”:"",“due_date”:"",“gateway_fee_item”:"",“gateway_fee_description”:"",“hours”:"",“id_number”:"",“invoice”:"",“invoice_date”:"",“invoice_number”:"",“item”:"",“line_total”:"",“outstanding”:"",“paid_to_date”:"",“partial_due”:"",“po_number”:"",“quantity”:"",“quote”:"",“quote_date”:"",“quote_number”:"",“rate”:"",“service”:"",“subtotal”:"",“tax”:"",“terms”:"",“unit_cost”:“Stukprijs”,“valid_until”:"",“vat_number”:""},
all_pages_footer= 0,
all_pages_header= 0,
invoice_fields= {“invoice_fields”:[“invoice.invoice_number”,“invoice.po_number”,“invoice.invoice_date”,“invoice.due_date”,“invoice.balance_due”,“invoice.partial_due”],“client_fields”:[“client.client_name”,“client.id_number”,“client.vat_number”,“client.address1”,“client.city_state_postal”,“client.email”],“account_fields1”:[“account.company_name”,“account.address1”,“account.city_state_postal”,“account.website”,“account.email”],“account_fields2”:[".blank",“account.vat_number”,“account.id_number”,“account.custom_value1”],“product_fields”:[“product.item”,“product.description”,“product.custom_value1”,“product.custom_value2”,“product.unit_cost”,“product.quantity”,“product.tax”,“product.line_total”],“task_fields”:[“product.service”,“product.description”,“product.custom_value1”,“product.custom_value2”,“product.rate”,“product.hours”,“product.tax”,“product.line_total”]},
invoice_embed_documents= 1,
background_image_id= where
id= 1) {"context":"PHP","user_id":1,"account_id":"1","user_name":"Lars Jansen","method":"POST","user_agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36","locale":"nl","ip":"84.241.xxx","count":11,"is_console":"no","is_api":"no","db_server":"mysql","url":"settings/invoice_design"} []
How to solve this?
Kind regards,
Lars Jansen