<html>
<head>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">The problem is, that with a trigger for
a table I can't delete rows from the same table:<br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
ERROR 1442: Can’t update table ‘sip_capture′ in stored
function/trigger because it is already used by statement which
invoked this<br>
<br>
<br>
<div class="moz-signature"><span style="font-size:8pt;
font-family:'Arial',sans-serif; color:#000000;"> <br>
</span> </div>
Am 27.08.13 17:42, schrieb Alex Balashov:<br>
</div>
<blockquote cite="mid:521CC903.30307@evaristesys.com" type="cite">Well,
you could use a trigger/stored procedure to do that inside the
database, as opposed to externally...
<br>
<br>
On 08/27/2013 11:41 AM, Sebastian Grosse wrote:
<br>
<br>
<blockquote type="cite">Hallo All,
<br>
I use the module sipcapture and this will fill a MySQL-database.
Is
<br>
there a better / an other way to cleanup the database frequently
as to
<br>
create an own cronjob?
<br>
I want to set a maximum interval of time or table-rows, because
I don't
<br>
want my database to grow eternal.
<br>
<br>
Any idea how to configure kamailio, sipcapture or an other
module or
<br>
other ideas?
<br>
<br>
Sebastian G.
<br>
<br>
<br>
<br>
_______________________________________________
<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
<br>
<br>
</blockquote>
<br>
<br>
</blockquote>
<br>
</body>
</html>