Re: [SR-Users] Mysql

In this sense, your initial post is profoundly misleading. You need to provide complete and accurate details from the context in which any issue occurs. And as Daniel said, the precise config contact on which this stored procedure is called is key. -- Sent from mobile. Apologies for brevity and errors. -----Original Message----- From: Nicolas Breuer &lt;Nicolas.Breuer(a)belcenter.biz&gt; To: &quot;miconda(a)gmail.com&quot; &lt;miconda(a)gmail.com&gt;om>, "Kamailio (SER) - Users Mailing List" &lt;sr-users(a)lists.kamailio.org&gt; Sent: Mon, 05 Nov 2018 6:05 AM Subject: Re: [SR-Users] Mysql It's a stored sql procedure launched by the rtimer module. De : Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Envoyé : lundi 5 novembre 2018 11:57 À : Nicolas Breuer &lt;Nicolas.Breuer(a)belcenter.biz&gt;iz>; Kamailio (SER) - Users Mailing List &lt;sr-users(a)lists.kamailio.org&gt; Objet : Re: [SR-Users] Mysql Hello, how do you execute that sql statement? Cheers, Daniel On 05.11.18 10:40, Nicolas Breuer wrote: Hello, We see the error when this procedure is executed : BEGIN delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace; END $$ De : Daniel-Constantin Mierla <miconda@gmail.com><mailto:miconda@gmail.com> Envoyé : lundi 5 novembre 2018 09:45 À : Nicolas Breuer <Nicolas.Breuer@belcenter.biz><mailto:Nicolas.Breuer@belcenter.biz>; Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org><mailto:sr-users@lists.kamailio.org> Objet : Re: [SR-Users] Mysql 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@gmail.com><mailto:miconda@gmail.com> Envoyé : lundi 5 novembre 2018 09:35 À : Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org><mailto:sr-users@lists.kamailio.org>; Nicolas Breuer <Nicolas.Breuer@belcenter.biz><mailto:Nicolas.Breuer@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@lists.kamailio.org<mailto:sr-users@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<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<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>