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

Răspunsul a fost util? 0 utilizatori au considerat informația utilă (0 Voturi)