Advertisement

Missing field in database: error, in Administration

Need help with the Administration of your Joomla! 3.x site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
GuyInCPT
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Jun 14, 2024 10:27 pm

Missing field in database: error, in Administration

Post by GuyInCPT » Fri Jun 14, 2024 10:43 pm

Hello,

Joomla newb here. I'm trying to manage a site created by a late relative. The site functions, it's really an text and gallery website, but if I try to edit any of the article files, I receive this error:
An error has occurred.

0 Missing field in database: Joomla\CMS\Table\Extension &#160; extension_id.
Also the Joomla version claims to be up to date. I'd like to get to be able to edit the site, I'd need to make some text changes on a few of the pages, but I'm unable to do that. Any help is really appreciated.

I suppose this is likely an outdated Joomla version problem? Thank you.

Forum Post Assistant (v1.6.7) : 14-Jun-2024 wrote:
Last PHP Error(s) Reported :: wrote:[14-Jun-2024 17:22:38 America/Chicago] PHP Fatal error: Type of JException::$file must be string (as in class Exception) in /home3/barcho/public_html/libraries/legacy/exception/exception.php on line 18
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.9.23-Stable (Amani) 24-November-2020
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: false | Cache: true | CacheTime: 30 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: N/A | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.9.23: No | Database Supports J! 3.9.23: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 4.19.286-203.ELK.el7.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br, zstd | System TMP Writable: Yes | Free Disk Space : 181.13 GiB |

PHP Configuration :: Version: 8.2.18 | PHP API: litespeed | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22519 | Log Errors To: error_log | Last Known Error: 14th June 2024 17:22:38. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 512M | Max. POST Size: 516M | Max. Input Time: 60 | Max. Execution Time: 60 | Memory Limit: 512M

Database Configuration :: Version: 5.7.23-23 (Client:mysqlnd 8.2.18) | Database Size: 30.91 MiB | #of Tables with config prefix:  116 | #of other Tables:  0 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (8.2.18) | date (8.2.18) | libxml (8.2.18) | openssl (8.2.18) | pcre (8.2.18) | zlib (8.2.18) | filter (8.2.18) | hash (8.2.18) | json (8.2.18) | pcntl (8.2.18) | random (8.2.18) | readline (8.2.18) | Reflection (8.2.18) | SPL (8.2.18) | session (8.2.18) | standard (8.2.18) | litespeed () | bcmath (8.2.18) | bz2 (8.2.18) | calendar (8.2.18) | ctype (8.2.18) | curl (8.2.18) | dom (20031129) | mbstring (8.2.18) | fileinfo (8.2.18) | ftp (8.2.18) | gd (8.2.18) | gettext (8.2.18) | gmp (8.2.18) | iconv (8.2.18) | imap (8.2.18) | intl (8.2.18) | exif (8.2.18) | mysqlnd (mysqlnd 8.2.18) | odbc (8.2.18) | PDO (8.2.18) | pgsql (8.2.18) | Phar (8.2.18) | posix (8.2.18) | pspell (8.2.18) | SimpleXML (8.2.18) | soap (8.2.18) | sockets (8.2.18) | sodium (8.2.18) | sqlite3 (8.2.18) | tidy (8.2.18) | tokenizer (8.2.18) | xml (8.2.18) | xmlwriter (8.2.18) | xsl (8.2.18) | zip (1.21.1) | mysqli (8.2.18) | pdo_mysql (8.2.18) | PDO_ODBC (8.2.18) | pdo_pgsql (8.2.18) | pdo_sqlite (8.2.18) | xmlreader (8.2.18) | apcu (5.1.22) | imagick (3.5.0) | Zend OPcache (8.2.18) | Zend Engine (4.2.18) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Potential Ownership Issues: No
Folder Permissions :: wrote: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/ (---) |

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 315679 | Threads: 6 | Questions: 405837485 | Slow queries: 0 | Opens: 32171050 | Flush tables: 1 | Open tables: 944 | Queries per second avg: 1285.601 |
Extensions Discovered :: wrote:Components :: Site ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party:: WF_CLEANUP_TITLE (2.9.1) ? | WF_FONTSIZESELECT_TITLE (2.9.1) ? | WF_TABLE_TITLE (2.9.1) ? | WF_IMGMANAGER_TITLE (2.9.1) ? | WF_LAYER_TITLE (2.8.1) ? | WF_CLIPBOARD_TITLE (2.9.1) ? | WF_PREVIEW_TITLE (2.9.1) ? | WF_WORDCOUNT_TITLE (2.9.1) ? | WF_STYLE_TITLE (2.9.1) ? | WF_DIRECTIONALITY_TITLE (2.9.1) ? | WF_HELP_TITLE (2.9.1) ? | WF_PRINT_TITLE (2.9.1) ? | WF_EMOTIONS_TITLE (2.9.1) ? | WF_HR_TITLE (2.9.1) ? | WF_ARTICLE_TITLE (2.9.1) ? | WF_BROWSER_TITLE (2.9.1) ? | WF_VISUALCHARS_TITLE (2.9.1) ? | WF_STYLESELECT_TITLE (2.9.1) ? | WF_XHTMLXTRAS_TITLE (2.9.1) ? | WF_CHARMAP_TITLE (2.9.1) ? | WF_REFERENCE_TITLE (2.9.1) ? | WF_ATTRIBUTES_TITLE (2.9.1) ? | WF_KITCHENSINK_TITLE (2.9.1) ? | WF_CONTEXTMENU_TITLE (2.9.1) ? | WF_SPELLCHECKER_TITLE (2.9.1) ? | WF_LISTS_TITLE (2.9.1) ? | WF_FULLSCREEN_TITLE (2.9.1) ? | JCE - Noneditable (1.0.0) ? | WF_NONBREAKING_TITLE (2.9.1) ? | WF_FORMATSELECT_TITLE (2.9.1) ? | WF_FONTCOLOR_TITLE (2.9.1) ? | WF_SOURCE_TITLE (2.9.1) ? | WF_AUTOSAVE_TITLE (2.9.1) ? | WF_SEARCHREPLACE_TITLE (2.9.1) ? | WF_VISUALBLOCKS_TITLE (2.9.1) ? | WF_TEXTCASE_TITLE (2.9.1) ? | WF_MEDIA_TITLE (2.9.1) ? | WF_LINK_TITLE (2.9.1) ? | WF_FONTSELECT_TITLE (2.9.1) ? | WF_ANCHOR_TITLE (2.9.1) ? | WF_LINKS_JOOMLALINKS_TITLE (2.9.1) ? | WF_AGGREGATOR_VIMEO_TITLE (2.9.1) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.9.1) ? | WF_AGGREGATOR_[youtube]_TITLE (2.9.1) ? | WF_AGGREGATOR_AUDIO_TITLE (2.9.1) ? | WF_AGGREGATOR_VIDEO_TITLE (2.9.1) ? | WF_LINK_SEARCH_TITLE (2.9.1) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.9.1) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.9.1) ? |

Components :: Admin ::
Core :: com_checkin (3.0.0) 1 | com_cache (3.0.0) 1 | com_admin (3.0.0) 1 | com_joomlaupdate (3.6.2) 1 | com_templates (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_modules (3.0.0) 1 | com_messages (3.0.0) 1 | com_search (3.0.0) 1 | com_redirect (3.0.0) 1 | com_menus (3.0.0) 1 | com_media (3.0.0) 1 | com_categories (3.0.0) 1 | com_plugins (3.0.0) 1 | com_content (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_languages (3.0.0) 1 | com_newsfeeds (3.0.0) 1 | com_tags (3.1.0) 1 | com_privacy (3.9.0) 1 | com_finder (3.0.0) 1 | com_installer (3.0.0) 1 | com_banners (3.0.0) 1 | com_config (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_contenthistory (3.2.0) 1 | com_users (3.0.0) 1 | com_login (3.0.0) 1 | com_associations (3.7.0) 1 | com_ajax (3.2.0) 1 | com_fields (3.7.0) 1 |
3rd Party:: COM_JCE (2.9.1) 1 | com_bfstop (1.4.0) 1 | COM_OSGALLERY (1.0.5) 1 | Akeeba (7.4.0) 1 | COM_EVENTGALLERY (3.11.22) 1 |

Modules :: Site ::
Core :: mod_feed (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_search (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_articles_popular (3.0.0) 1 | mod_login (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_custom (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_syndicate (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_articles_categories (3.0.0) 1 |
3rd Party:: MOD_EVENTGALLERY_EVENT (3.11.22) 1 | MOD_EVENTGALLERY_CUSTOM (3.11.22) 1 | MOD_EVENTGALLERY_CART (3.11.22) 1 | MOD_EVENTGALLERY_LATEST (3.11.22) 1 | MOD_EVENTGALLERY_CATEGORIES (3.11.22) 1 | MOD_EVENTGALLERY_EVENTS (3.11.22) 1 |

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

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

Plugins ::
Core :: PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_installer_webinstaller (2.1.2) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_privacyconsent (3.9.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_p3p (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_logrotation (3.9.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_cache (3.0.0) 0 | plg_system_fields (3.7.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_remember (3.0.0) 1 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_captcha_recaptcha (3.4.0) ? | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_joomla (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_pagebreak (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_fields_url (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_twofactorauth_totp (3.2.0) 0 |
3rd Party:: PLG_ACTIONLOG_AKEEBABACKUP (7.4.0) 0 | PLG_EVENTGALLERY_FINDER (3.11.22) 0 | PLG_INSTALLER_EVENTGALLERY (3.11.22) 1 | plg_installer_jce (2.9.1) 1 | PLG_EVENTGALLERY_SHIP_DOWNLOAD (3.11.22) 1 | PLG_EVENTGALLERY_SHIP_STANDARD (3.11.22) 0 | PLG_EVENTGALLERY_SHIP_EMAIL (3.11.22) 0 | PLG_EVENTGALLERY_SEARCH_FILE (3.11.22) 0 | PLG_EVENTGALLERY_SEARCH (3.11.22) 0 | PLG_SYSTEM_EVENTGALLERY_CAPABILITIE (3.11.22) ? | plg_system_bfstop (1.4.1) 1 | OS Gallery System (1.0.5) 1 | PLG_SYSTEM_AKEEBAUPDATECHECK (6.6.1) 0 | plg_system_jce (2.9.1) 1 | PLG_SYSTEM_EVENTGALLERYCONSOLE (3.11.22) 1 | PLG_SYSTEM_PICASAUPDATER (3.11.22) 1 | PLG_SYSTEM_BACKUPONUPDATE (7.4.0) 1 | plg_quickicon_akeebabackup (7.4.0) 1 | plg_quickicon_jce (2.9.1) 1 | PLG_EDITORS-XTD_EVENTGALLERYIMAGE (3.11.22) 1 | PLG_EDITORS-XTD_EVENTGALLERY (3.11.22) 1 | plg_editors_codemirror (5.56.0) 1 | plg_editors_jce (2.9.1) 1 | plg_editors_tinymce (4.5.12) 1 | plg_extension_jce (2.9.1) 1 | Light Gallery (2.0.0) 1 | EVENTGALLERY_FIELDS_CATEGORY (3.11.22) 1 | PLG_EVENTGALLERY_CONTENT (3.11.22) 1 | plg_content_jce (2.9.1) 1 | PLG_EVENTGALLERY_MULTILANGCONTENT (3.11.22) 1 | PLG_EVENTGALLERY_PAY_PAYPALBASIC (3.11.22) 0 | PLG_EVENTGALLERY_PAY_PAYPAL (3.11.22) 0 | PLG_EVENTGALLERY_PAY_STRIPE (3.11.22) 0 | PLG_EVENTGALLERY_PAY_STANDARD (3.11.22) 0 | PLG_EVENTGALLERY_PAY_BRAINTREE (3.11.22) 0 | PLG_EVENTGALLERY_SUR_STANDARD (3.11.22) 0 | plg_fields_mediajce (2.9.1) 1 |
Templates Discovered :: wrote:Templates :: Site :: beez3 (3.1.0) 1 | protostar (1.0) 1 |
Templates :: Admin :: hathor (3.0.0) 1 | isis (1.0) 1 |
Thank you.

Advertisement
mtgg
Joomla! Intern
Joomla! Intern
Posts: 55
Joined: Thu Apr 04, 2024 11:17 pm

Re: Missing field in database: error, in Administration

Post by mtgg » Fri Jun 14, 2024 10:50 pm

If possible, use PHP 7.3 (no later) with Joomla 3.9.23 and then upgrade to Joomla 3.10.12.

Advertisement

Post Reply

Return to “Administration Joomla! 3.x”