17 Mar
2014
17 Mar
'14
12:28 p.m.
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
17 Mar
17 Mar
2:54 p.m.
New subject: login to siremis failed Column not found: 1054 Unknown column 'T0.id' in 'field list
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
4:10 p.m.
New subject: 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
18 Mar
18 Mar
11:11 a.m.
New subject: 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
3757
days inactive
3758
days old
3 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
malik sherif