How to fix the error "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'fieldid' cannot be null (SQL: insert into `tblcustomfieldsvalues` (`value`, `relid`, `fieldid`) values (360, 64580, ?))"?
Scenario:
This is an error faced while you are trying to automate the Virtualizor VPS deployment, by the settings packages at WHMCS.
Order Accept Encountered Problems
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'fieldid' cannot be null (SQL: insert into `tblcustomfieldsvalues` (`value`, `relid`, `fieldid`) values (360, 64580, ?))
Fix:
You need to add a custom field under the Products/Services of that particular package as mentioned in the below image. Once you add the details to this custom field your issue will be resolved.
That's it !!!