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

        There are no comments yet on this issue.

          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