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

Duplicate entry in mysql database
http://forum.asterisk2billing.org/viewtopic.php?f=34&t=7143		 Page 1 of 1
Author:  bruce [ Fri Feb 19, 2010 11:42 pm ]
Post subject:  Duplicate entry in mysql database
After running a2billing-schema-v1.4.0.sql one runs into this for running the prefix-schema:

Code:
# mysql mya2billing -ua2billinguser -pa2billing < a2billing-schema-v1.4.0.sql
# mysql mya2billing -ua2billinguser -pa2billing < a2billing-prefix-table-v1.4.0.sql
ERROR 1062 (23000) at line 50: Duplicate entry '93' for key 1
Author:  areski [ Sat Feb 20, 2010 2:06 am ]
Post subject:  Re: Duplicate entry in mysql database
You should not apply the prefix script, a2billing-schema-v1.4.0.sql already contains them.

/Areski
Author:  bruce [ Sat Feb 20, 2010 3:53 pm ]
Post subject:  Re: Duplicate entry in mysql database
Thanks Areski.

Quick comment on this though. Why not just delete that file form the package then so that people don't get confused. If it's in the schema file then no need for the prefix file. right?!
Author:  jroper [ Sat Feb 20, 2010 7:14 pm ]
Post subject:  Re: Duplicate entry in mysql database
Hi

The prefix file is required for upgrade from 1.3.4 to 1.4 onwards.

Joe
Author:  Woolmer [ Sat Mar 28, 2015 5:25 pm ]
Post subject:  Re: Duplicate entry in mysql database
The system should share the same config files, we might want to create sip/iax_additional_a2billing.conf under an unique name for each A2Billing installation. Installation might have an unique A2Billing Instance Name, this could be generated at installation time.
Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/