<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><br><br><div><hr id="stopSpelling">From: asherif74@hotmail.com<br>To: sr-users@lists.sip-router.org<br>Date: Mon, 17 Mar 2014 16:28:46 +0000<br>Subject: [SR-Users] login to siremis failed 'siremis.user' doesn't exist<br><br>
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr">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"<br><br> <br>And then I created the table manually using the following commands<br><br>CREATE TABLE `user` (<br><br> `SYSID` int(11) NOT NULL auto_increment,<br><br> `USERID` varchar(15) NOT NULL,<br><br> `PASSWORD` varchar(15) default NULL,<br><br> PRIMARY KEY (`SYSID`)<br><br>);<br><br>But I still have problem login with the following error "Column not
found: 1054 Unknown column 'T0.id' in 'field list'".<br>The I run describe user, i got the following; <br>mysql> describe user;<br>+----------+-------------+------+-----+---------+----------------+<br>| Field | Type | Null | Key | Default | Extra |<br>+----------+-------------+------+-----+---------+----------------+<br>| SYSID | int(11) | NO | PRI | NULL | auto_increment |<br>| USERID | varchar(15) | NO | | NULL | |<br>| PASSWORD | varchar(15) | YES | | NULL | |<br>+----------+-------------+------+-----+---------+----------------+<br>3 rows in set (0.07 sec)<br><br>Any idea? <br> Your help is greatly appreciated<br>Thanks<br>Abdul<br> </div>
<br>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</div> </div></body>
</html>