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/