Remote API client_add stopped works after upgrade.
Summary
I upgraded to Debian 10 then remote API stopped work.
SoapFault exception: [database_error] Data truncated for column 'limit_cron_type' at row 1
Seems to related issue #6282 .
Steps to reproduce
- call API with $c_id = $connection[0]->client_add($connection[1], $reseller_id, $params); without parameter 'limit_cron_type'.
Correct behaviour
Create a client.
Environment
Server OS + version: Debian 10 ISPConfig version: 3.2.7p1 DB: MariaDB 10.3.31 database server PHP version: 7.4
Proposed fix
Added parameter 'limit_cron_type' with the value. Then it worked. 'limit_cron_type' => 'url'
Related log entries
SoapFault exception: [database_error] Data truncated for column 'limit_cron_type' at row 1 INSERT INTO
client (
company_name,
gender,
contact_firstname,
contact_name,
customer_no,
username,
password,
language,
usertheme,
street,
zip,
city,
state,
country,
telephone,
mobile,
fax,
email,
internet,
icq,
vat_id,
company_id,
bank_account_owner,
bank_account_number,
bank_code,
bank_name,
bank_account_iban,
bank_account_swift,
notes,
paypal_email,
locked,
canceled,
added_date,
added_by,
template_master,
template_additional,
default_mailserver,
mail_servers,
limit_maildomain,
limit_mailbox,
limit_mailalias,
limit_mailaliasdomain,
limit_mailmailinglist,
limit_mailforward,
limit_mailcatchall,
limit_mailrouting,
limit_mail_wblist,
limit_mailfilter,
limit_fetchmail,
limit_mailquota,
limit_spamfilter_wblist,
limit_spamfilter_user,
limit_spamfilter_policy,
limit_mail_backup,
limit_relayhost,
default_xmppserver,
xmpp_servers,
limit_xmpp_domain,
limit_xmpp_user,
limit_xmpp_muc,
limit_xmpp_anon,
limit_xmpp_vjud,
limit_xmpp_proxy,
limit_xmpp_status,
limit_xmpp_pastebin,
limit_xmpp_httparchive,
default_webserver,
web_servers,
limit_web_domain,
limit_web_quota,
web_php_options,
limit_cgi,
limit_ssi,
limit_perl,
limit_ruby,
limit_python,
force_suexec,
limit_hterror,
limit_wildcard,
limit_ssl,
limit_ssl_letsencrypt,
limit_web_aliasdomain,
limit_web_subdomain,
limit_ftp_user,
limit_shell_user,
ssh_chroot,
limit_webdav_user,
limit_backup,
limit_directive_snippets,
default_dnsserver,
dns_servers,
limit_dns_zone,
default_slave_dnsserver,
limit_dns_slave_zone,
limit_dns_record,
limit_client,
default_dbserver,
db_servers,
limit_database,
limit_database_user,
limit_database_quota,
limit_cron,
limit_cron_type,
limit_cron_frequency,
limit_traffic_quota,
limit_openvz_vm,
limit_openvz_vm_template_id,
limit_aps,
sys_userid,
sys_groupid,
sys_perm_user,
sys_perm_group,
sys_perm_other) VALUES ('', '', '', 'Client Name', '', 'username', 'abc', 'en', 'default', 'address1', '', 'city', '', 'MN', '', 'tel', '', 'email@gmail.com', '', '', '', '', '', '', '', '', '', '', '', '', 'n', 'n', NULL, '', '11', '', '1', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'n', 'n', '0', '', '0', '0', 'n', 'n', 'n', 'n', 'n', 'n', 'n', '2', '', '0', '0', 'no,fast-cgi,cgi,mod,php-fpm', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', '0', '0', '0', '0', 'no', '0', 'n', 'n', '2', '', '0', '1', '0', '0', '0', '2', '', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '1', '1', 'riud', 'riud', '')