I have a wpdatatable with the following sql-statement (sample sql-query).
SELECT Honig_Art.post_name as 'Category', 10 as 'Value' FROM wp_posts AS Honig_Art JOIN wp_posts AS Art ON Art.id = RIGHT(Honig_Art.post_name, 4)
WHERE regexp_substr(Honig_Art.post_name, '[0-9]+') = '%CURRENT_POST_ID%'
The result set of that query shows the correct values in the table. Server-side processing is enabled.
To display that wpdatatable data in a wpdatachart fails however.
WP error log shows:
[09-Jun-2023 21:20:29 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 for query SELECT COUNT(*) as cnt_total FROM made by do_action('wp_ajax_get_wdtable'), WP_Hook->do_action, WP_Hook->apply_filters, wdtGetAjaxData, WPDataTable->queryBasedConstruct
[09-Jun-2023 21:20:29 UTC] PHP Warning: Trying to access array offset on value of type null in ...public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php on line 2742
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
1. Can you tell me, does this chart load on the back-end and the issue is maybe just on front-end?
If that is the case, please send me an URL to the front-end page with the error,
and back-end access to inspect the table and chart setup.
Please provide me a temporary WP-admin (administrator) user for your website 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 parties.
You can write credentials here just make sure to mark the reply as PRIVATE,
then nobody can see them except us.
And point me to the Chart ID, please.
2. Did the chart initially generate OK, then after some time it thrown this error -
or does it happen when you are trying to create the Chart in the Wizard in the back-end?
- If you are not able to fully create the chart and the error happens during the Wizard steps,
can you record your screen and send me a Video to see all the steps and Chart Configuration?
3. If your chart was working, but it stopped,
is it possible that you changed any structure of the source table, like Header Name, Data Type of any column, etc?
If you change anything with the table structure, the chart will break, if you can try to make a new chart and let us know if that helps.
I have a wpdatatable with the following sql-statement (sample sql-query).
SELECT Honig_Art.post_name as 'Category',
10 as 'Value'
FROM wp_posts AS Honig_Art
JOIN wp_posts AS Art ON Art.id = RIGHT(Honig_Art.post_name, 4)
WHERE regexp_substr(Honig_Art.post_name, '[0-9]+') = '%CURRENT_POST_ID%'
The result set of that query shows the correct values in the table. Server-side processing is enabled.
To display that wpdatatable data in a wpdatachart fails however.
WP error log shows:
[09-Jun-2023 21:20:29 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 for query SELECT COUNT(*) as cnt_total FROM made by do_action('wp_ajax_get_wdtable'), WP_Hook->do_action, WP_Hook->apply_filters, wdtGetAjaxData, WPDataTable->queryBasedConstruct
[09-Jun-2023 21:20:29 UTC] PHP Warning: Trying to access array offset on value of type null in ...public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php on line 2742
Please help.
Thanks
Thomas
Hi ,Thomas.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
1. Can you tell me, does this chart load on the back-end and the issue is maybe just on front-end?
If that is the case, please send me an URL to the front-end page with the error,
and back-end access to inspect the table and chart setup.
Please provide me a temporary WP-admin (administrator) user for your website 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 parties.
You can write credentials here just make sure to mark the reply as PRIVATE,
then nobody can see them except us.
And point me to the Chart ID, please.
2. Did the chart initially generate OK, then after some time it thrown this error -
or does it happen when you are trying to create the Chart in the Wizard in the back-end?
- If you are not able to fully create the chart and the error happens during the Wizard steps,
can you record your screen and send me a Video to see all the steps and Chart Configuration?
3. If your chart was working, but it stopped,
is it possible that you changed any structure of the source table, like Header Name, Data Type of any column, etc?
If you change anything with the table structure, the chart will break, if you can try to make a new chart and let us know if that helps.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Thanks Milos.
I found the solution by myself.
If played around with the parameters of the table which is the basis for the diagram and suddenly it worked.
Hi, Thomas.
My apologies for the delayed response times on this ticket,
going to do my best to be quicker going forward.
I am delighted to hear that this has been resolved. Thank you for letting us know.
Please don't hesitate to create new tickets for anything else we could assist with.
Have a great day!
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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