By Kobus on

Hi,

I have a site based on Drupal 4.7.3, which works fine on one host, but not on my new host where I have a dedicated server, so I decided to upgrade the site to Drupal 4.7.8, and it still does not work. That rules out the code or some missing file in my Drupal installation.

I have deleted the database, exported it again, and it still does not work. What happens is this:

1. You try to log in.
2. You get an error "Username is not recognised"

I have checked the database, the username is there. I have tried password recovery, then it says "e-mail address is not recognised", and I did use the e-mail address associated with that particular account. I have repaired and optimized the database, no luck. I have also sent the differences between the server php.ini and the php.ini on my localhost (where it also works) to my host to update our server's php.ini, and it still does not work.

And for the most obvious... I have made sure that it connects to the correct database (believe me, I've had it before that connected to the wrong one, and couldn't figure out why the "DB doesn't update"... LOL. Also, the base URL in the settings.ini file is correct.

Has anyone experienced this before? If so, what have you done to correct this problem? I am out of ideas.

Thanks in advance,

Kobus

⋅ Categories: Drupal 4.7.x

Comments

Kobus’s picture

Kobus commented

Several of the last 10 topics posted seems to be related to this. I wonder if this is not a bug that only exhibits itself under certain server conditions/configurations?

-- Kobus

Kobus’s picture

Kobus commented

I am using the following server config...

Apache 1.3.26
Using PHP 5.0.4
MySQL 4.1.12-standard
phpMyAdmin 2.6.0-pl3

Incase this is important information to solve this problem...

-- Kobus

gpk’s picture

gpk commented

Run the following query against your DB. This will update username and password for uid=1. For now, make sure to use just lowercase plain ASCII characters.

UPDATE users SET name='your_username', pass=md5('your_password') WHERE uid=1;

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

Kobus’s picture

Kobus commented

I have done that successfully, and when browsing the DB, it reflects that user account 1's password has been changed, and tried to log in. Still no success. Still not working. No matter which username I try, it says "unknown username" and when I try to reset the password via the site, it does not recognize the e-mail address, even though it is exactly like that in the DB...

Thanks for the response!

-- Kobus

gpk’s picture

gpk commented

I wonder if it is some sort of encoding problem - so that the characters you type in aren't what arrive at the other end for processing?

Could try backing up user.module and then edit it to output debugging info/variables when you hit the error message.

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

Kobus’s picture

Kobus commented

I doubt if that is the case with the DB setup or something, because after running the query you suggested, the information is exactly as it was in the query.

If it is an encoding issue, it must then be within Drupal? Is that possible?

DB is setup as latin_swedish_ci, I think.

-- Kobus

gpk’s picture

gpk commented

Drupal wants everything UTF these days. http://drupal.org/node/8408. Check a module .install file for details of the encoding that should be used by tables. I've heard mention of problems arising in rare instances when things don't exactly match up but usually it's not a problem I think.

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

Kobus’s picture

Kobus commented

This is still a Drupal 4.7 install. It works on the old host as is, and not on the new host. Both of them use latin1. I will change all tables to UTF8 though - hopefully that works.

-- Kobus