DataBase Viewer not showing data entries X5 Pro 2019.2.5
Author: Robert Poissant
Visited 1707,
Followers 1,
Shared 0
X5 Pro 2019.2.5
The entries of the different databases are no longer displayed with the use of the DataBase Viewer object. We can save the data, it is populated in the Database. Is the problem known? is a fix planned for soon?
Posted on the
Hello.I just checked the operation of this object in X5 Pro 2019.2.5. It works fine.I see data from the database.
MySQL 5.7.16
PHP 7.1.30
Check for updates of this object, check for errors in the server logs or in the browser console.It is possible that the hosting has a firewall that blocks requests to the database.
Hi Robert,
I'm working with the same version and the current object 'Database Viewer'.I have no problems.The data is displayed. Problem seems not to be the 'Databas Viewer' object.
Klaus.
Author
Thank you Alexsej and Klaus, I don't know where is the problem all my sites using Database Viewer after X5 2019.2.5 upgrade are not showing their data even I am able to record new entries. Using web phpMyAdmin I can see all data. My web Hosting support team tell me everything are OK. I will request for support again.
MySQL is 5.7 and PHP 7.1
Robert, did you delete an existing Object of Database Viewer and include a new one in your WebSite ?
Author
Yes, I did destroy object of Database Viewer and recreate it. I also create a new DEV site and test with new objects and same result. I can write to DB but unable to view te data.
My web hosting support did check and here is the support response : «We do not block access to the database from our webservers. I am not showing any errors specifically logged on the webserver.
Hello Robert,
Here a tool to test your DB connection directly from the website directory with external php file.
http://wsx5.afsoftware.fr/viewforum.php?f=110
Enjoy
https://wsx5.afsoftware.fr
Hi Robert
It could be helpful to be able to check one of the pages where this is happening. Do you perhaps have an URL you can share here with me so that I might check it out for you?
If so, please let me know that here so that I might perform additional tests on them
Thank you
Stefano
Author
Thank you to all who take care to anwser. Everything is back to normal. Like I said I was able to write into my DB, so my connections were good but not able to write since update to 2.5.
From parameter - Database management, I destroyed all DB entries, all pages related to them and save and close the project. I open the project and recreate my DB environment and everything is back to normal.
Everything OK event upgrade to 2.7
Thank You