Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 10:05 pm
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 24 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Rates Batch Update
PostPosted: Fri Aug 07, 2009 5:27 pm 
Offline

Joined: Sat May 17, 2008 2:01 am
Posts: 26
Hi,

I`m having some trouble when I try to change all rates of one ratecard.

I go to Rates > Rates

Select the ratecard who I want to change the default Trunk.

go to Batch update,

select the box "Trunk" and select the new trunk for that rates, and do "Batch update ratecard"

then a error is showed up: "Could not perform the batch update!"

What is happening?

thanks


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Fri Aug 07, 2009 7:30 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
I just tried and it works fine for me!

/Areski


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Fri Aug 07, 2009 7:34 pm 
Offline

Joined: Sat May 17, 2008 2:01 am
Posts: 26
not for me ... i tried in another ratecard ... and the error persist... :(

what i doing wrong ... :(


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Sun Aug 09, 2009 11:58 pm 
Offline

Joined: Sat Aug 16, 2008 3:31 pm
Posts: 12
areski wrote:
I just tried and it works fine for me!

/Areski


Doesn't work to me. I enabled class table debug and catched the executed query. Rerun of the query in mysql gives error:

Code:
mysql> UPDATE cc_tariffgroup RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan ) LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id SET rateinitial = rateinitial +'0.005' WHERE cc_tariffgroup.id= '1' AND cc_ratecard.rateinitial = (SELECT min(c1.rateinitial) FROM cc_tariffgroup RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan ) LEFT JOIN cc_ratecard AS c1 ON c1.idtariffplan=cc_tariffplan.id WHERE cc_tariffgroup.id= '1' AND cc_ratecard.dialprefix=c1.dialprefix);
ERROR 1093 (HY000): You can't specify target table 'cc_tariffgroup' for update in FROM clause
mysql>


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 2:53 am 
Offline

Joined: Thu Mar 27, 2008 11:37 am
Posts: 111
Hi
i also have the same issue, anytime i want to do rate batch update
got message: could not perfom the bacth update


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 8:03 am 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
Can you try with the last trunk version and tell us how it goes,
plus the exact way to reproduce.

Yours,
/Areski


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 11:34 am 
Offline

Joined: Sat Aug 16, 2008 3:31 pm
Posts: 12
areski wrote:
Can you try with the last trunk version and tell us how it goes,
plus the exact way to reproduce.

Yours,
/Areski


In rates I selected a rate card, then selected a range of prefixes (search by prefix) and in batch update I specified "add 0.005 to sell rates".


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 12:36 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
please try with the last revision so that we know.

Cheers,
/Areski


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 12:42 pm 
Offline

Joined: Sat May 17, 2008 2:01 am
Posts: 26
Hi Areski and all.

I dont know why, but i have tried today change the rate/trunk and worked.

I try just selecting the tarrifgroup and perform a batch update and worked out ... then i do a Prefix filter, and try change rate/trunk and worked too ...

i dont know how worked, because i dont do nothing in server, apache or php configs.


:)

try and post the results.


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 12:44 pm 
Offline

Joined: Sat Aug 16, 2008 3:31 pm
Posts: 12
areski wrote:
please try with the last revision so that we know.

Cheers,
/Areski


Which files to pick up from SVN? I don't want to update the entire 1.4.1 installation now.


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 12:49 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
you can try on an other installation!


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 12:50 pm 
Offline

Joined: Sat Aug 16, 2008 3:31 pm
Posts: 12
willianmazzardo wrote:
I dont know why, but i have tried today change the rate/trunk and worked.


Do you use mysql or postgress?


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 2:40 pm 
Offline

Joined: Sat Aug 16, 2008 3:31 pm
Posts: 12
areski wrote:
you can try on an other installation!

Same error with trunk version.


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 4:09 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
Hi sokhapkin,
According to your SQL debug, I might believe that you ran an LCR export prior running the batch update,
this will have been useful information to know at first.

I just made a commit (rev 2295) now to disable the batch update if the LCR export is active.

/Areski


Top
 Profile  
 
 Post subject: Re: Rates Batch Update
PostPosted: Mon Aug 10, 2009 4:46 pm 
Offline

Joined: Sat Aug 16, 2008 3:31 pm
Posts: 12
areski wrote:
Hi sokhapkin,
According to your SQL debug, I might believe that you ran an LCR export prior running the batch update,
this will have been useful information to know at first.

I just made a commit (rev 2295) now to disable the batch update if the LCR export is active.

/Areski


No I didn't run LCR export. Actually I never run it.

Do you check with mysql or pgsql? mysql doesn't allow to update the table and use the same table in select subquery of the update statement.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 24 posts ]  Go to page 1, 2  Next
Hosted Voice Broadcast


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