Re: [Serusers] DB Error(table admin_privileges not exist) when usingserweb - sr-users

17 Jun 2004

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" &lt;wangji(a)bjut.edu.cn&gt;
To: &lt;serusers(a)iptel.org&gt;
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(a)iptel.org
 http://mail.iptel.org/mailman/listinfo/serusers