Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.2.0-b1
-
Component/s: None
-
Labels:None
Description
This error is becoming increasingly common:
importContacts: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'client_id' cannot be null on line 196
In plugins/import_manager/components/whmcs/whmcs_migrator.php around line 448 change from:
foreach ($contacts as $contact) { $vars = [ 'client_id' => isset($this->mappings['clients'][$contact->userid]) ? $this->mappings['clients'][$contact->userid] : null,
To
foreach ($contacts as $contact) { if (!isset($this->mappings['clients'][$contact->userid])) { continue; } $vars = [ 'client_id' => $this->mappings['clients'][$contact->userid],
Since client_id cannot be null