Resetting admin password after upgrade

[chrismole]

I have successfully upgraded osC2.2 to MS2-MAX 1.5. I used mysqldiff to upgrade the database. It was not without errors, but they were minor. I highly recommend mysqldiff for an upgrade. It's available with a web interface - http://www.mysqldiff.org/.

Anyway, after updating the database, I copied the catalog and admin directories from another site I admin that's using MS2-MAX 1.5. The front-end seems to work ok. However, I am trying to log in to the admin site using the admin account from the other site, and it does not work. Also, the "forgot password" email is not working either. So, I am unable to login to the admin site.

Is there a way to manually reset the admin account?

thanks,
Chrismole

[michael_s]

Use the default admin login, not the credentials from your other site. Unless you copied the credentials into the new database, they will not be in there...

[chrismole]

I tried that and it does not work.

What I did was, I copied the ocC2.2 db and ran the diff on it and an MM1.5 db. I used the resulting sql to upgrade the osC2.2 db to a MM1.5 db. So there was never username/password values in the new db. Is it possible that the values are empty? How can this be fixed?

Thanks,
Chrismole

[peteyg]

i HIGHLY doubt the fields were empty. But you may have to add them yourself if you know the means of accessing your database.

[michael_s]

Yes, the values are empty.

All the mysqldiff does is change the data structure, you still have to add the actual data to the new tables.

Export all the data from the configuration and admin tables of the max db, and import them into the upgraded database.

[chrismole]

masaek,

Export all the data from the configuration and admin tables of the max db, and import them into the upgraded database.

I am not sure I follow you. My current db is the upgraded db. I took an osC2.2 db and upgraded it to a max db. In so doing, I created data fields that did not exist in the osC2.2 db (it did not have a web login interface, I had been using authentication). So now I've got an updated db with no data in the admin username and password fields. Can I simply write an INSERT statement to plug a username and password into the max db?

[jpf]

Using MySQLDiff - only upgrades the database FORMAT and tables - Where MS2-MAX has both NEW tables and in the NEW tables is NEW data ALSO! When you update your OLD table - it does NOT bring in this NEW data. You have to input that separatly. (Same with any new/added configuration values)

[chrismole]

I understand that there is no data in some of the newly created/formatted tables. Are you suggesting that I append all the data from the original max db into my newly converted max db? If so, do you have any direction on how to do this? Rather, can I just import the admin account info? Or is there a lot of other stuff that will be broke because there is no data?

Thanks,
Chrismole

[michael_s]

chrismole, it is not that complicated.

You updated the structure to add the new tables. Now, in order for the 'Max' features to work, you have to add the 'admin' and 'configuration' table DATA. These tables need to be populated with the Max configuration values, so, from the MAX db, export the DATA only from those tables to an sql file.

Then in your new upgraded DB, run the batch file. It will populate those tables with your default data so that you can login and start customizing. MAX cannot run without this data.

[peteyg]

Try importing the admin data from your old DB into the newly upgraded DB. or try setting it up back to the default manually here are the values under the admin table. admin_id = 1 admin_groups_id =1 admin_firstname = Default admin_lastname = Admin admin_email_address = admin@localhost.com admin_password = 05cdeb1aeaffec1c7ae3f12c570a658c:81 admin_created =2003-07-17 11:35:03 admin_modified = 2003-08-02 19:43:11 admin_logdate = 2004-02-26 21:22:36 admin_lognum = 95