Hi all -
I have just completed installing InvoicePlane and have created entries for products, clients, groups and such.
When I try to create my first invoice, the process hangs with the “gear” going around in the browser.
When I re-navigate to Invoices, I find that there is a draft invoice but the numbers computed in the fields are wrong.
Here is the error that I see in the console:
A Database Error Occurred
Error Number: 1366
Incorrect decimal value: '' for column 'invoice_discount_amount' at row 1
UPDATE `ip_invoices` SET `invoice_number` = '161620150608', `invoice_terms` = '', `invoice_date_created` = '2015-06-08', `invoice_date_due` = '2015-07-08', `invoice_password` = '', `invoice_status_id` = '1', `payment_method` = '1', `invoice_discount_amount` = '', `invoice_discount_percent` = '', `invoice_date_modified` = '2015-06-08 22:01:26' WHERE `ip_invoices`.`invoice_id` = '3'
Filename: /Library/WebServer/Documents/invoices/core/MY_Model.php
Line Number: 220
I have tried various permutations of entering values for discount, no values, percentages, etc with no change in the problem. I’m sure this is something simple but I just can’t figure it out. I am using OS X Yosemite and the MySQL and Apache2 seem to work OK otherwise. The product installed without errors once I got the permissions right.
I just can’t create an invoice.
Any help would be appreciated.
Thanks in advance -
Joel