Hello,
when I start my roundcube installation I only see a white screen. The log says that this line is wrong, but I can't figure out what is wrong. I have chosen this configuration from the readme file of the extension:
$config['password_query'] = 'UPDATE users SET password=ENCRYPT(%p,concat(_utf8'$1$',right(md5(rand()),8),_utf8'$')) WHERE username=%u LIMIT 1';
Log: [10-Mar-2015 12:44:06 Europe/Berlin] PHP Parse error: syntax error, unexpected T_STRING in /var/www/.../plugins/password/config.inc.php on line 67
I'm using version 1.1.0
Regards, Pingponguin
You have unescaped quotes, try the following:
$config['password_query'] = "UPDATE users SET password=ENCRYPT(%p,concat(_utf8'$1$',right(md5(rand()),8),_utf8'$')) WHERE username=%u LIMIT 1";
That didn't change anything. Could the code be wrong?
you should also check the pervious lines in the file for missing quotes or semi colons, just incase.
Hello,
I'm one step further and one back. Now I'm getting this error message:
[11-Mar-2015 17:49:36 +0100]: <rhrg5aed> DB Error: [1054] Unknown column 'password' in 'field list' (SQL Query: UPDATE users SET password=ENCRYPT('*****',concat(_utf8'$1$',right(md5(rand()),8),_utf8'$')) WHERE username='[email protected]' LIMIT 1) in /var/www/virtual/***/]mail.domain.tld/program/lib/Roundcube/rcube_db.php on line 541 (POST /?_task=settings&_action=plugin.password-save?_task=&_action=)What does this mean?
Thanks and regards
The error is saying that there isn't a password field in the query. Did you customize the SQL query to fit your environment?
Quote from: SKaero on March 11, 2015, 01:25:25 PM
The error is saying that there isn't a password field in the query. Did you customize the SQL query to fit your environment?
I just put in the roundcube DB settings. Do I have to setup a table for the passwords or an extra DB and how do I have to call it?
You need to connect to the database that stores your mail accounts (not the Roundcube DB) and write a query that will update the account password. The query is going to be different depending on how your environment is setup so I can't post what it would be.