We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3934000
Table will not display
Open

Comments

  • Laurence Potter started the conversation

    This is a weird one.  For some of my users (and I have seen it as well) the table does not display.  For some, never a problem, for others it occurs a lot.

    I have researched to see if the issue is platform or browser related but have not seen a specific pattern. Attached is a screenshot of what my users are seeing.

    This is driving me nuts, and I am getting a lot of complaints.

    I am on the latest version of WordPress, use the current Divi 4 theme, use Cloudflare for caching. 

    WordPress Environment
    Home URL:https://khmtt.com
    Site URL:https://khmtt.com
    WP Content Path:/var/www/khmtt/wp-content
    WP Path:/var/www/khmtt/
    WP Version:6.7.2
    WP Multisite:No
    PHP Memory Limit:2 GB 
    WP Debug Mode:Inactive
    Language:en_US
    Server Environment
    Operating System: Linux
    Server Info:LiteSpeed
    PHP Version: 8.1.32 
    PHP Post Max Size: 256 MB
    PHP Time Limit: 300
    MySQL Version: 10.6.21 
    Max Upload Size:256 MB 
    Multibyte String:>span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="Multibyte String (mbstring) is used to convert character encoding.">
    XML extension: >span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="XML support is something that needs to be installed on the server for proper wpDataTables functionality.">
    DOM extension: >span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="DOM support is something that needs to be installed on the server for proper wpDataTables functionality.">
    Libxml extension: >span class="wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="Multibyte String (mbstring) require libxml to be installed. ">
    PDO extension:  - PDO Drivers: mysql>span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="PDO is used to connect to separate database connection like MS SQL and PostgreSQL.">
    Zip extension: >span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="ZIP support is something that needs to be installed on the server, as a package for the Linux operating system, or rather to the PHP software on the server.">
    Curl extension: >span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="wpDataTables use cURL for getting data from other servers.">
    Theme
    Name:Divi Child
    Version:2.1.4 
    Author:Elegant Themes
    Author URL:http://www.elegantthemes.com
    Active Plugins (29)
    Admin Menu Editorby Janis Elsts – 1.12.4 
    Divi Accordions Plusby Ivan Chiurcci(Chi) – 1.7.0 
    Contact Form 7by Takayuki Miyoshi – 6.0 
    Divi Dashby Elegant Themes – 1.0.3 
    Divi Layouts Extendedby Elicus – 2.10.0 
    Divi Modules Proby Divi Life – 1.2.8 
    Divi Pixelby Octolab OÜ – 2.33.0 
    DiviPasswordsby DonDivi – 1.1.10 
    DiviSignaturesby DonDivi – 1.6.0 
    DonDivi Builderby DonDivi – 1.4.1 
    Duo Two-Factor Authenticationby Duo Security – 2.5.7 
    Duplicate Menuby Jonathan Christopher – 0.2.2 
    Document Viewer for Officeby bPlugins – 2.2.9 
    EmbedPressby WPDeveloper – 4.1.3 
    Floating DiviMenusby DonDivi – 1.2.1 
    Gmedia Galleryby Rattus – 1.23.0 
    HD Quiz - Save Results Lightby Harmonic Design – 0.7.0 
    HD Quizby Harmonic Design – 1.8.15 
    Header and Footer Scriptsby Anand Kumar – 2.2.2 
    WPCode Liteby WPCode – 2.2.3.1 
    Max Mega Menuby megamenu.com – 3.4.1 
    Pages with category and tagby YAHMAN – 0.9.0 
    Photonic Gallery & Lightbox for Flickr, SmugMug, Google Photos & Othersby Sayontan Sinha – 3.12 
    Wicked Foldersby Wicked Plugins – 3.0.8 
    Super Page Cacheby Themeisle – 5.0.9 
    WP Crontrolby John Blackbourn – 1.17.0 
    WP Mail SMTPby WP Mail SMTP – 4.2.0 
    wpDataTablesby TMS-Plugins – 7.1.1 
    XYZ WP Insert Code Snippetby xyzscripts.com – 1.4.1 


    Attached files:  wpdatatables_error.png

  •  1,894
    Miloš replied

    Hello,
    We can see the table loading now - but, this is an SQL based table, so if you use server-side processing enabled in the table settings, and if you have any kind of active caching on this Page, in some instances, it can happen to get an "invalid JSON"/or AJAX error.


    Here are more details and how you can fix it :

     

    We currently have this issue which only happens for server-side processing tables when you have caching active on the page.

    Our developers are intensively working to resolve this issue, as soon as possible. I can't say an ETA on it, unfortunately.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

     

    For the time being, the only two possible solutions will be:

    1.  To disable caching only for pages where you have the tables, or perhaps disable caching entirely, if possible.

    Most caching Plugins have the option to add URL's that will be excluded, so if possible, see if you can add the Pages with tables there, and that should solve it for now.

     

    2. Or you can try disabling the server-side processing option in your Table.

    For the Manual Tables, it is not possible to disable server-side processing,

    but you can make a new SQL Query based table from the same data which is stored in a Manual Table.

    This is how that is done.

    First, check what is the MySQL Table name inside the Editing settings,

    7328050334.png

    then make an SQL Query like : 

     SELECT * FROM TableName  

    For any SQL Query based Table which has less than 2 thousand rows, you can disable the server-side option on SQL tables, and it will work like it does for tables linked from files. ( loads all rows on the browser regardless of table's pagination)

    5424981174.png

     

    If you need to increase the row count while still having the "toggle" to disable server-side,

    Please go to ../wp-content/plugins/wpdatatables/source/class.wpdatatable.php and around line 3188 you'll see this:

    if (is_array($res_dataRows) && count($res_dataRows) > 2000) {
    4647462986.png

    The lines of code can change during Updates because our Developers add new lines from time to time, so it is best to search for the line in any Code Editor with CTRL+F to get the right line.

    You can change the number 2000 to a value bigger than the number of rows in your table in order to still have that 'toggle option' for server-side processing.

    Another PHP file in this path :

    ../wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php

    In this file, please search for this, there should be two occurrences, first one around line 82 as :

    if (count($wpDataTable->getDataRows()) > 2000) {
    6921758130.png

    And second one around line 143:

    if (count($wpDataTable->getDataRows()) > 2000) {
    
    9764402593.png

    That will increase the server-side processing option automatic limit.

    We just advise caution not to increase that number 'too high' to avoid going over the limit what your Hosting Server's PHP Limitations can handle.

    Usually, up to around 5 to 6 thousand rows should pose no significant performance issues, but if you go higher than that data size without server-side processing, you could experience slow loading times.

    You can certainly test to see how a Table behaves on front-end, and if it loads too slow/or freezes the browser's Page, you can go back in the Table's Back-End and enable server-side processing for that Table.

     

    Let us know how it goes and if you have any questions.

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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