I've purchased this plugin today and started testing it. I've imported some existing data that I want to present on my website using this tool. I did some initial tests and apparently there is a common problem that badly affects the result and I can sum it up like that: while in the "Preview" everything looks nice, when I am trying to put it on a webpage, the table is distorted and does not comply with all the settings I gave it.
Initially I though that it might have to do with CSS settings, but some of the examples below show that this is not the case. It seems that something in the rendering process to the webpage is faulty (and I remind you that in the "Preview" it always looks good and according to the settings). Here is the list:
- I've asked to show all the records in the table (around 50). On the webpage it shows only the first 10
- I've asked to hide the 3 first columns. On the webpage it hides the titles of these columns, but keeps showing their data and this clearly causes a mess. In the Preview it is working fine!!!!!!
- I've asked for conditional formatting of some values. On the webpage it ignores the condition and does not do the formatting.
- There is a problem with the width in use on the website. I tried with or without a sidebar - it does not help. The table content overrides the sidebar, and the table "Search" overrides the table title. Bottom line - it looks like shit. See examples attached (bot on website and preview).
The issue like this ( when in preview mode everything is working fine) is almost 99% related to the theme. Can you 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 so I can take a look.
I will be at the office tomorrow at 11:30 so send me the credentials tomorrow but please do not forget to check PRIVATE reply so nobody can see it except us.
The data was there this morning and the only thing I did was to upgrade to the new version of the plugin which I got this morning... Looks like a separate bug to me.
Do you want to look into this before I re-enter the data?
1. The only way for data to not get lost is to follow these instructions from our documentation how to update the plugin manually - Link. Just please note:
IMPORTANT: Do NOT delete the old version from WP-admin (by clicking “Delete” in the plugins page) if you don’t want to lose all your tables!
Can you please tell me did you follow the steps when updating the plugin.
2. I can see that the table is manual, so can you please re-enter the data and I will copy paste it and create some support table.
1. No, I didn't follow the instuctions, as it was not mentioned anywhere visible... the normal practice is to simply update by re-installing the plug in or update via the WP interface (but I didn't have this option). anyway, this is less important now. I will keep this in mind for next time.
2. The good news is that now it is working nicely. Have a look at 'table3' and the page I've created. Looks like the update fixed the bug.
I was happy too soon. The bug is still here and I noted the following:
At the beginning, after re-entering the data, the parameter "Hide table until page is completely loaded" was turned off, and everything was looking ok, except that it took time for the table to be formatted on the page. So, I turned this parameter on and then the table did not show at all. So, I turned it back off and then the data presented is wrong (hidden columns present data - see first 3 columns).
I've turned the CDN on. In case you didn't log out, just close the window/tab that you used to log on to our website. Don't do anything else there. Thanks.
I logged out .
I will take a look again tomorrow if you can give me the access again.
I will also try to reproduce this issue on my side so I can find the issue when the Hide before load option is checked.
I logged out .
I will take a look again tomorrow if you can give me the access again.
I will also try to reproduce this issue on my side so I can find the issue when the Hide before load option is checked.
I've installed this morning the new update of your plugin. It is still not working properly, but this time the problem is different.
As you can see in the example, the table appears perfectly on the browser, as planned, but for some reason the title is pushed up. I've double checked this very same page with out the table, and the title was fine. Only once I put the [wpdatatable id=4] the title was pushed up, partially hidden below the overlay of the title.
In addition, when I use the "Hide the table before it is fully loaded", the page can not be scrolled down.... (I asked to show all the records (few dozens of these).
I know. I changed the password so you will not attempt to login without coordinating the exact timing!! The site is in production on CDN. You can not log in whenever you want. We have to turn the CDN before you log in.
However, please note that we had to manually "push" the title down by 150 pixels, as strangely enough when we put the [wpdatatable=7] tag on the page, the title was "pushed" up and this distorted the entire page. When we removed the [wpdatatable=7] tag the page was normal.
Another thing that I want to report on is that when we asked to show 'All' records the table hangs for long time and simply does not present the data. So, we set it to '100' records, which is enough for us now. The table is in MySQL and we use SQL query to retrieve the data.
I didn't see the title on that page. If this is still an issue please return it so I can take a look.
If you try to load all the data from table at once, even if you have server-side processing enabled, it could crash the table based on amount of data in it. Based on experience limitation for tables size which should work without server-side processing is around 2000-3000 rows and if you try to load whole table at once you are losing the benefits of server-side processing.
I could not log in with credentials that you gave us previously to examine this table more closely so if this table is not large please send us those credentials again so we can take a look
This is a production site and therefore we do not enable external login to it, without coordinating this with us beforehand.
The current title of the page is now OK, after we added this padding of 150px. As I said it happens only when we had your tag to the page. When we remove the tag, there is not problem! Something in the way you render the table code badly affects the template.
The full table includes roughly 1500 records (rows). In the current table there aren't more than 100 per 'filter'. The thing is that when we ask for 'All' it hangs, and when we ask for 'up to 100' it displays the data. In both cases the data is more in the area of 50 records (per filter). I have been working with SQL databases for 20 years by now. I know what are the implications of retrieving too much data. This is not the case here. Something is wrong with the 'All' the records.
Could you try to duplicate the table and load all the data without conditional formatting just to be sure that this option is not the one that are causing problems?
You actually have 3773 rows in that table and asking from table to show all off them will most probably hit the memory limit. I actually managed to show whole table in my local environment but it was really unresponsive and slow
In such queries only around 50 records are selected, and still the show "All" records hangs.
Unfortunately i still didn't understood this part. As i can see you remove "Rows per page" block so I don't understand how you select all records. Also i removed both filters from that page and table works stable and reasonably fast for that amount of data
I can confirm that the problem still persist on our live website. In order for you to login, this must be coordinated with me to ensure safe login.
Please note that I was using the same database and same table on another website I am currently developing on my desktop, using a different template and there is not such problem there.
I know that you have problem on your live website but please try to switch templates for just a minute to test if this is a template related issue or install same template that you are using on your production website in your local environment and see does the problem occurs there.
Hello,
I've purchased this plugin today and started testing it. I've imported some existing data that I want to present on my website using this tool. I did some initial tests and apparently there is a common problem that badly affects the result and I can sum it up like that: while in the "Preview" everything looks nice, when I am trying to put it on a webpage, the table is distorted and does not comply with all the settings I gave it.
Initially I though that it might have to do with CSS settings, but some of the examples below show that this is not the case. It seems that something in the rendering process to the webpage is faulty (and I remind you that in the "Preview" it always looks good and according to the settings). Here is the list:
- I've asked to show all the records in the table (around 50). On the webpage it shows only the first 10
- I've asked to hide the 3 first columns. On the webpage it hides the titles of these columns, but keeps showing their data and this clearly causes a mess. In the Preview it is working fine!!!!!!
- I've asked for conditional formatting of some values. On the webpage it ignores the condition and does not do the formatting.
- There is a problem with the width in use on the website. I tried with or without a sidebar - it does not help. The table content overrides the sidebar, and the table "Search" overrides the table title. Bottom line - it looks like shit. See examples attached (bot on website and preview).
Please help.
Thanks,
Yoram
Hi Yoram,
Thank you for your purchase.
Can you please try to change the theme and tell me does everything is working fine after that.
Thank you .
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,
I can't. It is on a live site.
Yoram
Hi Yoram,
The issue like this ( when in preview mode everything is working fine) is almost 99% related to the theme.
Can you 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 so I can take a look.
Thank you .
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,
This coming Tuesday, July 11th, at 11:30 CEST. Please send me a reply here when you are ready and I will send you the login credentials.
Thanks,
Yoram
Hi Yoram,
I will be at the office tomorrow at 11:30 so send me the credentials tomorrow but please do not forget to check PRIVATE reply so nobody can see it except us.
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
OK. Let's do that tomorrow.
Hi Yoram,
I logged in successfully.
I will get back to you as soon as I take a look at the issue.
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 Yoram,
I am looking at your site right now and as I can see there are not any data in the table id 2.
Can you please investigate this.
I will take a look at your issue in the next 2 hours but I am not allowed to have skype calls.
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
You are right.
The data was there this morning and the only thing I did was to upgrade to the new version of the plugin which I got this morning... Looks like a separate bug to me.
Do you want to look into this before I re-enter the data?
Hi Yoram,
1.
The only way for data to not get lost is to follow these instructions from our documentation how to update the plugin manually - Link.
Just please note:
IMPORTANT: Do NOT delete the old version from WP-admin (by clicking “Delete” in the plugins page) if you don’t want to lose all your tables!
Can you please tell me did you follow the steps when updating the plugin.
2. I can see that the table is manual, so can you please re-enter the data and I will copy paste it and create some support table.
Thank you.
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,
1. No, I didn't follow the instuctions, as it was not mentioned anywhere visible... the normal practice is to simply update by re-installing the plug in or update via the WP interface (but I didn't have this option). anyway, this is less important now. I will keep this in mind for next time.
2. The good news is that now it is working nicely. Have a look at 'table3' and the page I've created. Looks like the update fixed the bug.
Can you please verify that?
Yoram
Hi Bogdan,
I was happy too soon. The bug is still here and I noted the following:
At the beginning, after re-entering the data, the parameter "Hide table until page is completely loaded" was turned off, and everything was looking ok, except that it took time for the table to be formatted on the page. So, I turned this parameter on and then the table did not show at all. So, I turned it back off and then the data presented is wrong (hidden columns present data - see first 3 columns).
HELP please.
Thanks,
Yoram
Hi Yoram
OK now i see the issue with the "HIde table until page is loaded".
For testing purposes can you please try to change the theme and see if it will work after that.
Thank you.
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,
No, this is not an option, as the website is live.
Yoram
Hi Yoram,
Ok, can you please then update the plugin to the latest version which is 2.0.
You can manually update the plugin by following this steps:
1.) Download zip from this link
2.) Use FTP to open /yourwordpressfolder/wp-content/plugins
3.) Delete existing wpdatatables folder.
4.) Upload previously downloaded wpdatatables folder through FTP to plugins folder (unzip it)
5.) Go to WP-admin panel, open Plugins section.
6.) Deactivate wpDataTables, and then activate it again.
Also clear the browser cache just in case.
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
I did it, and now it is even worse. Check out the preview of the page.
I've turned the CDN on. In case you didn't log out, just close the window/tab that you used to log on to our website. Don't do anything else there. Thanks.
Hi Yoram,
I logged out
. I will take a look again tomorrow if you can give me the access again. I will also try to reproduce this issue on my side so I can find the issue when the Hide before load option is checked.
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 Yoram,
I logged out
. I will take a look again tomorrow if you can give me the access again. I will also try to reproduce this issue on my side so I can find the issue when the Hide before load option is checked.
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 Bogdan,
Do you want to continue tomorrow (Thursday)?
Yoram
Hi Yoram,
Sure we are currently very busy because of the 2.0 release but please write me here so I can get notification and start inspecting from my office.
Thank you.
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
Hui Bogdan,
I'm available all day long today. Let me know once you are ready and I will turn off the CDN.
Yoram
Hi Yoram,
Ok I am at the office now and I tried to login with the credentials below but It was unsuccessful.
Can you please investigate it.
Thank you.
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,
I've installed this morning the new update of your plugin. It is still not working properly, but this time the problem is different.
As you can see in the example, the table appears perfectly on the browser, as planned, but for some reason the title is pushed up. I've double checked this very same page with out the table, and the title was fine. Only once I put the [wpdatatable id=4] the title was pushed up, partially hidden below the overlay of the title.
In addition, when I use the "Hide the table before it is fully loaded", the page can not be scrolled down.... (I asked to show all the records (few dozens of these).
Best regards,
Yoram
Hi Yoram,
Unfortunately I still can not login with the credentials that you provided me. ( Attachment)
Can you please investigate it.
Thank you.
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
Dear Bogdan,
I know. I changed the password so you will not attempt to login without coordinating the exact timing!! The site is in production on CDN. You can not log in whenever you want. We have to turn the CDN before you log in.
Yoram
Hi Yoram,
I am at the office now so you can turn the CDN from 10:00 to 17:00 CET.
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 Yoram,
No problem. Let us now when you came back from the holiday.
Have a nice trip.
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
Dear Bogdan,
I'm back. In the meanwhile we have completed inserting the content into the table and set the page. You can see the final product here: https://beacontech.eu/erc-review-panel-members/
However, please note that we had to manually "push" the title down by 150 pixels, as strangely enough when we put the [wpdatatable=7] tag on the page, the title was "pushed" up and this distorted the entire page. When we removed the [wpdatatable=7] tag the page was normal.
Another thing that I want to report on is that when we asked to show 'All' records the table hangs for long time and simply does not present the data. So, we set it to '100' records, which is enough for us now. The table is in MySQL and we use SQL query to retrieve the data.
Best regards,
Yoram
Hi Yoram,
I didn't see the title on that page. If this is still an issue please return it so I can take a look.
If you try to load all the data from table at once, even if you have server-side processing enabled, it could crash the table based on amount of data in it. Based on experience limitation for tables size which should work without server-side processing is around 2000-3000 rows and if you try to load whole table at once you are losing the benefits of server-side processing.
I could not log in with credentials that you gave us previously to examine this table more closely so if this table is not large please send us those credentials again so we can take a look
Dear Miljko,
This is a production site and therefore we do not enable external login to it, without coordinating this with us beforehand.
The current title of the page is now OK, after we added this padding of 150px. As I said it happens only when we had your tag to the page. When we remove the tag, there is not problem! Something in the way you render the table code badly affects the template.
The full table includes roughly 1500 records (rows). In the current table there aren't more than 100 per 'filter'. The thing is that when we ask for 'All' it hangs, and when we ask for 'up to 100' it displays the data. In both cases the data is more in the area of 50 records (per filter). I have been working with SQL databases for 20 years by now. I know what are the implications of retrieving too much data. This is not the case here. Something is wrong with the 'All' the records.
Kind regards,
Yoram
Hi Yoram,
Could you try to duplicate the table and load all the data without conditional formatting just to be sure that this option is not the one that are causing problems?
The site is in production on CDN and we try to avoid such changes or additions.
I am willing to dump the SQL data and structure and send it to you to try and test it yourself, if you wish.
Hi Yoram,
Please send me SQL dump and I will try to investigate this in my local environment
Hi, did you manage to reproduce the problem with this table?
Hi Yoram,
You actually have 3773 rows in that table and asking from table to show all off them will most probably hit the memory limit. I actually managed to show whole table in my local environment but it was really unresponsive and slow
I never show all of them.
When I ask to show "All" it is always for a specific "category" and "panel" and in these there are usually no more than 100 records. Try this.
Hi Yoram,
I am not sure that I understood so to prevent future misunderstanding please tell me exact steps that you take when this problem occurs.
Hi Yoram,
I am not sure that I understood so to prevent future misunderstanding please tell me exact steps that you take when this problem occurs.
This is the query that I use to show the table:
SELECT wp_panelist.category,
wp_panelist.panel,
wp_panelist.name,
wp_panelist.y2016,
wp_panelist.y2015,
wp_panelist.y2014,
wp_panelist.y2013,
wp_panelist.y2012,
wp_panelist.y2011,
wp_panelist.y2010,
wp_panelist.y2009,
wp_panelist.y2008
FROM wp_panelist
ORDER BY wp_panelist.category,
wp_panelist.panel,
wp_panelist.y2016 desc,
wp_panelist.y2015 desc,
wp_panelist.y2014 desc,
wp_panelist.y2013 desc,
wp_panelist.y2012 desc,
wp_panelist.y2011 desc,
wp_panelist.y2010 desc,
wp_panelist.y2009 desc,
wp_panelist.y2008 desc,
wp_panelist.name
Now, when I use the table here: https://beacontech.eu/erc-review-panel-members/
I almost always limit it with these (see this example)
Category (StG/CoG/AdG): AdG
Panel: PE1
which I believe add the following to the query:
WHERE category="AdG" and panel="PE1".
In such queries only around 50 records are selected, and still the show "All" records hangs.
Hi Yoram,
Unfortunately i still didn't understood this part. As i can see you remove "Rows per page" block so I don't understand how you select all records. Also i removed both filters from that page and table works stable and reasonably fast for that amount of data
I did the selection of rows per page in the backend. There is such a parameter there. I don't want the user to play with that.
Hi Yoram,
Ok I understand that part but still have trouble to understand
Could you please tell me exact steps which I could repeat to reproduce this problem, or even better record me a screencast in which you will show me?
here are the screenshots of the settings that I have. note the limit to 100 (circled with red).
and two more screenshots
Hi Yoram,
I must repeat my question because it is crucial that you answer it
Could you please tell me exact steps which I could repeat to reproduce this problem, or even better record me a screencast in which you will show me?
OK. I have recorded the steps in the backend, demonstrating it on the preview. Note that it behaves the same on the front end.
You can watch the video here:
Hi Yoram,
I tried to recreate the problem with your database and same filter setup and table is working as expected.
It is hard for me to procced if I cannot see the problem. Is it still a problem for you to gave us access to your website so we can see this?
Dear Miljko,
I can confirm that the problem still persist on our live website. In order for you to login, this must be coordinated with me to ensure safe login.
Please note that I was using the same database and same table on another website I am currently developing on my desktop, using a different template and there is not such problem there.
Yoram
Hi Yoram,
I know that you have problem on your live website but please try to switch templates for just a minute to test if this is a template related issue or install same template that you are using on your production website in your local environment and see does the problem occurs there.