<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7036.0">
<TITLE>Accounting problems after mysql backup restore</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><FONT SIZE=2 FACE="Century Gothic">After backup and restoring MySQL the accounting did not worked anymore. I could make calls but the amount does not show up.</FONT></P>
<P><FONT FACE="Times New Roman">The problem is that o_uri has the format<BR>
sip:00 + codigo de tarifa<BR>
<BR>
pero en la base de datos se esta guardando sin el 00<BR>
solamente sip:+codigo de tarifa ( la razon no la se,<BR>
no he modificado nada de eso ).<BR>
<BR>
After changig in accounting </FONT>
<BR>
<BR><FONT FACE="Times New Roman">$codigo2 = "sip:".$row2->codigo;<BR>
if ( strncmp ( $codigo2, $row->o_uri, strlen($codigo2) ) == 0) {<BR>
$tarifa=$row2->tarifa;<BR>
$nombre=$row2->nombre</FONT>
</P>
<P><FONT FACE="Times New Roman">It works again.What is wrong???</FONT>
</P>
<P><FONT FACE="Times New Roman">Thanks to everybody who can help. CFM<BR>
</FONT>
</P>
</BODY>
</HTML>