Hi Asim,

   Discovered the solution for our problem !
   Just delete the folder serMyAdmin that you have on tomcat6 folder (or other webserver).
   Then restart tomcat (or other webserver).
   Open the web page http://<server address>:8080/serMyAdmin and it will add the necessary columns to the subscriber table.
   Try that and then tell something!

   BR,

   Nuno

2008/8/21 Asim Riaz <ariaz78@gmail.com>


---------- Forwarded message ----------
From: Asim Riaz <ariaz78@gmail.com>
Date: Thu, Aug 21, 2008 at 2:49 PM
Subject: Re: [Kamailio-Users] Help with SerMyAdmin
To: Nuno Marques <yangsengopenser@gmail.com>

my issue is same as Nano
 tried this command mysql -u root -p openser <openser.sql but still

got ERROR 1054 (42S22) at line 1: Unknown column 'version' in 'field list'


Regards
Asim

On Thu, Aug 21, 2008 at 12:26 PM, Nuno Marques <yangsengopenser@gmail.com> wrote:
Hi Muhammad,

I droped the database and then created a new database as you told me...
Now i have to create all users again and an admin for sermyadmin...
But when i tried to run the mysql commands that are on www.sermyadmin.org/openser/openser.sql they gave me an error: unknown column 'version' in 'field list'.
Have any idea of what is going on?
By the way... do you know what happened to www.sermyadmin.org - it's seem like it has been hacked or something...

Many tahnks,

                Nuno


2008/8/20 muhammad akl <muhammad.akl@gmail.com>



Hi Nuno

i faced some problems your already facing and succeeded to solve them so i'd like to as you

did you install SERweb tables ?

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

p.s i recommend you to remove the whole database e.g openser and install it again using openser_mysql.sh script

e.g /path/to/openser_mysql.sh create

press yes for presence and that stuff but for SERweb no

try and tell me what you get

BR

Muhammad


_______________________________________________
Users mailing list
Users@lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users




_______________________________________________
Users mailing list
Users@lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users