Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Tue Mar 19, 2024 8:53 am
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Unable to create new rates
PostPosted: Mon Oct 10, 2016 8:23 am 
Offline

Joined: Mon Oct 10, 2016 8:05 am
Posts: 11
Location: Italy
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


Top
 Profile  
 
 Post subject: Re: Unable to create new rates
PostPosted: Mon Oct 10, 2016 5:41 pm 
Offline

Joined: Mon Oct 10, 2016 8:05 am
Posts: 11
Location: Italy
solved by lams .
new mysql installation can default slq_mode to STRICT_TABLES.
[url]
viewtopic.php?f=33&t=12569[/url]


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
Voice Broadcast System


All times are UTC


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group