nkassebaum Posted March 18, 2014 Share Posted March 18, 2014 A guy who used to work for us set up our Prestashop based website and added a secondary username that you could log in with, but without all the privileges as the main username. He no longer works here, and so we can't log into the main username. Those are the only options we get from the username we do have access to. I would like to either give that name full administrative options or recover access to the username that does have full administrative options. Link to comment Share on other sites More sharing options...
p206ab Posted March 18, 2014 Share Posted March 18, 2014 I think you can edit password and accounts in your database in ps-employee table. Link to comment Share on other sites More sharing options...
nkassebaum Posted March 18, 2014 Author Share Posted March 18, 2014 For sure. I found the right area (I think) and edited the password field but I wasn't able to log in using what I changed it to. Is this the right area? Link to comment Share on other sites More sharing options...
p206ab Posted March 18, 2014 Share Posted March 18, 2014 This should help then http://www.inmotionhosting.com/support/edu/prestashop-15/308-password-change-via-database Link to comment Share on other sites More sharing options...
nkassebaum Posted March 18, 2014 Author Share Posted March 18, 2014 Thank you very much, that's very helpful. However, when I save it, I still can't log in with the password attached to the end of the cookie key. I click "edit" to get back into that users table, but the settings I made (md5, new password) aren't there and the old settings seem to be in place. I'm not sure if it is supposed to reset to that or not, but it does say "settings saved" at the top of the ps_employee table when I go back into that page. It's weird, it says its saved, but resets when I view into the table again. Also, there are 3 Db's which the main site could be located. Two of which were test installations so I've changed all 3 Link to comment Share on other sites More sharing options...
nkassebaum Posted March 19, 2014 Author Share Posted March 19, 2014 This issue is still unresolved. I tried changing the password in the myphpadmin area a couple different ways. Changing it via the cookie key and MD5 doesn't work, it doesn't seem to save and resets itself. I changed it by copying a password from a familiar username (http://mypresta.eu/en/art/tips-and-tricks/a-better-way-to-restore-prestashop-admin-password.html as described in that method) but logging in using the password I changed it too isn't letting me in still. Very stumped on this Link to comment Share on other sites More sharing options...
p206ab Posted March 19, 2014 Share Posted March 19, 2014 (edited) I don't know if this would work, I haven't tried it, but if there is nothing else you could do this. 1. Install a new blank prestashop somewhere (server,localhost), finish installation and then go to it's database and export table ps_employee. 2. Then go to first shop's database (the one you tried to edit) and export ps_employee so you will have a backup if this fails miserably. 3. Once you are sure you have a backup, delete ps_employee table and import the one you created in step 1. If this method works, you should be able to login using username and password you set up in that new prestashop installation. If it doesn't you can still import back ps_employee backup. Edited March 19, 2014 by p206ab (see edit history) Link to comment Share on other sites More sharing options...
prestashopninja Posted March 19, 2014 Share Posted March 19, 2014 There's an automated and free solution: Google for "invertus_passwd_reseter.php" Link to comment Share on other sites More sharing options...
nkassebaum Posted March 19, 2014 Author Share Posted March 19, 2014 Thanks all, working on it now Link to comment Share on other sites More sharing options...
nkassebaum Posted March 19, 2014 Author Share Posted March 19, 2014 I installed that .php page but I can't navigate to it for some reason. Gives me framed prestashop 404. I have it in the root of the presta installation Link to comment Share on other sites More sharing options...
mickeyboy1 Posted March 19, 2014 Share Posted March 19, 2014 See Vekias response in this thread: http://www.prestashop.com/forums/topic/314638-solved-i-want-to-remove-my-developer-from-admin-i-am-unable-to-do-that/ Link to comment Share on other sites More sharing options...
prestashopninja Posted March 19, 2014 Share Posted March 19, 2014 I installed that .php page but I can't navigate to it for some reason. Gives me framed prestashop 404. I have it in the root of the presta installation Please check the file permissions, make sure you have uploaded it into the correct directory. If it still returns 404, rename or remove .htaccess temporarily. Link to comment Share on other sites More sharing options...
nkassebaum Posted March 19, 2014 Author Share Posted March 19, 2014 I just got it. I was working in the wrong hosting companies control panel the entire time. The tables still exist on the host we migrated the site from and that's where I've been working this whole time. The first, simplest swapping out MD5 password method worked instantly. Oh my fucking god. Thanks a ton everyone Link to comment Share on other sites More sharing options...
Recommended Posts