Help Wanted

Are you interested in VOIP, Asterisk, PHP and Open Source.

We are looking for people to assist in developing AstBill.

Please contact us using the contact form http://astbill.com/feedback

We are also looking for sophisticated test environments for AstBill. Are you running Asterisk today?

Please contact us. We really like to work with you to improve your experience with Asterisk and to further extend and improve AstBill.

There are several request for HOW TO documents and USER MANUAL for AstBill. Are you ready for the challenge?

Doubt in astCreateAcc2

By brahmanandam on Wed, 2007-03-28 13:57

In astCreateAcc2 storedprocedure what is the meaning of thes sentences

SET @s := CONCAT(' uid from ',tbluser,' where uid = suid');
SET @t := CONCAT(' name from ',tbluser,' where uid = suid');

» login to post comments

Error on TRUNK insert

By fabio069 on Tue, 2007-08-07 19:27

Every time that I try to insert a new TRUNK, I got the following error:

user error: Unknown column 'comment' in 'field list'
query: INSERT INTO `asttrunk` ( registerstring , addprefix , removeprefix , `name` , `tech` , `path` , `isdefault` , `serverid` , `comment` , `vat` , `vat2` , `maxusage` , `trunkcost`, static, username, usstyleprefix ) VALUES ('','','0','astbill', 'SIP', '@astbill', '0' , '', 'MEUCCI', '0.00', '0.00', '9999', '0', 'R', 'astbill', '0') in /home/astbill/wwwroot/includes/database.mysql.inc on line 68.

warning: Cannot modify header information - headers already sent by (output started at /home/astbill/wwwroot/includes/common.inc:384) in /home/astbill/wwwroot/includes/common.inc on line 192.

Please.. I need some help to resolve this problem....
Thanks at all.

» login to post comments

Error onTrunk

By egeex on Sun, 2008-08-24 02:48

I fixed this by simply adding a field "comment" after "serverid" in the asttrunk table. i made it varchar 255 length not null

» login to post comments

The "comment" columns should

By geejay on Sun, 2007-08-12 17:32

The "comment" columns should be probably renamed to remark in that query- look into the asttrunk database to check what the actual name of the column is.

» login to post comments

answer

By fameal on Mon, 2007-04-16 19:14

The first concatenate the string 'uid from' with the variable tbluser and with 'where uid = suid'. The second one does the same, but changing some data.

» login to post comments

AstBill Software

New forum topics