Wiki doesn't like me [solved - read first post]

[Wp]

Oh, and in case you weren't already aware, there are only two admins for Comic Genesis and they both have day jobs (running the site is only a part-time function). CG doesn't have a team of technicians that can deeply analyze problems as they come up. Which is what makes small problems such as this one (that only affect a small fraction of the community) such a pain to fix...

I understand, which is why I said I wasn't in any rush.

[Kisai]

I've turned on ALL the debug code for the authentication module.

What I want people who are not able to login to do is copy and paste from the title to the top of the screen like so:

If you are logged in proper you will see this:

Code: Select all

1. DEBUG: Username: Kisai
2. DEBUG: authenticate
3. DEBUG: attempting to check password
4. DEBUG: Password OK
5. DEBUG: updateUser
Login successful

I repeat, grab the text, in my case where it says "login successful" click and drag to the top of the screen, as this text will be hidden behind the CG logo

If you blow the password you will see this:

Code: Select all

1. DEBUG: Username: Kisai
2. DEBUG: authenticate
3. DEBUG: attempting to check password
3. DEBUG: Password NOT OK
Log in / create account

And if the username doesn't exist for whatever reason, you'll see something like this

Code: Select all

1. DEBUG: Username: Sdfsdfsdfsdfsdf
DEBUG: userExists $username
Log in / create account

[Dr Neo Lao]

Code: Select all

1. DEBUG: Username: Dr Neo Lao
2. DEBUG: authenticate
3. DEBUG: attempting to check password
4. DEBUG: Password OK
5. DEBUG: updateUser

Code: Select all

1. DEBUG: Username: Drneolaothesecond
2. DEBUG: authenticate
3. DEBUG: Password NOT OK

That's interesting - I hadn't tried using my second account.

It's interesting because that account has the name drneolaothesecond - not Drneolaothesecond.

We finally have an error replication. I think...

[Wendybird]

Code: Select all

1. DEBUG: Username: Wendybird
2. DEBUG: authenticate
3. DEBUG: Password NOT OK
Log in / create account

Code: Select all

1. DEBUG: Username: WendyB
DEBUG: userExists $username
Log in / create account

Code: Select all

1. DEBUG: Username: Qwanderer
2. DEBUG: authenticate
3. DEBUG: Password NOT OK
Log in / create account

[Dr Neo Lao]

@ wendybird - when you tried to log into the Wiki, did you put in wendybird or Wendybird? And when you log into the forums, do you log in as wendybird or Wendybird?

Because if it's the former of the first, that would mean that on both your account and my secondary account it is making the first letter uppercase when it's not meant to be and then being all surprised when it doesn't match...

[Drneolaothesecond]

Dr Neo Lao again:

Logged in to Forum with proper name and capitalization and such - total accuracy - can log into SiteAdmin.



Appeares to capitalize first character.

[Moonshadow]

Code: Select all

1. DEBUG: Username: Moonshadow
2. DEBUG: authenticate
3. DEBUG: Password NOT OK

My log-in attempt was with lowercase at the start of my username, same as for here and siteadmin.

[Wendybird]

I log in to both the forums and the wiki with these capitalizations:
wendybird
wendyB
qwanderer

and it capitalizes them, like in your picture.

When I try to log in as wendyB, what it says in the red box is that there is no such person as WendyB.

Does that mean if I made a new account with uppercase at the beginning, I could use that to get in? I'm out of email addresses.

[Juststunned]

1. DEBUG: Username: Juststunned
DEBUG: userExists $username
Log in / create account

I registered/try to log in with lower case. Forum and Siteadmin both work just dandy.

[Dr Neo Lao]

@ wendybird - don't create a new account just yet, wait and see what Kisai says.

@ everyone else - please continue posting the messages the wiki gives so we can make sure.

At the moment, it would appear that the wiki is capitalizing the first letter. No idea why, I don't know a lot about MediaWiki.

[Ahaugen]

Code: Select all

1. DEBUG: Username: Ahaugen
2. DEBUG: authenticate
3. DEBUG: Password NOT OK

just spitballing and idea here, but might this be something from when Kelly lost all the emails?

[Dr Neo Lao]

Possible, but I don't see a possible connection.

On the plus side, it does seem that the error is consistent, at least among the people that have posted thus far...

Edit: This is interesting - everyone (except Diospyros) who has posted in this thread has a username that starts with a lower case letter. And here it gets more interesting - I looked in the Wiki at the recent changes and for the last 30 days, everybody who has made a change in the wiki has a username that starts with a capital letter.

Another Edit: At the moment I'm getting an Internal error: The upload directory (public) is not writable by the webserver when attempting to upload images. I'm assuming that this is part of the "let's find the bug and squish it" plan and that image uploads will return at some point soon...

[Wp]

Code: Select all

1. DEBUG: Username: Wp
2. DEBUG: authenticate 
3. DEBUG: Password NOT OK

[Kisai]

hmm
This actually does tell me what the problem is, see the SQL code is using 'like' instead of '=' which was to allow for people NOT putting the correct capitalization in. I hadn't realized that attempting to login once with a capital borks it.

I'll adjust this to be =, and people can tell me if they still have problems logging in after.

*mumble*

It's neither the forums nor the wiki at all, it's mysql.

Techobabble, the collation (aka, how characters are sorted. A-Z and a-z) is was case sensitive. I've patched the login script and it "should" work now.

[Nutshellcomics]

I'm don't think I am understanding the directions properly, but on the off chance that I did this is the response that i got:

1. DEBUG: Username: Nutshellcomics:nutshellcomics
Log in / create account
From CGWiki
Jump to: navigation, search
Login error:
You have not specified a valid user name.
Log in

Don't have a login? Create an account.

You must have cookies enabled to log in to CGWiki.
Username
Password
Remember my login on this computer

also I tried logging into the forum using a capitol 'N' in nutshellcomics and I logged in successfully but still not in CGWiki.

[Dr Neo Lao]

Code: Select all

1. DEBUG: Username: Drneolaothesecond:drneolaothesecond
Login error:
You have not specified a valid user name.

Well, it's getting closer. It's now trying double taps or something...

[Moonshadow]

Code: Select all

1. DEBUG: Username: Moonshadow:moonshadow
Login error:
You have not specified a valid user name.

Error successfully replicated, if that helps.

[Wp]

Code: Select all

1. DEBUG: Username: Wp:wp
Log in / create account
Login error: You have not specified a valid user name. 

[Kisai]

Okay try again.

[Wp]

Nope, same thing.