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

Unable to generate the Tax Liability Report due to an error

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 4.3.0
        • Fix Version/s: 4.4.0-b1
        • Component/s: None
        • Labels:
          None

          Description

          The Tax Liability Report under Billing > Reports cannot be generated because it produces the following error:

          SQLSTATE[42S22]: Column not found: 1054 Unknown column 'temp.id' in 'order clause' on line 196 in /public_html/vendors/minphp/db/src/PdoConnection.php

          The report is attempting to order by a column that is not selected.

          See https://www.blesta.com/forums/index.php?/topic/11893-tax-liability-report-wont-generate-blesta-432/

            Activity

            Ascending order - Click to sort in descending order
            tyson Tyson Phillips (Inactive) created issue -
            tyson Tyson Phillips (Inactive) made changes -
            Field Original Value New Value
            Rank Ranked higher
            tyson Tyson Phillips (Inactive) made changes -
            Sprint 4.4.0 Sprint 3 [ 59 ]
            tyson Tyson Phillips (Inactive) made changes -
            Rank Ranked higher
            Automated transition triggered when Tyson Phillips (Inactive) created a branch in Stash -
            Status Open [ 1 ] In Progress [ 3 ]
            tyson Tyson Phillips (Inactive) made changes -
            Description The Tax Liability Report under *Billing > Reports* cannot be generated because it produces the following error:

            {quote}
            SQLSTATE[42S22]: Column not found: 1054 Unknown column 'temp.id' in 'order clause' on line 196 in /public_html/vendors/minphp/db/src/PdoConnection.php
            {quote}

            The report is attempting to order by a column that is not selected.             		The Tax Liability Report under *Billing > Reports* cannot be generated because it produces the following error:

            {quote}
            SQLSTATE[42S22]: Column not found: 1054 Unknown column 'temp.id' in 'order clause' on line 196 in /public_html/vendors/minphp/db/src/PdoConnection.php
            {quote}

            The report is attempting to order by a column that is not selected.

            See https://www.blesta.com/forums/index.php?/topic/11893-tax-liability-report-wont-generate-blesta-432/
            Automated transition triggered when Tyson Phillips (Inactive) created pull request #527 in Stash -
            Status In Progress [ 3 ] In Review [ 5 ]
            Resolution Fixed [ 1 ]
            tyson Tyson Phillips (Inactive) made changes -
            Sprint 4.4.0 Sprint 3 [ 59 ] 4.4.0 Sprint 3, 4.4.0 Sprint 4 [ 59, 71 ]
            tyson Tyson Phillips (Inactive) made changes -
            Rank Ranked higher
            Automated transition triggered when Tyson Phillips (Inactive) merged pull request #527 in Stash -
            Status In Review [ 5 ] Closed [ 6 ]

              People

              • Assignee:
                tyson Tyson Phillips (Inactive)
                Reporter:
                tyson Tyson Phillips (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  22/Oct/18

                  Agile