[Serusers] DB Error(table admin_privileges not exist) when usingserweb

[wangji]

I find the reason. The version of SER that I used is branch 0.8.12 from CVS server. But SERWEB is compliant with CVS branch 0.8.13. The file ser_mysql.sh from branch 0.8.13 create table admin_privileges.
So are there a branch of SERWEB support SER 0.8.12 ?

Jimmy


----- Original Message ----- 
From: "wangji" <wangji at bjut.edu.cn>
To: <serusers at iptel.org>
Sent: Thursday, June 17, 2004 7:39 PM
Subject: [Serusers] DB Error(table admin_privileges not exist) when usingserweb 


> Hi all,
>     I got a DB error when I tried to login into serweb(both admin and user_interface). 
>    The message showing on IE is "DB Error: no such table, file: /var/www/novsky.com/serweb/html/data_layer.php:405". 
>    I checked mysql's log. It query DB ser, is:
>     select priv_name, priv_value from admin_privileges where username = 'admin' and domain = 'iptel.org' and (priv_name = 'change_privileges' or priv_name = 'is_admin');
>    That table "admin_privileges" is not exist.
>    In DB ser, there are these tables:
> +-----------------------+
> | Tables_in_ser         |
> +-----------------------+
> | acc                   |
> | active_sessions       |
> | aliases               |
> | config                |
> | domain                |
> | event                 |
> | grp                   |
> | location              |
> | missed_calls          |
> | pending               |
> | phonebook             |
> | preferences           |
> | reserved              |
> | server_monitoring     |
> | server_monitoring_agg |
> | silo                  |
> | subscriber            |
> | uri                   |
> | version               |
> +-----------------------+
> And these tables is created by ser_mysql.sh.
> How can I do?
> 
> 
> Best regards,
> 
> Jimmy
> 
> 


--------------------------------------------------------------------------------


> _______________________________________________
> Serusers mailing list
> Serusers at iptel.org
> http://mail.iptel.org/mailman/listinfo/serusers
>