"Dieter Fischer" <dieter.fischer@grid-it.ch> schrieb am 13.11.02 17:31:27:
I remember, I had this error message also once. I don't remember exactly what it was, but have you defined the tables correctly, and are you choosing the right db connection. Be carefull, because of aquisition you might have more than one.
first: i only made one connection, cannot choose a wrong connection second: My table looked the following way:
mysql> describe user; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | user_id | int(11) | | PRI | 0 | | | lang_id | int(11) | | MUL | 0 | | | group_id | int(11) | | MUL | 0 | | | lastname | varchar(64) | | | | | | firstname | varchar(64) | YES | | NULL | | | m_admin_uid | varchar(30) | | | | | | m_admin_pwd | varchar(30) | | | | | +-------------+--------------+------+-----+---------+-------+
then i added +-------------+--------------+------+-----+---------+-------+ | roles | varchar(255) | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+ to the table above Should work, nor ? I think it should because in the doku is the following snipplet: "The required schema is very simple. You need to store usernames, passwords, and roles. If your existing schema doesn't support a roles column you will have to add one." *hrm* +Z MySQL Database Connection at /MySQL_database_connection +The database connection is open. ________________________________________________________________ Viren? Wir wissen nicht was Ihr Arzt empfiehlt. Wir empfehlen den Virencheck für Dateianhänge! http://freemail.web.de/features/?mc=021159