<div dir="ltr"><br><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Asim Riaz</b> <span dir="ltr"><<a href="mailto:ariaz78@gmail.com">ariaz78@gmail.com</a>></span><br>
Date: Thu, Aug 21, 2008 at 2:49 PM<br>Subject: Re: [Kamailio-Users] Help with SerMyAdmin<br>To: Nuno Marques <<a href="mailto:yangsengopenser@gmail.com">yangsengopenser@gmail.com</a>><br><br>my issue is same as Nano<br>
<div dir="ltr"> tried this command mysql -u root -p openser <openser.sql but still <br><br>got ERROR 1054 (42S22) at line 1: Unknown column 'version' in 'field list'<br><br><br>Regards<br>Asim<br><br><div class="gmail_quote">
<div><div></div><div class="Wj3C7c">On Thu, Aug 21, 2008 at 12:26 PM, Nuno Marques <span dir="ltr"><<a href="mailto:yangsengopenser@gmail.com" target="_blank">yangsengopenser@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="Wj3C7c"><div dir="ltr">Hi Muhammad,<br><br>I droped the database and then created a new database as you told me...<br>
Now i have to create all users again and an admin for sermyadmin...<br>But when i tried to run the mysql commands that are on <a href="http://www.sermyadmin.org/openser/openser.sql" target="_blank">www.sermyadmin.org/openser/openser.sql</a> they gave me an error: unknown column 'version' in 'field list'.<br>
Have any idea of what is going on?<br>By the way... do you know what happened to <a href="http://www.sermyadmin.org" target="_blank">www.sermyadmin.org</a> - it's seem like it has been hacked or something...<br><br>Many tahnks,<br>
<br>
Nuno<br><br><br><div class="gmail_quote">2008/8/20 muhammad akl <span dir="ltr"><<a href="mailto:muhammad.akl@gmail.com" target="_blank">muhammad.akl@gmail.com</a>></span><div><div></div><div>
<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr"><br><br>Hi Nuno <br><br>i faced some problems your already facing and succeeded to solve them so i'd like to as you <br><br>did you install SERweb tables ? <br><br>if though the problems come from there especially the phplib_id field a duplication happened between it and the "id" filed so you have to remove SERweb tables and all thing will go smoothly without any errors <br>
<br>p.s i recommend you to remove the whole database e.g openser and install it again using openser_mysql.sh script <br><br>e.g /path/to/openser_mysql.sh create <br><br>press yes for presence and that stuff but for SERweb no <br>
<br>try and tell me what you get <br><br>BR <br><br>Muhammad<br></div>
</blockquote></div></div></div><br></div>
<br></div></div>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a><br>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>
</div><br></div>