[Serusers] Fw: Serweb problems - 0.8.12

[Karel Kozlik]

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 at ict.tuwien.ac.at>
>     To: Jon Ole Nome <mailto:jonome at avitrans.no>
>     Cc: serusers at lists.iptel.org <mailto:serusers at 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 at 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 at ict.tuwien.ac.at>
>             To: Jon Ole Nome <mailto:jonome at avitrans.no> ;
>             serusers at lists.iptel.org <mailto:serusers at 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 at avitrans.no]
>                 Sent: Monday, November 24, 2003 9:29 PM
>                 To: serusers at lists.iptel.org <mailto:serusers at 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 at ringsip.com
>                 <mailto:info at 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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers