[RCU] How To Remove Users From Database

Michael Orlitzky michael at orlitzky.com
Fri Aug 26 20:05:57 CEST 2011


On 08/26/11 13:38, Carlos Mennens wrote:
> On Fri, Aug 26, 2011 at 1:16 PM, Michael Orlitzky <michael at orlitzky.com> wrote:
>> Here's the RoundCube part. The user_id query is just "SELECT user_id
>> FROM users WHERE username = $1;"
> 
> I tried the RoundCube part of your ruby script & when I attempted to
> run the command straight into my database engine, it failed:
> 
> webmail-# FROM users WHERE username = $1;
> ERROR:  there is no parameter $1
> LINE 2: FROM users WHERE username = $1;
>                                                               ^
> Any ideas why that failed?

Did you replace,

  user_id = self.get_user_id(account)

with the user ID you want to delete? A plain old integer should work.
-- 
List info: http://lists.roundcube.net/users/
BT/9b404e9e



More information about the users mailing list