Skip to content

Blank grid that Data is not showing up in MS SQL, MySql, DB2 or other database

Scenario 1

If the grid is empty with only the header, no data displayed, you should look into the followings:

  1. First of all, check the SERVER_ROOT value in conf.php and make sure the value is set to a correct path.
    More reading:  

  2. Check if the session is working on your web server .e.g. Apache, IIS, Tomcat. Make sure the session path is set to a valid path and given written permission. Run phpinfo() to find out and look for  session.save_path 

    <?php phpinfo();?>

  3. Lastly, check the database column name including SELECT statement, primary key, foreign key, which could be case-sensitive on some systems.

  4. If you are using IIS as the webserver, check your app pool setting. If it defaults to a classic ASP app pool, Switched it to another one could do the trick as pointed out by one of our users.

Scenario 2

If you just see a completely blank page with no error reporting and you have no server access so you can't edit PHP configuration files like php.ini, add the following on top of the page.

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);

Feedback and Knowledge Base