asterisk2billing.org http://forum.asterisk2billing.org/ |
|
Unable to create new rates http://forum.asterisk2billing.org/viewtopic.php?f=34&t=12593 |
Page 1 of 1 |
Author: | spectris [ Mon Oct 10, 2016 8:23 am ] |
Post subject: | Unable to create new rates |
Hi all I'm having this issue on a fresh install performed using INSTALL.rst procedure . I'm using UBUNTU 16.06 + php 7 + apache + mysql 5.7 , a2billing 2.2.0 When I try to add a new customer or after filling the fields , I receive the "Your card cannot be inserted" message. Php logs are not telling me too much .. simply no error raised after click"confirm data " on the new customer form. So I enabled all the logs on mysql side and I discovered for example that the new rate form php script is performing a sql INSERT query with musiconhold field not valued : this will fail becasue the field value is defined as "cannot be null" in database schema. here I solved enabling the "advance mode " so also musiconhold field is visualized in the filling form for new rates. The first question is : if musiconhold filed cannot be null and the form is trying to perform an insert with that field valued , why the basic form is not showing this field? I have a doubt maybe my installation is not correctly setup ? Or maybe it is a bug? please let me know how to proceed thanks |
Author: | spectris [ Mon Oct 10, 2016 5:41 pm ] |
Post subject: | Re: Unable to create new rates |
solved by lams . new mysql installation can default slq_mode to STRICT_TABLES. [url] viewtopic.php?f=33&t=12569[/url] |
Page 1 of 1 | All times are UTC |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |