Can't update to Joomla 4 - table _user_mfa missing

[astrodene]

I've been trying to update a site thats been going since Joomla 1 from ver 3 to 4 but I get constant crashes. I clear files & db before restore and have deleted or disabled extentions where needed but still crashes. Working on a copy of the site in temporary environment. Any help would be appreciated

Debug report & FPA analysis below


Warning
JInstaller: :Install: Error SQL Field 'extra_params' doesn't have a default value
An error has occurred.
1146 Table 'dbb2j4rk2qws8c.wso41_user_mfa' doesn't exist
Call stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:442
2 Joomla\Database\Mysqli\MysqliStatement->execute() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:675
3 Joomla\Database\DatabaseDriver->execute() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1375
4 Joomla\Database\DatabaseDriver->loadObjectList() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625
5 Joomla\Database\Mysqli\MysqliDriver->getTableColumns() JROOT/libraries/src/Table/Table.php:248
6 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:193
7 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_users/src/Table/MfaTable.php:90
8 Joomla\Component\Users\Administrator\Table\MfaTable->__construct() JROOT/libraries/src/Application/MultiFactorAuthenticationHandler.php:404
9 Joomla\CMS\Application\AdministratorApplication->migrateFromLegacyMFA() JROOT/libraries/src/Application/MultiFactorAuthenticationHandler.php:99
10 Joomla\CMS\Application\AdministratorApplication->isHandlingMultiFactorAuthentication() JROOT/libraries/src/Application/AdministratorApplication.php:450
11 Joomla\CMS\Application\AdministratorApplication->route() JROOT/libraries/src/Application/AdministratorApplication.php:171
12 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293
13 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61
14 require_once() JROOT/administrator/index.php:32
Previous Error

Table 'dbb2j4rk2qws8c.wso41_user_mfa' doesn't exist

Call stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:437
2 Joomla\Database\Mysqli\MysqliStatement->execute() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:675
3 Joomla\Database\DatabaseDriver->execute() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1375
4 Joomla\Database\DatabaseDriver->loadObjectList() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625
5 Joomla\Database\Mysqli\MysqliDriver->getTableColumns() JROOT/libraries/src/Table/Table.php:248
6 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:193
7 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_users/src/Table/MfaTable.php:90
8 Joomla\Component\Users\Administrator\Table\MfaTable->__construct() JROOT/libraries/src/Application/MultiFactorAuthenticationHandler.php:404
9 Joomla\CMS\Application\AdministratorApplication->migrateFromLegacyMFA() JROOT/libraries/src/Application/MultiFactorAuthenticationHandler.php:99
10 Joomla\CMS\Application\AdministratorApplication->isHandlingMultiFactorAuthentication() JROOT/libraries/src/Application/AdministratorApplication.php:450
11 Joomla\CMS\Application\AdministratorApplication->route() JROOT/libraries/src/Application/AdministratorApplication.php:171
12 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293
13 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61
14 require_once() JROOT/administrator/index.php:32

[23-Sep-2023 17:41:19 CST6CDT] PHP Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /home/customer/www/davidh559.sg-host.com/public_html/fpa-en.php on line 6837

Joomla! Instance :: Joomla! 4.3.4-Stable (Bora) 22-August-2023
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: No (ReWrite Enabled but no .htaccess?) | GZip: true | Cache: true | 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: maximum | Site Debug: true | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.3.4: Yes | Database Supports J! 4.3.4: Yes | Database Credentials Present: Yes |

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

PHP Configuration :: Version: 8.0.30 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 30709 | Log Errors To: php_errorlog | Last Known Error: 23rd September 2023 22:41:19. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 256M | Max. POST Size: 256M | Max. Input Time: 120 | Max. Execution Time: 120 | Memory Limit: 768M

Database Configuration :: Version: 5.7.39-42-log (Client:mysqlnd 8.0.30) | Database Size: 124.28 MiB | #of Tables with config prefix:  161 | #of other Tables:  6 | User Privileges : GRANT ALL

PHP Extensions :: Core (8.0.30) | date (8.0.30) | libxml (8.0.30) | openssl (8.0.30) | pcre (8.0.30) | sqlite3 (8.0.30) | zlib (8.0.30) | bcmath (8.0.30) | bz2 (8.0.30) | calendar (8.0.30) | ctype (8.0.30) | curl (8.0.30) | dba (8.0.30) | dom (20031129) | enchant (8.0.30) | hash (8.0.30) | fileinfo (8.0.30) | filter (8.0.30) | ftp (8.0.30) | gd (8.0.30) | gettext (8.0.30) | gmp (8.0.30) | SPL (8.0.30) | iconv (8.0.30) | session (8.0.30) | intl (8.0.30) | json (8.0.30) | mbstring (8.0.30) | standard (8.0.30) | mysqlnd (mysqlnd 8.0.30) | mysqli (8.0.30) | PDO (8.0.30) | pdo_mysql (8.0.30) | pdo_pgsql (8.0.30) | pdo_sqlite (8.0.30) | pgsql (8.0.30) | Phar (8.0.30) | posix (8.0.30) | pspell (8.0.30) | Reflection (8.0.30) | imap (8.0.30) | shmop (8.0.30) | SimpleXML (8.0.30) | soap (8.0.30) | sockets (8.0.30) | sodium (8.0.30) | exif (8.0.30) | sysvmsg (8.0.30) | sysvsem (8.0.30) | tidy (8.0.30) | tokenizer (8.0.30) | xml (8.0.30) | xmlreader (8.0.30) | xmlwriter (8.0.30) | xsl (8.0.30) | zip (1.19.5) | apache2handler (8.0.30) | memcached (3.2.0) | Zend OPcache (8.0.30) | Zend Engine (4.0.30-dev) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No

Apache Modules :: core | mod_authn_file | mod_authn_core | mod_authz_host | mod_authz_groupfile | mod_authz_user | mod_authz_core | mod_access_compat | mod_auth_basic | mod_so | mod_watchdog | mod_include | mod_substitute | mod_deflate | http_core | mod_mime | mod_log_config | mod_env | mod_mime_magic | mod_expires | mod_headers | mod_unique_id | mod_setenvif | mod_version | mod_slotmem_shm | event | mod_unixd | mod_autoindex | mod_cgi | mod_dir | mod_userdir | mod_alias | mod_rewrite | mod_php | mod_dtimeout | mod_filter | mod_robots | mod_rpaf | mod_simpleupdate | mod_backtrace | mod_whatkilledus | mod_idleshutdown | Apache |
Potential Missing Modules :: mod_ssl |

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) | api/ (755) |

Elevated Permissions (First 10) ::

Database statistics :: Uptime: 21642275 | Threads: 1 | Questions: 94903915 | Slow queries: 52 | Opens: 5274525 | Flush tables: 1 | Open tables: 1906 | Queries per second avg: 4.385 |

Components :: Site ::
Core ::
3rd Party::

Components :: Admin ::
Core :: com_scheduler (4.1.0) ? | com_admin (4.0.0) 1 | com_messages (4.0.0) 1 | com_content (4.0.0) 1 | com_installer (4.0.0) 1 | com_cache (4.0.0) 1 | com_users (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_workflow (4.0.0) ? | com_actionlogs (3.9.0) 1 | com_banners (4.0.0) 1 | com_search (3.0.0) 1 | com_categories (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_guidedtours (4.3.0) ? | com_privacy (3.9.0) 1 | com_cpanel (4.0.0) 1 | com_fields (4.0.0) 1 | com_media (3.0.0) 1 | com_mails (4.0.0) ? | com_checkin (4.0.0) 1 | com_modules (4.0.0) 1 | com_menus (4.0.0) 1 | com_languages (4.0.0) 1 | com_config (4.0.0) 1 | com_ajax (4.0.0) 1 | com_associations (4.0.0) 1 | com_login (4.0.0) 1 | com_redirect (4.0.0) 1 | com_plugins (4.0.0) 1 | com_finder (4.0.0) 0 | com_templates (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_wrapper (4.0.0) 1 | com_tags (4.0.0) 1 |
3rd Party:: JMap (4.15) 1 |

Modules :: Site ::
Core :: mod_users_latest (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_login (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_search (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_finder (3.0.0) 0 | mod_whosonline (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_articles_archive (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_articles_latest (3.0.0) 1 |
3rd Party:: JSitemap module (4.15) 1 |

Modules :: Admin ::
Core :: mod_latestactions (3.9.0) 1 | mod_submenu (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_login (3.0.0) 1 | mod_frontend (4.0.0) ? | mod_privacy_status (4.0.0) ? | mod_logged (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_post_installation_messages (4.0.0) ? | mod_stats_admin (3.0.0) 1 | mod_user (4.0.0) ? | mod_messages (4.0.0) ? | mod_guidedtours (4.3.0) ? | mod_version (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_title (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_loginsupport (4.0.0) ? | mod_multilangstatus (3.0.0) 1 | mod_sampledata (3.8.0) 1 |
3rd Party:: JSitemap Quickicons (4.15) 1 |

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_multifactorauth_email (4.2.0) ? | plg_multifactorauth_yubikey (3.2.0) ? | plg_multifactorauth_webauthn (4.2.0) ? | plg_multifactorauth_totp (3.2.0) ? | plg_multifactorauth_fixed (4.2.0) ? | plg_media-action_resize (4.0.0) ? | plg_media-action_crop (4.0.0) ? | plg_media-action_rotate (4.0.0) ? | plg_fields_editor (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_subform (4.0.0) ? | plg_webservices_modules (4.0.0) ? | plg_webservices_messages (4.0.0) ? | plg_webservices_languages (4.0.0) ? | plg_webservices_menus (4.0.0) ? | plg_webservices_redirect (4.0.0) ? | plg_webservices_content (4.0.0) ? | plg_webservices_media (4.1.0) ? | plg_webservices_templates (4.0.0) ? | plg_webservices_plugins (4.0.0) ? | plg_webservices_privacy (4.0.0) ? | plg_webservices_tags (4.0.0) ? | plg_webservices_config (4.0.0) ? | plg_webservices_installer (4.0.0) ? | plg_webservices_users (4.0.0) ? | plg_webservices_banners (4.0.0) ? | plg_webservices_newsfeeds (4.0.0) ? | plg_finder_contacts (3.0.0) 0 | plg_finder_content (3.0.0) 0 | plg_finder_tags (3.0.0) 0 | plg_finder_categories (3.0.0) 0 | plg_finder_newsfeeds (3.0.0) 0 | plg_api-authentication_basic (4.0.0) ? | plg_api-authentication_token (4.0.0) ? | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_vote (3.0.0) 1 | plg_content_emailcloak (3.0.0) 0 | plg_content_joomla (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_captcha_recaptcha (3.4.0) 1 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_sampledata_multilang (4.0.0) ? | plg_installer_webinstaller (4.0.0) 1 | plg_installer_folderinstaller (3.6.0) ? | plg_installer_urlinstaller (3.6.0) ? | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_override (4.0.0) ? | plg_task_site_status (4.1) ? | plg_task_demo_tasks (4.1) ? | plg_task_check_files (4.1) ? | plg_task_requests (4.1) ? | plg_filesystem_local (4.0.0) ? | plg_user_token (3.9.0) ? | plg_user_terms (3.9.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_search_contacts (3.0.0) 0 | plg_search_content (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 0 | plg_behaviour_versionable (4.0.0) ? | plg_behaviour_taggable (4.0.0) ? | plg_actionlog_joomla (3.9.0) ? | plg_extension_finder (4.0.0) ? | plg_extension_joomla (3.0.0) 1 | plg_extension_namespacemap (4.0.0) ? | plg_editors-xtd_module (3.5.0) 0 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_article (3.0.0) 0 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_system_jooa11y (4.2.0) ? | plg_system_fields (3.7.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_webauthn (4.0.0) ? | plg_system_sessiongc (3.8.6) 1 | plg_system_remember (3.0.0) 1 | plg_system_schedulerunner (4.1) ? | plg_system_redirect (3.0.0) 1 | plg_system_guidedtours (4.3.0) ? | plg_system_shortcut (4.2.0) ? | plg_system_stats (3.5.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_accessibility (4.0.0) ? | plg_system_languagefilter (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_skipto (4.0.0) ? | plg_system_sef (3.0.0) 1 | plg_system_actionlogs (3.9.0) ? | plg_system_logout (3.0.0) 1 | plg_system_httpheaders (4.0.0) ? | plg_system_logrotation (3.9.0) 1 | plg_system_privacyconsent (3.9.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_task_notification (4.1) ? | plg_workflow_notification (4.0.0) ? | plg_workflow_featuring (4.0.0) ? | plg_workflow_publishing (4.0.0) ? | plg_quickicon_downloadkey (4.0.0) ? | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_eos310 (3.10.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_overridecheck (4.0.0) ? |
3rd Party:: Content - JSitemap Pingomatic (4.15) 1 | plg_editors_tinymce (5.10.7) 1 | plg_editors_codemirror (5.65.12) 1 | System - JSitemap utilities (4.15) 1 |

Templates :: Site :: cassiopeia (1.0) ? |
Templates :: Admin :: atum (1.0) ? |

[toivo]

The last update from Joomla 3.10.12 to Joomla 4.x must have stopped before the _user_mfa table was created. The details would still be available in the update log in administrator/logs/joomla_update.php.

Use the phpMyAdmin or a similar MySQL client, available in the cPanel provided by your host, and create the _user_mfa table by running the following SQL statements, but replace 'opoox' with the table prefix from your database:

Code: Select all

CREATE TABLE `opoox_user_mfa` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `method` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `default` tinyint NOT NULL DEFAULT '0',
  `options` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_on` datetime NOT NULL,
  `last_used` datetime DEFAULT NULL,
  `tries` int NOT NULL DEFAULT '0',
  `last_try` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Multi-factor Authentication settings';

[astrodene]

Thanks for your reply. I did find a post about the file administrator/logs/joomla_update.php but the logs/directory only has an index.html file in it. For 1 attempt I created a blank file with that name but nothing was added to it.

I also tried creating the missing user_mfa table before one update try which resulted in a different item missing which inturn bounced on to another. The following were the other errors before I could not find the unknown colum in the database anywhere and gave up.

500 Table 'dbb2j4rk2qws8c.wso41_workflow_associations' doesn't exist
500 Table 'dbb2j4rk2qws8c.wso41_workflow_stages' doesn't exist
500 Table 'dbb2j4rk2qws8c.wso41_workflows' doesn't exist
500 Unknown column 'fp.featured_up' in 'field list'

[toivo]

If the new tables were not created, get all the create statements from the Joomla 4.3.4 installation package. Expand the installation folder. All the create statements are in installation/sql/mysql. Copy and paste each statement separately and replace the string '#__' with your table prefix, in my example 'opoox_'.

500 Unknown column 'fp.featured_up' in 'field list'

The columns featured_up and featured_down are in the table _content_frontpage.

Do you have a full backup of the Joomla 3 site? It could be simpler to start from scratch, remove all the Joomla 4 files, drop the database schema and create a new one, then restore the Joomla 3 site and try the update again.

Alternatively, if you run a test and development environment in your workstation, using for example Wampserver, install Akeeba Backup in the restored Joomla 3 site, create a full backup, restore it using the .jpa file and Akeeba's Kickstart utility into a virtual host in your workstation and run the update in an easy-to-manage environment.

[astrodene]

Thank you. I'll work through those options

[astrodene]

I've been working through the above suggestions from a clean install using akeeba.

That revealed a folder from a long since removed ext. which has been deleted but the update still crashes with 2 errors. current FPA and debugs below

JInstaller: :Install: Error SQL Field 'extra_params' doesn't have a default value
Unknown column 'm.publish_up' in 'where clause'

Joomla\Database\Exception\
PrepareStatementFailureException
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php (line 141)
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> __construct (line 1089)
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php -> prepareStatement (line 1900)
DatabaseDriver->setQuery(object(MysqliQuery))
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/src/Menu/SiteMenu.php (line 166)
) ->bind(':currentDate2', $currentDate) ->order($this->db->quoteName('m.lft')); $items = []; $iterator = $this->db->setQuery($query)->getIterator(); foreach ($iterator as $item) { $items[$item->id] = new MenuItem((array) $item); }
SiteMenu->Joomla\CMS\Menu\{closure}()
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/src/Cache/Controller/CallbackController.php (line 93)
CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false)
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/src/Menu/SiteMenu.php (line 179)
SiteMenu->load()
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/src/Menu/AbstractMenu.php (line 333)
AbstractMenu->getMenu()
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/src/Menu/AbstractMenu.php (line 164)
AbstractMenu->getItem(null)
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/src/Application/SiteApplication.php (line 422)
SiteApplication->getTemplate(true)
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/src/Error/Renderer/HtmlRenderer.php (line 50)
HtmlRenderer->render(object(PrepareStatementFailureException))
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/src/Exception/ExceptionHandler.php (line 126)
ExceptionHandler::render(object(PrepareStatementFailureException))
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/src/Exception/ExceptionHandler.php (line 72)
ExceptionHandler::handleException(object(PrepareStatementFailureException))
in /home/customer/www/davidh559.sg-host.com/public_html/libraries/src/Application/CMSApplication.php (line 322)
CMSApplication->execute()
in /home/customer/www/davidh559.sg-host.com/public_html/includes/app.php (line 61)
require_once('/home/customer/www/davidh559.sg-host.com/public_html/includes/app.php')
in /home/customer/www/davidh559.sg-host.com/public_html/index.php (line 32)
Joomla\Database\Exception\
PrepareStatementFailureException
Unknown column 'm.publish_up' in 'where clause'

Joomla! Instance :: Joomla! 4.3.4-Stable (Bora) 22-August-2023
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: true | Cache: true | 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: 2 | Error Reporting: maximum | Site Debug: true | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.3.4: Yes | Database Supports J! 4.3.4: Yes | Database Credentials Present: Yes |

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

PHP Configuration :: Version: 8.0.30 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 30709 | Log Errors To: php_errorlog | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 256M | Max. POST Size: 256M | Max. Input Time: 120 | Max. Execution Time: 120 | Memory Limit: 768M

Database Configuration :: Version: 5.7.39-42-log (Client:mysqlnd 8.0.30) | Database Size: 84.32 MiB | #of Tables with config prefix:  161 | #of other Tables:  6 | User Privileges : GRANT ALL

PHP Extensions :: Core (8.0.30) | date (8.0.30) | libxml (8.0.30) | openssl (8.0.30) | pcre (8.0.30) | sqlite3 (8.0.30) | zlib (8.0.30) | bcmath (8.0.30) | bz2 (8.0.30) | calendar (8.0.30) | ctype (8.0.30) | curl (8.0.30) | dba (8.0.30) | dom (20031129) | enchant (8.0.30) | hash (8.0.30) | fileinfo (8.0.30) | filter (8.0.30) | ftp (8.0.30) | gd (8.0.30) | gettext (8.0.30) | gmp (8.0.30) | SPL (8.0.30) | iconv (8.0.30) | session (8.0.30) | intl (8.0.30) | json (8.0.30) | mbstring (8.0.30) | standard (8.0.30) | mysqlnd (mysqlnd 8.0.30) | mysqli (8.0.30) | PDO (8.0.30) | pdo_mysql (8.0.30) | pdo_pgsql (8.0.30) | pdo_sqlite (8.0.30) | pgsql (8.0.30) | Phar (8.0.30) | posix (8.0.30) | pspell (8.0.30) | Reflection (8.0.30) | imap (8.0.30) | shmop (8.0.30) | SimpleXML (8.0.30) | soap (8.0.30) | sockets (8.0.30) | sodium (8.0.30) | exif (8.0.30) | sysvmsg (8.0.30) | sysvsem (8.0.30) | tidy (8.0.30) | tokenizer (8.0.30) | xml (8.0.30) | xmlreader (8.0.30) | xmlwriter (8.0.30) | xsl (8.0.30) | zip (1.19.5) | apache2handler (8.0.30) | memcached (3.2.0) | Zend OPcache (8.0.30) | Zend Engine (4.0.30-dev) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No

Apache Modules :: core | mod_authn_file | mod_authn_core | mod_authz_host | mod_authz_groupfile | mod_authz_user | mod_authz_core | mod_access_compat | mod_auth_basic | mod_so | mod_watchdog | mod_include | mod_substitute | mod_deflate | http_core | mod_mime | mod_log_config | mod_env | mod_mime_magic | mod_expires | mod_headers | mod_unique_id | mod_setenvif | mod_version | mod_slotmem_shm | event | mod_unixd | mod_autoindex | mod_cgi | mod_dir | mod_userdir | mod_alias | mod_rewrite | mod_php | mod_dtimeout | mod_filter | mod_robots | mod_rpaf | mod_simpleupdate | mod_backtrace | mod_whatkilledus | mod_idleshutdown | Apache |
Potential Missing Modules :: mod_ssl |

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) | api/ (755) |

Elevated Permissions (First 10) ::

Database statistics :: Uptime: 21725633 | Threads: 1 | Questions: 95378145 | Slow queries: 52 | Opens: 5312915 | Flush tables: 1 | Open tables: 2382 | Queries per second avg: 4.390 |

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

Components :: Admin ::
Core :: com_scheduler (4.1.0) ? | com_admin (4.0.0) 1 | com_messages (4.0.0) 1 | com_content (4.0.0) 1 | com_weblinks (3.9.0) 1 | com_installer (4.0.0) 1 | com_cache (4.0.0) 1 | com_users (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_workflow (4.0.0) ? | com_actionlogs (3.9.0) 1 | com_banners (4.0.0) 1 | com_search (3.0.0) 1 | com_categories (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_guidedtours (4.3.0) ? | com_privacy (3.9.0) 1 | com_cpanel (4.0.0) 1 | com_fields (4.0.0) 1 | com_media (3.0.0) 1 | com_mails (4.0.0) ? | com_checkin (4.0.0) 1 | com_modules (4.0.0) 1 | com_menus (4.0.0) 1 | com_languages (4.0.0) 1 | com_config (4.0.0) 1 | com_ajax (4.0.0) 1 | com_associations (4.0.0) 1 | com_login (4.0.0) 1 | com_redirect (4.0.0) 1 | com_plugins (4.0.0) 1 | com_finder (4.0.0) 0 | com_templates (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_wrapper (4.0.0) 1 | com_tags (4.0.0) 1 |
3rd Party:: PWT ACL (4.3.0) 1 | Acym (8.7.3) 1 | COM_JCE (2.9.41) 1 | JMap (4.15) 1 |

Modules :: Site ::
Core :: mod_users_latest (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_login (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_search (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_finder (3.0.0) 0 | mod_whosonline (3.0.0) 1 | mod_weblinks (3.9.0) 1 | mod_feed (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_articles_archive (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_articles_latest (3.0.0) 1 |
3rd Party:: JSitemap module (4.15) 1 | MOD_FOXCONTACT (3.4.3) ? | AcyMailing subscription form (8.7.3) 1 | ARI Data Tables (2.0.1) 1 |

Modules :: Admin ::
Core :: mod_latestactions (3.9.0) 1 | mod_submenu (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_login (3.0.0) 1 | mod_frontend (4.0.0) ? | mod_privacy_status (4.0.0) ? | mod_logged (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_post_installation_messages (4.0.0) ? | mod_stats_admin (3.0.0) 1 | mod_user (4.0.0) ? | mod_messages (4.0.0) ? | mod_guidedtours (4.3.0) ? | mod_version (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_title (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_loginsupport (4.0.0) ? | mod_multilangstatus (3.0.0) 1 | mod_sampledata (3.8.0) 1 |
3rd Party:: JSitemap Quickicons (4.15) 1 |

Libraries ::
Core ::
3rd Party:: file_fof40 (4.1.1) ? |

Plugins ::
Core :: plg_multifactorauth_email (4.2.0) ? | plg_multifactorauth_yubikey (3.2.0) ? | plg_multifactorauth_webauthn (4.2.0) ? | plg_multifactorauth_totp (3.2.0) ? | plg_multifactorauth_fixed (4.2.0) ? | plg_media-action_resize (4.0.0) ? | plg_media-action_crop (4.0.0) ? | plg_media-action_rotate (4.0.0) ? | plg_fields_editor (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_subform (4.0.0) ? | plg_webservices_modules (4.0.0) ? | plg_webservices_messages (4.0.0) ? | plg_webservices_languages (4.0.0) ? | plg_webservices_menus (4.0.0) ? | plg_webservices_redirect (4.0.0) ? | plg_webservices_content (4.0.0) ? | plg_webservices_media (4.1.0) ? | plg_webservices_templates (4.0.0) ? | plg_webservices_plugins (4.0.0) ? | plg_webservices_privacy (4.0.0) ? | plg_webservices_tags (4.0.0) ? | plg_webservices_config (4.0.0) ? | plg_webservices_installer (4.0.0) ? | plg_webservices_users (4.0.0) ? | plg_webservices_banners (4.0.0) ? | plg_webservices_newsfeeds (4.0.0) ? | plg_finder_contacts (3.0.0) 0 | plg_finder_content (3.0.0) 0 | plg_finder_tags (3.0.0) 0 | plg_finder_categories (3.0.0) 0 | plg_finder_weblinks (3.9.0) 0 | plg_finder_newsfeeds (3.0.0) 0 | plg_api-authentication_basic (4.0.0) ? | plg_api-authentication_token (4.0.0) ? | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_vote (3.0.0) 1 | plg_content_emailcloak (3.0.0) 0 | plg_content_joomla (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_captcha_recaptcha (3.4.0) 1 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_sampledata_multilang (4.0.0) ? | plg_installer_webinstaller (4.0.0) 1 | plg_installer_folderinstaller (3.6.0) ? | plg_installer_urlinstaller (3.6.0) ? | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_override (4.0.0) ? | plg_task_site_status (4.1) ? | plg_task_demo_tasks (4.1) ? | plg_task_check_files (4.1) ? | plg_task_requests (4.1) ? | plg_filesystem_local (4.0.0) ? | plg_user_token (3.9.0) ? | plg_user_terms (3.9.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_search_contacts (3.0.0) 0 | plg_search_content (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_weblinks (3.9.0) 1 | plg_search_newsfeeds (3.0.0) 0 | plg_behaviour_versionable (4.0.0) ? | plg_behaviour_taggable (4.0.0) ? | plg_actionlog_joomla (3.9.0) ? | plg_extension_finder (4.0.0) ? | plg_extension_joomla (3.0.0) 1 | plg_extension_namespacemap (4.0.0) ? | 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_editors-xtd_weblink (3.9.0) 0 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_system_jooa11y (4.2.0) ? | plg_system_fields (3.7.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_webauthn (4.0.0) ? | plg_system_sessiongc (3.8.6) 1 | plg_system_remember (3.0.0) 1 | plg_system_schedulerunner (4.1) ? | plg_system_redirect (3.0.0) 1 | plg_system_guidedtours (4.3.0) ? | plg_system_shortcut (4.2.0) ? | plg_system_stats (3.5.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_accessibility (4.0.0) ? | plg_system_languagefilter (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_skipto (4.0.0) ? | plg_system_sef (3.0.0) 1 | plg_system_actionlogs (3.9.0) ? | plg_system_logout (3.0.0) 1 | plg_system_weblinks (3.9.0) 0 | plg_system_httpheaders (4.0.0) ? | plg_system_logrotation (3.9.0) 1 | plg_system_privacyconsent (3.9.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_task_notification (4.1) ? | plg_workflow_notification (4.0.0) ? | plg_workflow_featuring (4.0.0) ? | plg_workflow_publishing (4.0.0) ? | plg_quickicon_downloadkey (4.0.0) ? | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_eos310 (3.10.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_overridecheck (4.0.0) ? |
3rd Party:: plg_fields_mediajce (2.9.41) 1 | plg_content_jce (2.9.41) 1 | Content - ARI Data Tables (1.16.0) 1 | Content - ARI Data Tables (1.16.0) 1 | AllVideos (by JoomlaWorks) (6.1.0) 1 | AllVideos (by JoomlaWorks) (6.1.0) 1 | Content - JSitemap Pingomatic (4.15) 1 | plg_installer_jce (2.9.41) 1 | AcyMailing - Search emails in Jooml (8.7.3) ? | plg_editors_jce (2.9.41) 1 | plg_editors_tinymce (5.10.7) 1 | plg_editors_codemirror (5.65.12) 1 | plg_extension_jce (2.9.41) 1 | AcyMailing - Joomla integration (8.7.3) 1 | plg_system_jce (2.9.41) 1 | System - JSitemap utilities (4.15) 1 | EASYGOOGLEANALYTICS (4.0) 1 | AcyMailing - JCE integration (8.7.3) 1 | System - PWT ACL (4.3.0) 1 | System - ARI AJAX Dispatcher (1.2.0) 1 | System - ARI AJAX Dispatcher (1.3.0) 1 | plg_quickicon_jce (2.9.41) 1 |

Templates :: Site :: cassiopeia (1.0) ? |
Templates :: Admin :: atum (1.0) ? |

[nacc]

LiveSite: Is Not Empty : see https://www.google.com/search?q=live+si ... pty+joomla for the solution.

[astrodene]

Thanks for pointing that out. updated

[nacc]

As far as the rest of your problems are concerned (because of the previously failed attempt to upgrade from Joomla 3 to Joomla 4), I agree with @toivo. It would probably be better to delete all the files in the file system, DROP all the database tables that your website uses and restore the website from the backup you make of your Joomla 3 website before you started with the migration. That's what I would do.

What you decide to do is your business, however. Good luck.

[astrodene]

I've been working through the above suggestions from a clean install

That's what I am doing. Clean install then 1. apply any fix revealed by the error log, 2.back up 3. try the update 4. delete all files and drop database 5. restore the back up then go to step one and repeat the cycle. Currently stuck at the above point

[Per Yngve Berg]

Do you upgrade from 3.10.12?

[astrodene]

Yes ! do

[Per Yngve Berg]

Disable some 3. party Plugins (Jsitemap and Acymailing)

[astrodene]

Thanks. I have now run the update with all non core extentions disabled. same error shows

[leolam]

Please roll back to Joomla 3 as it was working as you mentioned.

Before updating make sure all old tdb-ables from your previous Joomla installations have been removed as well as files and folders of old stuff.

If you have access to the server setup/root access change the Apache Handler to PHP-CGI which solves probably some permission issues.

Also I do see extensions that are not up-to-date and are not compatible with J4 I believe

You might want to hire a professional to assist you with this migration to Joomla 4. You have a big site with loads of extensions and this migration (for me it is not an upgrade) to Joomla requires descent knowledge which pros can offer to you. You might find a partner among other options at https://community.joomla.org/service-pr ... ctory.html

Leo

[astrodene]

Thanks for the advice

[marto42]

I fixit the problem with migration.
1. disable two-factor google authentication
2. create new superadministator user
3. delete all user (or users used two-factor google authentication)
4. migrate!