I have some problems with your latest version of wpdatatbles. The mysql queries are missing some columns. It is giving me the column but no data at all. And these are very simple queries. I get some js errors in the console:
[Error] Failed to load resource: the server responded with a status of 404 (HTTP/2.0 404) (bootstrap-select.js.map, line 0)
[Error] Failed to load resource: the server responded with a status of 404 (HTTP/2.0 404) (pdfmake.min.js.map, line 0)
[Error] Failed to load resource: the server responded with a status of 404 (HTTP/2.0 404) (waves.min.js.map, line 0)
It seems this files are named differently. There is no such files in the corresponding directories with the .map ending. There are the correct files but with the only with .js ending.
All my results were fine with the old version. And it is working correctly. I am missing dates column and some random number columns. All these queries work fine on phpmyadmin and giving me all the information.
The error "Column 'pos' cannot be null" refers that there is a "space" in the column header in one of the columns or more . For example, column header : Last Name(space)
Can you please investigate it because that can cause all of the other issues below.
My suggestion when you have queries like this is to make a VIEW in phpmyadmin or any other database management system and see if it will return the desired results.
Hi There,
I have some problems with your latest version of wpdatatbles. The mysql queries are missing some columns. It is giving me the column but no data at all. And these are very simple queries. I get some js errors in the console:
[Error] Failed to load resource: the server responded with a status of 404 (HTTP/2.0 404) (bootstrap-select.js.map, line 0)
[Error] Failed to load resource: the server responded with a status of 404 (HTTP/2.0 404) (pdfmake.min.js.map, line 0)
[Error] Failed to load resource: the server responded with a status of 404 (HTTP/2.0 404) (waves.min.js.map, line 0)
It seems this files are named differently. There is no such files in the corresponding directories with the .map ending. There are the correct files but with the only with .js ending.
All my results were fine with the old version. And it is working correctly. I am missing dates column and some random number columns. All these queries work fine on phpmyadmin and giving me all the information.
I really need help with these problems...
Hi ilkkaH,
Thank you for your purchase.
It looks like the problem is on the side of the server.
Can you please check you server log and see if there are some issues.
Best regards.
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 ilkkaH,
The error "Column 'pos' cannot be null" refers that there is a "space" in the column header in one of the columns or more .
For example, column header : Last Name(space)
Can you please investigate it because that can cause all of the other issues below.
Best regards.
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,
Ok. I will be investigating this and get back to you when I have some results.
Hi ilkkaH,
My suggestion when you have queries like this is to make a VIEW in phpmyadmin or any other database management system and see if it will return the desired results.
No problem, let me know the result.
Best regards.
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