Broken site after upgrade from 4.4.1

Need help upgrading your Joomla! website or converting to Joomla! 5.x?

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
Grastorp
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun Nov 18, 2018 4:56 pm

Broken site after upgrade from 4.4.1

Post by Grastorp » Tue Dec 05, 2023 6:43 pm

Hi,
I have managed to stay out of trouble with our Joomla for some years doing upgrades when available. Now I did the classic mistake of not do a backup before upgrading to v5.0.1. No, I don't even have an old backup any longer (that's not so bright). I have tried to find advice online but not found anything that I think is relevant.

I have done the FPA.
We are hosted on one.com.

Is there a missing column in the database?
Any advice on how to fix the installation?
Forum Post Assistant (v1.6.6) : 5-Dec-2023 wrote:
Problem Description :: wrote:HTTP 500 Whoops, looks like something went wrong.
Log/Error Message :: wrote:Unknown column 'a.ordering' in 'order clause'
Basic Environment :: wrote:Joomla! Instance :: Joomla! 5.0.1-Stable (Kuboresha) 28-November-2023
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: maximum | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 5.0.1: Yes | Database Supports J! 5.0.1: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 5.15.0-75-generic | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 84820.17 GiB |

PHP Configuration :: Version: 8.1.26 | PHP API: cgi-fcgi | Session Path Writable: No | Display Errors: 0 | Error Reporting: 24567 | Log Errors To: | 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: 60 | Max. Execution Time: 300 | Memory Limit: 536870912

Database Configuration :: Version: 10.6.15-MariaDB-1:10.6.15+maria~ubu2204 (Client:mysqlnd 8.1.26) | Database Size: 10.52 MiB | #of Tables with config prefix:  78 | #of other Tables:  0 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (8.1.26) | date (8.1.26) | libxml (8.1.26) | openssl (8.1.26) | pcre (8.1.26) | sqlite3 (8.1.26) | zlib (8.1.26) | bcmath (8.1.26) | bz2 (8.1.26) | calendar (8.1.26) | ctype (8.1.26) | curl (8.1.26) | dba (8.1.26) | dom (20031129) | hash (8.1.26) | fileinfo (8.1.26) | filter (8.1.26) | gd (8.1.26) | gettext (8.1.26) | json (8.1.26) | iconv (8.1.26) | SPL (8.1.26) | intl (8.1.26) | session (8.1.26) | mbstring (8.1.26) | standard (8.1.26) | mysqlnd (mysqlnd 8.1.26) | exif (8.1.26) | mysqli (8.1.26) | PDO (8.1.26) | pdo_mysql (8.1.26) | pdo_sqlite (8.1.26) | Phar (8.1.26) | readline (8.1.26) | Reflection (8.1.26) | imap (8.1.26) | SimpleXML (8.1.26) | soap (8.1.26) | sodium (8.1.26) | sysvshm (8.1.26) | tokenizer (8.1.26) | xml (8.1.26) | xmlreader (8.1.26) | xmlwriter (8.1.26) | xsl (8.1.26) | zip (1.19.5) | cgi-fcgi (8.1.26) | imagick (3.7.0) | Zend OPcache (8.1.26) | Zend Engine (4.1.26) |
Potential Missing Extensions ::
Disabled Functions :: disk_total_space | diskfreespace | exec | system | popen | proc_open | proc_nice | shell_exec | passthru | dl |

Switch User Environment :: PHP CGI: Yes | Server SU: No | PHP SU: Yes | Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (---) | api/ (755) |

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 8935482 | Threads: 55 | Questions: 3886929641 | Slow queries: 92954 | Opens: 14143904 | Open tables: 24574 | Queries per second avg: 434.999 |
Extensions Discovered :: wrote:Components :: Site ::
Core ::
3rd Party::

Components :: Admin ::
Core :: com_actionlogs (3.9.0) 1 | com_admin (4.0.0) 1 | com_ajax (4.0.0) 1 | com_associations (4.0.0) 1 | com_banners (4.0.0) 1 | com_cache (4.0.0) 1 | com_categories (4.0.0) 1 | com_checkin (4.0.0) 1 | com_config (4.0.0) 1 | com_content (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_fields (4.0.0) 1 | com_finder (4.0.0) 1 | com_installer (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_languages (4.0.0) 1 | com_login (4.0.0) 1 | com_media (3.0.0) 1 | com_menus (4.0.0) 1 | com_messages (4.0.0) 1 | com_modules (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_plugins (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_privacy (3.9.0) 1 | com_redirect (4.0.0) 1 | com_search (4.0.0-dev) 1 | com_tags (4.0.0) 1 | com_templates (4.0.0) 1 | com_users (4.0.0) 1 | com_weblinks (4.3.1) 1 | com_mails (4.0.0) 1 | com_scheduler (4.1.0) 1 | com_workflow (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_guidedtours (4.3.0) 1 |
3rd Party:: com_joooid (1.2.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 (4.0.0-dev) 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_weblinks (4.3.1) 1 | mod_whosonline (3.0.0) 1 | mod_wrapper (3.0.0) 1 |
3rd Party:: Nivo-Szaki Slider (1.0) 1 |

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_submenu (3.0.0) 1 | mod_title (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_version (3.0.0) 1 | mod_frontend (4.0.0) 1 | mod_loginsupport (4.0.0) 1 | mod_messages (4.0.0) 1 | mod_post_installation_messages (4.0.0) 1 | mod_privacy_status (4.0.0) 1 | mod_user (4.0.0) 1 | mod_guidedtours (4.3.0) 1 |
3rd Party::

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_captcha_recaptcha (3.4.0) 1 | 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_geshi (2.5.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) 1 | 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_editors-xtd_weblink (4.3.1) 0 | plg_extension_joomla (3.0.0) 1 | plg_extension_finder (4.0.0) 1 | plg_extension_namespacemap (4.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_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_fields_subform (4.0.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_finder_weblinks (4.3.1) 1 | plg_installer_folderinstaller (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_override (4.0.0) 1 | plg_installer_webinstaller (4.0.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_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_quickicon_eos (4.4.0) 1 | plg_quickicon_downloadkey (4.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_search_categories (4.0.0-dev) 1 | plg_search_contacts (4.0.0-dev) 1 | plg_search_content (4.0.0-dev) 1 | plg_search_newsfeeds (4.0.0-dev) 1 | plg_search_tags (4.0.0-dev) 0 | plg_search_weblinks (4.3.1) 1 | plg_system_actionlogs (3.9.0) 0 | 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_shortcut (4.2.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_redirect (3.0.0) 1 | 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) 0 | plg_system_updatenotification (3.5.0) 1 | plg_system_weblinks (4.3.1) 0 | plg_system_accessibility (4.0.0) 0 | plg_system_httpheaders (4.0.0) 0 | plg_system_jooa11y (4.2.0) 1 | plg_system_schedulerunner (4.1) 1 | plg_system_skipto (4.0.0) 1 | plg_system_task_notification (4.1) 1 | plg_system_webauthn (4.0.0) 1 | plg_system_guidedtours (4.3.0) 1 | plg_system_schemaorg (5.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 | plg_user_token (3.9.0) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_api-authentication_token (4.0.0) 1 | plg_behaviour_taggable (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_behaviour_compat (5.0.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_task_check_files (4.1) 1 | plg_task_demo_tasks (4.1) 1 | plg_task_requests (4.1) 1 | plg_task_site_status (4.1) 1 | plg_task_deleteactionlogs (5.0.0) ? | plg_task_globalcheckin (5.0.0) ? | plg_task_privacyconsent (5.0.0) ? | plg_task_rotatelogs (5.0.0) ? | plg_task_sessiongc (5.0.0) ? | plg_task_updatenotification (5.0.0) ? | plg_webservices_banners (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_webservices_media (4.1.0) 1 | plg_webservices_menus (4.0.0) 1 | plg_webservices_messages (4.0.0) 1 | plg_webservices_modules (4.0.0) 1 | plg_webservices_newsfeeds (4.0.0) 1 | plg_webservices_plugins (4.0.0) 1 | plg_webservices_privacy (4.0.0) 1 | plg_webservices_redirect (4.0.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_users (4.0.0) 1 | plg_workflow_featuring (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 | plg_multifactorauth_webauthn (4.2.0) 0 | plg_multifactorauth_yubikey (3.2.0) 0 | plg_multifactorauth_email (4.2.0) 0 | plg_multifactorauth_totp (3.2.0) 0 | plg_multifactorauth_fixed (4.2.0) 0 | plg_schemaorg_blogposting (5.0.0) ? | plg_schemaorg_book (5.0.0) ? | plg_schemaorg_event (5.0.0) ? | plg_schemaorg_jobposting (5.0.0) ? | plg_schemaorg_organization (5.0.0) ? | plg_schemaorg_person (5.0.0) ? | plg_schemaorg_recipe (5.0.0) ? |
3rd Party:: plg_editors_codemirror (6.0.0) 1 | plg_editors_tinymce (6.7.3) 1 | Joooid XMLRPC (1.2.0) 1 |
Templates Discovered :: wrote:Templates :: Site :: art-blog-1.6 (2.0) 1 | beez5 (2.5.0) 1 | beez_20 (2.5.0) 1 | CodeGravityblue (1.0.0) 1 | J51_Oxygen (1.0) 1 | officeten1.6 (1.6.0) 0 | cassiopeia (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |
Last edited by imanickam on Tue Dec 05, 2023 6:49 pm, edited 1 time in total.
Reason: Disabled Smilies

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30697
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Broken site after upgrade from 4.4.1

Post by Per Yngve Berg » Tue Dec 05, 2023 7:18 pm

Mod. Note: Relocated topic from Installation to the Upgrade Forum.

You have a bunch of ancient templates installed.

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2533
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Broken site after upgrade from 4.4.1

Post by ceford » Wed Dec 06, 2023 9:00 am

Can you login to the backend? If so, go to Global Configuration and set Debug System to Yes and Error Reporting to Maximum. If not, edit configuration.php with a text editor (first set permissions to 644) and set public $debug = true;
and public $error_reporting = 'maximum';

Then trigger the error and take a screenshot of the Stack Trace to post here. It should indicate which extension triggered the error. You can then find and disable it.

Grastorp
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun Nov 18, 2018 4:56 pm

Re: Broken site after upgrade from 4.4.1

Post by Grastorp » Wed Dec 06, 2023 2:50 pm

Login accepts user and password but then it stops with the error message below.
I tried with $debug = '1' and maximum. Stopped at the same place.
One section was opened by default. Do you want to see the other as well?

CTRL+A gives this:

mysqli_sql_exception
HTTP 500 Whoops, looks like something went wrong.
Unknown column 'a.ordering' in 'order clause'
mysqli_sql_exception
Show exception properties
in /customers/b/8/1/gpsk.se/httpd.www/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php (line 138)
in /customers/b/8/1/gpsk.se/httpd.www/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php -> prepare (line 138)
in /customers/b/8/1/gpsk.se/httpd.www/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> __construct (line 1020)
in /customers/b/8/1/gpsk.se/httpd.www/libraries/vendor/joomla/database/src/DatabaseDriver.php -> prepareStatement (line 1785)
DatabaseDriver->setQuery(object(MysqliQuery)) in /customers/b/8/1/gpsk.se/httpd.www/administrator/components/com_menus/src/Helper/MenusHelper.php (line 816)

if ($iJoin) {
$query->join('INNER', $iJoin);
}
$results = $db->setQuery($query)->loadObjectList(); <--- this line highlighted
// Skip the entire group if no items to iterate over.
if ($results) {
// Show the repeatable group heading node only if not set as hidden.
if (!$hidden) {

MenusHelper::loadXml(object(SimpleXMLElement), object(AdministratorMenuItem), array()) in /customers/b/8/1/gpsk.se/httpd.www/administrator/components/com_menus/src/Helper/MenusHelper.php (line 841)
MenusHelper::loadXml(object(SimpleXMLElement), object(AdministratorMenuItem)) in /customers/b/8/1/gpsk.se/httpd.www/administrator/components/com_menus/src/Helper/MenusHelper.php (line 673)
MenusHelper::loadPreset('default') in /customers/b/8/1/gpsk.se/httpd.www/administrator/modules/mod_menu/src/Menu/CssMenu.php (line 121)
CssMenu->load(object(Registry), true) in /customers/b/8/1/gpsk.se/httpd.www/administrator/modules/mod_menu/mod_menu.php (line 19)
include('/customers/b/8/1/gpsk.se/httpd.www/administrator/modules/mod_menu/mod_menu.php') in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Dispatcher/ModuleDispatcher.php (line 52)
ModuleDispatcher::Joomla\CMS\Dispatcher\{closure}('/customers/b/8/1/gpsk.se/httpd.www/administrator/modules/mod_menu/mod_menu.php', null) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Dispatcher/ModuleDispatcher.php (line 55)
ModuleDispatcher->dispatch() in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Helper/ModuleHelper.php (line 291)
ModuleHelper::renderRawModule(object(stdClass), object(Registry), array('name' => 'menu', 'style' => 'none')) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Helper/ModuleHelper.php (line 162)
ModuleHelper::renderModule(object(stdClass), array('name' => 'menu', 'style' => 'none')) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Document/Renderer/Html/ModuleRenderer.php (line 99)
ModuleRenderer->render(object(stdClass), array('name' => 'menu', 'style' => 'none'), null) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Document/Renderer/Html/ModulesRenderer.php (line 51)
ModulesRenderer->render('menu', array('name' => 'menu', 'style' => 'none'), null) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Document/HtmlDocument.php (line 575)
HtmlDocument->getBuffer('modules', 'menu', array('name' => 'menu', 'style' => 'none')) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Document/HtmlDocument.php (line 894)
HtmlDocument->_renderTemplate() in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Document/HtmlDocument.php (line 647)
HtmlDocument->render(false, array('template' => 'atum', 'directory' => '/customers/b/8/1/gpsk.se/httpd.www/administrator/templates', 'debug' => '1', 'csp_nonce' => null, 'templateInherits' => '', 'params' => object(Registry), 'file' => 'error.php')) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Document/ErrorDocument.php (line 139)
ErrorDocument->render(false, array('template' => 'atum', 'directory' => '/customers/b/8/1/gpsk.se/httpd.www/administrator/templates', 'debug' => '1', 'csp_nonce' => null, 'templateInherits' => '', 'params' => object(Registry), 'file' => 'error.php')) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Error/Renderer/HtmlRenderer.php (line 78)
HtmlRenderer->render(object(mysqli_sql_exception)) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Exception/ExceptionHandler.php (line 136)
ExceptionHandler::render(object(mysqli_sql_exception)) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Exception/ExceptionHandler.php (line 73)
ExceptionHandler::handleException(object(mysqli_sql_exception)) in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Application/CMSApplication.php (line 336)
CMSApplication->execute() in /customers/b/8/1/gpsk.se/httpd.www/administrator/includes/app.php (line 58)
require_once('/customers/b/8/1/gpsk.se/httpd.www/administrator/includes/app.php') in /customers/b/8/1/gpsk.se/httpd.www/administrator/index.php (line 32)
mysqli_sql_exception

Unknown column 'a.ordering' in 'order clause'

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2533
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Broken site after upgrade from 4.4.1

Post by ceford » Wed Dec 06, 2023 4:16 pm

This post is describes a similar problem: https://github.com/joomla/joomla-cms/issues/41639

Can you open administrator/logs/joomla_update.php with a text editor and look down towards the end to see how the update went. It could be that an essential sql statement was not executed. This may be the one:

Code: Select all

ALTER TABLE `#__menu_types` ADD COLUMN `ordering` int NOT NULL DEFAULT 0 AFTER `client_id` /** CAN FAIL **/;
UPDATE `#__menu_types` SET `ordering` = `id` WHERE `client_id` = 0;
So have a look in your menu_types table to see if the ordering column is present.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 43900
Joined: Sat Apr 05, 2008 9:58 pm

Re: Broken site after upgrade from 4.4.1

Post by Webdongle » Wed Dec 06, 2023 4:19 pm

Session Path Writable: No should be yes ... talk to your Host
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

Grastorp
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun Nov 18, 2018 4:56 pm

Re: Broken site after upgrade from 4.4.1

Post by Grastorp » Wed Dec 06, 2023 7:29 pm

Log file found in logs/joomla_update.php

This is at the end:
2023-12-01T14:52:16+00:00 INFO 85.24.253.3 update Test logging
2023-12-01T14:52:16+00:00 INFO 85.24.253.3 update Update started by user XXXXX (45). Old version is 4.4.1.
2023-12-01T14:52:18+00:00 INFO 85.24.253.3 update Downloading update file from https://s3-us-west-2.amazonaws.com/joom ... b233384f03.
2023-12-01T14:52:22+00:00 INFO 85.24.253.3 update File Joomla_5.0.1-Stable-Update_Package.zip downloaded.
2023-12-01T14:52:22+00:00 INFO 85.24.253.3 update Starting installation of new version.
2023-12-01T14:54:27+00:00 INFO 85.24.253.3 update Starting installation of new version.
Only starting the installation.
Not finalising or any SQL updates.

I seem to be worse off than in the post from github.com.

Is it possible to run something or upload files to fix this?

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 43900
Joined: Sat Apr 05, 2008 9:58 pm

Re: Broken site after upgrade from 4.4.1

Post by Webdongle » Wed Dec 06, 2023 8:09 pm

http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2533
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Broken site after upgrade from 4.4.1

Post by ceford » Wed Dec 06, 2023 8:47 pm

Look in administrator/components/com_admin/sql/updates/mysql - there should be 10 sql files. You need to find out if any have been executed and if not, execute them. For example, the first one has this:

Code: Select all

DROP TABLE IF EXISTS `#__utf8_conversion`;
So check to see if you have that table in your database.

The next one has this:

Code: Select all

DELETE FROM `#__scheduler_tasks` WHERE `type` = 'demoTask_r1.sleep';
So look in that table to see if that task has been deleted. And so on.

If you can fix the database problems like this you may be able to login. Probably a good idea to take a database backup now before trying this.

Grastorp
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun Nov 18, 2018 4:56 pm

Re: Broken site after upgrade from 4.4.1

Post by Grastorp » Thu Dec 07, 2023 8:15 pm

ceford wrote:
Wed Dec 06, 2023 8:47 pm
Look in administrator/components/com_admin/sql/updates/mysql - there should be 10 sql files. You need to find out if any have been executed and if not, execute them. For example, the first one has this:

Code: Select all

DROP TABLE IF EXISTS `#__utf8_conversion`;
So check to see if you have that table in your database.

The next one has this:

Code: Select all

DELETE FROM `#__scheduler_tasks` WHERE `type` = 'demoTask_r1.sleep';
So look in that table to see if that task has been deleted. And so on.

If you can fix the database problems like this you may be able to login. Probably a good idea to take a database backup now before trying this.
Thank you for this!
I have executed all SQL files in the folder. Some didn't affect and some did.
I can now access the backend again!

I have this warning
Warning: set_time_limit(): Cannot set max execution time limit due to system policy in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Filesystem/Folder.php on line 574 Warning: set_time_limit(): Cannot set max execution time limit due to system policy in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Filesystem/Folder.php on line 574 Warning: set_time_limit(): Cannot set max execution time limit due to system policy in /customers/b/8/1/gpsk.se/httpd.www/libraries/src/Filesystem/Folder.php on line 574
Any idea to solve this?

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 17256
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

Re: Broken site after upgrade from 4.4.1

Post by toivo » Thu Dec 07, 2023 8:26 pm

The policy blocking the use of the native PHP function set_time_limit() has been set by your host. Contact your host.
Toivo Talikka, Global Moderator

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2533
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Broken site after upgrade from 4.4.1

Post by ceford » Thu Dec 07, 2023 9:28 pm

Where do you see the warning about set_time_limit? There are 35 instances of the function in core code but most have a check for the function existence and others try to suppress the error. It could be the Smart Search component or perhaps a third party extension.

Grastorp
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun Nov 18, 2018 4:56 pm

Re: Broken site after upgrade from 4.4.1

Post by Grastorp » Thu Dec 07, 2023 9:34 pm

toivo wrote:
Thu Dec 07, 2023 8:26 pm
The policy blocking the use of the native PHP function set_time_limit() has been set by your host. Contact your host.
Thanks you, Toivo!
I'll contact one.com and see what they say about this.

Grastorp
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun Nov 18, 2018 4:56 pm

Re: Broken site after upgrade from 4.4.1

Post by Grastorp » Thu Dec 07, 2023 9:39 pm

ceford wrote:
Thu Dec 07, 2023 9:28 pm
Where do you see the warning about set_time_limit? There are 35 instances of the function in core code but most have a check for the function existence and others try to suppress the error. It could be the Smart Search component or perhaps a third party extension.
I see this when I log into backend. On the left side, between Toggle menu and Home dashboard. When I go to System Dashboard it is removed from the left side and is shown in main window.

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2533
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Broken site after upgrade from 4.4.1

Post by ceford » Thu Dec 07, 2023 10:20 pm

Disable the joooid component and plugin and see what that does.

Grastorp
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun Nov 18, 2018 4:56 pm

Re: Broken site after upgrade from 4.4.1

Post by Grastorp » Sun Dec 10, 2023 2:14 pm

I have disabled joooid and nothing notable changed.

When I click on System and Site Template I get error:
An error has occurred.

0 Call to a member function get() on bool

Call Stack
# Function Location
1 () JROOT/administrator/components/com_templates/tmpl/templates/default.php:99
2 include() JROOT/libraries/src/MVC/View/HtmlView.php:416
3 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:204
4 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_templates/src/View/Templates/HtmlView.php:125
5 Joomla\Component\Templates\Administrator\View\Templates\HtmlView->display() JROOT/libraries/src/MVC/Controller/BaseController.php:697
6 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_templates/src/Controller/DisplayController.php:68
7 Joomla\Component\Templates\Administrator\Controller\DisplayController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:730
8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:143
9 Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
10 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:150
11 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:195
12 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:306
13 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:58
14 require_once() JROOT/administrator/index.php:32
Per Yngve Berg mentioned that I have a lot of ancient templates installed. Would they have been listed in Site Templates?

Can "Reinstall Joomla! core files" help fix this problem?

Thanks!

Grastorp
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun Nov 18, 2018 4:56 pm

Re: Broken site after upgrade from 4.4.1

Post by Grastorp » Sun Dec 10, 2023 2:20 pm

In Content I can access my articles but Media is empty.

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2533
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Broken site after upgrade from 4.4.1

Post by ceford » Sun Dec 10, 2023 4:37 pm

In your FPA report the list of templates has beez in bold - that probably means it is the default template. Open your database with phpMyAdmin and look at the template_styles table. Set the home value for both atum and cassiopeia to 1 and all others to 0.

User avatar
JAVesey
Joomla! Hero
Joomla! Hero
Posts: 2594
Joined: Tue May 14, 2013 1:21 pm
Location: Cardiff, Wales, UK
Contact:

Re: Broken site after upgrade from 4.4.1

Post by JAVesey » Sun Dec 10, 2023 8:22 pm

ceford wrote:
Sun Dec 10, 2023 4:37 pm
In your FPA report the list of templates has beez in bold - that probably means it is the default template. Open your database with phpMyAdmin and look at the template_styles table. Set the home value for both atum and cassiopeia to 1 and all others to 0.
Those old Joomla-installed templates should be long gone, removed by upgrade processes. I'm talking about the (2.5.0) ones. Uninstall them.
John V
Cardiff, Wales, UK
Joomla 5.0.3 "live" site on PHP 8.2.15 and MariaDB 10.11.6
Joomla 5.0.3 on XAMMP for OSX with PHP 8.2.4 and MariaDB 10.4.28

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 43900
Joined: Sat Apr 05, 2008 9:58 pm

Re: Broken site after upgrade from 4.4.1

Post by Webdongle » Sun Dec 10, 2023 8:29 pm

Depending on how many pages you have it could be quicker and cleaner to
Install a fresh Joomla
Recreate the Articles by copy/paste (via Notepad++) from the old to the new

It might save time the next time you update as well.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".


Post Reply

Return to “Migrating and Upgrading to Joomla! 5.x”