Hi there,
when trying to insert a new TXT record to a DNS zone using https://xxxx.xxxx.de:8080/remote/json.php?dns_txt_add , I get the following error message as part of the returned JSON:
Incorrect integer value: '' for column
Querying the zone is working fine!
Also, I do not see any other error message (e. g. in some ISPConfig log file) or I'm looking at the wrong place.
Some time ago, the system had been updated (server OS including PHP and database) to a more recent version of Ubuntu.
It might have to do with that upgrade, but I cannot figure out where to start searching.
Any ideas?
During parsing the log files, I saw another strange phenomenon. This line is logged every some seconds:
mod_fcgid: stderr: PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /usr/local/ispconfig/interface/lib/config.inc.php on line 48, referer: https://xxxx.xxxx.de:8080/
Any idea where this might come from?
Any idea on how to get rid of the message?
Going back to an earlier version of Ubuntu is not an option, unfortunately...
Btw, how can I change the PHP version ISPConfig is using?
Best regards,
Tom
when trying to insert a new TXT record to a DNS zone using https://xxxx.xxxx.de:8080/remote/json.php?dns_txt_add , I get the following error message as part of the returned JSON:
Incorrect integer value: '' for column
dbispconfig
.dns_rr
.sys_userid
at row 1 INSERT INTO dns_rr
(server_id
, zone
, name
, type
, data
, ttl
, active
, stamp
, serial
, sys_userid
, sys_groupid
, sys_perm_user
, sys_perm_group
, sys_perm_other
) VALUES ('1', '15', 'some.zone.de.', 'txt', '12345', '3600', 'y', '2020-01-22 16:14:14', '1579706054', '', '', 'riud', 'riud', '')Querying the zone is working fine!
Also, I do not see any other error message (e. g. in some ISPConfig log file) or I'm looking at the wrong place.
Some time ago, the system had been updated (server OS including PHP and database) to a more recent version of Ubuntu.
It might have to do with that upgrade, but I cannot figure out where to start searching.
Any ideas?
During parsing the log files, I saw another strange phenomenon. This line is logged every some seconds:
mod_fcgid: stderr: PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /usr/local/ispconfig/interface/lib/config.inc.php on line 48, referer: https://xxxx.xxxx.de:8080/
Any idea where this might come from?
Any idea on how to get rid of the message?
Going back to an earlier version of Ubuntu is not an option, unfortunately...
Btw, how can I change the PHP version ISPConfig is using?
Best regards,
Tom