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

[Daniel-Constantin Mierla]

Most likely you didn't ckecked the options to create database for 
siremis during the installation wizard step 2:

- http://kb.asipto.com/siremis:install40x:main#step_2

There are 4 options there, you have to select all of them first time.

You should drop siremis database if you created some tables manually.

Cheers,
Daniel


On 17/03/14 19:54, malik sherif wrote:
>
>
> ------------------------------------------------------------------------
> 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
>
>
> _______________________________________________
> 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

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference - April 2-4, 2014, Berlin, Germany
http://www.kamailioworld.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140317/e1c9f510/attachment.html>