hashimnaushahi Posted August 30, 2021 Share Posted August 30, 2021 (edited) Hi everyone, I'm wondering if there's anyone who can help me solve this mystery... When I'm logged in with my admin account in the backend of our PrestaShop website, I can see that we've got 78 products, 1434 customers and 1397 orders. However, when I'm looking at the SQL database with phpMyAdmin I can only see 659 customers and 612 orders while all the 78 products are all there. The strange thing is that there are no orders in the database of after 03-04-2020 and also no customers of after 13-04-2020. I checked with our hosting provider. They confirmed that that database is the only database that's connected to our PrestaShop website. So that database is the only source of everything that we can see in the backend of PrestaShop. So what happened with all the customers and orders since April last year? And how can I see all those customers and orders in the backend when I can't find them in the database? To me this is a real mystery. And I need an SQL file with all the products, customers and orders. Does anyone here has any ideas about how this is possible, where I can find the missing data and how I can get a complete SQL file? Any suggestion is more than welcome. Thank you all in advance! Edited August 30, 2021 by hashimnaushahi (see edit history) 1 Link to comment Share on other sites More sharing options...
joseantgv Posted August 31, 2021 Share Posted August 31, 2021 Which database manager are you using? Link to comment Share on other sites More sharing options...
hashimnaushahi Posted August 31, 2021 Author Share Posted August 31, 2021 (edited) 7 hours ago, joseantgv said: Which database manager are you using? Hi joseantgv, Thank you for commenting! I'm still new to everything related to databases. So I'm not sure what you mean with database manager. All I know is that our hosting provider uses phpMyAdmin to access the database. Is that what you mean? This is also what I know... MySQL version: 10.1.48-MariaDB-1~stretch MySQL engine: InnoDB MySQL driver: DbPDO I'm not sure if I can find anything else that might be useful... Edited August 31, 2021 by hashimnaushahi Additional information (see edit history) Link to comment Share on other sites More sharing options...
joseantgv Posted September 1, 2021 Share Posted September 1, 2021 Yes, phpMyAdmin was the answer You could try with https://www.adminer.org/ to check it. 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