Okay
  Public Ticket #3092641
Tables Spinning on Save / Tables Not as Expected on Front End
Closed

Comments

  • Becca started the conversation

    Starting with the last wpDataTables plugin update on 7/25 (for my site), when I edit a wpDataTables entry in the back end and save:

    • in the backend, it spins and spins and spins and no matter how long I wait (up to an hour; I left one and came back after lunch, it was still spinning) and I have to click over to the listing again to re-enter the wpDataTables edit screen, it has then not saved my changes
    • in the frontend, the table's shortcode then displays all columns from the SQL query, regardless of settings to show/hide columns, etc. and without any other configuration such as width, class, format
      • example: go to URL provided, scroll down to select any Example Choice, then scroll / click down to the Pricing Strategies section and you'll see how one of the affected tables now displays (same table for all in pricing strategies section, just using different placeholder variables)

    This behavior is continuing yesterday and today. I'm now kinda scared to do any more editing or adding of tables, and I really need to be as I have a long way to go (happily, I also have a long time to get there, so, yeah, anyhoot) to get the content fleshed out.

    I've been looking for correlations and so far not really finding any. This behavior has been true for:

    • editable and non-editable tables,
    • tables utilizing the Master-Detail add-on on those that aren't, 
      • --> added note: there was a notice yesterday that the Master-Detail add on was in need of an update, but then it couldn't because it "couldn't find the plugin"; it did successfully update today
    • tables reading from a view as well as ones reading from a table
    • tables with additional configuration (such as width, class, format) and those without
    • tables which use placeholders in the query and those that do not
    • tables having HTML in the column's content (NOT table html, those have all been converted :0) ) and those which are straight text/numbers only such as the example

    Other tables which reference an affected table for a foreign key relationship do not seem affected in any way. I can still front-end edit related table's entries, no problem. I cannot front-end add/edit entries for the affected tables.

    I use a MySQL data connection for all tables.

    I haven't added any new plugins, though several existing ones did update on/after the 25th as well. I disabled those and tried wpDataTables again. No change so I re-enabled them. 

    ~~~~~~~~

    System Info from wpDataTables plugin area:

    WordPress EnvironmentHome URL:https://pigasus.studioSite URL:https://pigasus.studio
    WP Version:6.0.1WP Multisite:NoPHP Memory Limit:1 GBWP Debug Mode:InactiveLanguage:en_USServer EnvironmentOperating System:LinuxServer Info:ApachePHP Version:7.4.30PHP Post Max Size:128 MBPHP Time Limit: 30 - We recommend setting max execution time to at least 180.
    See: Increasing max execution to PHPMySQL Version:8.0.29Max Upload Size:128 MBMultibyte 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, odbc, pgsql, sqlite>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.">ThemeName:Elation ChildVersion:1.0.0Author:Pigasus.StudioAuthor URL:http://Pigasus.StudioActive Plugins (42)InfiniteWP - Clientby Revmakx – 1.9.8Photo Gallery by Supsystic PROby supsystic gallery plugin – 2.9.6Admin Menu Groupsby Chaim Chaikin – 0.1.2WP Offload Mediaby Delicious Brains – 2.6.2Classic Editorby WordPress Contributors – 1.6.2Admin Columnsby AdminColumns.com – 4.4.5Simple Custom CSS and JSby SilkyPress.com – 3.40Data Tables Generator by Supsysticby supsystic.com – 1.10.20Disable Commentsby WPDeveloper – 2.4.0KB - Advanced Searchby Echo Plugins – 2.28.0KB - Elegant Layoutsby Echo Plugins – 2.12.0Knowledge Base for Documents and FAQsby Echo Plugins – 9.11.0KB - Links Editorby Echo Plugins – 1.4.0KB - Multiple Knowledge Basesby Echo Plugins – 2.5.0Elementorby Elementor.com – 3.6.8301 Redirectsby WebFactory Ltd – 2.72Essential Addons for Elementorby WPDeveloper – 5.1.8Featured Image Admin Thumbby Sean Hayes – 1.6WP Fast Total Searchby Epsiloncool – 1.51.178Photo Gallery by Supsysticby supsystic.com – 1.15.9The GDPR Frameworkby Data443 – 2.0.2Google Analytics for WordPress by MonsterInsightsby MonsterInsights – 8.7.0If Menu - Visibility control for menusby Layered – 0.16.3Modern Footnotesby Prism Tech Studios – 1.4.11PDF Embedderby WP PDF Embedder Team – 4.6.4Plugins Garbage Collector (Database Cleanup) Old!by Vladimir Garagulya – 0.14Post Type Switcherby Triple J Software, Inc. – 3.2.1Restore Classic Widgetsby Bill Minozzi – 1.7Shortcoderby Aakash Chakravarthy – 5.8Shortcodes Ultimateby Vladimir Anokhin – 5.12.0Tabby Responsive Tabsby cubecolour – 1.4.1Data Tables Generator PRO by Supsysticby supsystic.com – 1.7.11WordPress Version Infoby alpipego – 1.2.1Master-Detail Tables for wpDataTablesby TMS-Plugins – 1.3.3Open Graph and Twitter Card Tagsby PT Woo Plugins (by Webdados) – 3.2.0Wordfence Securityby Wordfence – 7.5.11WP Crontrolby John Blackbourn & crontributors – 1.14.0WP Lightbox 2by Syed Balkhi – 3.0.6.5WP Mail SMTPby WPForms – 3.5.1WP-Optimize - Clean, Compress, Cacheby David Anderson, Ruhani Rabin, Team Updraft – 3.2.6wpDataTablesby TMS-Plugins – 4.5XML Sitemap & Google Newsby RavanH – 5.3.3


  • Becca replied

    I did think to look at the javascript console today. Theses errors are showing when I load a page with both back-end and front-end display of a table that's exhibiting this behavior.

    jquery.min.js?ver=3.6.0:2 jQuery.Deferred exception: Cannot read properties of null (reading 'length') TypeError: Cannot read properties of null (reading 'length')
        at f (https://pigasus.studio/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.frontend.min.js?ver=4.5:8:6602)
        at X (https://pigasus.studio/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.frontend.min.js?ver=4.5:8:6689)
        at wa (https://pigasus.studio/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.frontend.min.js?ver=4.5:8:8920)
        at e (https://pigasus.studio/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.frontend.min.js?ver=4.5:8:19449)
        at HTMLTableElement. (https://pigasus.studio/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.frontend.min.js?ver=4.5:8:20460)
        at Function.each (https://pigasus.studio/wp-includes/js/jquery/jquery.min.js?ver=3.6.0:2:3003)
        at s.fn.init.each (https://pigasus.studio/wp-includes/js/jquery/jquery.min.js?ver=3.6.0:2:1481)
        at s.fn.init.n [as dataTable] (https://pigasus.studio/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.frontend.min.js?ver=4.5:8:15454)
        at wdtRenderDataTable (https://pigasus.studio/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.frontend.min.js?ver=4.5:429:69)
        at HTMLTableElement. (https://pigasus.studio/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.frontend.min.js?ver=4.5:487:184) undefined



    load-scripts.php?c=0&load%5Bchunk_0%5D=jquery-core,jquery-migrate,utils,moxiejs,plupload&ver=38c0d6937b0b5af330c6667b89947bf2:2 Uncaught TypeError: Cannot read properties of null (reading 'length')
        at f (jquery.dataTables.min.js?ver=4.5:65:1012)
        at X (jquery.dataTables.min.js?ver=4.5:66:84)
        at wa (jquery.dataTables.min.js?ver=4.5:70:288)
        at e (jquery.dataTables.min.js?ver=4.5:91:129)
        at HTMLTableElement.<anonymous> (jquery.dataTables.min.js?ver=4.5:93:136)
        at Function.each (load-scripts.php?c=0&load%5Bchunk_0%5D=jquery-core,jquery-migrate,utils,moxiejs,plupload&ver=38c0d6937b0b5af330c6667b89947bf2:2:3003)
        at s.fn.init.each (load-scripts.php?c=0&load%5Bchunk_0%5D=jquery-core,jquery-migrate,utils,moxiejs,plupload&ver=38c0d6937b0b5af330c6667b89947bf2:2:1481)
        at s.fn.init.n [as dataTable] (jquery.dataTables.min.js?ver=4.5:83:211)
        at wdtRenderDataTable (wpdatatables.js?ver=4.5:716:83)
        at HTMLTableElement.<anonymous> (wpdatatables.js?ver=4.5:1770:13)


  •  1,568
    Uroš replied

    Hello Becca,

    Thank you for reaching out to us.

    Please provide me a temporary WP-admin (administrator) user 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 parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.

    Kind Regards, 

    Uros Jovanovic
    [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

  •   Becca replied privately
  •  1,568
    Uroš replied

    Hello Becca,

    Thank you for the credentials.

    Which URL do I use for back-end log-in as the https://pigasus.studio/kb/wp-admin/ does not work?

    Looking forward to your reply.

    Kind Regards, 

    Uros Jovanovic
    [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

  •   Becca replied privately
  •   Miloš replied privately
  • Becca replied

    Thank you! I'll try the rollback and see if that makes it work again.

    I'm also going through a hosting migration, so it might be a few days before I get back to this, but I'll definitely let you know something once I do. :0)

  •  1,848
    Miloš replied

    Hi, Becca smile.png

    No problem at all.

    I am stil waiting for my end,  the 2nd level Team still didn't get a chance to review all the details for me;

    but if they make a breakthrough, i will let you know.

    Of course, let me know once you try from your end - and somehow we will get to a solution, i believesmile.png

    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

  •   Becca replied privately
  •  1,848
    Miloš replied

    Hi, Becca

    Thank you for the update, with new details.

    In the meantime, i got advised from my end by senior colleagues.

    They found an error "Uncaught TypeError: a is null" in https://pigasus.studio/wp-content/plugins/wpdatatables/assets/js/jquery-datatables/jquery.dataTables.min.js?ver=4.4

    -

    Could you please try to update to 4.5  of the plugin, and clear all cache?

    Please let me know if that helped - if not, we will urgently escalate this with our developers, they will assist us to further troubleshoot.

    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

  •  1
    Danie Coetzee replied

    This was actually my next question as well ... I am getting this error msg ... v4.5 ....

    wdt.frontend.min.js?ver=4.5:8 Uncaught TypeError: Cannot read properties of null (reading 'length')
        at f (wdt.frontend.min.js?ver=4.5:8:6602)
        at X (wdt.frontend.min.js?ver=4.5:8:6689)
        at wa (wdt.frontend.min.js?ver=4.5:8:8920)
        at e (wdt.frontend.min.js?ver=4.5:8:19449)
        at HTMLTableElement.<anonymous> (wdt.frontend.min.js?ver=4.5:8:20460)
        at Function.each (jquery.js:384:23)
        at m.fn.init.each (jquery.js:136:17)
        at m.fn.init.n [as dataTable] (wdt.frontend.min.js?ver=4.5:8:15454)
        at wdtRenderDataTable (wdt.frontend.min.js?ver=4.5:429:69)
        at HTMLTableElement.<anonymous> (wdt.frontend.min.js?ver=4.5:487:184)




  • Becca replied

    Hi Miloš,

    The test.pigasus.studio site is using wpDataTables Version 4.5, and Master-Detail Version 1.3.3. 

    I've cleared my browser (Chrome v 104) cache and cleared the wordPress object cache on the test.pigasus.studio site. 

    Am still seeing the same behavior and the same console errors.

    And I thought today to check the console *while* the back-end save wpDataTable ID = 2 attempt was spinning spinning spinning, and it does show an additional error as attached (and test site info page is updated with this as well).

    Thanks!

    Becca

  •  1
    Danie Coetzee replied

    Becca

    I also had the never-ending spinning wheel problem ... I cant remember how but I established there was a conflict between wpdatatables plugin and Form Maker (10web) plugin ... when I deactivated Form maker the spinning wheel problem disappeared ... 

  • Becca replied

    Thanks Danie, glad that worked for you and thanks for adding it in case it helps any others who run into this as well. :0)

    Unfortunately, not so easy for me. In my test site, I have two active plugins: wpDataTables and their Master-Detail add-on. 

  •  1,848
    Miloš replied

    Hi, Becca 

    Apologies for the waiting time once again.

    -

    This is turning out to be a tricky issue to determine.

    We have escalated this to our developer Team, they will investigate everything for us, and will do their best to isolate the issue as quickly as possible.

     Of course, i will keep you posted on their progress.

    -

    Danie, thank you for the input regarding the conflict that happened for you - that is always useful to know, for users who might experience anything similar - it is always good when troubleshooting to start by changing a theme,  and disabling all plugins > but ours;

    then to re-enable plugins 1 by 1 , until we find a conflict ( if there is one).

    But unfortunately, in working with WordPress and various plugins, sometimes it is more tricky than that, depending on the issue.smile.png

    This issue you reported now with the error : wdt.frontend.min.js?ver=4.5:8 Uncaught TypeError: Cannot read properties of null (reading 'length') ;

    i can't say what it is right away;  we have to do some troubleshooting first, before guessing.


    Could you please open a separate ticket from your account ?

    Also, if you can please elaborate a bit more, is there an action that causes the error, or it is during table load on a page?

    Does it happen only on front-end,  or also at the back-end?

    And please send us the front-end page where this issue happens >

    also if you can send us access to your Wp-Admin , just make sure to send the Admin credentials as a "private reply", on the ticket, and i will do my best to take a look as quick as i can.

    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

  •  1,848
    Miloš replied

    Hi, Becca

    Sorry for all the waiting time.  I got an update from our developers.

    There was an error in the browser console - the cause of the "spinny version" of the table, is because you have disabled sorting in all of the columns.

    When our plugin processes all the data per selected settings;   there is a null argument being passed in DataTables;

    and then DataTables returns an error.

    At the moment, one of our developers has set one column ( which is not visible on the front-end), to serve as a sorting column, and now they can not see an error in the console anymore,   everything looks good.

    If that column is not suitable to be the sorting one,   you could make a new column ( you can even hide if from front-end if needed),  the purpose will be just for dataTables to pass an argument for sorting, otherwise, it would break.

    Please check how it looks now, and apply this to your site - let us know if everything makes sense, and if you have any questions.smile.png

    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

  • Becca replied

    Excellent. I added a sort column on the tables in the production version as well and no more spinny-ness. Yay! I do have another issue, one which I was trying to document when I ran into this one, so I'll open that in a new ticket. This one can be closed. Thanks much!

  •  1,848
    Miloš replied


    Hi, Becca smile.png

    Apology for the delayed response.

    I saw your answer yesterday > but i am also covering the other , new ticket with the Master Detail issue, so i wanted to do further testing on it too,   before answering, and all of a sudden > "time flew" while i as doing all of that.  ( will respond to it now)

    In any case, regarding this ticket, i am absolutely delighted to hear that this has been resolved.

     Thank you for letting us know. We will close this one.

    Of course, as you know, don't hesitate to reach out to us whenever in need of assistance.

    Have a great day!smile.png

    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

  • Griet De Groote replied

    i have the same problem : please help me

  •  1,848
    Miloš replied

    Hi, Griet De Groote.

    Apology for the waiting time on the reply, you made the ticket during the weekend so it took us some time to go through other tickets.

    We only work on weekdays.

    We responded to your ticket, please check it and looking forward to your reply.

    As you see, here for Becca the issue was due to disabled sorting in all tables, but on your end it might be something completely different.

    We will proceed to advise you as quickly as possible.

    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