RE: [Serusers] serweb - sr-users

16 Jul 2003

Jan,

Yes, I know this a version mismatch.  I will upgrade ser version in this server soon, in
the meantime I fixed the serweb.  Thanks. 

--M

-----Original Message----- 
From: Jan Janak [mailto:jan@iptel.org] 
Sent: Wed 7/16/2003 12:20 AM 
To: Marcelo Schmidt 
Cc: serusers 
Subject: Re: [Serusers] serweb

	Hello,

	you are using old database tables. The database scheme has been changed,
	correct column name is username now.

	That probably means that you are using ser 0.8.10 (which uses the old
	database scheme) and serweb from cvs -- which uses the new scheme.

	I suggest you to convert you database to the new scheme and upgrade your
	ser to the latest stable branch from the CVS.

	 Jan.

	On 15-07 15:57, Marcelo Schmidt wrote:
...
  This is a serweb error but I hope someone saw same
error before in this
 list. Serwer defined 'username' and in mysql subscriber table the
 correct name is 'USER_ID'. However I went through all the serweb code to
 find where else is calling username instead of USER_ID but I couldn't
 find anything else that I already replaced.

 Database error: Invalid SQL: select username, perms from subscriber
 where phplib_id = '65e397cda0aa8e3202ea22cbd350e4e9'
 MySQL Error: 1054 (Unknown column 'username' in 'field list') Session
 halted.

 --M

 _______________________________________________
 Serusers mailing list
 Serusers(a)iptel.org
 http://mail.iptel.org/mailman/listinfo/serusers