Loading...
 
Skip to main content

15.x: Can not change a user password: Unknown column 'password' in 'field list'

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
15.x: Can not change a user password: Unknown column 'password' in 'field list'
Version
15.x
15.x Regression
Category
  • Regression
Feature
Admin Interface (UI)
User Administration (Registration, Login & Banning)
Resolution status
Works For Me
Submitted by
Xavier de Pedro
Lastmod by
Jonny Bradley
Rating
(0)
Description

I tried to change the password of my user with admin perms, and I couldn't.
I was using this type of url:
tiki-adminusers.php?numrows=25&sort_mode=login_asc&user=2

This system error message was shown:

Copy to clipboard
System error.
El siguiente mensaje de error fue devuelto:

 Unknown column 'password' in 'field list'
The query was:

update `users_users` set `hash`=? ,`password`=? ,`pass_confirm`=?, `provpass`=? where binary `login`=?
Values:

$1$U7wIlongstringhhere5utVMvA1
14numbershere85
UserName
The built query was likely:

update `users_users` set `hash`='$1$U7wIlongstringhhere5utVMvA1' ,`password`='' ,`pass_confirm`='14numbershere85', `provpass`='' where binary `login`='UserName'
Things to check:

Is your database up and running?

Is your database corrupt? Please see how to repair your database

Are your database credentials accurate? (username, database name, etc in db/local.php)

Did you complete the Tiki Installer?

Please see the documentation for more information.

Workaround
Tried on my local and it was fine, so a local db weirdness i guess?
Importance
8
Easy to solve?
5
Priority
40
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
6015
Created
Monday 04 July, 2016 14:14:23 UTC
by Xavier de Pedro
LastModif
Sunday 18 June, 2017 23:14:12 UTC


Show PHP error messages