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 

[email protected]

2033628753

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

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