Conent Smaart Search Causes Error to be Thrown

[webdevtim]

Error
Article save failed with the following error: SQLSTATE[HY000]: General error: 1114 The table 'lny6d_finder_tokens' is full

This occurs when I save a very long article. When I delete half the content and save again, I don't get the error. When I add the deleted content back, the error returns.

When I disable "Smart Search - Content" I no longer get the error when saving the entire article.

This is what virtual DBA had to say about the error:

It is possible to impose user-defined maximums by explicitly defining the variable innodb_data_file_path. For example setting it to a value of ibdata1:10M:autoextend:max:256M will limit the data in InnoDB tables to a total of 256MB. Removing the max:256MB term will eliminate the imposed maximum.

MySQL reports a “Table is full” error where, in most cases, the issue involves running out of disk space. By default, limits are not imposed on MySQL tables however there are relatively large maximums inherent to the database and those maximums have not been the issue in our experience. If you are seeing this error, first check the disk space on the partition to ensure that this is not the cause of the error. If disk space is not a concern, check the variable innodb_data_file_path to see if a maximum table size has been set explicitly.

Joomla Installation Dump:

SQL Error 1114

N?A

[03-Feb-2020 23:29:13 CST6CDT] PHP Deprecated: Function create_function() is deprecated in /home/customer/www/boston911truth-dev.org/public_html/media/widgetkit/widgets/lightbox/lightbox.php on line 49

Disable Content Smart Search

Joomla! Instance :: Joomla! 3.9.15-Stable (Amani) 27-January-2020
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 3.9
Configuration Options :: Offline: true | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 60 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: pdomysql | PHP Supports J! 3.9.15: Yes | Database Supports J! 3.9.15: Unknown | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.12.18-clouder0 | Technology: x86_64 | Web Server: Apache | Encoding: | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 1081.06 GiB |

PHP Configuration :: Version: 7.2.27 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 30709 | Log Errors To: php_errorlog | Last Known Error: 03rd February 2020 23:29:13. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 128M | Max. POST Size: 128M | Max. Input Time: 120 | Max. Execution Time: 120 | Memory Limit: 768M

Database Configuration :: Connection Error: : Database Credentials Present? in Configuration...

PHP Extensions :: Core (7.2.27) | date (7.2.27) | libxml (7.2.27) | openssl (7.2.27) | pcre (7.2.27) | sqlite3 (7.2.27) | zlib (7.2.27) | bcmath (7.2.27) | bz2 (7.2.27) | calendar (7.2.27) | ctype (7.2.27) | curl (7.2.27) | dba (7.2.27) | dom (20031129) | enchant (7.2.27) | hash (1.0) | fileinfo (1.0.5) | filter (7.2.27) | ftp (7.2.27) | gd (7.2.27) | gettext (7.2.27) | gmp (7.2.27) | SPL (7.2.27) | iconv (7.2.27) | session (7.2.27) | intl (1.1.0) | json (1.6.0) | ldap (7.2.27) | mbstring (7.2.27) | standard (7.2.27) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $) | pcntl (7.2.27) | mysqli (7.2.27) | PDO (7.2.27) | pdo_mysql (7.2.27) | pdo_pgsql (7.2.27) | pdo_sqlite (7.2.27) | pgsql (7.2.27) | Phar (2.0.2) | posix (7.2.27) | pspell (7.2.27) | readline (7.2.27) | Reflection (7.2.27) | imap (7.2.27) | shmop (7.2.27) | SimpleXML (7.2.27) | soap (7.2.27) | sockets (7.2.27) | sodium (7.2.27) | exif (7.2.27) | sysvmsg (7.2.27) | sysvsem (7.2.27) | tidy (7.2.27) | tokenizer (7.2.27) | wddx (7.2.27) | xml (7.2.27) | xmlreader (7.2.27) | xmlrpc (7.2.27) | xmlwriter (7.2.27) | xsl (7.2.27) | zip (1.15.4) | cgi-fcgi () | memcached (3.0.4) | ionCube Loader (10.3.9) | Zend OPcache (7.2.27) | Zend Engine (3.2.0) |
Potential Missing Extensions ::

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No

Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |

Elevated Permissions (First 10) ::

Components :: SITE ::
Core :: com_wrapper (3.0.0) ? | com_mailto (3.0.0) ? |
3rd Party:: kunena_tmpl_crypsis (5.1.15) ? | kunena_tmpl_crypsisb3 (5.1.15) ? | WF_FONTSELECT_TITLE (2.8.5) ? | WF_TABLE_TITLE (2.8.5) ? | WF_EMOTIONS_TITLE (2.8.5) ? | WF_MEDIAMANAGER_TITLE (2.8.5) ? | WF_AUTOSAVE_TITLE (2.8.5) ? | WF_ARTICLE_TITLE (2.8.5) ? | WF_PREVIEW_TITLE (2.8.5) ? | WF_PRINT_TITLE (2.8.5) ? | WF_FULLSCREEN_TITLE (2.8.5) ? | WF_FILEMANAGER_TITLE (2.8.5) ? | WF_TEXTPATTERN_TITLE (2.8.5) ? | WF_LAYER_TITLE (2.8.3) ? | WF_DIRECTIONALITY_TITLE (2.8.5) ? | WF_SPELLCHECKER_TITLE (2.8.5) ? | WF_KITCHENSINK_TITLE (2.8.5) ? | WF_IMGMANAGER_TITLE (2.8.5) ? | WF_TEXTCASE_TITLE (2.8.5) ? | WF_TEMPLATEMANAGER_TITLE (2.8.5) ? | WF_MEDIA_TITLE (2.8.5) ? | WF_CLIPBOARD_TITLE (2.8.5) ? | WF_CONTEXTMENU_TITLE (2.8.5) ? | WF_VISUALCHARS_TITLE (2.8.5) ? | WF_ANCHOR_TITLE (2.8.5) ? | WF_STYLE_TITLE (2.8.5) ? | WF_NONBREAKING_TITLE (2.8.5) ? | WF_FONTCOLOR_TITLE (2.8.5) ? | WF_STYLESELECT_TITLE (2.8.5) ? | WF_IFRAME_TITLE (2.8.5) ? | WF_IMGMANAGER_EXT_TITLE (2.8.5) ? | JCE - Noneditable (1.0.0) ? | WF_WORDCOUNT_TITLE (2.8.5) ? | WF_FORMATSELECT_TITLE (2.8.5) ? | JCE - Columns (1.0.0) ? | WF_HR_TITLE (2.8.5) ? | WF_LISTS_TITLE (2.8.5) ? | WF_XHTMLXTRAS_TITLE (2.8.5) ? | WF_FONTSIZESELECT_TITLE (2.8.5) ? | WF_BROWSER_TITLE (2.8.5) ? | WF_CHARMAP_TITLE (2.8.5) ? | WF_CLEANUP_TITLE (2.8.5) ? | WF_CAPTION_TITLE (2.8.5) ? | WF_SEARCHREPLACE_TITLE (2.8.5) ? | WF_MICRODATA_TITLE (2.8.5) ? | WF_SOURCE_TITLE (2.8.5) ? | WF_LINK_TITLE (2.8.5) ? | WF_VISUALBLOCKS_TITLE (2.8.5) ? | WF_LINKS_JOOMLALINKS_TITLE (2.8.5) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.8.5) ? | WF_LINK_SEARCH_TITLE (2.8.5) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.8.5) ? | WF_AGGREGATOR_VIMEO_TITLE (2.8.5) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.8.5) ? | WF_AGGREGATOR_VIDEO_TITLE (2.8.5) ? | WF_AGGREGATOR_AUDIO_TITLE (2.8.5) ? | WF_AGGREGATOR_[youtube]_TITLE (2.8.5) ? |

Components :: ADMIN ::
Core :: com_postinstall (3.2.0) ? | com_redirect (3.0.0) ? | com_admin (3.0.0) ? | com_languages (3.0.0) ? | com_search (3.0.0) ? | com_checkin (3.0.0) ? | com_contenthistory (3.2.0) ? | com_joomlaupdate (3.6.2) ? | com_associations (3.7.0) ? | com_media (3.0.0) ? | com_config (3.0.0) ? | com_users (3.0.0) ? | com_tags (3.1.0) ? | com_modules (3.0.0) ? | com_templates (3.0.0) ? | com_content (3.0.0) ? | com_finder (3.0.0) ? | com_installer (3.0.0) ? | com_weblinks (3.0.0) ? | com_banners (3.0.0) ? | com_menus (3.0.0) ? | com_privacy (3.9.0) ? | com_plugins (3.0.0) ? | com_cpanel (3.0.0) ? | com_fields (3.7.0) ? | com_actionlogs (3.9.0) ? | com_messages (3.0.0) ? | com_login (3.0.0) ? | com_newsfeeds (3.0.0) ? | com_cache (3.0.0) ? | com_ajax (3.2.0) ? | com_categories (3.0.0) ? |
3rd Party:: Akeeba (7.0.1) ? | plg_kunena_altauserpoints (5.1.15) ? | plg_kunena_easysocial (5.1.15) ? | plg_kunena_gravatar (5.1.15) ? | plg_kunena_finder (5.1.15) ? | plg_finder_kunena (5.1.15) ? | PLG_KUNENA_EASYPROFILE (5.1.15) ? | plg_kunena_joomla (5.1.15) ? | PLG_KUNENA_EASYBLOG (0.0.1) ? | plg_kunena_uddeim (5.1.15) ? | plg_kunena_kunena (5.1.15) ? | plg_kunena_community (5.1.15) ? | plg_kunena_comprofiler (5.1.15) ? | com_kunena (5.1.15) ? | Widgetkit (1.5.8) ? | COM_JCE (2.8.5) ? | Blank Component (3.0.0) ? | COM_JEVENTS (3.4.50) ? |

Modules :: SITE ::
Core :: mod_banners (3.0.0) ? | mod_wrapper (3.0.0) ? | mod_menu (3.0.0) ? | mod_login (3.0.0) ? | mod_languages (3.5.0) ? | mod_syndicate (3.0.0) ? | mod_whosonline (3.0.0) ? | mod_related_items (3.0.0) ? | mod_search (3.0.0) ? | mod_articles_category (3.0.0) ? | mod_random_image (3.0.0) ? | mod_stats (3.0.0) ? | mod_feed (3.0.0) ? | mod_articles_archive (3.0.0) ? | mod_custom (3.0.0) ? | mod_articles_latest (3.0.0) ? | mod_users_latest (3.0.0) ? | mod_breadcrumbs (3.0.0) ? | mod_articles_categories (3.0.0) ? | mod_tags_similar (3.1.0) ? | mod_articles_popular (3.0.0) ? | mod_weblinks (3.0.0) ? | mod_finder (3.0.0) ? | mod_articles_news (3.0.0) ? | mod_footer (3.0.0) ? | mod_tags_popular (3.1.0) ? |
3rd Party:: MOD_JEV_CUSTOM_MODULE_TITLE (3.4.50) ? | Widgetkit (1.0.0) ? | MOD_JEV_SWITCH_VIEW_TITLE (3.4.50) ? | MOD_JEV_LATEST_EVENTS_TITLE (3.4.50) ? | MOD_JEV_FILTER_MODULE_TITLE (3.4.50) ? | MOD_JEV_LEGEND_TITLE (3.4.50) ? | MOD_JEV_CALENDAR_TITLE (3.4.50) ? | Widgetkit Twitter (1.0.0) ? |

Modules :: ADMIN ::
Core :: mod_popular (3.0.0) ? | mod_logged (3.0.0) ? | mod_menu (3.0.0) ? | mod_login (3.0.0) ? | mod_submenu (3.0.0) ? | mod_title (3.0.0) ? | mod_latestactions (3.9.0) ? | mod_stats_admin (3.0.0) ? | mod_feed (3.0.0) ? | mod_version (3.0.0) ? | mod_sampledata (3.8.0) ? | mod_custom (3.0.0) ? | mod_toolbar (3.0.0) ? | mod_status (3.0.0) ? | mod_quickicon (3.0.0) ? | mod_privacy_dashboard (3.9.0) ? | mod_latest (3.0.0) ? | mod_multilangstatus (3.0.0) ? |
3rd Party::

Libraries ::
Core ::
3rd Party:: file_fof30 (3.5.1) ? |

Plugins ::
Core :: PLG_INSTALLER_FOLDERINSTALLER (3.6.0) ? | PLG_INSTALLER_URLINSTALLER (3.6.0) ? | plg_installer_packageinstaller (3.6.0) ? | plg_content_emailcloak (3.0.0) ? | plg_content_joomla (3.0.0) ? | plg_content_confirmconsent (3.9.0) ? | plg_content_pagebreak (3.0.0) ? | plg_content_pagenavigation (3.0.0) ? | plg_content_loadmodule (3.0.0) ? | plg_content_geshi (2.5.0) ? | plg_content_fields (3.7.0) ? | plg_content_finder (3.0.0) ? | plg_content_vote (3.0.0) ? | plg_quickicon_joomlaupdate (3.0.0) ? | plg_quickicon_privacycheck (3.9.0) ? | plg_quickicon_phpversioncheck (3.7.0) ? | plg_quickicon_extensionupdate (3.0.0) ? | PLG_ACTIONLOG_JOOMLA (3.9.0) ? | plg_extension_joomla (3.0.0) ? | plg_privacy_content (3.9.0) ? | plg_privacy_message (3.9.0) ? | plg_privacy_actionlogs (3.9.0) ? | plg_privacy_user (3.9.0) ? | plg_privacy_consents (3.9.0) ? | plg_system_debug (3.0.0) ? | plg_system_logout (3.0.0) ? | plg_system_remember (3.0.0) ? | plg_system_languagecode (3.0.0) ? | plg_system_stats (3.5.0) ? | plg_system_highlight (3.0.0) ? | plg_system_updatenotification (3.5.0) ? | plg_system_redirect (3.0.0) ? | PLG_SYSTEM_ACTIONLOGS (3.9.0) ? | plg_system_privacyconsent (3.9.0) ? | plg_system_log (3.0.0) ? | plg_system_languagefilter (3.0.0) ? | plg_system_sef (3.0.0) ? | plg_system_cache (3.0.0) ? | plg_system_logrotation (3.9.0) ? | plg_system_p3p (3.0.0) ? | plg_system_sessiongc (3.8.6) ? | plg_system_fields (3.7.0) ? | plg_editors-xtd_readmore (3.0.0) ? | plg_editors-xtd_menu (3.7.0) ? | plg_editors-xtd_article (3.0.0) ? | plg_editors-xtd_pagebreak (3.0.0) ? | plg_editors-xtd_module (3.5.0) ? | plg_editors-xtd_image (3.0.0) ? | plg_editors-xtd_fields (3.7.0) ? | plg_captcha_recaptcha (3.4.0) ? | plg_captcha_recaptcha_invisible (3.8) ? | plg_search_weblinks (3.0.0) ? | plg_search_content (3.0.0) ? | plg_search_tags (3.0.0) ? | plg_search_newsfeeds (3.0.0) ? | plg_search_categories (3.0.0) ? | plg_search_contacts (3.0.0) ? | plg_user_contactcreator (3.0.0) ? | plg_user_profile (3.0.0) ? | plg_user_terms (3.9.0) ? | plg_user_joomla (3.0.0) ? | plg_twofactorauth_totp (3.2.0) ? | plg_twofactorauth_yubikey (3.2.0) ? | plg_fields_calendar (3.7.0) ? | plg_fields_radio (3.7.0) ? | plg_fields_sql (3.7.0) ? | plg_fields_text (3.7.0) ? | plg_fields_media (3.7.0) ? | plg_fields_checkboxes (3.7.0) ? | plg_fields_integer (3.7.0) ? | plg_fields_repeatable (3.9.0) ? | plg_fields_list (3.7.0) ? | plg_fields_usergrouplist (3.7.0) ? | plg_fields_color (3.7.0) ? | plg_fields_user (3.7.0) ? | plg_fields_editor (3.7.0) ? | plg_fields_textarea (3.7.0) ? | plg_fields_imagelist (3.7.0) ? | plg_fields_url (3.7.0) ? | plg_authentication_cookie (3.0.0) ? | plg_authentication_gmail (3.0.0) ? | plg_authentication_joomla (3.0.0) ? | plg_authentication_ldap (3.0.0) ? | plg_finder_weblinks (3.0.0) ? | plg_finder_content (3.0.0) ? | plg_finder_tags (3.0.0) ? | plg_finder_newsfeeds (3.0.0) ? | plg_finder_categories (3.0.0) ? | plg_finder_contacts (3.0.0) ? |
3rd Party:: plg_installer_jeventsinstaller (3.4.50) ? | plg_installer_jce (2.8.5) ? | plg_editors_codemirror (5.40.0) ? | plg_editors_jce (2.8.5) ? | plg_editors_tinymce (4.5.11) ? | PLG_JEV_CORE_CONTENT_PLUGIN_TITLE (3.4.50) ? | plg_content_jce (2.8.5) ? | Content - Widgetkit (1.0.0) ? | plg_quickicon_jce (2.8.5) ? | plg_quickicon_kunena (5.1.15) ? | plg_quickicon_akeebabackup (7.0.1) ? | PLG_ACTIONLOG_AKEEBABACKUP (7.0.1) ? | plg_extension_jce (2.8.5) ? | PLG_SYSTEM_GWEJSON (3.4.50) ? | System - Widgetkit (1.0.0) ? | System - Widgetkit ZOO (3.1.0) ? | PLG_SYSTEM_AKEEBAUPDATECHECK (7.0.1) ? | plg_system_jcemediabox (2.0.13) ? | System - Widgetkit Joomla (1.0.0) ? | PLG_SYSTEM_BACKUPONUPDATE (7.0.1) ? | plg_system_jce (2.8.5) ? | plg_system_kunena (5.1.15) ? | PLG_JEV_SEARCH_TITLE (3.4.50) ? | plg_kunena_comprofiler (5.1.15) ? | plg_kunena_community (5.1.15) ? | plg_kunena_altauserpoints (5.1.15) ? | plg_kunena_joomla (5.1.15) ? | plg_kunena_uddeim (5.1.15) ? | plg_kunena_gravatar (5.1.15) ? | plg_kunena_easysocial (5.1.15) ? | plg_kunena_kunena (5.1.15) ? | PLG_KUNENA_EASYPROFILE (5.1.15) ? | plg_kunena_finder (5.1.15) ? | plg_fields_mediajce (2.8.5) ? | PLG_FINDER_JEVENTS (3.4.50) ? | plg_finder_kunena (5.1.15) ? |

Templates :: SITE :: jp-ultimate (1.0.005) ? | beez3 (3.1.0) ? | protostar (1.0) ? |
Templates :: ADMIN :: hathor (3.0.0) ? | isis (1.0) ? |

[webdevtim]

The title should have been:

"Smart Search - Content" Causes Error to be Thrown.

I first submitted a ticket to Siteground.com and the tech that worked with me came to the same conclusion I did, so the ticket got bumped upstairs.

The higher level tech that took over came to the conclusion that a search plugin was causing the problem.

I went through the list of search plugins disabling them one at a time and determined that the "Smart Search - Content" plugin was the offending plugin.

Would someone please look into this. I have already sited what may be the cause. This will need to be resolved before Joomla 4 is rolled out because we surely don't want to roll that out with a broken search plugin in tow.