Cant Create Invoice


Current Setup:
Windows 7
PHP 5.6

I am unable to create an Invoice. I can create a quote and then turn a quote into an Invoice. However if I click create an invoice, select a client, date and group. When I click submit nothing is done.

These are the server logs for the issue:
2015-12-18 18:28:05 GET /payment_methods - 80 - Mozilla/5.0+(Windows+NT+6.1;+WOW64;+Trident/7.0;+rv:11.0)+like+Gecko 200 0 0 1265
2015-12-18 18:28:13 POST /invoices/ajax/create - 80 - Mozilla/5.0+(Windows+NT+6.1;+WOW64;+Trident/7.0;+rv:11.0)+like+Gecko 500 0 0 828

I turned on the error logs in the config for the system.
this is the only error that shows up:
ERROR - 2015-12-18 13:32:54 --> Query error: Incorrect integer value: ‘’ for column ‘payment_method’ at row 1

Please note that I have made a payment method.

I have also found out that when I try to create a quote and leave the item discount field empty it throws an error as well. I have to have a value in it for it not to throw an error. Is there no empty checks done on the fields? Is that why the create invoice is not working?

Are you pulling that from the InvoicePlane log or IIS?

I currently am running on IIS but Server 2012 R2, PHP 5.6 and no issues creating invoices.

Did you try to use the PHP Manager for IIS to make sure that PHP is correctly setup?

I’ve used the Web Platform installer to install PHP 5.6 for IIS. The first error comes from IIS, the second from InvoicePlane Log. The PHP Manager is there and functioning fine.

I would try the following:

  1. Recycle the AppPool your site is running on, then restart the IIS Service

  2. Make sure that your mysql ini file is set to turn off Strict Mode How can I turn off MySQL strict mode?

Status: fixed :white_check_mark: