Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 12:37 pm
Voice Broadcast System


All times are UTC




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: v2.0 upgrade. e-mail templates and SIP account corruption
PostPosted: Tue Nov 13, 2012 10:21 am 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
I'm doing some testing upgrading systems to v2.0 (from 1.9.4) and have seen a couple of issues.

1 - After the upgrade when saving an e-mail template newlines characters are replaced with '\r\n\r\n'. They are stored in the database this way and also appear like that on e-mails that are sent out.

2 - Existing VOIP/SIP account details seem to get messed up as part of the upgrade process. I'm guessing maybe as a database table change. The NAT setting has unknown characters on the end '�����������'. When removing these and saving the changes the characters then appear in the DEFAULTIP and IPADDR boxes. After deleting these characters and saving the account seems to work correctly.

Anyone else seen the same?


Top
 Profile  
 
 Post subject: Re: v2.0 upgrade. e-mail templates and SIP account corruption
PostPosted: Wed Nov 14, 2012 1:06 am 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
to answer my own question ...

Seems the database update script is not converting the columns to UTF-8 correctly. Either that or there's some weird data in my tables. Fields were ending up padded with null characters (\0), this sorted out the issue -

mysql -p
use mya2billing;
update cc_sip_buddies set nat = replace(nat,'\0','');
update cc_sip_buddies set DEFAULTip = replace(DEFAULTip,'\0','');
update cc_sip_buddies set ipaddr = replace(ipaddr,'\0','');
update cc_sip_buddies set host = replace(host,'\0','');

As always - back up your data beforehand!

As for the e-mail templates it seems like it does it on the demo system here also, so it's either by design, and the mailer should be converting them back, or it's a bug.


Top
 Profile  
 
 Post subject: Re: v2.0 upgrade. e-mail templates and SIP account corruption
PostPosted: Wed Nov 14, 2012 1:49 am 
Offline

Joined: Mon Apr 14, 2008 8:37 pm
Posts: 356
Location: Canada
Good info... I need to consider this cos we're thinking of upgrading, but some major user interface flaws keep me from moving on -.-


Top
 Profile  
 
 Post subject: Re: v2.0 upgrade. e-mail templates and SIP account corruption
PostPosted: Wed Nov 14, 2012 11:04 am 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
I just made a new release where #1 is fixed :
https://github.com/Star2Billing/a2billi ... ad4214e91f

Download v2.0.1 from here :
http://www.asterisk2billing.org/get-sta ... -download/

I cannot reproduce #2, I think that could be related to the charset of your DB.

Yours,
/Areski


Top
 Profile  
 
 Post subject: Re: v2.0 upgrade. e-mail templates and SIP account corruption
PostPosted: Wed Nov 14, 2012 11:06 am 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
Hi Areski

Thanks for the quick respose - Matt


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 9 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