Roundcube Community Forum

 

[0.5.2] Can't login and self registration not working

Started by jeffshead, May 02, 2011, 11:52:44 PM

Previous topic - Next topic

jeffshead

When attempting to login or self registering a new account, I get a "SERVICE CURRENTLY NOT AVAILABLE! Error No. [500]" on the screen and the following errors in the log:

[02-May-2011 23:45:11] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_8c9fb99cb4f155810638a18493c054a21529fbde6 FROM 'UPDATE users\n                SET  password=? \n                WHERE user_id=?;']
[Native code: 1054]
[Native message: Unknown column 'password' in 'field list']


[02-May-2011 23:45:11 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_8c9fb99cb4f155810638a18493c054a21529fbde6 FROM 'UPDATE users\n                SET  password=? \n                WHERE user_id=?;']
[Native code: 1054]
[Native message: Unknown column 'password' in 'field list']
 in C:\www\MYSITE.COM\program\include\rcube_mdb2.php on line 268 (POST /?_task=&_action=login)
[02-May-2011 23:48:20] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_521b65ed9b0270b96c0ff1ce1192fc43486aebb34 FROM 'UPDATE users\n                SET  password=? \n                WHERE user_id=?;']
[Native code: 1054]
[Native message: Unknown column 'password' in 'field list']


[02-May-2011 23:48:20 -0400]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_521b65ed9b0270b96c0ff1ce1192fc43486aebb34 FROM 'UPDATE users\n                SET  password=? \n                WHERE user_id=?;']
[Native code: 1054]
[Native message: Unknown column 'password' in 'field list']
 in C:\www\MYSITE.COM\program\include\rcube_mdb2.php on line 268 (POST /?_task=login&_action=login)


Any ideas?
I just performed a clean install of RC 0.5.2. It used to work in RC 0.4x. I also noticed there is no password field in the users table of the RC 0.5.2 database but there is one in the RC 0.4x database.


UPDATE:
I manually added the password field to the database and it now seems to work. Is this a bug in the RC 0.5.2 release? Shouldn't the installer have created the password field?

rosali

The password field is required for the 'savepassword' plugin. It is not part of the default database structure. This is not a bug.
Regards,
Rosali

jeffshead

#2
Quote from: rosali;34593The password field is required for the 'savepassword' plugin. It is not part of the default database structure. This is not a bug.

Thank you for the reply. It's been a while since I've installed RC and I just don't recall manually adding that field to the database.

Please change status to solved.