Loading...
 
Skip to main content

Features / Usability


error when adding user

I'm using Tikiwiki 2.1 and I'm having problems adding users. When I add users via the Admin/Users module, I get this error. How do I fix this?


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 us...@do...
1
2 us...@do...
3
4 1223325992
5 4aa238969218088c81c450dc2e58ff2c
6 1223325992
7 1223325992
8 1223325992
9 NULL
10 NULL
11 NULL
12 a
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('us...@do...',,'us...@do...',,'1223325992','4aa238969218088c81c450dc2e58ff2c','1223

I read a lot of similar problems on http://dev.tikiwiki.org/Question => Bug Reports List

Actually I can't load the page, so try, if you can, and have a look maybe using the different search options.

I only remember very vaguely (!), that there were mentioned perhaps to deactivate the "validate user by email", when you have checked "user can register" and "but need confirmation by admin" (all under tiki-admin.php?page=login).

Just an idea ...


I think I managed to fix it. I think something didn't quite go right in my upgrade from 1.91 to 2.1 so I reupgraded the db and it started working again!