Grid Load Error

QuestionsGrid Load Error
Bo Smiht asked 7 years ago

Hi,
I have been working awhile now attempting to display my mysql database table. I can load the grid but all I get is a popup error message containing all of my table information. But nothing in the grid. I can use the add button and sure enough the table gets the new data inserted, but then the popup error shows again with all of the table data in it.
I am sure I am doing something very basic wrong, but cannot seem to figure it out.
Thanks,
Bo

1 Answers
Abu Ghufran answered 7 years ago

Hello,

Checkout the FAQ query #1. Point (1) looks to be your case.

##### 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,

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 1

Your Answer

14 + 11 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?