Okay
  Public Ticket #2269807
WPDataTables seems to fail when entries reach 3300
Closed

Comments

  • hotcoffeelawsuit started the conversation

    I have a wpdatatable linked to a gravity form that began displaying odd behavior - filtering not working, and any attempt to re-save the table would generate a red box "error! table in data source has no rows"

    other wpdatatables linked to other GF forms seemed fine

    in troubleshooting, i began trashing the most recent entries until the table started working again.  then i added back entries until failure, which seems to occur at entry 3300.  it doesnt seem to be a specific entry that breaks it - any entry that lifts the total to 3300 does it

    i did try updating GF, wpdatatables, and wpdatatables/GF integration to the latst version 

    it is pretty critical that i resolve this because my clients are expecting some reports asap based on these submissions

    thanks - erik shanabrough 

    erik@magtype.com

    2033628753

    Attached files:  Capture-redbox.JPG

  • hotcoffeelawsuit replied

    here is the copied gravity forms status report

    ### Gravity Forms ###

    Registration: Site registered ( 476ab61b-fa07-4a18-af41-c8b396e88132 )  ✔
    Version: 2.4.16 ✔
    Upload folder: /nas/content/live/countystaging/wp-content/uploads/gravity_forms/
    Upload folder permissions: Writable  ✔
    Output CSS: Yes
    Output HTML5: No
    No-Conflict Mode: No
    Currency: USD
    Background updates: Yes
    Locale: en_US

    ### Add-Ons ###

    GP Populate Anything: by Gravity Wiz - 1.0-beta-3.28  ✔
    Chained Selects: by rocketgenius - 1.3  ✔
    Dynamic Population Pro: by gravity+ - 2.2.0  ✔
    PayPal Payments Pro: by rocketgenius - 2.4  ✔
    GravityView - Entry Revisions: by GravityView - 1.0.2  ✔
    GravityView Inline Edit: by GravityView - 1.3.1  ✔
    Math by GravityView: by GravityView - 1.2  ✔

    ### Database ###

    Database Version: 2.4.16  ✔ Your database is up-to-date.
    wp_gf_form_view:   ✔
    wp_gf_form_meta:   ✔
    wp_gf_form:   ✔
    wp_gf_form_revisions:   ✔
    wp_gf_entry:   ✔
    wp_gf_entry_meta:   ✔
    wp_gf_entry_notes:   ✔
    wp_gf_draft_submissions:   ✔
    wp_gf_addon_feed:   ✔
    wp_gf_addon_payment_transaction:   ✔
    wp_gf_addon_payment_callback:   ✔

    ### WordPress ###

    Home URL: http://countystaging.wpengine.com
    Site URL: https://countystaging.wpengine.com
    WordPress Version: 5.3.2 ✔
    WordPress Multisite: No
    WordPress Memory Limit: 40M
    WordPress Debug Mode: No
    WordPress Debug Log: No
    WordPress Script Debug Mode: No
    WordPress Cron: Yes
    WordPress Alternate Cron: No
    Background tasks: Yes  ✔

    ### Active Theme ###

    The County Assemblies Child: by Magtype  - 1.0.0  ✔
    The County Assemblies (Parent): by Magtype (http://www.magtype.com) - 2.0.3  ✔

    ### Active Plugins ###

    Activity Log: by Activity Log Team - 2.5.2  ✔
    Advanced Custom Fields: by Elliot Condon - 5.8.2  ✔
    Category Tag Pages: by Marzio Carro - 1.0  ✔
    Classic Editor: by WordPress Contributors - 1.5  ✔
    Cusmin: by Cusmin - 1.17.2  ✔
    Custom Sidebars: by WPMU DEV - 3.2.3  ✔
    Disable Comments: by Samir Shah - 1.10.2  ✔
    Duplicate Post: by Enrico Battocchi - 3.2.3  ✔
    GFChart: by Mensard, with gravity+ - 1.13.0  ✔
    GFChart Charting vs Time Add-On: by gravity+ - 0.5  ✔
    GFChart GravityView Add-On: by gravity+ - 0.5.beta1  ✔
    GP Better User Activation: by Gravity Wiz - 1.1.9  ✔
    GP Read Only: by David Smith - 1.3.8  ✔
    GP Terms of Service: by Gravity Wiz - 1.3.13  ✔
    GP Unique ID: by David Smith - 1.3.14  ✔
    Gravity Forms - Advanced Conditional Logic: by Caleb McDonnell - 1.3.7  ✔
    Gravity Forms All Fields Template: by Gravity Wiz - 0.9.3  ✔
    Gravity Forms integration for wpDataTables: by TMS-Plugins - 1.2.1  ✔
    Gravity Forms User Registration Enhanced: by gravity+ - 1.1.0  ✔
    Gravity Perks: by Gravity Wiz - 2.1.8  ✔
    GravityView: by GravityView - 2.4  ✔
    GravityView - Advanced Filter Extension: by GravityView - 1.3  ✔
    GravityView - DataTables Extension: by GravityView - 2.3.4  ✔
    GravityView - Multiple Forms: by GravityView - 0.1-beta.2  ✔
    Justified Image Grid: by Firsh - 3.1.1  ✔
    Login Widget With Shortcode: by aviplugins.com - 6.0.5  ✔
    Max Mega Menu: by megamenu.com - 2.7.1.4  ✔
    Max Mega Menu - Pro Addon: by Tom Hemsley - 1.6.6  ✔
    Modula: by MachoThemes - 2.1.5  ✔
    Modula PRO: by Macho Themes - 2.0.6  ✔
    Page Builder by SiteOrigin: by SiteOrigin - 2.10.11  ✔
    Page scroll to id: by malihu - 1.6.6  ✔
    Peter's Login Redirect: by Peter Keung - 2.9.3  ✔
    Post Expirator: by Aaron Axelsen - 2.4.0.1  ✔
    Restrict User Access: by Joachim Jensen - 1.1.2  ✔
    SiteOrigin CSS: by SiteOrigin - 1.2.4  ✔
    SiteOrigin Premium: by SiteOrigin - 1.9.0  ✔
    SiteOrigin Widgets Bundle: by SiteOrigin - 1.15.8  ✔
    TablePress: by Tobias Bäthge - 1.9.2  ✔
    Title Remover: by WPGurus - 1.2.1  ✔
    Ultimate Header Builder: by BestBug - 1.2.2  ✔
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com, DavidAnderson - 2.16.21.0  ✔
    User Role Editor: by Vladimir Garagulya - 4.51.2  ✔
    User Switching: by John Blackbourn & contributors - 1.5.3  ✔
    Woody ad snippets (PHP snippets | Insert PHP): by Will Bontrager Software, LLC , Webcraftic  - 2.2.5  ✔
    Woody ad snippets premium: by Webcraftic  - 1.0.1  ✔
    wpDataTables: by TMS-Plugins - 2.8.1  ✔
    WP Logo Showcase: by RadiusTheme - 2.5.4  ✔
    WP Mail Logging: by MailPoet - 1.9.5  ✔
    WP Mail SMTP Pro: by WPForms - 1.7.0  ✔
    WP Test Email: by Boopathi Rajan - 1.1.3  ✔

    ### Web Server ###

    Software: Apache
    Port: 80
    Document Root: /nas/wp/www/sites/countystaging

    ### PHP ###

    Version: 7.3.13-1+ubuntu18.04.1+deb.sury.org+1 ✔
    Memory Limit: 512M
    Maximum Execution Time: 3600
    Maximum File Upload Size: 50M
    Maximum File Uploads: 20
    Maximum Post Size: 100M
    Maximum Input Variables: 1000
    cURL Enabled: Yes (version 7.58.0)
    OpenSSL: OpenSSL 1.1.1d  10 Sep 2019 (269488207)
    Mcrypt Enabled: No
    Mbstring Enabled: Yes
    Loaded Extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, sodium, session, standard, apache2handler, mysqlnd, newrelic, PDO, xml, bcmath, bz2, calendar, ctype, curl, dba, dom, mbstring, fileinfo, ftp, gd, gettext, gmp, gnupg, iconv, igbinary, imagick, imap, intl, json, ldap, exif, msgpack, mysqli, pdo_mysql, Phar, posix, readline, redis, shmop, SimpleXML, soap, sockets, ssh2, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xmlreader, xmlrpc, xmlwriter, xsl, zip, memcached, Zend OPcache

    ### MySQL ###

    Version: 5.7.27 ✔
    Database Character Set: latin1
    Database Collation: latin1_swedish_ci

    ### Date and Time ###

    WordPress (Local) Timezone: America/New_York
    MySQL (UTC): 2020-01-13 23:31:55
    MySQL (Local): January 13, 2020 at 6:31 pm
    PHP (UTC): 2020-01-13 23:31:55
    PHP (Local): January 13, 2020 at 6:31 pm

  •  508
    Aleksandar replied

    Hello Erik.

    Sorry for the inconvenience.

    We haven't experienced issues like this. Can you, please install the Duplicator plugin, duplicate your website, and send the two files it generates to me?

    We will then create a copy of your website locally, and see what happens. Also, please make sure to provide me with log-in credentials.

    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.

    When you create the files, you can send them to aleksandar.vukovic@tms-outsource.com

    Kind Regards, 

    Aleksandar Vuković
    aleksandar.vukovic@tms-outsource.com

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitterAmelia demo sites | Docs

    You can try wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables

  • hotcoffeelawsuit replied

    hi Aleksandar - thanks so much for your reply

    i think we sorted it out a few hours ago.  i noticed a KILLED QUERY limit in the web host's raw log files (wp-engine).  the query generated on this particular GF entry table was too long and bumping against a character cap set by the host.

    thats why when we reached a certain number of entries, it crapped out - because it caused wpdatatables to exceed the query cap

    we've had the host temporarily remove the cap and we're monitoring the activity today - but so far, so good

    so we can go ahead and close this ticket

    thanks again..!  erik

  •  508
    Aleksandar replied

    Hello again Erik

    That's great news, thanks for letting me know.

    Keep an eye on it, and let me know if the issue occurs again. We're using Gravity's API to generate functionalities like server-side, sorting, filtering, and so on. They generate queries that can be very big, so with this cap removed, it should work fine. It looks like they overlooked back-end when they created the plugin.

    Kind Regards, 

    Aleksandar Vuković
    aleksandar.vukovic@tms-outsource.com

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitterAmelia demo sites | Docs

    You can try wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables