Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 4.0.0-b6
-
Component/s: Staff Interface
-
Labels:None
Description
The following error can occur when adding (and presumably editing) a recurring invoice:
General error: 1366 Incorrect integer value: '' for column 'taxable' at row 1
This likely occurs on some databases with sql_mode STRICT_TRANS_TABLES. I suspect that adding a recurring invoice includes a 'taxable' value in vars, but it is set to an empty string. Instead, it should not be set at all so that the table will default it to 0.
Activity
I am not able to duplicate this with sql_mode=STRICT_TRANS_TABLES on version 5.5.50-MariaDB. Either I'm not testing properly, or this doesn't affect v5.5.50.
Paul Phillips
added a comment - I am not able to duplicate this with sql_mode=STRICT_TRANS_TABLES on version 5.5.50-MariaDB. Either I'm not testing properly, or this doesn't affect v5.5.50. Likely isolated to the MySQL version, which the user did not provide.
Tyson Phillips (Inactive)
added a comment - Likely isolated to the MySQL version, which the user did not provide. 
Your suspicion appears to be correct regarding STRICT_TRANS_TABLES, at least for one particular customer. See https://www.blesta.com/forums/index.php?/topic/8772-recurring-invoice-bug/