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

Import Manager: Update the "Import Affiliates" task

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.11.2
    • Component/s: Plugins
    • Labels:
      None

      Description

      In CORE-3656 the "visits" and "referrals" columns were removed from the "order_affiliates" table and instead replaced by the "order_affiliate_statistics" table which stores statistics in a more accurate and efficient manner.

      However, the Import Manager plugin was not updated to reflect this change and when the task is executed it throws a SQL-related error:

      importAffiliates: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'visits' in 'field list' on line 196
      importMisc: There is already an active transaction on line 231
      

        Activity

        abdy Abdy Franco created issue -
        abdy Abdy Franco made changes -
        Field Original Value New Value
        Rank Ranked higher
        jonathan Jonathan Reissmueller made changes -
        Fix Version/s 4.11.2 [ 11508 ]
        Fix Version/s 4.12.0-b1 [ 11502 ]
        jonathan Jonathan Reissmueller made changes -
        Sprint 4.12.0 Sprint 3 [ 115 ]
        jonathan Jonathan Reissmueller made changes -
        Rank Ranked lower
        abdy Abdy Franco made changes -
        Assignee Abdy Franco [ abdy ]
        Automated transition triggered when Abdy Franco created a branch in Stash -
        Status Open [ 1 ] In Progress [ 3 ]
        abdy Abdy Franco made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 4 hours, 5 minutes [ 14700 ]
        Worklog Id 13997 [ 13997 ]
        Automated transition triggered when Abdy Franco created pull request #20 in Stash -
        Status In Progress [ 3 ] In Review [ 5 ]
        Resolution Fixed [ 1 ]
        jonathan Jonathan Reissmueller made changes -
        Time Spent 4 hours, 5 minutes [ 14700 ] 4 hours, 35 minutes [ 16500 ]
        Worklog Id 14002 [ 14002 ]
        Automated transition triggered when Jonathan Reissmueller merged pull request #20 in Stash -
        Status In Review [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            abdy Abdy Franco
            Reporter:
            abdy Abdy Franco
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              24/Aug/20

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 4 hours, 35 minutes
              4h 35m

                Agile