I have a wpdata table created from MySQL with values joined from another table. For example:
SELECT a.company As customer, b.contact As Contact FROM a JOIN b ON a.ID = b.ID
Now the table displays fine but when I show the filters above the table and filter for any value of table B, I get "DataTables warning: table id=table_1 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1", which doesn't help as there is no error in the console.
the error log is empty, the access log just shows the usual stuff.
The only other thing that came into my mind which might be helpful is that I only show the table to logged in users, don't know if that's relevant. On the other hand, the values not joined can be filtered fine so I guess it's not a general compatibility issue.
After adding other entry to the table I'm now seeing these errors in the console as well, maybe this helps:
Source-Map-Fehler: SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data Ressourcen-Adresse: https://url/wp-content/plugins/wpdatatables/assets/js/bootstrap/bootstrap-select/bootstrap-select.min.js?ver=4.9.6 Source-Map-Adresse: bootstrap-select.js.map[Weitere Informationen] Source-Map-Fehler: SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data Ressourcen-Adresse: https://url/wp-content/plugins/wpdatatables/assets/js/waves/waves.min.js?ver=4.9.6 Source-Map-Adresse: waves.min.js.map[Weitere Informationen]
Source-Map-Fehler: SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data Ressourcen-Adresse: https://url/wp-content/plugins/wpdatatables/assets/js/export-tools/pdfmake.min.js?ver=4.9.6 Source-Map-Adresse: pdfmake.min.js.map
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.
Also point me to the table ID where I can try to reproduce the issue.
I have a wpdata table created from MySQL with values joined from another table. For example:
SELECT a.company As customer, b.contact As Contact FROM a JOIN b ON a.ID = b.ID
Now the table displays fine but when I show the filters above the table and filter for any value of table B, I get "DataTables warning: table id=table_1 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1", which doesn't help as there is no error in the console.
HI burgunderblau,
Thank you for your purchase.
Can you please check your server log and tell me are there any errors.
Best regards.
Kind Regards,
Miloš Jovanović
[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 Bogdan,
the error log is empty, the access log just shows the usual stuff.
The only other thing that came into my mind which might be helpful is that I only show the table to logged in users, don't know if that's relevant. On the other hand, the values not joined can be filtered fine so I guess it's not a general compatibility issue.
Regards,
Jan
Hi,
After adding other entry to the table I'm now seeing these errors in the console as well, maybe this helps:
HI burgunderblau,
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.
Also point me to the table ID where I can try to reproduce the issue.
Best regards.
Kind Regards,
Miloš Jovanović
[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