[Serusers] serweb

Marcelo Schmidt mschmidt at equinix.com
Wed Jul 16 10:34:13 CEST 2003

Yes, I know this a version mismatch.  I will upgrade ser version in this server soon, in the meantime I fixed the serweb.  Thanks. 
-----Original Message----- 
From: Jan Janak [mailto:jan at iptel.org] 
Sent: Wed 7/16/2003 12:20 AM 
To: Marcelo Schmidt 
Cc: serusers 
Subject: Re: [Serusers] serweb

	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.
	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 at iptel.org
	> http://mail.iptel.org/mailman/listinfo/serusers

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20030716/f1c2a49d/attachment.htm>

More information about the sr-users mailing list