<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6396.0">
<TITLE>Re: [Serusers] serweb</TITLE>
</HEAD>
<BODY dir=ltr>
<DIV>Jan,</DIV>
<DIV> </DIV>
<DIV>Yes, I know this a version mismatch. I will upgrade ser version
in this server soon, in the meantime I fixed the serweb.
Thanks. </DIV>
<DIV> </DIV>
<DIV>--M</DIV>
<DIV> </DIV>
<DIV><FONT size=2>-----Original Message----- <BR><B>From:</B> Jan Janak
[mailto:jan@iptel.org] <BR><B>Sent:</B> Wed 7/16/2003 12:20 AM <BR><B>To:</B>
Marcelo Schmidt <BR><B>Cc:</B> serusers <BR><B>Subject:</B> Re: [Serusers]
serweb<BR><BR></DIV></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><FONT size=2>Hello,<BR><BR>you are using old database tables. The database
scheme has been changed,<BR>correct column name is username now.<BR><BR>That
probably means that you are using ser 0.8.10 (which uses the old<BR>database
scheme) and serweb from cvs -- which uses the new scheme.<BR><BR>I suggest you
to convert you database to the new scheme and upgrade your<BR>ser to the
latest stable branch from the CVS.<BR><BR> Jan.<BR><BR>On 15-07 15:57,
Marcelo Schmidt wrote:<BR>> This is a serweb error but I hope someone saw
same error before in this<BR>> list. Serwer defined 'username' and in mysql
subscriber table the<BR>> correct name is 'USER_ID'. However I went through
all the serweb code to<BR>> find where else is calling username instead of
USER_ID but I couldn't<BR>> find anything else that I already
replaced.<BR>><BR>> Database error: Invalid SQL: select username, perms
from subscriber<BR>> where phplib_id =
'65e397cda0aa8e3202ea22cbd350e4e9'<BR>> MySQL Error: 1054 (Unknown column
'username' in 'field list') Session<BR>> halted.<BR>><BR>>
--M<BR>><BR>> _______________________________________________<BR>>
Serusers mailing list<BR>> Serusers@iptel.org<BR>> <A
href="http://mail.iptel.org/mailman/listinfo/serusers">http://mail.iptel.org/mailman/listinfo/serusers</A><BR></FONT></P></BLOCKQUOTE>
</BODY>
</HTML>