Upgrading to RC2a Can't get into admin. Wrong Username and Password

[commonground]

I am trying to upgrade my shop. I have imported my current database into a new one, made changes to the various tables, updated all the PHP files, (by copying them from a new test installation).

 

It seems to work at the catalog end, but I had a problem accessing the admin section and couldn't get to the login screen. The error was:

 

1146 - Table 'Mydatabasename.administrators' doesn't exist

 

select id from administrators limit 1

 

[TEP STOP]

 

 

I investigated the database in my test installation and created a similar table 'administrators' in the database for the system I am upgrading.

 

I inserted one entry for usename and password into that table using:

 

INSERT INTO `administrators` VALUES (1, 'myusername', 'mypassword');

 

I was then able to reach the admin/login screen but the password I entered into the database was not valid.

 

I think that the username and password need to be encripted. CAN ANYBODY SUGGEST HOW I CAN ENTER A USERNAME AND PASSWORD INTO THE administrators TABLE SO THAT IT IS ENCRIPTED AND LETS ME LOG IN?

 

I have had a look at the install script and wondered if I might just be able to run the section that created the username and password without doing the rest of the installation but removing the code that sets up the database looks a bit daunting with my limited knowledge.

 

I now have a shop that is taking orders but I can't manage them! Any advice appreciated.

 

Cheers

 

 

Pete Heywood

[germ]

This might help.

 

If not, I don't have the answer as I am MYSQL illiterate...

:blush:

 

(Although I can plagiarize existing code fairly well...)

:D

[germ]

Maybe you need this instead.

(I haven't tried it)

[commonground]

Thanks very much

 

Running a simple contribution to reset the password has solved the problem. I think that all it did was to delete the username and password that I had entered in the table and the login prompted me to enter a new one.

 

Simple. Could have saved hours of headaches if I had asked in the forum sooner

 

Cheers

 

Pete

[germ]

Don't beat yourself too severely.

 

Hindsight is always 20-20 (at least mine is ;) )

 

Just glad you're up and running.

:)