The tables we have integrated on our site kittec.eu are no longer displaying, but only on SOME devices and browsers.
- On my employers devices, no tables are showing on any browser except the one he uses himself to admin the site
- on my mac, the tables are showing in Chrome (which I use to admin the site and edit wpDataTables), an in firefox (which I use to test the front-end, while not logged-in), but are NOT showing on Safari, which I have never used to admin the site.
- In Safari, some of the tables are showing some of the time, but most are not. No pattern determining which tables work and which don´t that I could identify...
Last week, everything worked perfectly. The last thing I did was trying to work around an issue:
One field of our master mySQL table shows non-integer numbers (power in kW). Some of the bigger values have no ",00", and should not have any, others look like "3,5". I chose "Float" as datatype for this column in all wpDataTables referencing the master table, but there it´s probably a string.
That lead to the error, somehow the string from mySQL was translated incorrectly, for instance: "3,7" would become "3,00".
My workaround was to change the datatype of that column in every one of our wpDataTables to "String", and the numbers would again be displayed correctly.
Only now, nothing is displayed at all...
If I change values in the master table, they are updated correctly on those devices/browsers that do display them at all, so the database connection itself is still working.
Can this be a permissions issue? Is something stored in the cache of those browsers that are used to admin the sites, so tables still get displayed correctly?
I think I came across another bug while still trying to find out why SOME tables work on SOME device-browser combinations, but not on others (I know you have a holiday today, but my employer wants this fixed as soon as possible, of course, with full knowledge what the cause of it was. Trusting that the error will "go away" is not an option...).
So I try different settings etc. just to narrow it down, so far I have found nothing conclusive, but some interesting behaviour. For instance I get this, when I switch on/off "server-side processing": Exhibit A shows the table with server-side processing set to ON, Exhibit B is the exact same table with it turned OFF, nothing else has changed. Is this expected behaviour?
Sorry for the delay. As you mentioned - we've had a non-working Monday due to the National Holiday.
wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look the same both in back-end and in front-end. If your front-end table looks and behaves differently than in back-end, this usually implies that there is another plugin (or the current theme) that's changing the behavior of our plugin.
However, since this is happening only on a specific browser, and for specific tables, it could be that there are some permission issues, and/or leftover cache in the browser. Having the table display differently based on server-side processing being on or off is a weird issue, as it should be working the same. Server-side fetches only those rows needed on the page at the exact moment, while non-server-side fetches all rows.
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.
Hi guys, this is rather urgent:
The tables we have integrated on our site kittec.eu are no longer displaying, but only on SOME devices and browsers.
- On my employers devices, no tables are showing on any browser except the one he uses himself to admin the site
- on my mac, the tables are showing in Chrome (which I use to admin the site and edit wpDataTables), an in firefox (which I use to test the front-end, while not logged-in), but are NOT showing on Safari, which I have never used to admin the site.
- In Safari, some of the tables are showing some of the time, but most are not. No pattern determining which tables work and which don´t that I could identify...
Last week, everything worked perfectly. The last thing I did was trying to work around an issue:
One field of our master mySQL table shows non-integer numbers (power in kW). Some of the bigger values have no ",00", and should not have any, others look like "3,5". I chose "Float" as datatype for this column in all wpDataTables referencing the master table, but there it´s probably a string.
That lead to the error, somehow the string from mySQL was translated incorrectly, for instance: "3,7" would become "3,00".
My workaround was to change the datatype of that column in every one of our wpDataTables to "String", and the numbers would again be displayed correctly.
Only now, nothing is displayed at all...
If I change values in the master table, they are updated correctly on those devices/browsers that do display them at all, so the database connection itself is still working.
Can this be a permissions issue? Is something stored in the cache of those browsers that are used to admin the sites, so tables still get displayed correctly?
Thank you!
I think I came across another bug while still trying to find out why SOME tables work on SOME device-browser combinations, but not on others (I know you have a holiday today, but my employer wants this fixed as soon as possible, of course, with full knowledge what the cause of it was. Trusting that the error will "go away" is not an option...).
So I try different settings etc. just to narrow it down, so far I have found nothing conclusive, but some interesting behaviour. For instance I get this, when I switch on/off "server-side processing": Exhibit A shows the table with server-side processing set to ON, Exhibit B is the exact same table with it turned OFF, nothing else has changed. Is this expected behaviour?
Hello Florian
Sorry for the delay. As you mentioned - we've had a non-working Monday due to the National Holiday.
wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look the same both in back-end and in front-end. If your front-end table looks and behaves differently than in back-end, this usually implies that there is another plugin (or the current theme) that's changing the behavior of our plugin.
However, since this is happening only on a specific browser, and for specific tables, it could be that there are some permission issues, and/or leftover cache in the browser. Having the table display differently based on server-side processing being on or off is a weird issue, as it should be working the same. Server-side fetches only those rows needed on the page at the exact moment, while non-server-side fetches all rows.
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.
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