<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">That's a bug, is fixed now in darcs<div><br></div><div>Adrian</div><div><br><div><div>On Jun 18, 2009, at 2:32 AM, bay2x1 wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><br>I have double checked the cdrtool and opensips database. The changes<br>required on the alter_tables.mysql has been implemented. I also encountered<br>this error when I executed the importRatingTables.php:<br>Importing Profiles:<br>Database error for query select * from billing_profiles<br> where name = 'grn_premium'<br> and reseller_id= '0'<br> and gateway = ''<br> and domain = ''<br> and subscriber = ''<br>: Unknown column 'gateway' in 'where clause' (1054)Error: cannot connect to<br>network rating engine<br><br>I am wondering why the sql query is still looking for the gateway, domain,<br>and subscriber columns where it has been noted on the changelog for 6.8 that<br>this columns where removed?<br><br><br>Adrian Georgescu wrote:<br><blockquote type="cite"><br></blockquote><blockquote type="cite">Hi bay2x1,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Did you read the changelog to see what you need to do after the upgrade?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Did you update your database schema using setup/mysql/ <br></blockquote><blockquote type="cite">alter_tables.mysql?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Adrian<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">On Jun 17, 2009, at 1:59 AM, bay2x1 wrote:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I recently upgraded from version 6.7.8 to 6.8. Everything was working<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">perfectly using the default user and password. I created a new user <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">with the<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">same permissions with the default user and log-out. When I tried <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">using the<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">new user I was able to log-in but when I checked the rating section, <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">(the<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">destination, ratings, profiles etc) it was no longer displaying the <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">records.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">When I tried to switch back to the default user again and checked <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">the rating<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">section again, it no longer displays the record. Any help to <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">resolve this<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">problem would be appreciated. Thank you.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">-- <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">View this message in context:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://n2.nabble.com/CDRTool-6.8-unable-to-display-table-records-on-rating-section.-tp3089627p3089627.html">http://n2.nabble.com/CDRTool-6.8-unable-to-display-table-records-on-rating-section.-tp3089627p3089627.html</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Sent from the OpenSIPS - Users mailing list archive at Nabble.com.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">_______________________________________________<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Users mailing list<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">Users mailing list<br></blockquote><blockquote type="cite"><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br></blockquote><blockquote type="cite"><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><br>-- <br>View this message in context: <a href="http://n2.nabble.com/CDRTool-6.8-unable-to-display-table-records-on-rating-section.-tp3089627p3096466.html">http://n2.nabble.com/CDRTool-6.8-unable-to-display-table-records-on-rating-section.-tp3089627p3096466.html</a><br>Sent from the OpenSIPS - Users mailing list archive at Nabble.com.<br><br><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></div></blockquote></div><br></div></body></html>