Page 1 of 1

Site admin throws a System Error

Posted: Wed Apr 17, 2024 7:21 am
by bec_aus
Hi, my website loads fine, however today I went to login to load the recent upgrade and I get an orange/red page with an error message. Here are the results of FPA, however they don't look right. The site works so the PHP error is misleading.

In the admin logs I see this error:
[09-Apr-2024 13:05:30 Australia/Melbourne] PHP Warning: Array to string conversion in /home/crisps/public_html/components/com_ajax/ajax.php on line 230
[17-Apr-2024 16:41:40 Australia/Melbourne] PHP Warning: Array to string conversion in /home/crisps/public_html/components/com_ajax/ajax.php on line 230

Given the dates it looks to have been there since I upgraded to 5.0.3

What do I do next?

Thanks
Brian
Forum Post Assistant (v1.6.6) : 17-Apr-2024 wrote:
Last PHP Error(s) Reported :: wrote:[17-Apr-2024 17:10:15 Australia/Melbourne] PHP Warning: session_start(): Failed to read session data: files (path: /var/cpanel/php/sessions/alt-php82) in /home/crisps/public_html/fpa-en.php on line 648
Basic Environment :: wrote:Joomla! Instance :: Joomla! 5.0.3-Stable (Kuboresha) 20-February-2024
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: N/A | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 1 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 5.0.3: No | Database Supports J! 5.0.3: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 4.18.0-513.11.1.lve.el8.x86_64 | Technology: x86_64 | Web Server: LiteSpeed | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 2113.21 GiB |

PHP Configuration :: Version: 8.3.3 | PHP API: litespeed | Session Path Writable: No | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: error_log | Last Known Error: 17th April 2024 17:10:25. | 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: 60 | Max. Execution Time: 30 | Memory Limit: 128M

Database Configuration :: Version: 8.0.36-cll-lve (Client:mysqlnd 8.3.3) | Database Size: 6.60 MiB | #of Tables with config prefix:  73 | #of other Tables:  0 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (8.3.3) | date (8.3.3) | libxml (8.3.3) | openssl (8.3.3) | pcre (8.3.3) | sqlite3 (8.3.3) | zlib (8.3.3) | bz2 (8.3.3) | calendar (8.3.3) | ctype (8.3.3) | curl (8.3.3) | hash (8.3.3) | filter (8.3.3) | ftp (8.3.3) | gettext (8.3.3) | json (8.3.3) | iconv (8.3.3) | SPL (8.3.3) | pcntl (8.3.3) | random (8.3.3) | readline (8.3.3) | Reflection (8.3.3) | session (8.3.3) | standard (8.3.3) | mbstring (8.3.3) | shmop (8.3.3) | SimpleXML (8.3.3) | tokenizer (8.3.3) | xml (8.3.3) | litespeed () | bcmath (8.3.3) | dom (20031129) | fileinfo (8.3.3) | gd (8.3.3) | gmp (8.3.3) | imap (8.3.3) | intl (8.3.3) | exif (8.3.3) | mysqlnd (mysqlnd 8.3.3) | mysqli (8.3.3) | PDO (8.3.3) | pdo_mysql (8.3.3) | pdo_sqlite (8.3.3) | Phar (8.3.3) | posix (8.3.3) | xmlreader (8.3.3) | xmlwriter (8.3.3) | xsl (8.3.3) | zip (1.22.3) | clos_ssa (1.0) | Zend Engine (4.3.3) |
Potential Missing Extensions ::

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

Elevated Permissions (First 10) :: blog/_cache/c1/ (775) | blog/_cache/c2/ (775) | blog/_cache/c3/ (775) | blog/_cache/c4/ (775) | blog/_cache/c5/ (775) | blog/_cache/general/ (775) | blog/media/blogs/a/ (775) | blog/media/blogs/b/ (775) | blog/media/blogs/fa/ (775) | blog/media/blogs/fa/quick-uploads/p100/ (775) |
Database Information :: wrote:Database statistics :: Uptime: 1389589 | Threads: 4 | Questions: 138255179 | Slow queries: 129 | Opens: 4873761 | Flush tables: 1075 | Open tables: 4000 | Queries per second avg: 99.493 |
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_guidedtours (4.3.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_mails (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_scheduler (4.1.0) 1 | com_tags (4.0.0) 1 | com_templates (4.0.0) 1 | com_users (4.0.0) 1 | com_workflow (4.0.0) 1 | com_wrapper (4.0.0) 1 |
3rd Party:: COM_N1ED (4.0.15) 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_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_frontend (4.0.0) 1 | mod_guidedtours (4.3.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_loginsupport (4.0.0) 1 | mod_menu (3.0.0) 1 | mod_messages (4.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_post_installation_messages (4.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_privacy_status (4.0.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_user (4.0.0) 1 | mod_version (3.0.0) 1 |
3rd Party::

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_api-authentication_token (4.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_behaviour_compat (4.4.0) 1 | plg_behaviour_taggable (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 1 | 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) 1 | 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_finder (4.0.0) 1 | plg_extension_joomla (3.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_subform (4.0.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_filesystem_local (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_installer_folderinstaller (3.6.0) 1 | plg_installer_override (4.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_webinstaller (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_multifactorauth_email (4.2.0) 1 | plg_multifactorauth_fixed (4.2.0) 0 | plg_multifactorauth_totp (3.2.0) 1 | plg_multifactorauth_webauthn (4.2.0) 1 | plg_multifactorauth_yubikey (3.2.0) 0 | 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_downloadkey (4.0.0) 1 | plg_quickicon_eos (4.4.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_system_accessibility (4.0.0) 0 | 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_guidedtours (4.3.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_httpheaders (4.0.0) 1 | plg_system_jooa11y (4.2.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_privacyconsent (3.9.0) 0 | plg_system_redirect (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_schedulerunner (4.1) 1 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_shortcut (4.2.0) 1 | plg_system_skipto (4.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_task_notification (4.1) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_webauthn (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_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_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 |
3rd Party:: plg_editors_codemirror (5.65.15) 1 | N1ED (4.0.15) 1 | plg_editors_tinymce (5.10.9) 1 |
Templates Discovered :: wrote:Templates :: Site :: cassiopeia (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |

Re: Site admin throws a System Error

Posted: Wed Apr 17, 2024 7:23 am
by SharkyKZ
Enable debug and post stack trace.

Re: Site admin throws a System Error

Posted: Wed Apr 17, 2024 8:57 am
by AMurray
FPA says J 5.0.3 is not supported on PHP 8.3.3.
FPA wrote: PHP Supports J! 5.0.3: No
Maybe that is not correct, I don't see why J5.x would not be supported on PHP 8.3.

J5 was released in October 2023
PHP 8.3 was released in November 2023.
FPA wrote:Session Path Writable: No
could be explain this problem:
FPA wrote:Last PHP Error(s) Reported :: wrote:
17-Apr-2024 17:10:15 Australia/Melbourne] PHP Warning: session_start(): Failed to read session data: files (path: /var/cpanel/php/sessions/alt-php82) in /home/crisps/public_html/fpa-en.php on line 648
You're using https://extensions.joomla.org/extension/n1ed/ and it doesn't indicate J5 compatible not even "J5 - compatibility plugin", although its last update listed on JED indicates December 2023. N1ED seems to be a fork of TinyMCE so again, not seeing why it would not work with J5 (given TinyMCE is the default editor for Joomla, and has been for many years). Other than that one 3rd party extension, the FPA seems to report a clean install, apart from some questionable file permissions (775 instead of 755).

Re: Site admin throws a System Error

Posted: Wed Apr 17, 2024 9:13 am
by bec_aus
Thanks,
Is it hard to uninstall NED without access to admin pages? If there are some instructions to do that I might start there, as it seems like a likely solution, and I will have to hunt to find out how to do a stack trace.

Re: Site admin throws a System Error

Posted: Wed Apr 17, 2024 9:27 am
by gws
GWS wrote:Disable it in phpmyadmin extensions table. Don't worry about the file permissions as you are on a localhost using windows and that is normal.
FPA says "Linux" not Windows?

(@gws - your post/comment seems to have disappeared from this thread)

Re: Site admin throws a System Error

Posted: Wed Apr 17, 2024 10:52 am
by bec_aus
Hi,

Thanks for all the advice I have received.

I disabled NE1D in the database and nothing changed. Then I removed the files, again nothing changed, so I have put them back and done a stack trace. I'm not sure how to best show the output. I have tried to put the source code in an attachment, but that was rejected. I have now added a screenshot of it. Please advise the most useful way to share this progress.
I'm not sure what the error
[17-Apr-2024 20:15:52 Australia/Melbourne] PHP Warning: session_start(): Failed to read session data: files (path: /var/cpanel/php/sessions/alt-php82) in /home/crisps/public_html/fpa-en.php on line 648
is telling me. I know that folder exists and has 755 permissions at all levels up the tree. So for now I'm ignoring it - perhaps unwisely.

Re: Site admin throws a System Error

Posted: Wed Apr 17, 2024 11:19 am
by bec_aus
I found this line in public_html/administrator/logs/everything.php that might help:
2024-04-17T11:09:50+00:00 CRITICAL 101.114.141.20 error Uncaught Throwable of type mysqli_sql_exception thrown with message "Unknown column 'a.ordering' in 'order clause'". Stack trace: #0 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php(138): mysqli->prepare()

It repeats every time I refresh the page. The whole amount added to the log is:
2024-04-17T11:09:50+00:00 CRITICAL 101.114.141.20 error Uncaught Throwable of type mysqli_sql_exception thrown with message "Unknown column 'a.ordering' in 'order clause'". Stack trace: #0 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php(138): mysqli->prepare()
#1 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(1020): Joomla\Database\Mysqli\MysqliStatement->__construct()
#2 [ROOT]/libraries/vendor/joomla/database/src/DatabaseDriver.php(1785): Joomla\Database\Mysqli\MysqliDriver->prepareStatement()
#3 [ROOT]/administrator/components/com_menus/src/Helper/MenusHelper.php(816): Joomla\Database\DatabaseDriver->setQuery()
#4 [ROOT]/administrator/components/com_menus/src/Helper/MenusHelper.php(841): Joomla\Component\Menus\Administrator\Helper\MenusHelper::loadXml()
#5 [ROOT]/administrator/components/com_menus/src/Helper/MenusHelper.php(673): Joomla\Component\Menus\Administrator\Helper\MenusHelper::loadXml()
#6 [ROOT]/administrator/modules/mod_menu/src/Menu/CssMenu.php(121): Joomla\Component\Menus\Administrator\Helper\MenusHelper::loadPreset()
#7 [ROOT]/administrator/modules/mod_menu/mod_menu.php(19): Joomla\Module\Menu\Administrator\Menu\CssMenu->load()
#8 [ROOT]/libraries/src/Dispatcher/ModuleDispatcher.php(52): include('/home/crisps/pu...')
#9 [ROOT]/libraries/src/Dispatcher/ModuleDispatcher.php(55): Joomla\CMS\Dispatcher\ModuleDispatcher::Joomla\CMS\Dispatcher\{closure}()
#10 [ROOT]/libraries/src/Helper/ModuleHelper.php(291): Joomla\CMS\Dispatcher\ModuleDispatcher->dispatch()
#11 [ROOT]/libraries/src/Helper/ModuleHelper.php(162): Joomla\CMS\Helper\ModuleHelper::renderRawModule()
#12 [ROOT]/libraries/src/Document/Renderer/Html/ModuleRenderer.php(99): Joomla\CMS\Helper\ModuleHelper::renderModule()
#13 [ROOT]/libraries/src/Document/Renderer/Html/ModulesRenderer.php(51): Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()
#14 [ROOT]/libraries/src/Document/HtmlDocument.php(575): Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()
#15 [ROOT]/libraries/src/Document/HtmlDocument.php(894): Joomla\CMS\Document\HtmlDocument->getBuffer()
#16 [ROOT]/libraries/src/Document/HtmlDocument.php(647): Joomla\CMS\Document\HtmlDocument->_renderTemplate()
#17 [ROOT]/libraries/src/Application/CMSApplication.php(1073): Joomla\CMS\Document\HtmlDocument->render()
#18 [ROOT]/libraries/src/Application/AdministratorApplication.php(434): Joomla\CMS\Application\CMSApplication->render()
#19 [ROOT]/libraries/src/Application/CMSApplication.php(311): Joomla\CMS\Application\AdministratorApplication->render()
#20 [ROOT]/administrator/includes/app.php(58): Joomla\CMS\Application\CMSApplication->execute()
#21 [ROOT]/administrator/index.php(32): require_once('/home/crisps/pu...')
#22 {main}

Re: Site admin throws a System Error

Posted: Wed Apr 17, 2024 12:22 pm
by SharkyKZ
Looks like upgrade to 5.0 went bad. If you have CLI access, run maintenance:database command.

Re: Site admin throws a System Error

Posted: Wed Apr 17, 2024 1:01 pm
by bec_aus
I have cPanel access, or I can ask the server administrator to run something. Where do I find the command to run? Linux isn’t my strong suit !

Thanks.

Re: Site admin throws a System Error

Posted: Thu Apr 18, 2024 5:30 am
by SharkyKZ
You need to execute Joomla's cli/joomla.php file from PHP CLI. Normally the command should look like this "php path/to/joomla/cli/joomla.php maintenance:database". In some cases PHP command may unavailable so you may have to prepend full path to PHP executable. It depends on your hosting. Best ask your host or read their documentation.

Re: Site admin throws a System Error

Posted: Thu Apr 18, 2024 5:34 am
by bec_aus
Thanks

Re: Site admin throws a System Error

Posted: Thu Apr 18, 2024 8:29 am
by gws
gws wrote: Wed Apr 17, 2024 9:27 am
GWS wrote:Disable it in phpmyadmin extensions table. Don't worry about the file permissions as you are on a localhost using windows and that is normal.
FPA says "Linux" not Windows?

(@gws - your post/comment seems to have disappeared from this thread)
I think I replied to the wrong thread,getting old and daft...

Re: Site admin throws a System Error

Posted: Thu Apr 18, 2024 8:53 am
by bec_aus
I did wonder about the mention of Windows. Thanks for double checking.

Currently the hosting company is running joomla.php database:maintenance. I’ll update when it is done.

Re: Site admin throws a System Error

Posted: Thu Apr 18, 2024 8:56 am
by SharkyKZ
When they're finished, ask them to run maintenance:database :D .

Re: Site admin throws a System Error

Posted: Thu Apr 18, 2024 10:52 am
by bec_aus
Hi,
Hmmm that was a typo on my part :o . They have finished and the output is below. I can see 2 things.
  • the upgrade from 4 to 5 didn't complete properly and I still have a 4.4 db
  • I compounded the problem by putting the 5.1 version of joomla.php there
Is there any chance the 5.0 version of joomla.php would actually upgrade the database and make everything consistent? If not then I'll do a clean install and create the pages again. There aren't many pages and the website all works so I have a reference to start from.

The output is as follows:

Code: Select all

Maintenance Database
====================
----- ------------ ------------------ ------------------ 
ID     Name       Database Version Manifest Version Problems
----- ------------ ------------------ ------------------ 
220 Joomla CMS 4.4.0-2023-09-13 4.4.3 Database version (4.4.0-2023-09-13) does not match manifest version (5.1.0-2024-03-28).
Database update version (<strong>4.4.3</strong>) does not match <strong>Joomla CMS</strong> version (<strong>5.1.0</strong>).
Table 'joses_menu_types' does not have column 'ordering'. (From file 5.0.0-2023-07-12.sql.)
----- ------------ ------------------ ------------------ 
[WARNING] There are tables not up to date!

Re: Site admin throws a System Error

Posted: Thu Apr 18, 2024 11:33 am
by SharkyKZ
I forgot to mention that you need to pass --fix option to actually fix the structure: "php cli/joomla.php maintenance:database --fix".

Re: Site admin throws a System Error

Posted: Thu Apr 18, 2024 12:32 pm
by bec_aus
Thanks, I might try that. In the mean time I have re-built the content (it was pretty small). Hopefully I learn that the database can be fixed.

Re: Site admin throws a System Error

Posted: Thu Apr 18, 2024 2:19 pm
by Per Yngve Berg
Your server has some problems after an upgrade of php 8.2->8.3

Session Path is not writable on the server and points to the folder for 8.2. Have your host fix this.