No data showing in table
-
This issue has been discussed before, but the fix published for Michael Walker 5 months ago did not work for me.
I have configured the plugin as specified in the installation instructions, and on page load the table header is loaded correctly (with the right column headers), but there is no data populating the table. The plugin is finding the table data in wpf-jqgdata.php, but does not display it.
Thank you for the start of a really useful plugin!
-
can you please send me the source (html) and the structure of the table?
If you can you should inspect what happens when page loads using Firebug.Just so you have some more information – I am using the built-in Sunny theme for display, and the table only contains columns of type “int”, “varchar”, and “float”.
And finally, like Michael. am also running WP in a subdirectory on my site. I could not see the error that he did though.
When no data is displayed probably there is an issue with generated jscript. This is the reason why I asked you the html code.
Sure – the table structure is as follows:
item_id – int(11)
item_name – varchar(255)
item_description – varchar(500)
item_price float – No
date_served – varchar(100)
glutenfree – int(11)
nutfree – int(11)
shellfishfree – int(11)
eatsmart – int(11)
vegan – int(11)
is_breakfast – int(11)
is_lunch – int(11)
is_dinner – int(11)Although I was having the same issue when I tried to display the included sample table, so I don’t think it’s the DB table.
The HTML for the table is pasted below:
<div id="edit-menu-form"> <!-- SHORTCODE ATTIVO DI WPF-jqGrid per la Tabella wp_menu VER. 0.12 --> <div class="ui-jqgrid ui-widget ui-widget-content ui-corner-all" id="gbox_wpfjqg_1" dir="ltr" style="width: 1079px;"><div class="ui-widget-overlay jqgrid-overlay" id="lui_wpfjqg_1"></div><div class="loading ui-state-default ui-state-active" id="load_wpfjqg_1" style="display: none;">Loading...</div><div class="ui-jqgrid-view" id="gview_wpfjqg_1" style="width: 1079px;"><div class="ui-jqgrid-titlebar ui-widget-header ui-corner-top ui-helper-clearfix"><a role="link" href="javascript:void(0)" class="ui-jqgrid-titlebar-close HeaderButton" style="right: 0px;"><span class="ui-icon ui-icon-circle-triangle-n"></span></a><span class="ui-jqgrid-title">Menu Items</span></div><div class="ui-state-default ui-jqgrid-hdiv" style="width: 1079px;"><div class="ui-jqgrid-hbox"><table class="ui-jqgrid-htable" style="width:1079px" role="grid" aria-labelledby="gbox_wpfjqg_1" cellspacing="0" cellpadding="0" border="0"><thead><tr class="ui-jqgrid-labels" role="rowheader"><th id="wpfjqg_1_item_id" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 150px; display: none;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_item_id" class="ui-jqgrid-sortable">Item Id<span class="s-ico" style=""><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_item_name" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_item_name" class="ui-jqgrid-sortable">Item Name<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_item_description" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_item_description" class="ui-jqgrid-sortable">Item Description<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_item_price" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_item_price" class="ui-jqgrid-sortable">Item Price<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_date_served" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_date_served" class="ui-jqgrid-sortable">Date Served<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_glutenfree" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_glutenfree" class="ui-jqgrid-sortable">Glutenfree<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_nutfree" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_nutfree" class="ui-jqgrid-sortable">Nutfree<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_shellfishfree" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_shellfishfree" class="ui-jqgrid-sortable">Shellfishfree<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_eatsmart" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_eatsmart" class="ui-jqgrid-sortable">Eatsmart<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_vegan" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_vegan" class="ui-jqgrid-sortable">Vegan<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_is_breakfast" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_is_breakfast" class="ui-jqgrid-sortable">Is Breakfast<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_is_lunch" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_is_lunch" class="ui-jqgrid-sortable">Is Lunch<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_is_dinner" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 89px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_is_dinner" class="ui-jqgrid-sortable">Is Dinner<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th></tr><tr class="ui-search-toolbar" role="rowheader"><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="display: none;"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="item_id" id="gs_item_id" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="item_name" id="gs_item_name" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="item_description" id="gs_item_description" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="item_price" id="gs_item_price" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="date_served" id="gs_date_served" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="glutenfree" id="gs_glutenfree" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="nutfree" id="gs_nutfree" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="shellfishfree" id="gs_shellfishfree" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="eatsmart" id="gs_eatsmart" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="vegan" id="gs_vegan" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="is_breakfast" id="gs_is_breakfast" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="is_lunch" id="gs_is_lunch" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="is_dinner" id="gs_is_dinner" value=""></div></th></tr></thead></table></div></div><div class="ui-jqgrid-bdiv" style="height: 100%; width: 1079px;"><div style="position:relative;"><div></div><table id="wpfjqg_1" tabindex="0" cellspacing="0" cellpadding="0" border="0" role="grid" aria-multiselectable="false" aria-labelledby="gbox_wpfjqg_1" class="ui-jqgrid-btable" style="width: 1079px;"><tbody><tr class="jqgfirstrow" role="row" style="height:auto"><td role="gridcell" style="height:0px;width:150px;display:none;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:89px;"></td></tr></tbody></table></div></div></div><div class="ui-jqgrid-resize-mark" id="rs_mwpfjqg_1"> </div><div id="wpfjqgNav_1" class="ui-state-default ui-jqgrid-pager ui-corner-bottom" dir="ltr" style="width: 1079px;"><div id="pg_wpfjqgNav_1" class="ui-pager-control" role="group"><table cellspacing="0" cellpadding="0" border="0" class="ui-pg-table" style="width:100%;table-layout:fixed;height:100%;" role="row"><tbody><tr><td id="wpfjqgNav_1_left" align="left"><table cellspacing="0" cellpadding="0" border="0" class="ui-pg-table navtable" style="float:left;table-layout:auto;"><tbody><tr><td class="ui-pg-button ui-corner-all" title="Add new row" id="add_wpfjqg_1"><div class="ui-pg-div"><span class="ui-icon ui-icon-plus"></span></div></td><td class="ui-pg-button ui-corner-all" title="Edit selected row" id="edit_wpfjqg_1"><div class="ui-pg-div"><span class="ui-icon ui-icon-pencil"></span></div></td><td class="ui-pg-button ui-corner-all" title="Delete selected row" id="del_wpfjqg_1"><div class="ui-pg-div"><span class="ui-icon ui-icon-trash"></span></div></td><td class="ui-pg-button ui-state-disabled" style="width:4px;"><span class="ui-separator"></span></td><td class="ui-pg-button ui-corner-all" title="Find records" id="search_wpfjqg_1"><div class="ui-pg-div"><span class="ui-icon ui-icon-search"></span></div></td><td class="ui-pg-button ui-corner-all" title="Reload Grid" id="refresh_wpfjqg_1"><div class="ui-pg-div"><span class="ui-icon ui-icon-refresh"></span></div></td></tr></tbody></table></td><td id="wpfjqgNav_1_center" align="center" style="white-space: pre; width: 297px;"><table cellspacing="0" cellpadding="0" border="0" style="table-layout:auto;" class="ui-pg-table"><tbody><tr><td id="first_wpfjqgNav_1" class="ui-pg-button ui-corner-all"><span class="ui-icon ui-icon-seek-first"></span></td><td id="prev_wpfjqgNav_1" class="ui-pg-button ui-corner-all"><span class="ui-icon ui-icon-seek-prev"></span></td><td class="ui-pg-button ui-state-disabled" style="width:4px;"><span class="ui-separator"></span></td><td dir="ltr">Page <input class="ui-pg-input" type="text" size="2" maxlength="7" value="0" role="textbox"> of <span id="sp_1_wpfjqgNav_1"></span></td><td class="ui-pg-button ui-state-disabled" style="width:4px;"><span class="ui-separator"></span></td><td id="next_wpfjqgNav_1" class="ui-pg-button ui-corner-all"><span class="ui-icon ui-icon-seek-next"></span></td><td id="last_wpfjqgNav_1" class="ui-pg-button ui-corner-all"><span class="ui-icon ui-icon-seek-end"></span></td><td dir="ltr"><select class="ui-pg-selbox" role="listbox"><option role="option" value="2">2</option><option role="option" value="5">5</option><option role="option" value="10" selected="selected">10</option><option role="option" value="25">25</option><option role="option" value="50">50</option><option role="option" value="500">500</option></select></td></tr></tbody></table></td><td id="wpfjqgNav_1_right" align="right"><div dir="ltr" style="text-align:right" class="ui-paging-info"></div></td></tr></tbody></table></div></div></div> <div id="wpfjqgSearch_1" class="fm-button ui-state-default ui-corner-all fm-button-icon-right ui-reset">Search<span class="ui-icon ui-icon-search"></span></div> <script type="text/javascript"> var lastSel; jQuery('#wpfjqg_1').jqGrid({ url: 'https://localhost:8888/wordpress/wp-admin//admin-ajax.php?action=ajax-wpfjqg&nonce=56d3710d95&table=wp_menu', datatype: 'json', colNames: ['Item Id','Item Name','Item Description','Item Price','Date Served','Glutenfree','Nutfree','Shellfishfree','Eatsmart','Vegan','Is Breakfast','Is Lunch','Is Dinner'], colModel: [{title:'Item Id',name:'item_id',index:'item_id',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,hidden:true,key:true}, {title:'Item Name',name:'item_name',index:'item_name',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'left',editoptions:{'size':20}, editrules:{required: true,}}, {title:'Item Description',name:'item_description',index:'item_description',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'left',editoptions:{'size':20}, editrules:{required: true,}}, {title:'Item Price',name:'item_price',index:'item_price',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'right', formatter:'number', formatoptions: {decimalSeparator:',', thousandsSeparator: '.', decimalPlaces: 2, defaulValue: 0},editoptions:{'size':20}, editrules:{required: true,}}, {title:'Date Served',name:'date_served',index:'date_served',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'left',editoptions:{'size':20}, editrules:{required: true,}}, {title:'Glutenfree',name:'glutenfree',index:'glutenfree',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,edittype: 'checkbox'}, {title:'Nutfree',name:'nutfree',index:'nutfree',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Shellfishfree',name:'shellfishfree',index:'shellfishfree',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Eatsmart',name:'eatsmart',index:'eatsmart',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Vegan',name:'vegan',index:'vegan',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Is Breakfast',name:'is_breakfast',index:'is_breakfast',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Is Lunch',name:'is_lunch',index:'is_lunch',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Is Dinner',name:'is_dinner',index:'is_dinner',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, ], pager: '#wpfjqgNav_1', rowNum: 10, rowList: [2, 5, 10, 25, 50, 500], autowidth: true, sortname: '1', sortorder: 'asc', viewrecords: true, jsonReader: { repeatitems: false }, width: 640, caption: 'Menu Items', height: '100%', editurl: 'https://localhost:8888/wordpress/wp-admin//admin-ajax.php?action=ajax-wpfjqg&nonce=56d3710d95&table=wp_menu', edit_options:{'closeAfterEdit':true}, /* fjqg_onlineEdit */ onSelectRow: function(ids) { if(ids == null) { ids=0; } } }); /* autofilter */ jQuery('#wpfjqg_1').jqGrid('filterToolbar',{stringResult:true, searchOnEnter:false}); </script><script type="text/javascript"> masterGrid = jQuery('#wpfjqg_1').jqGrid('navGrid', '#wpfjqgNav_1', { edit: true, add: true, del: true }, //options {recreateForm: true, beforeShowForm: function (form) {jQuery('#Id', form).attr('readonly', 'readonly');}, closeAfterEdit: true, width: 400, reloadAfterSubmit: true }, // edit options {recreateForm: true, closeAfterAdd: true, reloadAfterSubmit: true }, // add options {reloadAfterSubmit: true }, // del options {} // search options ); //standard search button jQuery('#wpfjqgSearch_1').click(function () { jQuery('#wpfjqg_1').jqGrid('searchGrid', { sopt: ['cn', 'bw', 'eq', 'ne', 'lt', 'gt', 'ew'] } ); }); </script> </div>
I know this is not the easiest thing in the world to read, so let me know if you need the information in another form. I’m not sure how to directly message someone via WP comments.
Thanks for the quick response! This is time sensitive, so I really appreciate the help.
I’ve figured it out. When loading the JSON data, the returned result contained a PHP error generated by the call to
ob_clean
inwpf-jqdata.php
. Commenting out that line fixes the problem for now:<br /> <b>Notice</b>: ob_clean(): failed to delete buffer. No buffer to delete in <b>/directory/path/wpf-jqgdata.php</b> on line <b>71</b><br />
I’m not sure if this is a bug in my config options or the plugin, but it works now!
Thank you very much for your troubleshooting.
I never run in this problem, that may be related to php version.
Anyway I’ll fix it now and ask you to try the new version, that just like yours: indeed there are no reasons to have this instruction!
- The topic ‘No data showing in table’ is closed to new replies.