[Migrating from WHMCS - Import Errors]

PHP is at 7.4.16

[Migrating from WHMCS - Import Errors]

What would be the best way to check null client_id’s?

general error log - looks like i may have a permission problem on my copied DB?

[2021-04-10T03:05:30.925713+00:00] general.ERROR: PDOException: SQLSTATE[HY000] [1044] Access denied for user 'XXXXX'@'localhost' to database 'whmcs_copy' in /xxxxx/customers/vendors/minphp/db/src/PdoConnection.php:329 Stack trace: #0 /xxxx/customers/vendors/minphp/db/src/PdoConnection.php(329): PDO->__construct('mysql:host=loca...', 'xxxxx', 'xxxXXxx', Array) #1 /xxxxxxx/customers/vendors/minphp/db/src/PdoConnection.php(114): Minphp\Db\PdoConnection->makeConnection('mysql:host=loca...', 'xxxx', 'xxXXxx', Array) #2 /xxxxx/customers/vendors/minphp/db/src/PdoConnection.php(190): Minphp\Db\PdoConnection->connect() #3 /xxxxx/customers/vendors/minphp/record/src/Record.php(834): Minphp\Db\PdoConnection->query('SELECT * FROM `...', Array) #4 /xxxxx/customers/plugins/import_manager/components/migrators/whmcs/8.0/models/whmcs_products.php(20): Minphp\Record\Record->getStatement() #5 /xxxxx/customers/plugins/import_manager/components/migrators/whmcs/8.0/whmcs8_0.php(157): WhmcsProducts->get() #6 /xxx/customers/plugins/import_manager/controllers/admin_manage_plugin.php(94): Whmcs8_0->getConfiguration(Array) #7 /xxxxx/customers/app/controllers/admin_company_plugins.php(141): AdminManagePlugin->import() #8 /xxxxx/customers/vendors/minphp/bridge/src/Lib/Dispatcher.php(142): AdminCompanyPlugins->manage() #9 /xxxxx/customers/index.php(21): Dispatcher::dispatch('/customers/admi...') #10 {main}  

 

Other logs attached.

general-notice-2021-04-10.log general-warning-2021-04-10.log

[Migrating from WHMCS - Import Errors]

Hello,

I am testing out Blesta and trying to import data from my WHMCS 8.1.2 installation.  I have created a copy of the WHMCS DB.

I am getting the below errors.  If I keep trying and then go back to the admin area, I can see clients, details, transactions etc, but don't quite trust the import.  I've also done the "password change" in the blesta.php file but the test WHMCS client I have cannot login, doesn't matter what combo I use (username and/or email) unless I reset the password.

Is there is a way to check "line 196" or what client doesn't have a "client id"?

 

importStaff
-----------------
importStaff took: 0.9778 seconds
-----------------

importClients
-----------------
importClients took: 0.6809 seconds
-----------------

importContacts
-----------------
importTaxes
-----------------
importCurrencies
-----------------
importInvoices
-----------------
importTransactions
-----------------
importPackages
-----------------
importPackageOptions
-----------------
importPackageOptions took: 0.0007 seconds
-----------------

importServices
-----------------
importSupportDepartments
-----------------
importSupportTickets
-----------------
importAffiliates
-----------------
importMisc
-----------------
decrypted 0 values using WHMCS' custom algorithm
decrypt took: 0 seconds
total time took: 1.7446 seconds
Array
(
    [error] => Array
        (
            [0] => 
            [1] => importContacts: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'client_id' cannot be null on line 196
            [2] => importTaxes: There is already an active transaction on line 231
            [3] => importCurrencies: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [4] => importInvoices: There is already an active transaction on line 231
            [5] => importTransactions: There is already an active transaction on line 231
            [6] => importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [7] => importServices: There is already an active transaction on line 231
            [8] => importSupportDepartments: There is already an active transaction on line 231
            [9] => importSupportTickets: There is already an active transaction on line 231
            [10] => importAffiliates: There is already an active transaction on line 231
            [11] => importMisc: There is already an active transaction on line 231
        )

)