[Serusers] DB Error(table admin_privileges not exist) when using serweb - sr-users

17 Jun 2004


      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