[SR-Users] login to siremis failed Column not found: 1054 Unknown column 'T0.id' in 'field list

[malik sherif]

From: asherif74 at hotmail.com
To: sr-users at lists.sip-router.org
Date: Mon, 17 Mar 2014 16:28:46 +0000
Subject: [SR-Users] login to siremis failed  'siremis.user' doesn't exist




When I attempted to login to siremis , i got the following errors "Base table
 or view not found: 1146 Table 'siremis.user' doesn't exist"

  
And then I created the table manually using the following commands

CREATE TABLE `user` (

  `SYSID` int(11) NOT NULL auto_increment,

  `USERID` varchar(15) NOT NULL,

  `PASSWORD` varchar(15) default NULL,

  PRIMARY KEY  (`SYSID`)

);

But I still have problem login with the following error "Column not
 found: 1054 Unknown column 'T0.id' in 'field list'".
The I run describe user, i got the following; 
mysql> describe user;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| SYSID    | int(11)     | NO   | PRI | NULL    | auto_increment |
| USERID   | varchar(15) | NO   |     | NULL    |                |
| PASSWORD | varchar(15) | YES  |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
3 rows in set (0.07 sec)

Any idea? 
 Your help is greatly appreciated
Thanks
Abdul
 		 	   		  

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users at lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140317/482c9168/attachment.html>