WebSite X5Help Center

 
Robert Poissant
Robert Poissant
User

DataBase Viewer not showing data entries X5 Pro 2019.2.5  en

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
8 ANSWERS - 1 USEFUL - 1 CORRECT
Aleksej H.
Aleksej H.
Moderator

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.

Read more
Posted on the from Aleksej H.
Klaus W.
Klaus W.
User

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.

Read more
Posted on the from Klaus W.
Robert Poissant
Robert Poissant
User
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

Read more
Posted on the from Robert Poissant
Klaus W.
Klaus W.
User

Robert, did you delete an existing Object of Database Viewer and include a new one in your WebSite ?

Read more
Posted on the from Klaus W.
Robert Poissant
Robert Poissant
User
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.

Read more
Posted on the from Robert Poissant
Incomedia
Stefano G.
Incomedia

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

Read more
Posted on the from Stefano G.
Robert Poissant
Robert Poissant
User
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

Read more
Posted on the from Robert Poissant