Topic: roundcube password plugin error
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.5.1 MARIADB
- Deployed with iRedMail Easy or the downloadable installer? downloadable
- Linux/BSD distribution name and version: CentOS Stream release 8
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): mysql
- Web server (Apache or Nginx): nginx
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
I have update iredmail, including roundcube software. after that password change plugin doesn't work properly at the roundcube web gui.
I get on the password page: could not save new password
at the log file i got:
Sep 2 01:37:26 server roundcube[281465]: <jcoeonu1> DB Error: [1064] You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '%D,passwordlastchange=NOW() WHERE username='user@domain.com'' at line 1 (SQL Query:
UPDATE mailbox SET password=%D,passwordlastchange=NOW() WHERE username='user@domain.com') in /opt/www/roundcubemail/program/lib/Roundc
ube/rcube_db.php on line 564 (POST /mail/?_task=settings&_action=plugin.password-save)
after i made some google , but with no luck, other password_query line produce same error:
Sep 2 02:19:56 server roundcube[283077]: <jcoeonu1> DB Error: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%c, modified=now() WHERE `username` = 'user@domain.com' LIMIT 1' at line 1 (SQL Query: UPDATE `mailbox` SET `password` = %c, modified=now() WHERE `username` = 'user@domain.com' LIMIT 1) in /opt/www/roundcubemail/program/lib/Roundcube/rcube_db.php on line 564 (POST /mail/?_task=settings&_action=plugin.password-save)
Can you please help with that?
Regards
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.