Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 5:09 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Your new Card hasn't been inserted.
PostPosted: Wed Aug 31, 2016 3:15 am 
Offline

Joined: Sat Aug 20, 2016 4:38 pm
Posts: 11
A2billing 2.2; Debian 8, Mysql 5.7

Unable to add new customer or new rates; I get these errors
Your new Card hasn't been inserted.
Your new rate hasn't been inserted.

Seems like a VERY longstanding problem with A2billing - for over 10 years on this forum - yet I have not seen a closure on this issue.

I have implemented two prior 'solutions':
changed my.cnf to have:
thread_stack=256K

I have also got mysql upto date.

Still no solution - 10 year old problem!


Top
 Profile  
 
 Post subject: Re: Your new Card hasn't been inserted.
PostPosted: Thu Sep 01, 2016 10:08 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi

In 10 years of installations, I've not had that problem on a fresh install.

Enable PHP Quick profiler to see what queries are being executed, then run them manually in the MySQL console, this will give you an error message which you can use to diagnose your problem.

It's in ./common/lib/admin.defines.php, PHP_QUICK_PROFILER = true (default is false)

Joe


Top
 Profile  
 
 Post subject: Re: Your new Card hasn't been inserted.
PostPosted: Fri Sep 02, 2016 3:26 am 
Offline

Joined: Sat Aug 20, 2016 4:38 pm
Posts: 11
Thanks Joe,

I will try this out and post an update.


Top
 Profile  
 
 Post subject: Re: Your new Card hasn't been inserted.
PostPosted: Mon Sep 12, 2016 12:23 am 
Offline

Joined: Sat Aug 20, 2016 4:38 pm
Posts: 11
Thanks Joe.

I was able to trace the problem to a database default sql_mode of 'STRICT_TRANS_TABLES'. After removing this and restarting mysql, I was able to set rates and add customers.

Php quick profiler was helpful in identifying an 'insert' sql command not executing because of this sql_mode setting.


Top
 Profile  
 
 Post subject: Re: Your new Card hasn't been inserted.
PostPosted: Mon Oct 10, 2016 5:35 pm 
Offline

Joined: Mon Oct 10, 2016 8:05 am
Posts: 11
Location: Italy
Many thanks for that solution it worked for me too


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 
Predictive Dialer


All times are UTC


Who is online

Users browsing this forum: No registered users and 13 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:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group