I have created MySQL with similar query using wpDataTables Constructor and you can take a look at this table (Attachment) but when I save the table and go to preview or put it on the page I can see the query is different and also I got "error 406 Not Acceptable":
You can take a look more about error 406 on this Link
This problem happens quite rarely and isn’t up to the plugin, but rather up to host. The plugin is working correctly, it generates the query. But we discovered that on some hosts (I believe it’s mostly on shared hosts) there is some sort of server protection that throws 404 or 406 for any request that contains a SQL query that it finds ‘suspicious’, we believe this is a security measure against SQL injections. Unfortunately there is nothing we can do from our side to fix this as it is somewhere in server configuration beyond our reach.
Steps you can do:
- Try to contact your host and explain that you would like to add an exception for this SQL injections protection, for HTTP POST requests to wp-admin/admin-ajax.php
- Maybe you can consider changing the hosting plan or provider
- If nothing else helps you can try to copy the generated queries and create PHP files that would perform the query to the host and return the data in a serialized array
Hi Lughen,
Thank you for your purchase.
Could you please point me to the table where you have mentioned query?
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
http://www.webmo.org/tesdarizal/wp-admin/post.php?post=2111&action=edit
[wpdatatable id=13]
SELECT
concat_ws(last_name,' ',first_name,' ',middle_initial) as Name,
nc_title,
sector,
expiration_date
FROM
wp_hbor_tesda_rwacfile
the result must be: Lastname, Firstname M.
Hi Lughen,
I have created MySQL with similar query using wpDataTables Constructor and you can take a look at this table (Attachment) but when I save the table and go to preview or put it on the page I can see the query is different and also I got "error 406 Not Acceptable":
You can take a look more about error 406 on this Link
This problem happens quite rarely and isn’t up to the plugin, but rather up to host. The plugin is working correctly, it generates the query. But we discovered that on some hosts (I believe it’s mostly on shared hosts) there is some sort of server protection that throws 404 or 406 for any request that contains a SQL query that it finds ‘suspicious’, we believe this is a security measure against SQL injections.
Unfortunately there is nothing we can do from our side to fix this as it is somewhere in server configuration beyond our reach. Steps you can do:
- Try to contact your host and explain that you would like to add an exception for this SQL injections protection, for HTTP POST requests to wp-admin/admin-ajax.php
- Maybe you can consider changing the hosting plan or provider
- If nothing else helps you can try to copy the generated queries and create PHP files that would perform the query to the host and return the data in a serialized array
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
Hi Bogdan,
Thank you very much for the assistance.
Hi Bogdan,
For your reference, I have resolve the problem by using 'concat_ws(separator,string,string)' function.
Hi Lughen,
We are glad that you find the solution.
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