Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Mon Dec 11, 2017 5:01 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Duplicate entry in mysql database
PostPosted: Fri Feb 19, 2010 11:42 pm 
Offline

Joined: Wed Mar 15, 2006 11:58 pm
Posts: 325
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


Top
 Profile  
 
 Post subject: Re: Duplicate entry in mysql database
PostPosted: Sat Feb 20, 2010 2:06 am 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
You should not apply the prefix script, a2billing-schema-v1.4.0.sql already contains them.

/Areski


Top
 Profile  
 
 Post subject: Re: Duplicate entry in mysql database
PostPosted: Sat Feb 20, 2010 3:53 pm 
Offline

Joined: Wed Mar 15, 2006 11:58 pm
Posts: 325
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?!


Top
 Profile  
 
 Post subject: Re: Duplicate entry in mysql database
PostPosted: Sat Feb 20, 2010 7:14 pm 
Offline

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

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

Joe


Top
 Profile  
 
 Post subject: Re: Duplicate entry in mysql database
PostPosted: Sat Mar 28, 2015 5:25 pm 
Offline

Joined: Sat Mar 28, 2015 5:23 pm
Posts: 1
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 
VoIP Billing solution


All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


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