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:  http://phpgrid.com/documentation/installation/  

  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.

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
?>

Feedback and Knowledge Base