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 [email protected] wrote: > Hello again list, > > On tues., dec 08, 2009, [email protected] 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 > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- Bogdan-Andrei Iancu www.voice-system.ro _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
