Database error - Missing table Topic is solved
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.
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.
-
- Joomla! Explorer
- Posts: 426
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Database error - Missing table
When trying to access any extension management or update functions I get
Missing field in database: Joomla\CMS\Table\Extension   extension_id.
As there isn't an extension with id-160 I have no idea what is missing.
I have posted the FPA which does note that the update functions have been disabled.
Help would be appreciated as I need to update this website to J4 and I can't while this problem exists.
Missing field in database: Joomla\CMS\Table\Extension   extension_id.
As there isn't an extension with id-160 I have no idea what is missing.
I have posted the FPA which does note that the update functions have been disabled.
Help would be appreciated as I need to update this website to J4 and I can't while this problem exists.
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
-
- Joomla! Explorer
- Posts: 426
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: Database error - Missing table
Forum Post Assistant (v1.6.6) : 7-Jun-2023 wrote:Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.10.2-Stable (Daraja) 12-September-2021
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Writable (644) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: Is Not Empty | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.10.2: Yes | Database Supports J! 3.10.2: Yes | Database Credentials Present: Yes |
Host Configuration :: OS: Linux | OS Version: 4.4.302-icpu-092 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 389.22 GiB |
PHP Configuration :: Version: 8.1.19 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22517 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 64M | Max. POST Size: 64M | Max. Input Time: -1 | Max. Execution Time: 100000 | Memory Limit: -2M
Database Configuration :: Version: 8.0.32 (Client:mysqlnd 8.1.19) | Database Size: 29.56 MiB | #of Tables with config prefix: 197 | #of other Tables: 164 | User Privileges : GRANT ALLDetailed Environment :: wrote:PHP Extensions :: Core (8.1.19) | date (8.1.19) | libxml (8.1.19) | openssl (8.1.19) | pcre (8.1.19) | sqlite3 (8.1.19) | zlib (8.1.19) | bcmath (8.1.19) | bz2 (8.1.19) | calendar (8.1.19) | ctype (8.1.19) | curl (8.1.19) | dba (8.1.19) | dom (20031129) | hash (8.1.19) | fileinfo (8.1.19) | filter (8.1.19) | ftp (8.1.19) | gd (8.1.19) | gettext (8.1.19) | gmp (8.1.19) | json (8.1.19) | iconv (8.1.19) | SPL (8.1.19) | intl (8.1.19) | session (8.1.19) | mbstring (8.1.19) | standard (8.1.19) | PDO (8.1.19) | mysqlnd (mysqlnd 8.1.19) | pdo_sqlite (8.1.19) | Phar (8.1.19) | posix (8.1.19) | Reflection (8.1.19) | imap (8.1.19) | shmop (8.1.19) | SimpleXML (8.1.19) | soap (8.1.19) | sodium (8.1.19) | pdo_mysql (8.1.19) | exif (8.1.19) | tidy (8.1.19) | tokenizer (8.1.19) | xml (8.1.19) | xmlreader (8.1.19) | xmlwriter (8.1.19) | xsl (8.1.19) | zip (1.19.5) | mysqli (8.1.19) | cgi-fcgi (8.1.19) | Zend Engine (4.1.19) |
Potential Missing Extensions ::
Switch User Environment :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Potential Ownership Issues: NoFolder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |
Elevated Permissions (First 10) ::Database Information :: wrote:Database statistics :: Uptime: 6056255 | Threads: 19 | Questions: 2478079149 | Slow queries: 19822 | Opens: 86504912 | Flush tables: 23850 | Open tables: 6000 | Queries per second avg: 409.176 |Extensions Discovered :: wrote:Components :: Site ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party:: WF_LINK_SEARCH_TITLE (2.9.33) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.9.33) ? | WF_LINKS_JOOMLALINKS_TITLE (2.9.33) ? | WF_AGGREGATOR_VIDEO_TITLE (2.9.33) ? | WF_AGGREGATOR_AUDIO_TITLE (2.9.33) ? | WF_AGGREGATOR_VIMEO_TITLE (2.9.33) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.9.33) ? | WF_AGGREGATOR_[youtube]_TITLE (2.9.33) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.9.33) ? | WF_LANGCODE_TITLE (2.9.33) ? | WF_FILEMANAGER_TITLE (2.9.33) ? | WF_TEXTPATTERN_TITLE (2.9.33) ? | WF_EMOTIONS_TITLE (2.9.33) ? | JCE - Noneditable (1.0.0) ? | WF_AUTOSAVE_TITLE (2.9.33) ? | WF_REFERENCE_TITLE (2.9.33) ? | WF_FORMATSELECT_TITLE (2.9.33) ? | WF_LISTS_TITLE (2.9.33) ? | WF_ATTRIBUTES_TITLE (2.9.33) ? | WF_FONTCOLOR_TITLE (2.9.33) ? | WF_TEXTCASE_TITLE (2.9.33) ? | WF_KITCHENSINK_TITLE (2.9.33) ? | WF_WORDCOUNT_TITLE (2.9.33) ? | JCE - Columns (1.0.0) ? | WF_XHTMLXTRAS_TITLE (2.9.30) ? | WF_CLIPBOARD_TITLE (2.9.33) ? | WF_BROWSER_TITLE (2.9.33) ? | WF_FULLSCREEN_TITLE (2.9.33) ? | WF_CLEANUP_TITLE (2.9.33) ? | WF_MICRODATA_TITLE (2.9.33) ? | WF_STYLESELECT_TITLE (2.9.33) ? | WF_CHARMAP_TITLE (2.9.33) ? | WF_LINK_TITLE (2.9.33) ? | WF_PRINT_TITLE (2.9.33) ? | WF_HELP_TITLE (2.9.33) ? | WF_IMGMANAGER_EXT_TITLE (2.9.33) ? | WF_CAPTION_TITLE (2.9.33) ? | WF_TABLE_TITLE (2.9.33) ? | WF_ARTICLE_TITLE (2.9.33) ? | WF_MEDIA_TITLE (2.9.33) ? | WF_FONTSIZESELECT_TITLE (2.9.33) ? | WF_DIRECTIONALITY_TITLE (2.9.33) ? | WF_LAYER_TITLE (2.8.3) ? | WF_CONTEXTMENU_TITLE (2.9.33) ? | WF_FONTSELECT_TITLE (2.9.33) ? | WF_ANCHOR_TITLE (2.9.33) ? | WF_STYLE_TITLE (2.9.33) ? | WF_TEMPLATEMANAGER_TITLE (2.9.33) ? | WF_IFRAME_TITLE (2.9.33) ? | WF_IMGMANAGER_TITLE (2.9.33) ? | WF_SPELLCHECKER_TITLE (2.9.33) ? | WF_VISUALBLOCKS_TITLE (2.9.33) ? | WF_VISUALCHARS_TITLE (2.9.33) ? | WF_HR_TITLE (2.9.33) ? | WF_NONBREAKING_TITLE (2.9.33) ? | WF_PREVIEW_TITLE (2.9.33) ? | WF_MEDIAMANAGER_TITLE (2.9.33) ? | WF_SOURCE_TITLE (2.9.33) ? | WF_SEARCHREPLACE_TITLE (2.9.33) ? |
Components :: Admin ::
Core :: com_actionlogs (3.9.0) 1 | com_admin (3.0.0) 1 | com_ajax (3.2.0) 1 | com_associations (3.7.0) 1 | com_banners (3.0.0) 1 | com_cache (3.0.0) 1 | com_categories (3.0.0) 1 | com_checkin (3.0.0) 1 | com_config (3.0.0) 1 | com_content (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_cpanel (3.0.0) 1 | com_fields (3.7.0) 1 | com_finder (3.0.0) 1 | com_installer (3.0.0) 1 | com_joomlaupdate (3.10.1) 1 | com_languages (3.0.0) 1 | com_login (3.0.0) 1 | com_media (3.0.0) 1 | com_menus (3.0.0) 1 | com_messages (3.0.0) 1 | com_modules (3.0.0) 1 | com_newsfeeds (3.0.0) 1 | com_plugins (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_privacy (3.9.0) 1 | com_redirect (3.0.0) 1 | com_search (3.0.0) 1 | com_tags (3.1.0) 1 | com_templates (3.0.0) 1 | com_users (3.0.0) 1 |
3rd Party:: Akeeba (8.2.7) 1 | GRIDBOX (2.12.12) 1 | COM_JCE (2.9.33) 1 | BaGallery (2.3.0) 1 | com_rsform (3.1.7) 1 | BaForms (2.0.0) 1 |
Modules :: Site ::
Core :: mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_search (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_tags_similar (3.1.0) 1 | mod_users_latest (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_wrapper (3.0.0) 1 |
3rd Party::
Modules :: Admin ::
Core :: mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_logged (3.0.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_quickicon (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_stats_admin (3.0.0) 1 | mod_status (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_title (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_version (3.0.0) 1 |
3rd Party::
Libraries ::
Core ::
3rd Party:: file_fof40 (4.1.0) ? | file_fof30 (3.6.2) ? |
Plugins ::
Core :: PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_joomla (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_vote (3.0.0) 0 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_quickicon_eos310 (3.10.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_tags (3.0.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_log (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_p3p (3.0.0) 0 | plg_system_privacyconsent (3.9.0) 0 | plg_system_redirect (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_stats (3.5.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 | plg_user_terms (3.9.0) 0 |
3rd Party:: PLG_ACTIONLOG_AKEEBABACKUP (8.2.7) 0 | plg_content_jce (2.9.33) 1 | plg_editors_codemirror (5.60.0) 1 | plg_editors_tinymce (4.5.12) 1 | plg_editors_jce (2.9.33) 1 | BaForms - Shortcode (2.0.0) 1 | BaGallery - Shortcode (2.3.0) 1 | plg_extension_jce (2.9.33) 1 | plg_fields_mediajce (2.9.33) 1 | Gridbox - Smart Search (2.12.7) 1 | PLG_INSTALLER_AKEEBABACKUP (8.2.7) 1 | plg_installer_jce (2.9.33) 1 | plg_installer_rsform (1.0.0) 1 | plg_quickicon_akeebabackup (8.2.7) 0 | plg_quickicon_jce (2.9.33) 1 | Gridbox - Search (2.12.1) 1 | PLG_SYSTEM_BACKUPONUPDATE (8.2.7) 1 | BaForms - System (2.0.0) 1 | plg_system_jcemediabox (2.1.2) 0 | Gridbox - System (2.12.8) 1 | BaGallery - System (2.3.0) 1 | System - RSForm! Pro Delete Submiss (1.0.0) ? | plg_system_jce (2.9.33) 1 |Templates Discovered :: wrote:Templates :: Site :: beez3 (3.1.0) 1 | protostar (1.0) 1 | Gridbox (2.12.12) 1 |
Templates :: Admin :: hathor (3.0.0) 1 | isis (1.0) 1 |
Last edited by toivo on Wed Jun 07, 2023 10:56 am, edited 1 time in total.
Reason: mod note: disabled smilies in post Options for readability
Reason: mod note: disabled smilies in post Options for readability
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
-
- Joomla! Champion
- Posts: 5466
- Joined: Tue Aug 23, 2005 1:56 pm
- Location: South coast, UK
- Contact:
Re: Database error - Missing table
LiveSite: Is Not Empty it should be empty,empty it in global config.
Max. Input Time: -1 | Max. Execution Time: 100000 | Memory Limit: -2M
Max input time 60, max execution time 300 Memory limit 256Mb
Using the unlimited value -1 and -2M have been known to cause issues. Adjust these and repost the FPA please.
Max. Input Time: -1 | Max. Execution Time: 100000 | Memory Limit: -2M
Max input time 60, max execution time 300 Memory limit 256Mb
Using the unlimited value -1 and -2M have been known to cause issues. Adjust these and repost the FPA please.
http://www.gadsolutions.biz Electrical services
http://www.electrical-testing-safety.co.uk Testing services
http://www.electrical-testing-safety.co.uk Testing services
- pe7er
- Joomla! Master
- Posts: 24602
- Joined: Thu Aug 18, 2005 8:55 pm
- Location: Nijmegen, Netherlands
- Contact:
Re: Database error - Missing table
The 160 in your error is not related to ID 160.
  is the HTML entity number for "non-breaking space"
Can you install a J3.10.2 on your local system? And compare the database structure of some of its tables with the database structure of your live site? In particular the #__extensions table.
  is the HTML entity number for "non-breaking space"
Can you install a J3.10.2 on your local system? And compare the database structure of some of its tables with the database structure of your live site? In particular the #__extensions table.
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
Peter Martin, Global Moderator
Company website: https://db8.nl - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
-
- Joomla! Explorer
- Posts: 426
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: Database error - Missing table
Thanks for the responses guys
I applied gws's suggestion and it doesn't appear to have resolved the problem.
I applied gws's suggestion and it doesn't appear to have resolved the problem.
Forum Post Assistant (v1.6.6) : 13-Jun-2023 wrote:Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.10.2-Stable (Daraja) 12-September-2021
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Writable (604) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.10.2: Yes | Database Supports J! 3.10.2: Yes | Database Credentials Present: Yes |
Host Configuration :: OS: Linux | OS Version: 4.4.302-icpu-092 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 373.11 GiB |
PHP Configuration :: Version: 8.1.19 | PHP API: cgi-fcgi | Session Path Writable: No | Display Errors: 0 | Error Reporting: | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 526M | Max. POST Size: 256M | Max. Input Time: 580 | Max. Execution Time: 300 | Memory Limit: 256M
Database Configuration :: Version: 5.7.41-log (Client:mysqlnd 8.1.19) | Database Size: 29.25 MiB | #of Tables with config prefix: 197 | #of other Tables: 164 | User Privileges : GRANT ALLDetailed Environment :: wrote:PHP Extensions :: Core (8.1.19) | date (8.1.19) | libxml (8.1.19) | openssl (8.1.19) | pcre (8.1.19) | sqlite3 (8.1.19) | zlib (8.1.19) | bcmath (8.1.19) | bz2 (8.1.19) | calendar (8.1.19) | ctype (8.1.19) | curl (8.1.19) | dba (8.1.19) | dom (20031129) | hash (8.1.19) | fileinfo (8.1.19) | filter (8.1.19) | ftp (8.1.19) | gd (8.1.19) | gettext (8.1.19) | gmp (8.1.19) | json (8.1.19) | iconv (8.1.19) | SPL (8.1.19) | intl (8.1.19) | session (8.1.19) | mbstring (8.1.19) | standard (8.1.19) | PDO (8.1.19) | mysqlnd (mysqlnd 8.1.19) | pdo_sqlite (8.1.19) | Phar (8.1.19) | posix (8.1.19) | Reflection (8.1.19) | imap (8.1.19) | shmop (8.1.19) | SimpleXML (8.1.19) | soap (8.1.19) | sodium (8.1.19) | pdo_mysql (8.1.19) | exif (8.1.19) | tidy (8.1.19) | tokenizer (8.1.19) | xml (8.1.19) | xmlreader (8.1.19) | xmlwriter (8.1.19) | xsl (8.1.19) | zip (1.19.5) | mysqli (8.1.19) | cgi-fcgi (8.1.19) | Zend Engine (4.1.19) |
Potential Missing Extensions ::
Switch User Environment :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Potential Ownership Issues: NoFolder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |
Elevated Permissions (First 10) ::Database Information :: wrote:Database statistics :: Uptime: 6592973 | Threads: 17 | Questions: 5121949223 | Slow queries: 893 | Opens: 147401272 | Flush tables: 87102 | Open tables: 6000 | Queries per second avg: 776.880 |Extensions Discovered :: wrote:Components :: Site ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party:: WF_SEARCHREPLACE_TITLE (2.9.33) ? | WF_SOURCE_TITLE (2.9.33) ? | WF_MEDIAMANAGER_TITLE (2.9.33) ? | WF_PREVIEW_TITLE (2.9.33) ? | WF_NONBREAKING_TITLE (2.9.33) ? | WF_HR_TITLE (2.9.33) ? | WF_VISUALCHARS_TITLE (2.9.33) ? | WF_VISUALBLOCKS_TITLE (2.9.33) ? | WF_SPELLCHECKER_TITLE (2.9.33) ? | WF_IMGMANAGER_TITLE (2.9.33) ? | WF_IFRAME_TITLE (2.9.33) ? | WF_TEMPLATEMANAGER_TITLE (2.9.33) ? | WF_STYLE_TITLE (2.9.33) ? | WF_ANCHOR_TITLE (2.9.33) ? | WF_FONTSELECT_TITLE (2.9.33) ? | WF_CONTEXTMENU_TITLE (2.9.33) ? | WF_LAYER_TITLE (2.8.3) ? | WF_DIRECTIONALITY_TITLE (2.9.33) ? | WF_FONTSIZESELECT_TITLE (2.9.33) ? | WF_MEDIA_TITLE (2.9.33) ? | WF_ARTICLE_TITLE (2.9.33) ? | WF_TABLE_TITLE (2.9.33) ? | WF_CAPTION_TITLE (2.9.33) ? | WF_IMGMANAGER_EXT_TITLE (2.9.33) ? | WF_HELP_TITLE (2.9.33) ? | WF_PRINT_TITLE (2.9.33) ? | WF_LINK_TITLE (2.9.33) ? | WF_CHARMAP_TITLE (2.9.33) ? | WF_STYLESELECT_TITLE (2.9.33) ? | WF_MICRODATA_TITLE (2.9.33) ? | WF_CLEANUP_TITLE (2.9.33) ? | WF_FULLSCREEN_TITLE (2.9.33) ? | WF_BROWSER_TITLE (2.9.33) ? | WF_CLIPBOARD_TITLE (2.9.33) ? | WF_XHTMLXTRAS_TITLE (2.9.30) ? | JCE - Columns (1.0.0) ? | WF_WORDCOUNT_TITLE (2.9.33) ? | WF_KITCHENSINK_TITLE (2.9.33) ? | WF_TEXTCASE_TITLE (2.9.33) ? | WF_FONTCOLOR_TITLE (2.9.33) ? | WF_ATTRIBUTES_TITLE (2.9.33) ? | WF_LISTS_TITLE (2.9.33) ? | WF_FORMATSELECT_TITLE (2.9.33) ? | WF_REFERENCE_TITLE (2.9.33) ? | WF_AUTOSAVE_TITLE (2.9.33) ? | JCE - Noneditable (1.0.0) ? | WF_EMOTIONS_TITLE (2.9.33) ? | WF_TEXTPATTERN_TITLE (2.9.33) ? | WF_FILEMANAGER_TITLE (2.9.33) ? | WF_LANGCODE_TITLE (2.9.33) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.9.33) ? | WF_AGGREGATOR_VIDEO_TITLE (2.9.33) ? | WF_AGGREGATOR_AUDIO_TITLE (2.9.33) ? | WF_AGGREGATOR_VIMEO_TITLE (2.9.33) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.9.33) ? | WF_AGGREGATOR_[youtube]_TITLE (2.9.33) ? | WF_LINKS_JOOMLALINKS_TITLE (2.9.33) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.9.33) ? | WF_LINK_SEARCH_TITLE (2.9.33) ? |
Components :: Admin ::
Core :: com_plugins (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_modules (3.0.0) 1 | com_associations (3.7.0) 1 | com_cpanel (3.0.0) 1 | com_messages (3.0.0) 1 | com_config (3.0.0) 1 | com_admin (3.0.0) 1 | com_finder (3.0.0) 1 | com_ajax (3.2.0) 1 | com_media (3.0.0) 1 | com_redirect (3.0.0) 1 | com_banners (3.0.0) 1 | com_cache (3.0.0) 1 | com_fields (3.7.0) 1 | com_users (3.0.0) 1 | com_content (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_contenthistory (3.2.0) 1 | com_joomlaupdate (3.10.1) 1 | com_languages (3.0.0) 1 | com_templates (3.0.0) 1 | com_checkin (3.0.0) 1 | com_search (3.0.0) 1 | com_installer (3.0.0) 1 | com_privacy (3.9.0) 1 | com_tags (3.1.0) 1 | com_categories (3.0.0) 1 | com_newsfeeds (3.0.0) 1 | com_menus (3.0.0) 1 | com_login (3.0.0) 1 |
3rd Party:: Akeeba (8.2.7) 1 | BaForms (2.0.0) 1 | com_rsform (3.1.7) 1 | BaGallery (2.3.0) 1 | COM_JCE (2.9.33) 1 | GRIDBOX (2.12.12) 1 |
Modules :: Site ::
Core :: mod_whosonline (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_search (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_login (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_articles_news (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_languages (3.5.0) 1 | mod_banners (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_finder (3.0.0) 1 |
3rd Party::
Modules :: Admin ::
Core :: mod_submenu (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_version (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_status (3.0.0) 1 | mod_title (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_login (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_menu (3.0.0) 1 | mod_popular (3.0.0) 1 |
3rd Party::
Libraries ::
Core ::
3rd Party:: file_fof30 (3.6.2) ? | file_fof40 (4.1.0) ? |
Plugins ::
Core :: plg_privacy_message (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_eos310 (3.10.0) 1 | plg_user_terms (3.9.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_content_pagenavigation (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_content_vote (3.0.0) 0 | plg_content_finder (3.0.0) 0 | plg_content_loadmodule (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.0 | plg_system_updatenotification (3.5.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_p3p (3.0.0) 0 | plg_system_sessiongc (3.8.6) 1 | plg_system_sef (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_cache (3.0.0) 0 | plg_system_highlight (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_logout (3.0.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 |
3rd Party:: plg_editors_codemirror (5.60.0) 1 | plg_editors_tinymce (4.5.12) 1 | plg_editors_jce (2.9.33) 1 | plg_quickicon_jce (2.9.33) 1 | plg_quickicon_akeebabackup (8.2.7) 0 | plg_installer_rsform (1.0.0) 1 | plg_installer_jce (2.9.33) 1 | PLG_INSTALLER_AKEEBABACKUP (8.2.7) 1 | plg_fields_mediajce (2.9.33) 1 | plg_extension_jce (2.9.33) 1 | Gridbox - Search (2.12.1) 1 | BaGallery - Shortcode (2.3.0) 1 | BaForms - Shortcode (2.0.0) 1 | Gridbox - Smart Search (2.12.7) 1 | plg_content_jce (2.9.33) 1 | PLG_ACTIONLOG_AKEEBABACKUP (8.2.7) 0 | plg_system_jce (2.9.33) 1 | System - RSForm! Pro Delete Submiss (1.0.0) ? | BaGallery - System (2.3.0) 1 | Gridbox - System (2.12.1 | plg_system_jcemediabox (2.1.2) 0 | BaForms - System (2.0.0) 1 | PLG_SYSTEM_BACKUPONUPDATE (8.2.7) 1 |
Templates Discovered :: wrote:Templates :: Site :: beez3 (3.1.0) 1 | protostar (1.0) 1 | Gridbox (2.12.12) 1 |
Templates :: Admin :: hathor (3.0.0) 1 | isis (1.0) 1 |
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
-
- Joomla! Explorer
- Posts: 258
- Joined: Thu Jun 10, 2010 12:38 pm
- Contact:
Re: Database error - Missing table
Session Path Writeable is currently "No" and should be "Yes"
-
- Joomla! Explorer
- Posts: 426
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: Database error - Missing table
The /tmp directory is set to 755 and 'Path to Temp Folder' is set correctly in Global Settings.
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
-
- Joomla! Explorer
- Posts: 426
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: Database error - Missing table
I'm plainly missing something here
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
-
- Joomla! Explorer
- Posts: 258
- Joined: Thu Jun 10, 2010 12:38 pm
- Contact:
Re: Database error - Missing table
Your hosting company can help with changing the Session Path Writeable from no to yes - it is a server issue.
-
- Joomla! Explorer
- Posts: 426
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: Database error - Missing table
Sadly my hosting is on a shared server and Ionos can't make the change, apparently.
I do have a number of Joomla sites on the same shared server, all running similar sets of extensions without this problem.
This website is the only website running Balbooa Gridbox. I'm beginning to think that may be the problem. Because of this issue I can't update, uninstall or disable any of the extensions.
I do have a number of Joomla sites on the same shared server, all running similar sets of extensions without this problem.
This website is the only website running Balbooa Gridbox. I'm beginning to think that may be the problem. Because of this issue I can't update, uninstall or disable any of the extensions.
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
-
- Joomla! Explorer
- Posts: 426
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: Database error - Missing table
Ok, session path is now writeable.
Any more ideas?
Any more ideas?
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
-
- Joomla! Explorer
- Posts: 426
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: Database error - Missing table
Solution found
I set the PHP back to version 7.4.1 which corrected this error.
That allowed me to access the extension updates. The offender was Balbooa Gridbox as it turns out. Once updated I could then reset the PHP back to 8.1.
Strangely, and a completely different issue, The Joomla update seems to think I have the latest version at 3.10.11 even though it's set to 'Next'.
I set the PHP back to version 7.4.1 which corrected this error.
That allowed me to access the extension updates. The offender was Balbooa Gridbox as it turns out. Once updated I could then reset the PHP back to 8.1.
Strangely, and a completely different issue, The Joomla update seems to think I have the latest version at 3.10.11 even though it's set to 'Next'.
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
- pe7er
- Joomla! Master
- Posts: 24602
- Joined: Thu Aug 18, 2005 8:55 pm
- Location: Nijmegen, Netherlands
- Contact:
Re: Database error - Missing table
Good to hear that you've solved it. Thanks for sharing your solution!
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
Peter Martin, Global Moderator
Company website: https://db8.nl - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com