[OpenSIPS-Users] Help with sip trace errors please

[Bogdan-Andrei Iancu]

Hi Brian,

Field 0 is the "msg" field  (used as DB_BLOB by siptrace) should be 
"STR" to work, but I already see it is set at string in your table 
definition....so I looked for a bug and found one in the db_text module 
- if you update from SVN, it should be ok.

Thanks and regards,
Bogdan

opensipslist at encambio.com wrote:
> Hello again list,
>
> On tues., dec 08, 2009, opensipslist at encambio.com wrote:
>   
>> In my /pfx/var/opensips/db/sip_trace I have:
>>
>>    id(int,auto) time_stamp(int) callid(string) traced_user(string) msg(string) method(string) status(string) fromip(string) toip(string) fromtag(string) direction(string)
>>
>> ...and I see in the log:
>>
>>    Dec 08 23:04:06 name.host.tld <error> opensips[14400]: ERROR:db_text:dbt_insert: incompatible types v[0] - c[4]!
>>
>>     
> Bogdan mentioned to a previous user reporting a similar problem with
> 'incompatible types v[6] - c[1]' that the 'time_stamp(str)' field
> should be of type 'int'. This is not my problem (it's already int),
> but I see that maybe another value is the problem.
>
> ...but how to map v[N] and c[M] to db_text fields? The sourcecode is
> horrible in this respect, and doesn't help at all.
>
> Can I presume that v[] is the datatype, and c[] the column number?
> So I guess my problem is that datatype '0' is wrong for column '4'
> (msg if using '0' as the starting column.) But what is the datatype
> '0' mapped to, and what should the column 'msg' be?
>
> Thanks,
> Brian
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro