Author Topic: [0.5.2] Can't login and self registration not working  (Read 3204 times)

Offline jeffshead

  • Full Member
  • ***
  • Posts: 71
[0.5.2] Can't login and self registration not working
« on: May 02, 2011, 11:52:44 PM »
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?
« Last Edit: May 03, 2011, 12:36:05 AM by jeffshead »

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
[0.5.2] Can't login and self registration not working
« Reply #1 on: May 03, 2011, 12:55:27 AM »
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
__________________
MyRoundcube Project (commercial)

Offline jeffshead

  • Full Member
  • ***
  • Posts: 71
[0.5.2] Can't login and self registration not working
« Reply #2 on: May 03, 2011, 01:01:52 AM »
Quote from: rosali;34593
The 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.
« Last Edit: May 03, 2011, 05:19:50 AM by jeffshead »