Hi Matteo, I ran into the same problem, OpenSips 1.4.3 and Mediaproxy 2.1.0 with CDRtool 6.6.10.
In the file /var/www/CDRTool/library/cdr_openser.php I changed time_stamp to date on lines 2943 and 3015. That's the only places I found it and the siptrace in CDRTool works wonderfully now. Hope you'll find the same success. //Magnus > Hi all. > I have added the bug on the opensips-cp tracker. > I hope that the problem be resolved soon. > I'm trying to understand how the sip trace tool search by date of records in > the sip_trace table,<but I do not know very well the language php. > > > >> Hi Matteo , >> > > >> looks like a mismatching of naming (in opensips and opensips-cp) :(.... >> "date" and "time_stamp" are the same... >> > > >> Please report the bug on the opensips-cp tracker. >> > > >> Regards, >> Bogdan >> > > [email protected] wrote: > >> Hi. >> In the table of the Sip Trace tool the Date Time column is blank for each >> sip message stored and if I try to do a search by date, I get the error: >> >> Unknown column 'date' in 'where clause' >> >> In the sip_trace table the values in the time_stamp column are present. >> >> There is a problem of mismatch between the names of columns or a problem of >> date formats? >> >> Thanks. >> >> Marzuola Matteo >> >> >> >> >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
