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

Was this answer helpful? 2 Users Found This Useful (2 Votes)