DataGrid Tab Appears but no records in the grid

Archived from the Xataface Users forum.

lhat — Thu Nov 04, 2010 11:12 am

Hi, All.

I’ve downloaded and installed the datagrid module, added the required modules line in my conf.ini, and even have added the datagrid:view, etc. lines to my permissions.ini. This results in the Grid tab appearing in my application, and when I click on it, I get the DataGrid layout well enough; but there are no records listed, even though my test application has 50 some records. The records show up normally in list view–here’s what it looks like:

As you can see, the frame and headers appear, including the notation of how many records, pagination, and showing xx results per page; the next row also looks normal (add row; toggle full screen; export csv); and then the table’s column/field heads which are all toggle-able. The export button even works, providing me a download of the records. But no records are listed.

I thought this must be a permissions issue, but I’ve logged in as admin and that role has the full array of datagrid perms in place, all set to work.

I’m stumped and would welcome any pointers/suggestions!

---

shannah — Thu Nov 04, 2010 11:24 am

check your error log and see if it reports anything.

---

lhat — Thu Nov 04, 2010 3:56 pm

Thanks, Steve–

Further experimentation has resolved the issue: my first field and primary key was of type INT, and several of the others in the table were INT variants; I changed these all to varchar types and the records became visible once more. Thanks!