Site admin throws a System Error

Need help with the Administration of your Joomla! 5.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
bec_aus
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jul 03, 2016 9:02 am

Site admin throws a System Error

Post by bec_aus » Wed Apr 17, 2024 7:21 am

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 |
Last edited by toivo on Wed Apr 17, 2024 8:27 am, edited 1 time in total.
Reason: mod note: disabled smilies in post Options for readability

SharkyKZ
Joomla! Hero
Joomla! Hero
Posts: 2956
Joined: Fri Jul 05, 2013 10:35 am
Location: Parts Unknown

Re: Site admin throws a System Error

Post by SharkyKZ » Wed Apr 17, 2024 7:23 am

Enable debug and post stack trace.

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9848
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Site admin throws a System Error

Post by AMurray » Wed Apr 17, 2024 8:57 am

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).
Last edited by AMurray on Wed Apr 17, 2024 9:09 am, edited 1 time in total.
Reason: more relevant information added.
Regards - A Murray
General Support Moderator

bec_aus
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jul 03, 2016 9:02 am

Re: Site admin throws a System Error

Post by bec_aus » Wed Apr 17, 2024 9:13 am

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.

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

Re: Site admin throws a System Error

Post by gws » 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)

bec_aus
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jul 03, 2016 9:02 am

Re: Site admin throws a System Error

Post by bec_aus » Wed Apr 17, 2024 10:52 am

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.
You do not have the required permissions to view the files attached to this post.

bec_aus
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jul 03, 2016 9:02 am

Re: Site admin throws a System Error

Post by bec_aus » Wed Apr 17, 2024 11:19 am

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}

SharkyKZ
Joomla! Hero
Joomla! Hero
Posts: 2956
Joined: Fri Jul 05, 2013 10:35 am
Location: Parts Unknown

Re: Site admin throws a System Error

Post by SharkyKZ » Wed Apr 17, 2024 12:22 pm

Looks like upgrade to 5.0 went bad. If you have CLI access, run maintenance:database command.

bec_aus
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jul 03, 2016 9:02 am

Re: Site admin throws a System Error

Post by bec_aus » Wed Apr 17, 2024 1:01 pm

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.

SharkyKZ
Joomla! Hero
Joomla! Hero
Posts: 2956
Joined: Fri Jul 05, 2013 10:35 am
Location: Parts Unknown

Re: Site admin throws a System Error

Post by SharkyKZ » Thu Apr 18, 2024 5:30 am

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.

bec_aus
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jul 03, 2016 9:02 am

Re: Site admin throws a System Error

Post by bec_aus » Thu Apr 18, 2024 5:34 am

Thanks

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

Re: Site admin throws a System Error

Post by gws » Thu Apr 18, 2024 8:29 am

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...

bec_aus
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jul 03, 2016 9:02 am

Re: Site admin throws a System Error

Post by bec_aus » Thu Apr 18, 2024 8:53 am

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.

SharkyKZ
Joomla! Hero
Joomla! Hero
Posts: 2956
Joined: Fri Jul 05, 2013 10:35 am
Location: Parts Unknown

Re: Site admin throws a System Error

Post by SharkyKZ » Thu Apr 18, 2024 8:56 am

When they're finished, ask them to run maintenance:database :D .

bec_aus
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jul 03, 2016 9:02 am

Re: Site admin throws a System Error

Post by bec_aus » Thu Apr 18, 2024 10:52 am

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!

SharkyKZ
Joomla! Hero
Joomla! Hero
Posts: 2956
Joined: Fri Jul 05, 2013 10:35 am
Location: Parts Unknown

Re: Site admin throws a System Error

Post by SharkyKZ » Thu Apr 18, 2024 11:33 am

I forgot to mention that you need to pass --fix option to actually fix the structure: "php cli/joomla.php maintenance:database --fix".

bec_aus
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jul 03, 2016 9:02 am

Re: Site admin throws a System Error

Post by bec_aus » Thu Apr 18, 2024 12:32 pm

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.

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

Re: Site admin throws a System Error

Post by Per Yngve Berg » Thu Apr 18, 2024 2:19 pm

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.


Post Reply

Return to “Administration Joomla! 5.x”