I'm trying to use a serialized php data source and I get an error of "Table in data source has no rows". The errors below also appear in php_errors.log.
PHP Warning: Invalid argument supplied for foreach() in C:\inetpub\wwwroot\wp-content\plugins\codecanyon-3958969-wpdatatables-tables-and-charts-manager-for-wordpress\templates\admin\table-settings\add_column_modal.inc.php on line 72
PHP Warning: Invalid argument supplied for foreach() in C:\inetpub\wwwroot\wp-content\plugins\codecanyon-3958969-wpdatatables-tables-and-charts-manager-for-wordpress\templates\admin\table-settings\remove_column_modal.inc.php on line 40
Are the errors above causing the no rows error? I'm using version 2.3.
After further troubleshooting I believe my issue relates to some of the string lengths withing the serialized array are not correct, which I believe has something to do with character encoding.
Can you please tell me did you follow instructions from our documentation?
The format of the serialized array should be the following: 2D-array, where the parent level is an indexed array, and the second level is an associative array. Parent array entries will be parsed as rows, child array keys will be parsed as column headers, and child array values as cell values.
Can you please send me a link of that php script so we can take a look and check did that script have proper format for wpdatatables?
Hi Milan, I've resolved the problem. It was a Windows IIS authentication issue. I'm able to load tables from various datasources now including the serialized php array.
Hi,
I'm trying to use a serialized php data source and I get an error of "Table in data source has no rows". The errors below also appear in php_errors.log.
PHP Warning: Invalid argument supplied for foreach() in C:\inetpub\wwwroot\wp-content\plugins\codecanyon-3958969-wpdatatables-tables-and-charts-manager-for-wordpress\templates\admin\table-settings\add_column_modal.inc.php on line 72
PHP Warning: Invalid argument supplied for foreach() in C:\inetpub\wwwroot\wp-content\plugins\codecanyon-3958969-wpdatatables-tables-and-charts-manager-for-wordpress\templates\admin\table-settings\remove_column_modal.inc.php on line 40
Are the errors above causing the no rows error? I'm using version 2.3.
After further troubleshooting I believe my issue relates to some of the string lengths withing the serialized array are not correct, which I believe has something to do with character encoding.
Hi Dustin,
Thank you for your purchase.
Can you please tell me did you follow instructions from our documentation?
The format of the serialized array should be the following: 2D-array, where the parent level is an indexed array, and the second level is an associative array. Parent array entries will be parsed as rows, child array keys will be parsed as column headers, and child array values as cell values.
Can you please send me a link of that php script so we can take a look and check did that script have proper format for wpdatatables?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan,
Yes the array is formatted per the documentation. When the php file is loaded in the browser it displays the serialized array.
Also, I tried to create a table with the JSON example file from the documentation and I get the datasource has no rows error there as well.
Hi Dustin,
Can you please send me a link of that php script or link of that that json file so I can take a look?
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan, I've resolved the problem. It was a Windows IIS authentication issue. I'm able to load tables from various datasources now including the serialized php array.
Hi Dustin,
I am glad that you find what cause the issue and that you now can make all tables in plugin.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables