Whmcs Migrator - Failed

[locthb]

Array(    [error] => Array        (            [0] => The import completed but the following errors ocurred:            [1] => importPackages: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'term' in 'field list' on line 124            [2] => importServices: There is already an active transaction on line 163            [3] => importSupportDepartments: There is already an active transaction on line 163            [4] => importSupportTickets: There is already an active transaction on line 163            [5] => importMisc: There is already an active transaction on line 163        ))

Blesta 3.1 beta

Help me.

[Michael]

Have you got two transactions with the same ID on WHM**?

[Paul]

Did you run the migrator twice?

 

You'll need to re-install Blesta before attempting another import. What we recommend is after installing 3.0, do a backup of your 3.0 database. Then, do the import. If for any reason you need to run the importer again, first restore your 3.0 database.

 

Importing to a clean database is the only supported import method.

[locthb]

I tried more than 10 times. Every time I have a new installation blasta.

[medfordite]

What version of WHMCS are you importing from?

 

They might have dropped a column depending on the version.  I am basing this on your error:

  [1] => importPackages: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'term' in 'field list' on line 124

Like others are suggesting is that if you are getting an "Already" exists type of error, this means there is a duplicate somewhere.  Also, remember that 3.1 is not ready for production so it may have issues.   If you are wanting to run Production, you might want to drop down to 3.0.7 which is the most current release at the moment.

[locthb]

Test on Blesta 3.0.7 ok. But not import domains service.

[Cody]

Sounds like it could be an issue with an older version of the migrator. Did you use the migrator included in the 3.1.0-b1 installation, or the one downloaded from the forums?

You should use the one included with 3.1.0-b1.

[pcfacility]

Hello,

 

I have the same error with blesta beta 2 (fresh install) and whmcs 5.2.15.

[Michael]

I wonder if WHM** changed something in their 5.2.15 to try and secure a few issues, and that's mucked something up.

[Cody]

I've confirmed the issue and am working on a fix.

[Cody]

Here's the solution. In /plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php change:

            if (version_compare(BLESTA_VERSION, "3.1.0", ">=")) {

To:

            if (version_compare(BLESTA_VERSION, "3.1.0-b1", ">=")) {

This fix will be included in 3.1.0 (CORE-969).

[locthb]

can not import into blesta. "tbldomainpricing, tbldomains"

 

(Blesta 3.1-b2)

[Cody]

 

 

can not import into blesta. "tbldomainpricing, tbldomains"

 

(Blesta 3.1-b2)

 

 

Your image doesn't work, and there's not much to go on from what you wrote.

 

What version of WHMCS, PHP, and MySQL are you running? What was the error you received? Did you run the migration with debug enabled?