[Serusers] Re: error with cdrtool installation

[varala ramakanth]

hello adrian,

now if i execute ./setup_mysql.sh i get this error
[root at server mysql]# ./setup_mysql.sh
ERROR 1136 at line 4: Column count doesn't match value
count at row 1

at line 4 i have

 


i have checked the cdrtools database and destinations

table in that i have seen that

we have only four fields 

mysql> desc destinations
    -> ;
+-----------+---------------------+------+-----+---------+----------------+
| Field     | Type                | Null | Key |
Default | Extra          |
+-----------+---------------------+------+-----+---------+----------------+
| id        | bigint(20) unsigned |      | PRI | NULL 
  | auto_increment |
| dest_id   | varchar(25)         |      | MUL |      
  |                |
| dest_name | varchar(255)        |      |     |      
  |                |
| language  | char(2)             |      |     | NL   
  |                |
+-----------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)


but while insering form create_date.sql i observed

this 

INSERT INTO destinations VALUES
(1908,'9501','Conference','NL',0,0,0,0);

so is this a bug or any other table values



with regards

rama kanth


--- Adrian Georgescu <ag at ag-projects.com> wrote:
> Try this
> 
> 
> INSERT INTO auth_user VALUES
>
('c14cbf141ab1b7cd009356f555b607dc','admin','admin','admin,callsearch,st
> 
> atistics,sqlquery','2099-01-02','Amin user',
> 'Admin  
> user','+878-11 
>
-7472999222','support at x.com','1','1','','','','','','ser_radius,asterisk
> 
> ,ser_acc,cisco','0','','2006-05-14
> 12:55:00','94nx9');
> 
> On Jun 3, 2004, at 8:29 AM, varala ramakanth wrote:
> 
> > INSERT INTO auth_user
> >
>
(user_id,username,password,perms,expire,organization,name,tel,email,dis
> 
> >
>
play_cli,dispaly_card,domainFilter,codeFilter,aNumberFilter,afterDateFi
> 
> >
>
lter,sources,otp_enable,otp_rcpt,otp_expire,otp_passwd)
> > VALUES
> >
>
('c14cbf141ab1b7cd009356f555b607dc','admin','admin','admin,callsearch,s
> 
> > tatistics,sqlquery','2099-01-01','AG
> > Projects','Adrian
> > Georgescu','31-620-534309','support at ag- 
> > projects.com','1','1','','','','','0000-00 
> >
>
-00','ipnxcdr,ipnxlog,telecats,asterisk,cisco,ser','0','','2003-10-28
> > 12:52:00','8n36r');
> 



	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/