Category: User Administration (Registration, Login & Banning)

Not sure if this is prevalent in 1.10.0 or not, but...

User twentytwo had problems in IRC with user registration set to ON with validation set ON. When the regisration form was submitted by the new user, the script would bomb with an SQL error because the first three fields were nulls and couldn't be.

I could only reproduce this bug when User Registration was turned on, with validation also turned on, but with General->Sender email UNSET. So during setup, the sender email was not set. As I also do not have this set at home since I don't want to send any emails, I was able to reproduce the problem. With sender email SET, there is no DB error.

When a user is registering on a tiki, within the default template, if there is an error, it is no longer obvious that there is an error. The errors use to be highlighted, but now they are black text that looks like field descriptions.

Using a Tiki at tiki-admin.php?page=login you can set the user to receive an email to validate its account or as welcome.
This work fine.

You can also use a tracker plugin in a wiki page to fill a tracker item and set that this include a registration.
However the user then doesn't receive any email or validation email.

There is a parameter "Validate users" (y/n) that override only part of the process:
"Here one can overrule the default validate users by e-mail preference"

Setting to Y, users are validated automatically.
They don't receive the registration validation email or anything else (all process is overruled) .

Setting to N, users are not validated.
But, they also don't receive the registration validation email or anything else (all process is overruled) .

in templates/mail/moderate_validation_mail.tpl this line is converted badly by smarty:
{$mail_machine}?user={$mail_user|escape:'url'}&pass={$mail_apass}}?user={$mail_user|escape:'url'}&pass={$mail_apass}Hi

to

http://www.olgpuchong.org/community/tiki-login_validate.ph?user=paulquek&pass=ef786a8eac742d7502b87668f5132cf7

were
tiki-login_validate.php has a missing "p"

this result in bad link for user registration validation

{syntax type="tiki" editor="plain"}
Users can have several status:
*new account (needs to be validated)
*normal account.

Maybe we will want more in the future (ex.: suspended)

It would be good for the admin to be able to see the status in tiki-adminusers.php, filter by type and change/override the status. Ex.: a user never received the validation email because of spam filter.

Users Information Tracker Fields Asked at Registration Time
(fieldIds separated with :)
corresponds with the Tracker plugin's fields

No autoassign is possible by the time of registration, while the plugin would offer that TW5<=.

They are case you want your user to create a tracker item at creation but want them to fill supplemental information later.

When setting tracker to store user information (Log-In, https://doc.tiki.org/User-Tracker) if in the Group setting you don’t assign anything for "Group or User Tracker Registration Fields" (if you don’t need to fill anything more but to save an item with the username) the tracker item is not created.

To reproduce the bug;
Set everything like described at : https://doc.tiki.org/User-Tracker

On the Group page for the registered group let "Group or User Tracker Registration Fields" empty. The registration will work but no item will be created.

Add any field of the user tracker in the "Group or User Tracker Registration Fields" and it will work.

I would like to send a message to my users, with a unique URL, so they can update their user tracker without needing to login.

{syntax type="tiki" editor="plain"}
Please see:
((doc:User Preference Field))
((doc:User Trackers))


Missing:
Avatar, Full name, URL, avatar, etc.


Also, each relevant field here should optional tiki-user_preferences.php

Tiki Wiki CMS Groupware v16.0svn (SVN) "Situla"
Last update from SVN (16.0svn): Monday 31 October 2016 12:39:28 GMT-0100- REV 60095

Users register to the site autonomously.
Registration is set to validation by Administrator.
Member of group Admins cannot validate the users - neither by the validation link in the notification email, nor by logging in and trying manual validation on-site.

So no new users possible at this site with registation moderation.
This is a crucial bug.

Update 6 Nov 2016: it was reportedt, that 'creation of users' is broken at all in current Tiki16.

Userlist accessed from Community menu displays on page 1 the first 10 of my 18 users, on page 2 I see 8 users but they are names from the first list and in different order!!! This wiki is a fresh install of 1.9 using a DB sucessfully(?) upgraded from 1.8.5

When user has spaces in their name they can`t use messaging system
try "test user" as username

In earlier versions of Tiki, usernames for login were case insensitive.
marclaporte = MarcLaporte

Now, they are case sensitive:
marclaporte <> MarcLaporte

This is a usability problem, especially with non-technical users.

When trying to login with their username (with a different case) they get "Invalid username or password".

So they try to use tiki-remind_password.php (again with the wrong case) The error message is: "Unable to send mail. User has not configured email: MarcLaporte"

So they end up trying to create another user. When they try to create a new user with a different case, they get an error "User already exists". If usernames are really case sensitive, I should be able to create 2 distinct users, MarcLaporte and marclaporte. This would obviously lead to confusion.

My request / suggestion:

Restore case insensitiveness in usernames for logins (or at least restore the option with much better error messages when in case sensitive mode)

Thanks!

M ;-)

I have two users at tw.o: xavi and xavidp. Both with lower case.

I can log in on doc.tw.o using either Xavi or xavi. When I log in with user Xavi, when I click on watching adding a page, or watching another page, I get this type of error:
{CODE(wrap=>1)}
An error occured in a database query!

Context:
File tiki-editpage.php
Url tiki-editpage.php
Query:
insert into `tiki_user_watches`(`user`,`event`,`object`,`email`,`type`,`title`,`url`) values(?,?,?,?,?,?,?)
Values:
0 Xavi
1 wiki_page_changed
2 Tikiwiki 1.10 ca
3 NULL
4 wiki page
5 Tikiwiki 1.10 ca
6 tiki-index.php?page=Tikiwiki 1.10 ca
Message:
Column 'email' cannot be null
Built query was probably:
insert into `tiki_user_watches`(`user`,`event`,`object`,`email`,`type`,`title`,`url`) values('Xavi','wiki_page_changed','Tikiwiki 1.10 ca',NULL,'wiki page','Tikiwiki 1.10 ca','tiki-index.php?page=Tikiwiki 1.10 ca')
{CODE}

At https://next.tiki.org/tiki-list_articles.php my username is changed to the letter "n".

{img fileId="1658" thumb="box"}
{img fileId="1659" thumb="box"}

Tiki.org is set to force "Minimum 4 characters long" for username on registration.
An error "Minimum 4 characters long" appears before any test is done on the field.

It should appear until the field is checked.
If this is a warning, then it should look like a warning but not an error.

Checked on Tiki 16 and Trunk.

Click on "Delete my account" as user has no effect. The user has the permission "tiki_p_delete_account". A look into "tiki-user_preferences.php" shows, that the button "deleteaccount" is not handled.

TikiWiki 4.2

Tested with R26214. Delete-Button didn't work yet. Perhaps forget the upload?

I do not know when the regression was introduced (that used to work in earlier Tiki12 versions maybe?), but with latest Tiki12 and trunk (as of Nov 7, 2014), the setup to have users choose group at registration time, and fill in the form of the associated user tracker item for each group, fails at some point, since the user can't get to see the form at all, but just a never-ending spinner attempting to load something (the form)

{img fileId="956" thumb="y" rel="box[g]"}

In that place, the loading spinner never ends.

Reproduced in general here:
http://xavi-9794-5501.show.tikiwiki.org/tiki-register.php

Login as admin to see the setup:
u: admin
p: 12345

In this show instance the spinner does end, but no form is shown either wih the fields to be filled, etc.

I meant to ask if anyone has a clue what this could be caused by? I don't see anything in the console which baffles me. The regCapsLock error that Brendan mentions below might be a false lead - when I add tracker fields to the registration it works but that error is there too, so it may be unrelated.

In Tiki 16, there is a problem where user cannot register. After clicking "Register", the use sees "Saving..." spinner forever.

I can confirm the problem disappears if you add user tracker fields to the registration. i.e. the problem only occurs on the basic registration setup.

See below for more information.




On 06.11.2016 16:36, Brendan Ferguson wrote:
Ive confirmed its a JS error. When I disable javascript with NoScript, it works fine.

Brendan



On Nov 6, 2016, at 10:29 AM, Nelson Ko <nelson@citadelrock.com> wrote:

I finally managed to roll back to r60095 but it doesn't help. Which is bizarre since I can register on tiki.org. The registration form on tiki.org is more than the default one though (has tracker info). So maybe it has something to do with that but that is just a guess. So anyway if someone else has time to troubleshoot it will be great - I will have to check back later.

On Sun, Nov 6, 2016 at 10:20 AM, Brendan Ferguson <drsassafras@gmail.com> wrote:
Ive got a console error here.

ReferenceError: event is not defined

regCapsLock(event);

Its not my area of expertise.

Ive verified that user creation through the admin panel is unaffected.

Brendan

I've confirmed that there is no user creation in the database when this error occurres. It's what one would expect with this kind of error, but it's good to make sure :)
Dr Sassafras

Users do not receive registration confirmation emails.

whereas admin does receive the registration asks by email and also receive its watch notification.
(which seems to exclude configuration php.ini config...)

Using 1.9 cvs from a week ago (more or less)

I made a site (in a multitiki install as subdirectories, in case it matters) with "Request passcode to register:" off, and "Prevent automatic/robot registration" as on. New registrations work fine.

( http://moviments.net/valldelcorb )

Then I shifted to "Request passcode to register:" on (and a simple string of 8 letters, no special chars., in "request passcode to register", with checkbox on), and Prevent automatic/robot registration as off. New registrations fail.
I tried myself with several new users, or emails (and e-mail domains), and I don't get any confirmation email.

I created another site on the same multitiki installation on the same server, with a duplication of the same database to start with, and set back login params. as "Request passcode to register:" off, and "Prevent automatic/robot registration" as on. New registrations with same user details (username, password, email) and they work fine. I get the confirmation email in less than 5 min.

( http://moviments.net/drecerca )

It looks like a bug is hidden somewhere there...
--------
Update: April 17th

It's kind of weird.... On a third site in the same multitiki install (on the same server, of course), tiki registration works ok having "Request passcode to register:" on (and a simple string of 13 letters), and Prevent automatic/robot registration as off.

http://moviments.net/diaspora

Weird... I wonder if this is not some configuration problem... in that tiki, even if I did (that I remember of) nothing different from the other tikis.... :-/ ¿?
-----------
Update August 11th 2007
Updated 1.9 cvs code from today in
[http://margalef.ourproject.org]
which have both request passcode to register as on, and prevent automatic registration of robots as on.
I got the confirmation email to my inbox, I clicked on the full link to validate the new registration request (it was from a google account, recognizing properly the full url link), but I got the answer from the tiki site:
"User or password not valid" (or something similar, since I have translated it from another language)
Still something not fully fixed around there...
-----------------
^
-=Update August 12, 2007=-
I close the bug, since I cannot reproduce it myself in many sites. And I marked as not enough information, since it seems that on one of the sites, the problem is still there.^

I updated the 1.9 cvs code and cleaned tiki caches. There is still some problem on the http://moviments.net/valldelcorb installation, which is using a modified twist theme (in case it matters, even if not using any special template for registration of mail sending). If request passcode to register is on, no messages are received to mailboxes (tried on 2 different ones).

But on other installations of the same multitiki (for instance, http://moviments.net/drecerca , based upon a modified planetfall theme), mails are sent ok, and once validated the link, the account is successfully created, etc.

Last, but not least, I've realized on the http://margalef.ourproject.org tiki install (not multitiki at all, and on another server; using also a modified planetfall theme), last time (the trial from yesterday, August 11th), I received a second email message 3 minutes later, to the same mail box, and regarding the same single user account request made from me, with a different url to validate the account (something weird, isn't it?). This second url worked fine to validate the account, but not the first.

In any case, with updatd cvs code from today, I got normal behavior for new registrations on http://margalef.ourproject.org , using "request passcode to register" as on.

Whatever it was, it seems mostly fixed. And since it seems that I'm only the one with this weird behavior, I close the bug report.
If anybody else find similar problems, just reopen.

Thanks for checking the code for this issue, for those of you who invested time to check that the code was ok.

On a Tiki24 I go to :/tiki-adminusers.php click on add a new user.
Fill everything but omit the email and click "Add".

I'm redirected a new page with an error:
"We were unable to create your account because this email is already in use"
Everything is lost.


Prefs related to log-in;
allowRegister = 'y' ('n')
userTracker = 'y' ('n')
user_unique_email = 'y' ('n')

If you use the validation link for userA while you are logged as userB you will see the "Validation was successful" page/message.

While this is not a common case, Tiki should tell that this link for userA is not valid for userB.

Tiki newsletter works well for small volumes.

But for large volumes, as with any web app, sending emails from a server can be a challenge. Risk of being flagged as spammer, high server load/difficult to throttle, limits from your web hosts (ex.: max x emails per hour), etc

A helpful alternative would be something like this:
https://addons.mozilla.org/en-US/thunderbird/addon/4883

So my Thunderbird client or desktop newsletter application (ex.: [http://gammadyne.com/mmail.htm|Gammadybe Mailer]) should be able to access the TikiWiki database to generate recipient list.



---

Another approach is to make the Tiki contacts (address book) accessible via the LDAP protocol and thus, email clients can access.

Related:
http://www.egroupware.org/egroupware/index.php?menuaction=wiki.uiwiki.view&page=AddresbookAccountsConcept

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?