not for me ... i tried in another ratecard ... and the error persist...
what i doing wrong ...
| asterisk2billing.org http://forum.asterisk2billing.org/ |
|
| Rates Batch Update http://forum.asterisk2billing.org/viewtopic.php?f=22&t=5990 |
Page 1 of 2 |
| Author: | willianmazzardo [ Fri Aug 07, 2009 5:27 pm ] |
| Post subject: | Rates Batch Update |
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 |
|
| Author: | areski [ Fri Aug 07, 2009 7:30 pm ] |
| Post subject: | Re: Rates Batch Update |
I just tried and it works fine for me! /Areski |
|
| Author: | willianmazzardo [ Fri Aug 07, 2009 7:34 pm ] |
| Post subject: | Re: Rates Batch Update |
not for me ... i tried in another ratecard ... and the error persist... what i doing wrong ...
|
|
| Author: | sokhapkin [ Sun Aug 09, 2009 11:58 pm ] |
| Post subject: | Re: Rates Batch Update |
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> |
|
| Author: | hnetfone [ Mon Aug 10, 2009 2:53 am ] |
| Post subject: | Re: Rates Batch Update |
Hi i also have the same issue, anytime i want to do rate batch update got message: could not perfom the bacth update |
|
| Author: | areski [ Mon Aug 10, 2009 8:03 am ] |
| Post subject: | Re: Rates Batch Update |
Can you try with the last trunk version and tell us how it goes, plus the exact way to reproduce. Yours, /Areski |
|
| Author: | sokhapkin [ Mon Aug 10, 2009 11:34 am ] |
| Post subject: | Re: Rates Batch Update |
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". |
|
| Author: | areski [ Mon Aug 10, 2009 12:36 pm ] |
| Post subject: | Re: Rates Batch Update |
please try with the last revision so that we know. Cheers, /Areski |
|
| Author: | willianmazzardo [ Mon Aug 10, 2009 12:42 pm ] |
| Post subject: | Re: Rates Batch Update |
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. |
|
| Author: | sokhapkin [ Mon Aug 10, 2009 12:44 pm ] |
| Post subject: | Re: Rates Batch Update |
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. |
|
| Author: | areski [ Mon Aug 10, 2009 12:49 pm ] |
| Post subject: | Re: Rates Batch Update |
you can try on an other installation! |
|
| Author: | sokhapkin [ Mon Aug 10, 2009 12:50 pm ] |
| Post subject: | Re: Rates Batch Update |
willianmazzardo wrote: I dont know why, but i have tried today change the rate/trunk and worked. Do you use mysql or postgress? |
|
| Author: | sokhapkin [ Mon Aug 10, 2009 2:40 pm ] |
| Post subject: | Re: Rates Batch Update |
areski wrote: you can try on an other installation! Same error with trunk version. |
|
| Author: | areski [ Mon Aug 10, 2009 4:09 pm ] |
| Post subject: | Re: Rates Batch Update |
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 |
|
| Author: | sokhapkin [ Mon Aug 10, 2009 4:46 pm ] |
| Post subject: | Re: Rates Batch Update |
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. |
|
| Page 1 of 2 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|