24 Nov
2003
24 Nov
'03
11:06 p.m.
Hello,
Hello again, do you know where I can find line 43 in
the SQL query?
this is the line 43 in file serweb/html/user_interface/reg/confirmation.php
The error came when serweb copies the new user from 'pending' to
'subscriber' table, but I can't say why.
User isn't deleted from 'pending' table and alias isn't created because
there is an error when user is copied.
Karel
Maybe I can figure out what is wrong if I know what
it's trying to do.
Doesn't serweb add an alias for the user? That was the next thing I
wanted to look into. I don't want users to select their own usernames, I
want to assign a number when they register. Not sure how to set that up,
though :)
Jon Ole
----- Original Message -----
From: Klaus Darilion <mailto:darilion@ict.tuwien.ac.at>
To: Jon Ole Nome <mailto:jonome@avitrans.no>
Cc: serusers(a)lists.iptel.org <mailto:serusers@lists.iptel.org>
Sent: Monday, November 24, 2003 9:44 PM
Subject: RE: [Serusers] Fw: Serweb problems - 0.8.12
Hi!
Please CC to the list!
Looks like serweb copies the new user from 'pending' to 'subscriber'
table, but failes to delete the new user from the 'pending' table.
I think these activities of serweb are unrelated to ser - serweb
interacts directly with the DB. Maybe the table/colum names have
changed slightly.
Klaus
-----Original Message-----
From: Jon Ole Nome [mailto:jonome@avitrans.no]
Sent: Monday, November 24, 2003 9:39 PM
To: Klaus Darilion
Subject: Re: [Serusers] Fw: Serweb problems - 0.8.12
Thanks for the quick reply! Looking in the database I see that
the new user is both in the pending and subscriber tables. Does
that tell you anything?
Jon Ole
----- Original Message -----
From: Klaus Darilion <mailto:darilion@ict.tuwien.ac.at>
To: Jon Ole Nome <mailto:jonome@avitrans.no> ;
serusers(a)lists.iptel.org <mailto:serusers@lists.iptel.org>
Sent: Monday, November 24, 2003 9:33 PM
Subject: RE: [Serusers] Fw: Serweb problems - 0.8.12
The aliases table is unrelated to this!
Serweb adds the user to the "pending" table and when you
confirm the registration by clicking the link, serweb moves
the user from "pending" to "subscriber".
Klaus
-----Original Message-----
From: Jon Ole Nome [mailto:jonome@avitrans.no]
Sent: Monday, November 24, 2003 9:29 PM
To: serusers(a)lists.iptel.org <mailto:serusers@lists.iptel.org>
Subject: [Serusers] Fw: Serweb problems - 0.8.12
I am running ser 0.8.12 with MySQL support on a RH9
server. Downloaded the latest serweb tarball from the
cvs. I can log in with existing userids, both on the
admin and user_interface web pages. If I try to register
a new user in serweb the registration process runs ok
and I get a mail asking for confirmation, but when I
click the link to confirm I get this error:
ringsip.com User Management
error in SQL query, line: 43
We regret but your ringsip.com confirmation attempt failed.
Please contact info(a)ringsip.com
<mailto:info@ringsip.com> for further assistance.
I have verified that the new user is added to the
database, and I can log in to user_interface with the
new userid. But there is nothing in the "aliases" table
in the database. Any ideas? Grateful for any help!
Jon Ole
------------------------------------------------------------------------
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers