Joomdle 1.0 Installation

problem with CAPITAL letters

  • Iliya
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
10 years 6 months ago #1 by Iliya
problem with CAPITAL letters was created by Iliya
Hi again :)
Before update I had lot of users with capital letters in username. It looks like user have Username with capital letter in Joomla, but username without it in moodle. It worked fine, but I think only before moment when someone choose existing username, but without capital letter.
Now in new joomdle version we have great plugin that forbid capital letters at all. But now my old users with capital letter can't login.
So I tried to change capital letter in user name manually, but site told me that I already have this user in moodle (of course I have because moodle username havenot capital letters at all :)).
How can I easily solve this?

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago - 10 years 6 months ago #2 by Antonio Durán
Replied by Antonio Durán on topic problem with CAPITAL letters
You can disable the user check plugin while you do the changes.
Last edit: 10 years 6 months ago by Antonio Durán.

Please Log in or Create an account to join the conversation.

  • Iliya
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
10 years 6 months ago #3 by Iliya
Replied by Iliya on topic problem with CAPITAL letters
It works, thank you )
But maybe you know how can I change all capital letters in usernames globaly? :)

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #4 by Antonio Durán
Replied by Antonio Durán on topic problem with CAPITAL letters
I don't know what you mean with change all capital letters golbally.

Please Log in or Create an account to join the conversation.

  • Iliya
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
10 years 6 months ago #5 by Iliya
Replied by Iliya on topic problem with CAPITAL letters
I mean, can I write script that search all usernames in joomla (maybe in joomla database) and replace all capital characters. Or I need something to do in joomdle and in moodle databases.

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #6 by Antonio Durán
Replied by Antonio Durán on topic problem with CAPITAL letters
You could write a simple php script to do it... possibly you could even do it with a sql query directly.

That said, I don't understand why old users with caps cannot login anymore. User check plugin does nothing on user login.

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago - 10 years 6 months ago #7 by Chris
Replied by Chris on topic problem with CAPITAL letters
Fastest and easiest way is to use your phpmyadmin or other mysql admin client and run a MYSQL update with UPPER.
Code:
UPDATE table SET column = UPPER(column)
Last edit: 10 years 6 months ago by Chris.

Please Log in or Create an account to join the conversation.

  • Iliya
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
10 years 6 months ago #8 by Iliya
Replied by Iliya on topic problem with CAPITAL letters
I don't know why, but then I try to recover user (with uppercase symbol in username) site told: "The username can only contain alphanumeric lowercase characters, underscore (_), hyphen (-), period (.) or at symbol (@)"

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #9 by Antonio Durán
Replied by Antonio Durán on topic problem with CAPITAL letters
What do you mean by recover a user?

Please Log in or Create an account to join the conversation.

  • Iliya
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
10 years 6 months ago #10 by Iliya
Replied by Iliya on topic problem with CAPITAL letters
I mean, that I try to recover username or password via frontend jomsocial form. :)
(Click on "Foget login?" or "Foget password?")

Please Log in or Create an account to join the conversation.