WordPress.org

Ready to get started?Download WordPress

Forums

WPF-jqGrid
[resolved] No data showing in table (7 posts)

  1. davidsomerset
    Member
    Posted 1 month ago #

    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!

    https://wordpress.org/plugins/wp-fjqgrid/

  2. faina09
    Member
    Plugin Author

    Posted 1 month ago #

    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.

  3. davidsomerset
    Member
    Posted 1 month ago #

    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.

  4. faina09
    Member
    Plugin Author

    Posted 1 month ago #

    When no data is displayed probably there is an issue with generated jscript. This is the reason why I asked you the html code.

  5. davidsomerset
    Member
    Posted 1 month ago #

    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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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;">&nbsp;</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">&nbsp;</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: 'http://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: 'http://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.

  6. davidsomerset
    Member
    Posted 1 month ago #

    I've figured it out. When loading the JSON data, the returned result contained a PHP error generated by the call to ob_clean in wpf-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!

  7. faina09
    Member
    Plugin Author

    Posted 1 month ago #

    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!

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.