zooky

PHP is at 7.4.16

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

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 ) )