Page 1 of 1

DataGrid Tab Appears but no records in the grid

PostPosted: Thu Nov 04, 2010 11:12 am
by lhat
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:
broken_grid.png
broken_grid.png (20.62 KiB) Viewed 1414 times

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!

Re: DataGrid Tab Appears but no records in the grid

PostPosted: Thu Nov 04, 2010 11:24 am
by shannah
check your error log and see if it reports anything.

Re: DataGrid Tab/No Records--SOLVED; Nxt questions

PostPosted: Thu Nov 04, 2010 3:56 pm
by lhat
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!