Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-2337

Creating a recurring invoice can result in an SQL error on 'taxable' column

        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

              People

              • Assignee:
                jonathan Jonathan Reissmueller
                Reporter:
                tyson Tyson Phillips (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  3/Mar/17

                  Agile