A2B_entity_friend.php empty Rev.2526

manugmedia · **Joined:** Wed Feb 13, 2008 11:11 am **Posts:** 224

Hi All,
Current trunk version doesn't let you edit VOIP Settings. A2B_entity_friend.php is all empty when you click on edit.
Anybody having this issue?

Thanks
Eamonn

dbbrito · **Joined:** Sun Mar 30, 2008 5:52 pm **Posts:** 138

I rev.2526 and I do not have this problem!

areski · **Posted:** Wed Nov 18, 2009 1:39 pm

Make sure you updated your database correctly.

Yours,
/Areski

manugmedia · **Joined:** Wed Feb 13, 2008 11:11 am **Posts:** 224

Thanks dbbrito.
Thanks Areski, i clearly overlooked updating database. i fell Very embarrassed :wall:

Rgds
Eamonn

david · **Joined:** Thu Apr 09, 2009 9:24 am **Posts:** 13

Hi Eamonn,

I m having the same problem as u while update my database from a2billing-v1.4.3-to-v1.4.4.sql. I m getting this error msg "ERROR 1050 (42S01) at line 35: Table 'cc_callplan_lcr' already exists" Can u show me how u update ur database as i m not expert in mysql. By the way i m using Revision 2581.

Thks

Regards

David

areski · **Posted:** Tue Dec 08, 2009 12:39 pm

Perhaps you should run this script on your mysql :

Code:

DROP VIEW cc_callplan_lcr;
CREATE VIEW cc_callplan_lcr AS
   SELECT cc_ratecard.id, cc_prefix.destination, cc_ratecard.dialprefix, cc_ratecard.buyrate, cc_ratecard.rateinitial, cc_ratecard.startdate, cc_ratecard.stopdate, cc_ratecard.initblock, cc_ratecard.connectcharge, cc_ratecard.id_trunk , cc_ratecard.idtariffplan , cc_ratecard.id as ratecard_id, cc_tariffgroup.id AS tariffgroup_id
   
   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 ON cc_ratecard.idtariffplan=cc_tariffplan.id
   LEFT JOIN cc_prefix ON prefix=cc_ratecard.destination
   WHERE cc_ratecard.id IS NOT NULL;

Yours,
/Areski

provided by Star2Billing S.L.

A2B_entity_friend.php empty Rev.2526

Who is online