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

[malik sherif]

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 at gmail.com
To: sr-users at 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 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
  


_______________________________________________
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/20140318/9380fa85/attachment.html>