Jump to content
petb

Prestashop 1.5.3.1 backoffice accounts verdwenen?

Recommended Posts

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

Share this post


Link to post
Share on other sites

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 by scorpionsworld (see edit history)

Share this post


Link to post
Share on other sites

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 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 2 id_profile int(10) UNSIGNED No None dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 3 id_lang int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 4 lastname varchar(32) utf8_general_ci No None dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 5 firstname varchar(32) utf8_general_ci No None dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 6 email varchar(128) utf8_general_ci No None dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 7 passwd varchar(32) utf8_general_ci No None dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 8 last_passwd_gen timestamp on update CURRENT_TIMESTAMP No CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 9 stats_date_from date Yes NULL dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 10 stats_date_to date Yes NULL dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 11 bo_color varchar(32) utf8_general_ci Yes NULL dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 12 bo_theme varchar(32) utf8_general_ci Yes NULL dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 13 default_tab int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 14 bo_width int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 15 bo_show_screencast tinyint(1) No 1 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 16 active tinyint(1) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 17 id_last_order int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 18 id_last_customer_message int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 19 id_last_customer int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index

arrow_ltr.png Check All/ Uncheck AllWith selected: Browse Change Drop Primary Unique Index

Share this post


Link to post
Share on other sites

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 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 2 id_profile int(10) UNSIGNED No None dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 3 id_lang int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 4 lastname varchar(32) utf8_general_ci No None dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 5 firstname varchar(32) utf8_general_ci No None dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 6 email varchar(128) utf8_general_ci No None dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 7 passwd varchar(32) utf8_general_ci No None dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 8 last_passwd_gen timestamp on update CURRENT_TIMESTAMP No CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 9 stats_date_from date Yes NULL dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 10 stats_date_to date Yes NULL dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 11 bo_color varchar(32) utf8_general_ci Yes NULL dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 12 bo_theme varchar(32) utf8_general_ci Yes NULL dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 13 default_tab int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 14 bo_width int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 15 bo_show_screencast tinyint(1) No 1 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 16 active tinyint(1) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 17 id_last_order int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 18 id_last_customer_message int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index 19 id_last_customer int(10) UNSIGNED No 0 dot.gif Change dot.gif Drop dot.gif Browse distinct values dot.gif Primary dot.gif Unique dot.gif Index dot.gif Spatial dot.gif Fulltext dot.gif More

 

dot.gif Browse distinct values

dot.gif Add primary key

dot.gif Add unique index

dot.gif Add index

dot.gif Add SPATIAL index

dot.gif Add FULLTEXT index

arrow_ltr.png Check All/ Uncheck AllWith selected: Browse Change Drop Primary Unique Index

Dat is de tabelstructuur. niet de rijen in de tabel

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Nee voor zover ik kan zien is dit het enigste.

 

Lijkt erop dat ik een groot probleem heb?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

ik heb een backup van 1.5.2.0 in installatron

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 by petb (see edit history)

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More