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 
                
                




_______________________________________________
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

Reply via email to