HI, Good day
I have just upgraded mariadb from 5.6 to 10.
Now I have problems in PBX Configuration,
I have checked the tables and not changed any colunms.
Currently - PHP 5.4.16
Currently - 10.2.36-MariaDB MariaDB Server
Old - 5.5.6-MariaDB MariaDB Server
Every configurations where there is Integer Colunm show me error like below:
FATAL ERROR
INSERT INTO queues_config ( extension, descr, grppre, alertinfo, joinannounce_id, ringing, agentannounce_id, maxwait, password, ivr_id, callback_id, dest, destcontinue, cwignore, qregex, queuewait, use_queue_context, togglehint, qnoanswer, callconfirm, callconfirm_id, monitor_type, monitor_heard, monitor_spoken) VALUES ( '76', 'a', '', '', '0', '0', '', '', '', 'none', 'none', '', '', '0', '', '0', '0', '0', '0', '0', '0', '', '0', '0') [nativecode=1366 Incorrect integer value: '' for column asterisk.queues_config.agentannounce_id at row 1]SQL -
INSERT INTO queues_config ( extension, descr, grppre, alertinfo, joinannounce_id, ringing, agentannounce_id, maxwait, password, ivr_id, callback_id, dest, destcontinue, cwignore, qregex, queuewait, use_queue_context, togglehint, qnoanswer, callconfirm, callconfirm_id, monitor_type, monitor_heard, monitor_spoken) VALUES ( '76', 'a', '', '', '0', '0', '', '', '', 'none', 'none', '', '', '0', '', '0', '0', '0', '0', '0', '0', '', '0', '0')
Trace Back
/var/www/html/admin/libraries/sql.functions.php:25 die_issabelpbx()
/var/www/html/admin/modules/queues/functions.inc/geters_seters.php:228 sql()
/var/www/html/admin/modules/queues/page.queues.php:169 queues_add()
2:
[3]:
[4]:
[5]:
[7]:
[9]:
[10]:
[12]:
[15]:
[21]:
/var/www/html/modules/pbxadmin/libs/contentIssabelPBX.php:499 include()
/var/www/html/modules/pbxadmin/index.php:29 getContent()
0:
/var/www/html/libs/paloSantoNavigation.class.php:264 _moduleContent()
0:
/var/www/html/libs/paloSantoNavigation.class.php:228 paloSantoNavigation->includeModule()
/var/www/html/index.php:301 paloSantoNavigation->showContent()
