Category: User Administration (Registration, Login & Banning)

I have encountered a few snags after upgrading from Tiki 1.9.11 to 2.0

One of the problems is that I am unable to register / add users, because of the following error message:

An error occured in a database query!
Unknown column 'email_confirm' in 'field list'

This happens on
tiki-register.php (registration) and tiki-adminusers.php (batch upload / add)

Is there a fix for this?

Seems like Tanzania keeps falling out of the country list. This was the case some years ago. Might as well add Swahili as a language option if applicable.

I have an error when I try to add a new user:

{img src=images/code.png}%%% {CODE()} 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 trenad
1
2 n.trepanier@rrsss16.gouv.qc.ca
3
4 1224014104
5 $1$98TWiy55$sm3YVgaZTDG8wTR6O9kvz0
6 1224014104
7 1224014104
8 1224014104
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('trenad','','n.trepanier@rrsss16.gouv.qc.ca','','1224014104','$1$98TWiy55$sm3YVgaZTDG8wTR6O9kvz0','1224014104','1224014104','1224014104',NULL,NULL,NULL,NULL){CODE}

Do you guys have any idea what is happening.

User set forum style as Plain and save it after next login style is Threaded again.

{syntax type="tiki" editor="plain"}
Enabling 2FA for a user works, but when trying to login, one is presented with a System Error page. With debug enabled, we see:

'''
System error.

The following error message was returned:

Unknown column 'last_mfa_date' in 'SET'

The query was:
update `users_users` set `last_mfa_date` = ? WHERE `login` = ?

Values:

1788618450
username

The built query was likely:
update `users_users` set `last_mfa_date` = '1788618450' WHERE `login` = 'username'
'''

I can confirm that adding in the column manually with:

alter table users_users add column if not exists last_mfa_date bigint DEFAULT NULL;

has allowed me to login/logout with MFA enabled.

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

{syntax type="tiki" editor="plain"}
I have been having problems upgrading from previous versions and decided to install a new blank install of v7. Everything works fine until I try and log in with the admin user name and password I created during the install process. I receive a message that cookies need to be enabled. This is not a message that I have had before on any prior versions and cookies are definitely enabled in my browser. I have tried with Chrome, FireFox and IE and the problem is the same on v7. I have seen various discussions on this topic in the forums but it seems there is no resolution for this one and no clear answer as to what is causing it. My URL's have no ~ in them.

{syntax type="tiki" editor="plain"}
The login window in Tiki7, using the Fivealive Theme, and when using the "Register" and "I forgot my password" features, those two link options are too close together unlike in Tiki 6.x.

In v6 those options were horizontally side-by-side. In v7 they are stacked vertically. When pointing directly on the text for "Register" the option "I forgot my password" is selected. To select the Register option, you have to move the pointer above the "Register" option to activate that page.

This happens regardless of OS or browser as I've tried it in XP Pro (32bit) using Firefox 5, Win7 Ultimate (on a 64 bit virtual machine), using Chrome and Firefox5 and Ubuntu 10.4 (32bit), using Firefox 5, Konqueror and Chromium.

Though I've been able to figure out where to hover the pointer to make the appropriate selection, my site visitors aren't likely to figure that out and leave the site out of frustration.

{syntax type="tiki" editor="plain"}
Does the "Users Information Tracker Fields Asked at Registration Time" work for someone in 6.1? it used to work in 5.x. not pretty.

This feature was not particularly important if the trackers with registration="y" would work nicely. Read more here.
[http://irc.tiki.org/irclogger_log/tikiwiki?date=2011-01-08,Sat&sel=52#l48]

1 click to add a login box instead of using the login module.

A user with all forum-perms except tiki_p_admin_forum can edit any forum post.
That shouldn't be like that..

A user is subscribed to a forum. Everything works fine (no messages are sent by the server to blank email addresses).

An admin deletes that user.

When a new message is posted to that forum, there is a message sent to a blank address, which is then returned to the server users from which the posts where sent.

It seems as if the forum still tries to send a copy of the post to that user, but has no address to send it to, since the user was deleted.

{syntax type="tiki" editor="plain"}
I can't seem to get the self registration of a new user to work in a new install of Tikiwiki 4.0. I can do the self registration, and get the email to validate, and can even successfully validate the account. However, once validated, any subsequent time I try to resign on, I get "Error" page showing "Account Disabled".

If admin account validation is enabled, Admin receive mails to confirm users registration.

But, if the admin is logged (with its own account) on tiki when he clicks the confirmation url, the user is not well-registered (provpass is still there in DB).

Whereas if he is not logged on, the registration works well.

Action log broken: wiki page editions not shown

Reproduced in demo.t.o/12x:

I've edited today the homepage, and yesterday somebody else did, as it can be seen in the wiki page history or the wiki last changes for the past 2 days:
* http://demo.tiki.org/12x/tiki-pagehistory.php?page=HomePage
* http://demo.tiki.org/12x/tiki-lastchanges.php?days=2

But when in the action log, nothing is reported as changed regarding wiki pages (and it's set to show wiki editions):
* http://demo.tiki.org/12x/tiki-admin_actionlog.php?startDate_Month=12&startDate_Day=02&startDate_Year=2003&Time_Hour=13&Time_Minute=00&Time_Second=18&endDate_Month=12&endDate_Day=14&endDate_Year=2003&end_Hour=13&end_Minute=00&end_Second=18&categId=&unit=bytes&contribTime=w&find=&max=25&list=Report#Report

This feature is __very important__ to be working bug-free since it's one of the easy ways to detect damage by intruders, and ban them in bulk through the action log.

----
For some reason, the day I first tested this and reported as a bug, the years were staying in the past (2003, and not 2013, ...). It seems fixed. Closing.

Ex.:
tiki-adminusers.php?group=Editors


It will make it easier to manage groups.

You cant set it that individual polls can be set to viewed by only certain groups.

It took me quite a while to figure out where the "unsuccessful login attempts" options were.
https://doc.tiki.org/Login+General+Preferences

I think some additional admin panel search terms might include:
"brute force"
"brute-force"
"login failure"
"login-failure"
"failed logins"

Thanks!
Pete

It would be really handy to be able to quickly switch between several users when testing complicated permissions setups, so a little "recent users" dropdown that switches when selected would really speed things up.

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)

Adding many users at once to a group fails in 12.x, and it used to work nicely in 9.x LTS at least.

I had Jquery Chosen enabled, and when I disabled it, I was able to add them to a group through tiki-adminusers.php as usual.


To reproduce, go to:
http://xavi-9794-5163.show.tikiwiki.org/tiki-adminusers.php

u: admin
p: 12345

select both users (user1 & user2), click at "Manage group assignments", and choose to assign them to group "Admins". Validate the confirmation step. Nothing happens (they are not added to the Admins group).

Repeat without JQuery Chosen, and it will work as expected.
---
Update {sign user="xavi" datetime="2014-04-07T07:44:15+00:00"}
Actions on multiple users with chosen and sortable tables work, but the second dropdown is not shown properly:
{img fileId="742" thumb="y" rel="box[g]"}
---
Update {sign user="xavi" datetime="2015-04-02T08:04:24+00:00"}
You can't even select any groups at the step to choose group in the multi selection combo box.
{img fileId="992" thumb="y" rel="box[g]"}
---
Update {sign user="lindon" datetime="2015-04-07T03:41:55+00:00"}
I am not able to recreate this [[the former issue report related to jquery sortable tables] using my local 12x - I am able to add or remove multiple users to multiple groups. Did it with 25 users with no issue. The list of groups came up properly and I was able to multi-select.
---
Update {sign user="xavi" datetime="2015-12-16T07:59:32+00:00"}: removed references to Tablesorter as I could confirm that at least with current code (thanks lindon for checking!) the issue seems to be attibuted to Chosen only.

{syntax type="tiki" editor="plain"}
If I create a new group in tiki-admingroups.php, and want to add a user, I must go to tiki-adminusers.php

I should be able to add users to groups from tiki-admingroups.php, with a drop-down (if < 500 users) or a search username box (if users > 500) , or something like this...