Textpattern CMS

#1 2007-07-18 11:19:03

diniscorreia

Member

From: Lisbon, Portugal

Registered: 2007-07-18

Posts: 19

User logins: case-sensitivity

Hi there,

Simply put, I created an account on a Textpattern installation for a client of mine. The username chosen was ‘otic’ (like this, all lowercase).

A few days ago, I logged in and saw, in the Articles section, that some artciles had ‘otic’ on the article’s author and others had ‘OTIC’ (all uppercase). My thought was that the client was entering the username in lowercase sometimes and uppercase other times – still, I thought it as strange that articles’ author name would change according to that.

So yesterday my clients say he can’t edit his own articles. Conclusion: if he logs in as ‘otic’ he can only modify the artcile published by ‘otic’, and when he logs in with ‘OTIC’… well, you get were this is going.

This is a very serious issue. Eitheir the system should be case-insensitive in all areas or case-sensitive. It’s case-insensetive for logins, but case-sensitive for user roles and permissions? Makes no sense to me.

Anyone having similar issues?

Thanks,
-Dinis Correia

EDIT: realized there is a Troubleshooting discussion – could someone pleas move this post? Thanks!

(Edit: updated discussion topic. -Mary)

Last edited by Mary (2007-07-19 01:43:39)

#2 2007-07-18 11:36:40

Sencer

Archived Developer

From: cgn, de

Registered: 2004-03-23

Posts: 1,803

Website

Re: User logins: case-sensitivity

This has to do with mysql-settings, not textpattern itself. More specifically it has to with whether it’s set to case-sensitive or case-insensitive – with utf8-tables we use “utf8_general_ci” (where the ci indicates case-insensitive) and on older versions of mysql (<=4.0) when using latin1 I think we fall back to the configured values for the database.
If however you have moved (dump/restore) your database in the past, it’s possible that you (inadvertently) changed those settings.

Eitherway the easiest way to fix stuff is:

• update content to a single account (via phpmyadmin, or with an existing plugin – workflow something… was it’s name)
• remove duplicate user-account
• change collation of the relevant tables to <whatever>_ci

If you continue to have problems, please post your (highlevel) diagostics, and additionally tell us the collation of the tables (can be found out via phpmyadmin for example).

Last edited by Sencer (2007-07-18 11:36:57)