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
versin mismatch: use CVS serweb with CVS ser and 8.10 ser with 8.10 serweb, that's it. 8.10 is at ftp://ftp.berlios.de/pub/ser/latest/, 8.11 on CVS.
-jiri
At 12:57 AM 7/16/2003, 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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-- Jiri Kuthan http://iptel.org/~jiri/
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Jan Janak -
Jiri Kuthan -
Marcelo Schmidt