The problem is, that with a trigger for a table I can't delete rows from the same table:
ERROR 1442: Can't update table 'sip_capture' in stored function/trigger because it is already used by statement which invoked this
Am 27.08.13 17:42, schrieb Alex Balashov:
Well, you could use a trigger/stored procedure to do that inside the database, as opposed to externally... On 08/27/2013 11:41 AM, Sebastian Grosse wrote:
Hallo All, I use the module sipcapture and this will fill a MySQL-database. Is there a better / an other way to cleanup the database frequently as to create an own cronjob? I want to set a maximum interval of time or table-rows, because I don't want my database to grow eternal. Any idea how to configure kamailio, sipcapture or an other module or other ideas? Sebastian G. _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users