This is a discussion on Resetting admin password after upgrade within the osCMax v1.7 Discussion forums, part of the osCMax v1.7 Forums category; I have successfully upgraded osC2.2 to MS2-MAX 1.5. I used mysqldiff to upgrade the database. It was not without errors, ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| 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 |
| Sponsored Links | ||
| ||
| |
|
#2
| ||||
| ||||
| 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...
__________________ Michael Sasek osCMax Developer
|
|
#3
| ||||
| ||||
| 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 |
|
#4
| |||
| |||
| i HIGHLY doubt the fields were empty. But you may have to add them yourself if you know the means of accessing your database. |
|
#5
| ||||
| ||||
| 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.
__________________ Michael Sasek osCMax Developer
|
|
#6
| ||||
| ||||
| masaek, Quote:
|
|
#7
| ||||
| ||||
| 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)
__________________ JPF - osCMax Fourm Moderator Try out our osCMax at: Live Catalog Demo Limited access Admin: Live Admin Demo Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped! |
|
#8
| ||||
| ||||
| 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 |
|
#9
| ||||
| ||||
| 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.
__________________ Michael Sasek osCMax Developer
|
|
#10
| |||
| |||
| 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 |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Resetting Customer Password | goaskmom | osCMax v1.7 Discussion | 1 | 03-07-2005 09:14 AM |
| Admin password | vinces | osCMax v1.7 Discussion | 3 | 11-21-2004 01:04 PM |
| Admin password out of sync with site password | bjrafferty | osCMax v1.7 Discussion | 3 | 07-19-2004 09:34 AM |
| No password in Admin | goldie | osCommerce 2.2 Modification Help | 2 | 08-26-2003 02:33 PM |
| Admin password? | pilot1 | osCommerce 2.2 Installation Help | 2 | 05-06-2003 02:23 AM |