Missing 'pm' column when adding web site from examples/

am working on getting a website installed via the remote API. Using the examples in

Code:

sites_web_domain_add.php

I came across the following error:

Code:

Data truncated for column 'pm' at row 1 INSERT INTO `web_domain` (...

Now the value was

Code:

''

This confused me until I realised the column wasn't even sent. The defaults were taken from the examples/ directory, so the missing column was being generated from the database defaults, which did of course not exist, and it's an ENUM. Just FYI, maybe something to fix?

 

in case someone stumbled across this while searching for the same error.
i encountered this while adding cwispy/ispcfg3 module to WHMCS
was unable to add website from the client panel of ispcfg3 model tools
had to comment out pm field in web_vhost_domain.tform.php
Thank you Richard for pointing out the source of the issue

 

@jesse, your absolutely right, and will be done when migrating to production, i am not a developer so had to find the logic on this to test some functionalities
And yes, the 'pm' field has a default this is why it worked
Thank you

 

Issue fixed by setting sql to strict mode
sql_mode=NO_ENGINE_SUBSTITUTION
Seems i have missed this step somewhere along the way while setting up ISPconfig