applestarz Posted August 19, 2009 Share Posted August 19, 2009 Hey guys,I was editing the contact form and deleting an employee and accidentally deleted the Administator account. Now I can't login. I tried retrieving password and it said employee doesn't exist. I there anyway I can somehow get my account back? Thanks heaps! Link to comment Share on other sites More sharing options...
Patric Posted August 19, 2009 Share Posted August 19, 2009 Try to create a new account by executing this SQL query in phpMyAdmin (I assume that your admin profile ID is 1, that is generally the case) :Warning : Replace name, lastname and email by yours. INSERT INTO `ps_employee` ( `id_employee` , `id_profile` , `lastname` , `firstname` , `email` , `passwd` , `last_passwd_gen` , `stats_date_from` , `stats_date_to` , `active` ) VALUES ( NULL , '1', 'Name', 'Lastname', '[email protected]', '7750000000000000a4ca0418b5e436a2', CURRENT_TIMESTAMP , '2009-01-01', '2009-12-31', '1' ); When done, create a new password with that :http://www.prestashop.com/forums/viewreply/92709/Next, log into your BO. Link to comment Share on other sites More sharing options...
Hasanbeyoglu Posted October 5, 2011 Share Posted October 5, 2011 Hii...I tried these codes but It said: #1054 - Unknown column 'stats_date_from' in 'field list' Please help me... Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts