asterisk2billing.org
http://forum.asterisk2billing.org/

Your new Card hasn't been inserted.
http://forum.asterisk2billing.org/viewtopic.php?f=33&t=12569		 Page 1 of 1
Author:  lams [ Wed Aug 31, 2016 3:15 am ]
Post subject:  Your new Card hasn't been inserted.
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!
Author:  jroper [ Thu Sep 01, 2016 10:08 am ]
Post subject:  Re: Your new Card hasn't been inserted.
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
Author:  lams [ Fri Sep 02, 2016 3:26 am ]
Post subject:  Re: Your new Card hasn't been inserted.
Thanks Joe,

I will try this out and post an update.
Author:  lams [ Mon Sep 12, 2016 12:23 am ]
Post subject:  Re: Your new Card hasn't been inserted.
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.
Author:  spectris [ Mon Oct 10, 2016 5:35 pm ]
Post subject:  Re: Your new Card hasn't been inserted.
Many thanks for that solution it worked for me too
Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/