<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <p>Dear Sergio,</p>
    <p>What was previous version of your system?</p>
    <p>Could you please share output of the:<br>
    </p>
     mysql ngcp <<< 'select id,revision,applied_at from
    db_schema order by id desc limit 1;'<br>
    <br>
    ?<br>
    <br>
    Best regards,<br>
    Irina Peshinskaya<br>
    <br>
    <div class="moz-cite-prefix">On 26.01.2017 17:43, Sergio Serrano
      wrote:<br>
    </div>
    <blockquote cite="mid:1485445390.26876.24.camel@avanzada7.com"
      type="cite">
      <div>Hi all,</div>
      <div><br>
      </div>
      <div><span class="Apple-tab-span" style="white-space:pre">        </span>after
        we upgradeto 4.5.3 all work fine, but when I try to change
        billing fees system throw next error in panel.log:</div>
      <div><br>
      </div>
      <div>Jan 26 16:37:20 sipwise ngcp-panel: ERROR: IP=87.220.105.140
        CALLED=Controller::Billing::fees_upload TX=149D5C64D49BB170
        USER=administrator DATA={ 'upload_fees' =>
        'billing_fees_1.txt', 'purge_existing' => '1', 'submitid'
        => '', 'save' => 'Upload'} MSG="Failed to upload Billing
        Fees ({UNKNOWN}: DBI Exception: DBD::mysql::db do failed:
        PROCEDURE billing.fill_billing_fees does not exist [for
        Statement "call billing.fill_billing_fees(?)"] at
        /usr/share/perl5/NGCP/Panel/Utils/Billing.pm line 268#012)"
        LOG=""</div>
      <div><br>
      </div>
      <div>I had downloaded actual fees, replace an try to upload. If I
        try to add fee manually, I obtain a </div>
      <div><br>
      </div>
      <div>Sorry!</div>
      <div>500 Internal server error</div>
      <div>
        <div class="error-details">
          <p>We are terribly sorry, an exceptional error has occured:</p>
          <div><strong>incident number:</strong> 149D5CA208E6EA20</div>
          <div><strong>time of incident:</strong>
            2017-01-26T15:41:43.105940000Z</div>
          <br>
          <p>Details have been logged on the server. If you want to
            report the error, describe what you were doing or attempting
            to do just before.</p>
          <p><br>
          </p>
          <p>and in panel.log I have seen</p>
          <p><br>
          </p>
          <p>Jan 26 16:41:43 sipwise ngcp-panel: ERROR: fatal error,
            id=149D5CA208E6EA20,
            timestamp=2017-01-26T15:41:43.105940000Z, error={UNKNOWN}:
            DBI Exception: DBD::mysql::db do failed: PROCEDURE
            billing.fill_billing_fees does not exist [for Statement
            "call billing.fill_billing_fees(?)"] at
            /usr/share/perl5/NGCP/Panel/Utils/Billing.pm line 268</p>
          <p><br>
          </p>
          <p>Are there any bug in reltaion with billing fees in 4.5.3?</p>
          <p><br>
          </p>
          <p>regards,</p>
          <p><br>
          </p>
          <p>Sergio</p>
        </div>
      </div>
      <div class="-x-evo-paragraph -x-evo-top-signature-spacer"><br>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>