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