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

Thank you very much for your help, I am able to login to SIREMIS now, I was only selected replace DB config on step 2 but this time I also selected create siremis DB and I am able to login Thanks Abdul Date: Mon, 17 Mar 2014 21:10:39 +0100 From: miconda(a)gmail.com To: sr-users(a)lists.sip-router.org Subject: Re: [SR-Users] login to siremis failed Column not found: 1054 Unknown column 'T0.id' in 'field list 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(a)hotmail.com To: sr-users(a)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(a)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(a)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 _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users