Database error - Missing table Topic is solved

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
Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 434
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Database error - Missing table

Post by Donethat » Wed Jun 07, 2023 10:06 am

When trying to access any extension management or update functions I get

Missing field in database: Joomla\CMS\Table\Extension &#160; 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

Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 434
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: Database error - Missing table

Post by Donethat » Wed Jun 07, 2023 10:09 am

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 ALL
Detailed 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: No
Folder 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
Perfection is a state of mind, not reality
www.cavespider.co.uk

gws
Joomla! Champion
Joomla! Champion
Posts: 5947
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Database error - Missing table

Post by gws » Wed Jun 07, 2023 10:14 am

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.

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 24977
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: Database error - Missing table

Post by pe7er » Wed Jun 07, 2023 10:20 am

The 160 in your error is not related to ID 160.
&#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.
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com

Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 434
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: Database error - Missing table

Post by Donethat » Tue Jun 13, 2023 3:17 pm

Thanks for the responses guys

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 ALL
Detailed 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: No
Folder 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.8) 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.8) 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

gsmela
Joomla! Explorer
Joomla! Explorer
Posts: 289
Joined: Thu Jun 10, 2010 12:38 pm
Contact:

Re: Database error - Missing table

Post by gsmela » Tue Jun 13, 2023 3:22 pm

Session Path Writeable is currently "No" and should be "Yes"

Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 434
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: Database error - Missing table

Post by Donethat » Tue Jun 13, 2023 3:39 pm

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

Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 434
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: Database error - Missing table

Post by Donethat » Tue Jun 13, 2023 3:42 pm

I'm plainly missing something here
Perfection is a state of mind, not reality
www.cavespider.co.uk

gsmela
Joomla! Explorer
Joomla! Explorer
Posts: 289
Joined: Thu Jun 10, 2010 12:38 pm
Contact:

Re: Database error - Missing table

Post by gsmela » Tue Jun 13, 2023 3:49 pm

Your hosting company can help with changing the Session Path Writeable from no to yes - it is a server issue.

Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 434
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: Database error - Missing table

Post by Donethat » Wed Jun 14, 2023 9:20 am

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.
Perfection is a state of mind, not reality
www.cavespider.co.uk

Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 434
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: Database error - Missing table

Post by Donethat » Wed Jun 14, 2023 10:24 am

Ok, session path is now writeable.

Any more ideas?
Perfection is a state of mind, not reality
www.cavespider.co.uk

Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 434
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: Database error - Missing table

Post by Donethat » Tue Jun 27, 2023 8:55 am

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'.
Perfection is a state of mind, not reality
www.cavespider.co.uk

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 24977
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: Database error - Missing table

Post by pe7er » Tue Jun 27, 2023 8:56 am

Good to hear that you've solved it. Thanks for sharing your solution!
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com


Post Reply

Return to “Administration Joomla! 3.x”