[SR-Users] Mysql

[Daniel-Constantin Mierla]

There is no column "Msg_text" there, are you sure it is about this table?

Cheers,
Daniel


On 05.11.18 09:37, Nicolas Breuer wrote:
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
>
> | sip_trace | CREATE TABLE `sip_trace` (
>
>   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
>
>   `time_stamp` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',
>
>   `time_us` int(10) unsigned NOT NULL DEFAULT '0',
>
>   `callid` varchar(255) NOT NULL DEFAULT '',
>
>   `traced_user` varchar(128) NOT NULL DEFAULT '',
>
>   `msg` mediumtext NOT NULL,
>
>   `method` varchar(50) NOT NULL DEFAULT '',
>
>   `status` varchar(128) NOT NULL DEFAULT '',
>
>   `fromip` varchar(50) NOT NULL DEFAULT '',
>
>   `toip` varchar(50) NOT NULL DEFAULT '',
>
>   `fromtag` varchar(64) NOT NULL DEFAULT '',
>
>   `totag` varchar(64) NOT NULL DEFAULT '',
>
>   `direction` varchar(4) NOT NULL DEFAULT '',
>
>   PRIMARY KEY (`id`),
>
>   KEY `traced_user_idx` (`traced_user`),
>
>   KEY `date_idx` (`time_stamp`),
>
>   KEY `fromip_idx` (`fromip`),
>
>   KEY `callid_idx` (`callid`),
>
>   KEY `id` (`id`),
>
>   KEY `id_2` (`id`)
>
> ) ENGINE=MyISAM AUTO_INCREMENT=6810087 DEFAULT CHARSET=latin1
> ROW_FORMAT=DYNAMIC |
>
> +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>  
>
> *De :*Daniel-Constantin Mierla <miconda at gmail.com>
> *Envoyé :* lundi 5 novembre 2018 09:35
> *À :* Kamailio (SER) - Users Mailing List
> <sr-users at lists.kamailio.org>; Nicolas Breuer
> <Nicolas.Breuer at belcenter.biz>
> *Objet :* Re: [SR-Users] Mysql
>
>  
>
> Hello,
>
> can you give the output of the next command run in mysql client tool?
>
> show create table sip_trace;
>
> Cheers,
> Daniel
>
>  
>
> On 04.11.18 10:09, Nicolas Breuer wrote:
>
>     Hello,
>
>      
>
>     Working on sip_trace table produce this error
>
>      
>
>     WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns():
>     unhandled data type column (Msg_text) type id (250), use
>     DB1_STRING as default
>
>      
>
>      
>
>
>
>
>     _______________________________________________
>
>     Kamailio (SER) - Users Mailing List
>
>     sr-users at lists.kamailio.org <mailto:sr-users at lists.kamailio.org>
>
>     https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
> -- 
> Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
> Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
> Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20181105/a6f4f283/attachment.html>