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

Import Manager: Add support for WHMCS 8

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.12.1
    • Fix Version/s: Short Term
    • Component/s: Plugins
    • Labels:
      None

      Description

      The import manager no longer works for WHMCS version 8, probably due to changed implemented in that version that affect users.

      Staff users are imported, but that's all.

      Logs written during import:

      ==> /general-info-2020-10-19.log <==
      [2020-10-19 20:18:52] general.INFO: Created Staff

      {"user_id":"3","first_name":"Admin","last_name":"Two","email":"email@address.com","status":"active","id":"2"}

      [2020-10-19 20:18:52] general.INFO: Created Staff

      {"user_id":"4","first_name":"Admin","last_name":"Three","email":"email2@address.com","status":"active","id":"3"}

      The following errors are displayed on the page:

      The import completed but the following errors ocurred:

      importClients: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY' on line 196

      importContacts: There is already an active transaction on line 231

      importTaxes: There is already an active transaction on line 231

      importCurrencies: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

      importInvoices: There is already an active transaction on line 231

      importTransactions: There is already an active transaction on line 231

      importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

      importPackageOptions: There is already an active transaction on line 231

      importServices: There is already an active transaction on line 231

      importSupportDepartments: There is already an active transaction on line 231

      importSupportTickets: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #29 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'blestau_whmcs.tbladmins.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on line 196

      importAffiliates: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tbltickets.admin' in 'on clause' on line 196

      importMisc: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `tbltickets`, `tblaffiliates`, `tblconfiguration` LEFT JOIN `tbladmins` O' at line 1 on line 196

        Activity

        Hide
        admin Paul Phillips added a comment -

        The importer should be backwards compatible with versions < 8, so if we need to add another link besides "5.2" for which the importer was originally designed, we should do that.. and if so, rename 5.2 to "5.2-7.10"

        Show
        admin Paul Phillips added a comment - The importer should be backwards compatible with versions < 8, so if we need to add another link besides "5.2" for which the importer was originally designed, we should do that.. and if so, rename 5.2 to "5.2-7.10"

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 1 day, 1 hour, 53 minutes
              1d 1h 53m