Hello
i've installed ser-0.8.11pre29-1.i386.rpm and mysql support. I've started ser service, but when i use serctl command to add new user this is the response:
ERROR 1054 at line 1: Unknown column 'user_id' in 'where clause' ERROR 1054 at line 1: Unknown column 'user_id' in 'field list' introducing a new user to the database failed
why? I think that the configuration file ser.cfg is ok.
thanks to all. Andrea
------------------------------------------------------- Andrea Girardi mobile +39 347 9624051 http://www.giandrea.com
You should have your SQL database structure updated. Run /usr/local/sbin/ser_mysql.sh and try again.
----- Original Message ----- From: giAndrea To: serusers@iptel.org Sent: Tuesday, July 22, 2003 5:20 PM Subject: [Serusers] serclt error
Hello
i've installed ser-0.8.11pre29-1.i386.rpm and mysql support. I've started ser service, but when i use serctl command to add new user this is the response:
ERROR 1054 at line 1: Unknown column 'user_id' in 'where clause' ERROR 1054 at line 1: Unknown column 'user_id' in 'field list' introducing a new user to the database failed
why? I think that the configuration file ser.cfg is ok.
thanks to all. Andrea
------------------------------------------------------- Andrea Girardi mobile +39 347 9624051 http://www.giandrea.com
------------------------------------------------------------------------------
_______________________________________________ Serusers mailing list Serusers@iptel.org http://mail.iptel.org/mailman/listinfo/serusers
8.10 and 8.11 ser/serctl use different table structures. It seems you are using 8.10 serctl with 8.11 SER. You need to use both 8.11, with username column called "username" now.
-jiri
At 11:20 AM 7/22/2003, giAndrea wrote:
Hello
i've installed ser-0.8.11pre29-1.i386.rpm and mysql support. I've started ser service, but when i use serctl command to add new user this is the response:
ERROR 1054 at line 1: Unknown column 'user_id' in 'where clause' ERROR 1054 at line 1: Unknown column 'user_id' in 'field list' introducing a new user to the database failed
why? I think that the configuration file ser.cfg is ok.
thanks to all. Andrea
Andrea Girardi mobile +39 347 9624051 http://www.giandrea.com _______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-- Jiri Kuthan http://iptel.org/~jiri/
-
giAndrea -
Jiri Kuthan -
Younger Wang