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
Activity
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
| Sprint | 5.3.0 Sprint 1 [ 138 ] |
| Rank | Ranked higher |
| Assignee | Abdy Franco [ abdy ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 28 minutes [ 1680 ] | |
| Worklog Id | 15276 [ 15276 ] |
| Status | In Progress [ 3 ] | In Review [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Status | In Review [ 5 ] | Closed [ 6 ] |
