provided by Star2Billing S.L.

hi a2billing teem

seems like there is sum errors in "DataBase/mysql-5.x/UPDATE-a2billing-v1.4.3-to-v1.4.4.sql" from update 2535 and still in 2542.
when try to do

mysql -u root -p mya2billing < DataBase/mysql-5.x/UPDATE-a2billing-v1.4.3-to-v1.4.4.sql

getting lot of errors
i am using

svn co --username guest --password guest http://svn.a2billing.net/svn/asterisk2billing/trunk/ /usr/local/src/a2billing

to download a2billing

can a2billing team look in to this

Thanks
Avi

ok. did the debuging

ERROR 1064 (42000) at line 44: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--new Agent commission module
ALTER TABLE `cc_agent` ADD `com_balance` DECIMAL( ' at line 1


ERROR 1146 (42S02) at line 49: Table 'a2billing.cc_config' doesn't exist



ERROR 1049 (42000) at line 63: Unknown database 'a2billing'


finel file shuld look like this
--------------------------------------------------------------------------------------------


/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */

/**
* This file is part of A2Billing (http://www.a2billing.net/)
*
* A2Billing, Commercial Open Source Telecom Billing platform,
* powered by Star2billing S.L. <http://www.star2billing.com/>
*
* @copyright Copyright (C) 2004-2009 - Star2billing S.L.
* @author Belaid Arezqui <[email protected]>
* @license http://www.fsf.org/licensing/licenses/agpl-3.0.html
* @package A2Billing
*
* Software License Agreement (GNU Affero General Public License)
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*
**/



CREATE VIEW cc_callplan_lcr AS
SELECT cc_ratecard.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, 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;


/* --new Agent commission module */
ALTER TABLE `cc_agent` ADD `com_balance` DECIMAL( 15, 5 ) NOT NULL;
ALTER TABLE `cc_agent_commission` DROP `paid_status` ;
ALTER TABLE `cc_agent_commission` ADD `commission_type` TINYINT NOT NULL ;
ALTER TABLE `cc_agent_commission` ADD `commission_percent` DECIMAL( 10, 4 ) NOT NULL ;
INSERT INTO `cc_config` (
`id` ,
`config_title` ,
`config_key` ,
`config_value` ,
`config_description` ,
`config_valuetype` ,
`config_listvalues` ,
`config_group_title`
) VALUES ( NULL , 'Authorize Remittance Request', 'remittance_request', '1', 'Enable or disable the link which allow agent to submit a remittance request', '0', 'yes,no', 'webagentui');

ALTER TABLE `cc_agent` ADD `threshold_remittance` DECIMAL( 15, 5 ) NOT NULL ;
ALTER TABLE `cc_agent` ADD `bank_info` MEDIUMTEXT NULL ;

CREATE TABLE `cc_remittance_request` (
`id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`id_agent` BIGINT NOT NULL ,
`amount` DECIMAL( 15, 5 ) NOT NULL ,
`type` TINYINT NOT NULL
) ENGINE = MYISAM ;

/*
ALTER TABLE `cc_remittance_request` ADD `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
ADD `status` TINYINT NOT NULL ,
ADD `description` MEDIUMTEXT NULL;
*/

ALTER TABLE `cc_remittance_request` ADD `status` TINYINT NOT NULL DEFAULT '0',
ADD `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
ADD `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NULL;

this is fixed in version 2554

thanks

Forgive my ignorance guys but.. how do I check my current's A2Billing revision? And, you are speaking of A2B version 1.4.4 when the website's link says the latest is 1.4.2.1 Where do you find the patches / versions of the latest A2Billing improvements?

Thank you in advance,

Paul

you can follow a2billing development here :
http://www.asterisk2billing.org/cgi-bin ... i/timeline

We are about to release 1.4.4 Stable in a moment,
you will see a post on the forum in the announcement section :
viewforum.php?f=1

and on the main page of Trac.


Yours,
/Areski

Areski:

So will you be releasing v. 1.4.4 soon?

Also, how can I check in my current A2B version the revision?

Thanks,

Paul