My pages have started throwing the following warning:
Warning: Invalid argument supplied for foreach() in /home/leemrw1/dev.leemrw.com/wp-content/plugins/wpdatatables/lib/PHPSQLParser/builders/SubTreeBuilder.php on line 100
Warning: Invalid argument supplied for foreach() in /home/leemrw1/dev.leemrw.com/wp-content/plugins/wpdatatables/lib/PHPSQLParser/builders/SubTreeBuilder.php on line 100
I have 4 tables defined. Each time I go to the page where they are to be displayed I get 3 warnings:
Warning: Invalid argument supplied for foreach() in /home/leemrw1/dev.leemrw.com/wp-content/plugins/wpdatatables/lib/PHPSQLParser/builders/SubTreeBuilder.php on line 100
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
We are a security company which has a specific policy against granting such privileges. My Chief Technology Officer has specifically stated that we would have to drop wpDataTables if support always depended on granting administrative privilege.
Please note that Bogdan provided the following response to another ticket (#1319220) I submitted:
"We are avare that there is some problem with that PHP sqlparser for this version of plugin and we are working to fix it for our upcoming update. Also we suggest to make a VIEW in phpmyadmin or any other database management system and see if the query is returning the desired results. If the results are wright use that query as an input when creating tables with Add from data source option."
Given the that the warning references the PHPSQLParser directory I would think this has more to do with code on your side than anything that we are doing.
We are satisfied with the way wpDataTables is performing except for the warnings. So maybe we should look more towards suppressing those warnings from appearing on our site pages.
I can also look to unraveling our query with a View but it may be difficult because of the way the query is structured.
In summary, here are my questions:
Can the warnings be suppressed?
When do you expect to release the update to wpDataTables?
My pages have started throwing the following warning:
Warning: Invalid argument supplied for foreach() in /home/leemrw1/dev.leemrw.com/wp-content/plugins/wpdatatables/lib/PHPSQLParser/builders/SubTreeBuilder.php on line 100
Warning: Invalid argument supplied for foreach() in /home/leemrw1/dev.leemrw.com/wp-content/plugins/wpdatatables/lib/PHPSQLParser/builders/SubTreeBuilder.php on line 100
Please advise
Hi Mark,
Thank you for your purchase.
Can you please send me a screenshot of "INFO" tab in wpdatatable settings?(attachment)
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
Here is the information you requested.
Hi Mark,
Can you update the PHP version to the latest?
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 did just upgrade the PHP level (see the attachment). Unfortunately, the problem persists .
What can we look at now?
Mark Lee
I have 4 tables defined. Each time I go to the page where they are to be displayed I get 3 warnings:
Warning: Invalid argument supplied for foreach() in /home/leemrw1/dev.leemrw.com/wp-content/plugins/wpdatatables/lib/PHPSQLParser/builders/SubTreeBuilder.php on line 100
It seems that for 3 of the 4 warnings are thrown.
Hi Mark,
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
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,
We are a security company which has a specific policy against granting such privileges. My Chief Technology Officer has specifically stated that we would have to drop wpDataTables if support always depended on granting administrative privilege.
Please note that Bogdan provided the following response to another ticket (#1319220) I submitted:
"We are avare that there is some problem with that PHP sqlparser for this version of plugin and we are working to fix it for our upcoming update.
Also we suggest to make a VIEW in phpmyadmin or any other database management system and see if the query is returning the desired results. If the results are wright use that query as an input when creating tables with Add from data source option."
Given the that the warning references the PHPSQLParser directory I would think this has more to do with code on your side than anything that we are doing.
We are satisfied with the way wpDataTables is performing except for the warnings. So maybe we should look more towards suppressing those warnings from appearing on our site pages.
I can also look to unraveling our query with a View but it may be difficult because of the way the query is structured.
In summary, here are my questions:
I look forward to hearing from you.
Mark Lee
Hi Mark,
Correct me if I am wrong, you don't have problems with showing tables, you just have this warning on page?
You can hide this warnings by updating file
wp-config.phpyou can solved the issue and successfully suppressed the warnings.You have to find:
define('WP_DEBUG', false);and replace with this:
ini_set('log_errors','On');
ini_set('display_errors','Off');
ini_set('error_reporting', E_ALL );
define('WP_DEBUG', false);
define('WP_DEBUG_LOG', true);
define('WP_DEBUG_DISPLAY', false);
This will be log all errors and warnings in log file, but it will not be displayed.
We will try to be as soon as possible.
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
Yes, thanks. I have succeeded in suppressing the warning messages.
Hi Mark,
You are welcome. Glad that we solved the issue.
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