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 finein 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 iti 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
Attached files: Capture-redbox.JPG
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: YesOutput HTML5: NoNo-Conflict Mode: NoCurrency: USDBackground updates: YesLocale: 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.comSite URL: https://countystaging.wpengine.comWordPress Version: 5.3.2 ✔WordPress Multisite: NoWordPress Memory Limit: 40MWordPress Debug Mode: NoWordPress Debug Log: NoWordPress Script Debug Mode: NoWordPress Cron: YesWordPress Alternate Cron: NoBackground 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 - 188.8.131.52 ✔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 - 184.108.40.206 ✔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 - 220.127.116.11 ✔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: ApachePort: 80Document Root: /nas/wp/www/sites/countystaging
### PHP ###
Version: 7.3.13-1+ubuntu18.04.1+deb.sury.org+1 ✔Memory Limit: 512MMaximum Execution Time: 3600Maximum File Upload Size: 50MMaximum File Uploads: 20Maximum Post Size: 100MMaximum Input Variables: 1000cURL Enabled: Yes (version 7.58.0)OpenSSL: OpenSSL 1.1.1d 10 Sep 2019 (269488207)Mcrypt Enabled: NoMbstring Enabled: YesLoaded 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: latin1Database Collation: latin1_swedish_ci
### Date and Time ###
WordPress (Local) Timezone: America/New_YorkMySQL (UTC): 2020-01-13 23:31:55MySQL (Local): January 13, 2020 at 6:31 pmPHP (UTC): 2020-01-13 23:31:55PHP (Local): January 13, 2020 at 6:31 pm
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 firstname.lastname@example.org
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
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
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.