Hi, i've purchased the Full Package to mount an SQL Server connection.
The connection is OK, i can see the table header but data is not displayed.
Thanks in advance.
Pasting from faq:
Q) How to debug no records (blank grid)?
Few considerations before use
1) include the jqgrid_dist.php file before any thing rendered to output.
2) Check the ajax response of grid,
Also make sure, you call '$g->render();' function before any HTML is rendered
(echo'd) to output, as it expect exact JSON format for ajax calls
Use firefox->firebug->net->ajax-call of grid->response. You will see the output there, in case of any error. It should be proper JSON format data in order to render grid
Review this tutorial for '[debugging with firebug](https://phpgrid.desk.com/customer/portal/articles/926266)'.
To enable debugging errors,
1) Turn errors on. Goto jqgrid_dist.php make it 'on'
ini_set("display_errors","on"); // changed from off to on
2) If you are using non-mysql database, Goto file jqgrid_dist.php
$g = new jqgrid($db);
$g->con->debug = 1; // changed from 0 to 1r
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!