I'm running WordPress 5.6 and WPTB 3.3. My page has multiple charts and a couple of the charts require the tables for the sake of filtering, but the tables are hidden.
For every column in those tables (but not for datapoints on other charts), there are hundreds of "undefined index" PHP notices all pointing at wp-content/plugins/wpdatatables/source/class.wpdatatable.php:1177. So this sounds like a problem with WPDT.
I suspect it's all these notices that are significantly slowing down server response when loading my page without caching.
I really can't help you much with the issue if I don't know what those notices are. You mentioned they are related to class.wpdatatable.php:1177, and I told you that line is used for managing number formats when a table is being pulled from a database (through MySQL).
Are all 4,600+ notices "undefined index"? Are they happening for all tables, or only for some tables?
Also, you seem to be using SQL query based tables, which are available only in the full version of the plugin, so why have you opened the ticket in the Pre-Purchase section?
I don't know why this was marked as "pre-purchase" question. I'm quite certain I marked it as technical support and included my order ID. So maybe your form is having trouble.
I'm loading only the tables I need in order to apply the table filtering to charts. All of these JSON-linked tables are reporting the undefined index errors. I would guess the number of errors is equal to the number of cells.
I tried, but I couldn't replicate this. In your screenshot, I can see these are reported:
The line you say is reporting an error refers to manage number formats, so can you tell me what filter type are you using for this column? If you're trying to use number-range, I suppose that's causing the issue, but I can't say for sure. This ticket has been forwarded to one of our developers, so he can check it out, and I'll get back to you as soon as I hear from him.
Could you also provide me with a temporary wp-admin user (administrator), in case he needs to log in, and inspect this?
Please note that this is a public ticket, so if you're leaving your log-in credentials, make sure to enable the PRIVATE response.
Although I do have some number-range formatting since there seems to be no way to filter out null or 0-value rows, nearly all those columns have no filtering.
Yes, this will be easier with admin access to my site. So I'll share that in a private response.
Which honestly doesn't make much sense (if it's the same on your end).
Can you clone your website?
If yes - I'll ask you to install the Duplicator plugin. It will generate a couple of files which you can send me (along with the log-in credentials), and then I can create an exact copy of your website, see what the issue is and try to resolve it.
Please note that the files will be too large to attach to the ticket, so you can upload them via wetransfer.com and just send me the link.
Also, please explain to me how we can access the contents from the JSON URL, because it's protected, and a table can't be made with the links you have in your localhost. We need a specific URL, so we can recreate the table and debug the plugin.
Remember this is a public ticket, so enable the Private response again when sending the duplicator files.
When those three columns are removed from JSON, it doesn't throw any notices. That means that the issue is coming from those columns, that is - from the data in them.
We've tried with the Excel export, and it's working fine, so API returns something that's not parsed well in wpDataTables. Either create it for us, or allow us to use that API call in localhost, so we can debug it, and see what it returns. On your website, there's no Plugin Editor, so we can't see what API returns as values through your website.
I'm running WordPress 5.6 and WPTB 3.3. My page has multiple charts and a couple of the charts require the tables for the sake of filtering, but the tables are hidden.
For every column in those tables (but not for datapoints on other charts), there are hundreds of "undefined index" PHP notices all pointing at wp-content/plugins/wpdatatables/source/class.wpdatatable.php:1177. So this sounds like a problem with WPDT.
I suspect it's all these notices that are significantly slowing down server response when loading my page without caching.
Hello Daniel
This line is used for managing number formats when a table is being pulled from a database (through MySQL).
Can you please show me the page?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Here's the page: https://podcastindustryinsights.com/apple-podcasts-statistics/
Hello again Daniel.
All I can see on that page is this:
And it's all related to Elementor, as far as I can see.
Can you please show me what you mean?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Of course you can't see the 4,600+ PHP Notices. They're in my server's log and also caught and reported to me by Query Monitor.
So what are the notices you see?
I really can't help you much with the issue if I don't know what those notices are. You mentioned they are related to class.wpdatatable.php:1177, and I told you that line is used for managing number formats when a table is being pulled from a database (through MySQL).
Are all 4,600+ notices "undefined index"? Are they happening for all tables, or only for some tables?
Also, you seem to be using SQL query based tables, which are available only in the full version of the plugin, so why have you opened the ticket in the Pre-Purchase section?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I don't know why this was marked as "pre-purchase" question. I'm quite certain I marked it as technical support and included my order ID. So maybe your form is having trouble.
I'm loading only the tables I need in order to apply the table filtering to charts. All of these JSON-linked tables are reporting the undefined index errors. I would guess the number of errors is equal to the number of cells.
Have you tried replicating the issue?
Hi again Daniel
I tried, but I couldn't replicate this. In your screenshot, I can see these are reported:
The line you say is reporting an error refers to manage number formats, so can you tell me what filter type are you using for this column? If you're trying to use number-range, I suppose that's causing the issue, but I can't say for sure. This ticket has been forwarded to one of our developers, so he can check it out, and I'll get back to you as soon as I hear from him.
Could you also provide me with a temporary wp-admin user (administrator), in case he needs to log in, and inspect this?
Please note that this is a public ticket, so if you're leaving your log-in credentials, make sure to enable the PRIVATE response.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Although I do have some number-range formatting since there seems to be no way to filter out null or 0-value rows, nearly all those columns have no filtering.
Yes, this will be easier with admin access to my site. So I'll share that in a private response.
Thanks Daniel
I forwarded the credentials to one of our developers, so he can take a look.
I'll get back to you as soon as I hear from him.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi again Daniel.
Unfortunately, you don't have the Plugin editor enabled, so we couldn't see which specific code is on that referenced line. On our end, it's:
$numberFormat = get_option('wdtNumberFormat') ? get_option('wdtNumberFormat') : 1;
Which honestly doesn't make much sense (if it's the same on your end).
Can you clone your website?
If yes - I'll ask you to install the Duplicator plugin. It will generate a couple of files which you can send me (along with the log-in credentials), and then I can create an exact copy of your website, see what the issue is and try to resolve it.
Please note that the files will be too large to attach to the ticket, so you can upload them via wetransfer.com and just send me the link.
Also, please explain to me how we can access the contents from the JSON URL, because it's protected, and a table can't be made with the links you have in your localhost. We need a specific URL, so we can recreate the table and debug the plugin.
Remember this is a public ticket, so enable the Private response again when sending the duplicator files.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you, Daniel
I forwarded the ticket to one of our developers, but I don't know if he'll be able to do anything without a duplicate of your website locally.
I'll wait for him, and let you know as soon as he responds.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi again Daniel
When those three columns are removed from JSON, it doesn't throw any notices. That means that the issue is coming from those columns, that is - from the data in them.
We've tried with the Excel export, and it's working fine, so API returns something that's not parsed well in wpDataTables. Either create it for us, or allow us to use that API call in localhost, so we can debug it, and see what it returns. On your website, there's no Plugin Editor, so we can't see what API returns as values through your website.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables