If I filter using "Województwo" field and choose any value, results = 0. Server side processing ON. SQL is vary simple, select (...) from table where field = x. The same table (copied) with server side OFF works fine (at the bottom of the page): http://niechzyja.pl/mapa-stref-cichych-polowan/
I hope you don't mind, but I used the log-in credentials you provided in one of the previous tickets and looked at [wpdatatable id=27].
I just deleted the accent grave ( ` ) around "dane_obwody" and the issue was resolved.
SELECT wojewodztwo, obwod_nr, powiat, nadlesnictwo, dzierzawca FROM dane_obwody WHERE cichy = 1
From version 2.3 we implemented the feature that you can use multiple separate db connections for (MySQL, MSSQL and PostgreSQL) and for MySQL engine we are dynamically adding accent grave ( ` ).
Your suggestions are always welcome, and I will forward this to our development team, so they can look into it, or at least add it to our documentation.
http://niechzyja.pl/test/
If I filter using "Województwo" field and choose any value, results = 0. Server side processing ON. SQL is vary simple, select (...) from table where field = x. The same table (copied) with server side OFF works fine (at the bottom of the page): http://niechzyja.pl/mapa-stref-cichych-polowan/
Hello Przemyslaw.
I hope you don't mind, but I used the log-in credentials you provided in one of the previous tickets and looked at [wpdatatable id=27].
I just deleted the accent grave ( ` ) around "dane_obwody" and the issue was resolved.
From version 2.3 we implemented the feature that you can use multiple separate db connections for (MySQL, MSSQL and PostgreSQL) and for MySQL engine we are dynamically adding accent grave ( ` ).
Best regards.
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,
I suggest adding this information to https://wpdatatables.com/documentation/creating-wpdatatables/creating-mysql-based-wpdatatables/. Or maybe even better just automatically remove this symbols from SQL, if You intend to add it later.
Hi Przemyslaw.
You're welcome. Glad we resolved this issue.
Your suggestions are always welcome, and I will forward this to our development team, so they can look into it, or at least add it to our documentation.
Best regards.
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