petb Posted January 14, 2013 Share Posted January 14, 2013 na de update kan ik opeens kan ik niet meer in de backoffice komen . Lijkt er dus op dat het hele admin gegevens om in te loggen verdwenen zijn. Iemand misschien en tip of idee? Krijg dan deze melding There is 1 error Employee does not exist or password is incorrect Als ik kies voor gegevens naar gerigistreerd email adress There is 1 error This account does not exist Link to comment Share on other sites More sharing options...
scorpionsworld Posted January 14, 2013 Share Posted January 14, 2013 (edited) Tip 1. Kijk via phpmyadmin in de databse of de tabel ps_employee bestaat en of daar de account(s) met de e-mail adressen in vermeld staan. Tip 2. Kijk op http://www.prestashopmaken.nl/veiligheid/wat-te-doen-als-het-wachtwoord-van-je-account-naar-de-backoffice-niet-meer-werkt/ Edited January 14, 2013 by scorpionsworld (see edit history) Link to comment Share on other sites More sharing options...
petb Posted January 14, 2013 Author Share Posted January 14, 2013 Bedankt voor de info alvast! hier een overzicht van de tabel ps_employee. Zal dit niet goed zijn? Volgens mij staat daar geen accounts in ? 1 id_employee int(10) UNSIGNED No None AUTO_INCREMENT Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 2 id_profile int(10) UNSIGNED No None Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 3 id_lang int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 4 lastname varchar(32) utf8_general_ci No None Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 5 firstname varchar(32) utf8_general_ci No None Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 6 email varchar(128) utf8_general_ci No None Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 7 passwd varchar(32) utf8_general_ci No None Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 8 last_passwd_gen timestamp on update CURRENT_TIMESTAMP No CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 9 stats_date_from date Yes NULL Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 10 stats_date_to date Yes NULL Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 11 bo_color varchar(32) utf8_general_ci Yes NULL Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 12 bo_theme varchar(32) utf8_general_ci Yes NULL Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 13 default_tab int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 14 bo_width int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 15 bo_show_screencast tinyint(1) No 1 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 16 active tinyint(1) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 17 id_last_order int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 18 id_last_customer_message int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 19 id_last_customer int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index Check All/ Uncheck AllWith selected: Browse Change Drop Primary Unique Index Link to comment Share on other sites More sharing options...
scorpionsworld Posted January 14, 2013 Share Posted January 14, 2013 Bedankt voor de info alvast! hier een overzicht van de tabel ps_employee. Zal dit niet goed zijn? Volgens mij staat daar geen accounts in ? 1 id_employee int(10) UNSIGNED No None AUTO_INCREMENT Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 2 id_profile int(10) UNSIGNED No None Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 3 id_lang int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 4 lastname varchar(32) utf8_general_ci No None Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 5 firstname varchar(32) utf8_general_ci No None Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 6 email varchar(128) utf8_general_ci No None Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 7 passwd varchar(32) utf8_general_ci No None Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 8 last_passwd_gen timestamp on update CURRENT_TIMESTAMP No CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 9 stats_date_from date Yes NULL Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 10 stats_date_to date Yes NULL Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 11 bo_color varchar(32) utf8_general_ci Yes NULL Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 12 bo_theme varchar(32) utf8_general_ci Yes NULL Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 13 default_tab int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 14 bo_width int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 15 bo_show_screencast tinyint(1) No 1 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 16 active tinyint(1) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 17 id_last_order int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 18 id_last_customer_message int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index 19 id_last_customer int(10) UNSIGNED No 0 Change Drop Browse distinct values Primary Unique Index Spatial Fulltext More Browse distinct values Add primary key Add unique index Add index Add SPATIAL index Add FULLTEXT index Check All/ Uncheck AllWith selected: Browse Change Drop Primary Unique Index Dat is de tabelstructuur. niet de rijen in de tabel Link to comment Share on other sites More sharing options...
petb Posted January 14, 2013 Author Share Posted January 14, 2013 Als ik dan op browse klik krijg ik dit te zien SELECT COUNT(*)AS`Rows` ,`id_employee` FROM`ps_employee` GROUPBY`id_employee` ORDERBY`id_employee` LIMIT 0 , 30 is dit goed? Link to comment Share on other sites More sharing options...
scorpionsworld Posted January 14, 2013 Share Posted January 14, 2013 Als ik dan op browse klik krijg ik dit te zien SELECT COUNT(*)AS`Rows` ,`id_employee` FROM`ps_employee` GROUPBY`id_employee` ORDERBY`id_employee` LIMIT 0 , 30 is dit goed? Dat is de SQL query. Laat phpmyadmin verder geen rijen met gegevens zien? Zo niet, dan zijn alle accounts verdwenen. Link to comment Share on other sites More sharing options...
petb Posted January 14, 2013 Author Share Posted January 14, 2013 Nee voor zover ik kan zien is dit het enigste. Lijkt erop dat ik een groot probleem heb? Link to comment Share on other sites More sharing options...
scorpionsworld Posted January 14, 2013 Share Posted January 14, 2013 Nee voor zover ik kan zien is dit het enigste. Lijkt erop dat ik een groot probleem heb? Best wel. Heb je een backup van de database? Link to comment Share on other sites More sharing options...
petb Posted January 14, 2013 Author Share Posted January 14, 2013 ik heb een backup van 1.5.2.0 in installatron Link to comment Share on other sites More sharing options...
scorpionsworld Posted January 14, 2013 Share Posted January 14, 2013 ik heb een backup van 1.5.2.0 in installatron Van de scripts/bestanden of van de database? wat je nodig hebt is een .sql of .sql.gzip bestand.Wat je ook kunt doen is via phpmyadmin een nieuw BO account aanmaken. Voor het wachtwoord van de account dien je dan de instructie op http://www.prestashopmaken.nl/veiligheid/wat-te-doen-als-het-wachtwoord-van-je-account-naar-de-backoffice-niet-meer-werkt/ te volgen. Link to comment Share on other sites More sharing options...
petb Posted January 19, 2013 Author Share Posted January 19, 2013 (edited) ik probeer via de php deze mogelijkheid (zoek in deze tabel de regel op welke hoort bij uw account voor de backoffice, herkenbaar aan het e-mail adres, en klik op bewerk/edit. ) Die regel met een email adres te vinden maar die staat er niet blijkbaar. Ik heb een back van een oudere versie 1.5.2.0, is daar op de een of andere manier die admin settings weer terug te plaatsen? Edited January 19, 2013 by petb (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now