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