DB Error: MDB2 Error: not found Query

[g_manesh]

Iam running IIS6 with hmail, mysql and round cube release 0.3 for my intranet mailing solutions.

My round cube is working fine except for the password changer plugin.

And Iam very new to all those things....

When I change the password, it says "Could Not Save New Password", and the error log says.... the following...

[Last executed query: SELECT update_passwd('$1$RLo@UZ/D$arxg8A8PwXu/xE0tJIIDT0', 'manesh@prajnareports.org')]
[Native code: 1305]
[Native message: FUNCTION prajnastudiosmails.update_passwd does not exist]
 [03-Jul-2010 05:18:25 +0000]: DB Error: MDB2 Error: not found Query: _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT update_passwd('$1$RLo@UZ/D$arxg8A8PwXu/xE0tJIIDT0', 'manesh@prajnareports.org')] [Native code: 1305] [Native message: FUNCTION prajnastudiosmails.update_passwd does not exist]  in C:\Intranet\WebMail\program\include\rcube_mdb2.php on line 627 (POST /index.php?_task=settings&_action=plugin.password-save?_task=&_action=)

Can anyone help me on this please,,, its very urgent for me....

Thanking you in advance.

[JohnDoh]

Hi,

You need to change the password_query in the config for the password plugin to what ever you need it to be for your setup, the one in the config by default is just an example - it replies on a function called update_passwd having been created in MySQL (again this is something you would have to setup).

[g_manesh]

Thank you boss.... as iam  very new to this,, where can i get some information on changing the password query please?

Also, after identifying the table which mail accountaddress and accountpassword are stored, and changed the same in config.php, the following error is displayed.

Native message: Unknown column 'modified' in 'field list']
 [03-Jul-2010 13:27:40 +0000]: DB Error: MDB2 Error: no such field Query: _doQuery: [Error message: Could not execute statement] [Last executed query: UPDATE `hm_accounts` SET `accountpassword` = '$1$4y7h4cyK$pevevLKNEnbzZ9GItpWzx1', modified=now() WHERE `accountaddress` = 'manesh@prajnareports.org' LIMIT 1] [Native code: 1054] [Native message: Unknown column 'modified' in 'field list']  in C:\Intranet\WebMail\program\include\rcube_mdb2.php on line 627 (POST /index.php?_task=settings&_action=plugin.password-save?_task=&_action=)


... and the query was changed into the below in config.inc.php

$rcmail_config['password_query'] = "UPDATE `hm_accounts` SET `accountpassword` = %c, modified=now() WHERE `accountaddress` = %u LIMIT 1";


Looking for some solution on this please.

Thanking you all in advance.

[JohnDoh]

I think your query might still be wrong coz the error "Native message: Unknown column 'modified' in 'field list'" is pritty clear.

[alec]

There's no "FROM table" in the query

[JohnDoh]

its an UPDATE query it doesn't need a FROM

[g_manesh]

but still, it says, Password cannot be saved... kindly help me please.... iam desperate on this.

Thanking you in advance.

[rosali]

The query should be:

$rcmail_config['password_query'] = "UPDATE `hm_accounts` SET `accountpassword`=%c WHERE `accountaddress` = %u LIMIT 1";

But even this won't work as hmailserver does not encrypt the password md5 anymore. Use hmail driver for the password plugin. It is included in recent SVN version (Roundcube Webmail).

[g_manesh]

Infact. i tried using the same also, by setting plugings array = ('settings', hmail_password') in main.inc.php.

It said php cannot initiate the plugin. I dont know where I gone wrong. I know Iam bugging everyone......

Kindly help me in setting the same please.

Thanking you in advance.

[rosali]

Did you try the hmail driver in the default password plugin?

Give me ftp access to roundcube folder, phpmyadmin access and a IMAP test account along with the URL to Roundcube. I'll see what I can do.

[g_manesh]

This is on an Intranet,,, Windows 2003 Server, IIS 6, PHP, MYSQL and Round Cube for my local use.

Moreover, I have not installed phpMyAdmin on the machine also.