Loading...
 
Skip to main content

Add user fails after upgrade from 1.9.11 to 2.0

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Add user fails after upgrade from 1.9.11 to 2.0
Version
2.x
Category
  • Error
Feature
User Administration (Registration, Login & Banning)
Resolution status
Out of Date
Submitted by
hfalk
Lastmod by
Marc Laporte
Rating
(0)
Description

I have upgraded from 1.9.11 to 2.0 and now I cannot add users manually in "Admin users"

I get the following error when adding user "testuser" with pasword "testuser" as an example...

An error occured in a database query!

Context:
File tiki-adminusers.php
Url tiki-adminusers.php
Query:
insert into `users_users`(`login`, `password`, `email`, `provpass`, `registrationDate`, `hash`, `pass_confirm`, `email_confirm`, `created`, `valid`, `openid_url`, `lastLogin`, `waiting`) values(?,?,?,?,?,?,?,?,?,?,?,?,?)
Values:
0 testuser
1
2
3
4 1220738236
5 $1$opJz3I9u$Qcgr2S0jFBIBklNAdZyv60
6 1220738236
7 1220738236
8 1220738236
9 NULL
10 NULL
11 NULL
12 NULL
Message:
Unknown column 'email_confirm' in 'field list'
Built query was probably:
insert into `users_users`(`login`, `password`, `email`, `provpass`, `registrationDate`, `hash`, `pass_confirm`, `email_confirm`, `created`, `valid`, `openid_url`, `lastLogin`, `waiting`) values('testuser',,,'','1220738236','$1$opJz3I9u$Qcgr2S0jFBIBklNAdZyv60','1220738236','1220738236','1220738236',NULL,NULL,NULL,NULL)

Solution

Sorry the release was done with a bug
You need to run this sql command in phpMyadmin or ....
ALTER TABLE users_users ADD email_confirm int(14) default NULL;

Importance
8
Priority
40
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
2015
Created
Saturday 06 September, 2008 22:05:02 UTC
by Unknown
LastModif
Thursday 14 January, 2010 19:26:48 UTC


Show PHP error messages