Re: [RCU] How To Remove Users From Database

On 08/26/11 13:38, Carlos Mennens wrote:

On Fri, Aug 26, 2011 at 1:16 PM, Michael Orlitzky michael@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