Upgraded and all works, except users -> manage? Topic is solved

Need help with the Administration of your Joomla! 4.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
Jukkis-wc
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Nov 21, 2022 7:44 pm

Upgraded and all works, except users -> manage?

Post by Jukkis-wc » Mon Nov 21, 2022 7:52 pm

Hi! Really wierd issue as i got successful migration and all works except "users -> manager", i can see the non activated users, but not activated. I get this error details when logging enabled.

I am lost where to start troubleshooting as Googling these erros does not bring anything meaningful.
error-500-user-manage.jpg
All help much appreaciated.
You do not have the required permissions to view the files attached to this post.
Last edited by toivo on Mon Nov 21, 2022 8:38 pm, edited 1 time in total.
Reason: mod note: moved from 4.x Migrating and Upgrading

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 13103
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Upgraded and all works, except users -> manage?

Post by sozzled » Mon Nov 21, 2022 8:04 pm

The error "Commands out of sync; you can't run this command now" suggests an issue with MySql. Further information may be available if we knew what SQL environment you are using. Suggest you use the Forum Post Assistant reporting tool (see the pink area at the top of this page for more information) and post the [BBcode] report here.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?”
Walking the talk: https://j4xdemo.enduring.com.au
:)

Jukkis-wc
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Nov 21, 2022 7:44 pm

Re: Upgraded and all works, except users -> manage?

Post by Jukkis-wc » Mon Nov 21, 2022 8:12 pm

Hi! Thanks for the info and its really wierd as the user creation etc. works also i can access all the other functions for users, except the "enabled one"... '

Anyway, i am using: mysql 10.5.15-MariaDB, will have a look at the FPA.

Jukkis-wc
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Nov 21, 2022 7:44 pm

Re: Upgraded and all works, except users -> manage?

Post by Jukkis-wc » Mon Nov 21, 2022 8:30 pm

Forum Post Assistant (v1.6.5) : 21-Nov-2022 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.2.5-Stable (Uaminifu) 8-November-2022
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: 30 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 30 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.2.5: Yes | Database Supports J! 4.2.5: Yes | Database Credentials Present: Yes |

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

PHP Configuration :: Version: 8.1.12 | PHP API: litespeed | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 32759 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 1024M | Max. POST Size: 1024M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 512M

Database Configuration :: Version: 10.5.15-MariaDB-log (Client:mysqlnd 8.1.12) | Database Size: 388.86 MiB | #of Tables with config prefix:  167 | #of other Tables:  0 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (8.1.12) | date (8.1.12) | libxml (8.1.12) | openssl (8.1.12) | pcre (8.1.12) | sqlite3 (8.1.12) | zlib (8.1.12) | bz2 (8.1.12) | calendar (8.1.12) | ctype (8.1.12) | curl (8.1.12) | hash (8.1.12) | filter (8.1.12) | ftp (8.1.12) | gettext (8.1.12) | json (8.1.12) | iconv (8.1.12) | SPL (8.1.12) | pcntl (8.1.12) | readline (8.1.12) | Reflection (8.1.12) | session (8.1.12) | standard (8.1.12) | mbstring (8.1.12) | shmop (8.1.12) | SimpleXML (8.1.12) | tokenizer (8.1.12) | xml (8.1.12) | litespeed () | Phar (8.1.12) | exif (8.1.12) | mysqlnd (mysqlnd 8.1.12) | mysqli (8.1.12) | dom (20031129) | gd (8.1.12) | imap (8.1.12) | zip (1.19.5) | xmlreader (8.1.12) | fileinfo (8.1.12) | Zend OPcache (8.1.12) | Zend Engine (4.1.12) |
Potential Missing Extensions :: pdo_mysql |

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

Elevated Permissions (First 10) :: administrator/components/com_akeebabackup/varmistukset/ (775) |
Database Information :: wrote:Database statistics :: Uptime: 260312 | Threads: 156 | Questions: 302683082 | Slow queries: 9223 | Opens: 8680277 | Open tables: 200 | Queries per second avg: 1162.770 |
Extensions Discovered :: wrote:Components :: Site ::
Core ::
3rd Party:: os_worldpay (4.3.0) ? | os_authnet (4.3.0) ? | os_offline (4.3.0) ? | os_paypal (4.3.0) ? | os_eway (4.3.0) ? |

Components :: Admin ::
Core :: com_menus (4.0.0) 1 | com_search (4.0.0-dev) 1 | com_joomlaupdate (4.0.3) 1 | com_tags (4.0.0) 1 | com_admin (4.0.0) 1 | com_templates (4.0.0) 1 | com_banners (4.0.0) 1 | com_fields (4.0.0) 1 | com_media (3.0.0) 1 | com_content (4.0.0) 1 | com_checkin (4.0.0) 1 | com_workflow (4.0.0) 1 | com_mails (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_messages (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_ajax (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_scheduler (4.1.0) 1 | com_postinstall (4.0.0) 1 | com_actionlogs (3.9.0) 1 | com_users (4.0.0) 1 | com_login (4.0.0) 1 | com_redirect (4.0.0) 1 | com_config (4.0.0) 1 | com_associations (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_plugins (4.0.0) 1 | com_languages (4.0.0) 1 | com_installer (4.0.0) 1 | com_cache (4.0.0) 1 | com_privacy (3.9.0) 1 | com_modules (4.0.0) 1 | com_finder (4.0.0) 1 | com_categories (4.0.0) 1 |
3rd Party:: com_gantry5 (5.5.14) 1 | JRealtimeAnalytics (3.7.2) 1 | Acym (7.9.7) 1 | com_akeebabackup (9.4.3) 1 | Event Booking (4.3.0) 1 | com_admintools (7.1.11) 1 |

Modules :: Site ::
Core :: mod_random_image (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_articles_latest (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_search (4.0.0-dev) 1 | mod_breadcrumbs (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_languages (3.5.0) 1 | mod_menu (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_login (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_articles_news (3.0.0) 1 |
3rd Party:: Events Booking - Event Categories (4.3.0) 1 | Events Booking - Events By City (4.3.0) 1 | Events Booking - Upcoming Events (4.3.0) 1 | Events Booking - Cart Module (4.3.0) 1 | Events Booking - Search Events (4.3.0) 1 | AcyMailing subscription form (7.9.7) 1 | Events Booking - Events By Location (4.3.0) 1 | JRealtime Analytics Module (3.7.2) 1 | Events Booking - Events By State (4.3.0) 1 | Events Booking - Google Map (4.3.0) 1 | mod_gantry5_particle (5.5.14) 1 | Events Booking - Easy View (4.3.0) 1 | Events Booking - Mini Calendar (4.3.0) 1 | Events Booking - Advanced Events Sl (4.3.0) ? |

Modules :: Admin ::
Core :: mod_stats_admin (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_user (4.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_post_installation_messages (4.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_loginsupport (4.0.0) 1 | mod_menu (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_frontend (4.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_messages (4.0.0) 1 | mod_latest (3.0.0) 1 | mod_title (3.0.0) 1 | mod_privacy_status (4.0.0) 1 | mod_version (3.0.0) 1 | mod_login (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_privacy_dashboard (3.9.0) 1 |
3rd Party:: Events Booking - Latest Registrants (4.3.0) 1 |

Libraries ::
Core ::
3rd Party:: file_fof30 (3.6.2) ? | file_fof40 (4.1.0) ? |

Plugins ::
Core :: plg_search_tags (4.0.0-dev) 1 | plg_search_content (4.0.0-dev) 1 | plg_search_newsfeeds (4.0.0-dev) 1 | plg_search_categories (4.0.0-dev) 1 | plg_search_contacts (4.0.0-dev) 1 | plg_actionlog_joomla (3.9.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_privacy (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_messages (4.0.0) 1 | plg_webservices_menus (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_webservices_banners (4.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_media (4.1.0) 1 | plg_webservices_users (4.0.0) 1 | plg_webservices_plugins (4.0.0) 1 | plg_webservices_newsfeeds (4.0.0) 1 | plg_webservices_redirect (4.0.0) 1 | plg_webservices_modules (4.0.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_privacy_actionlogs (3.9.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_fields (3.7.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_finder (3.0.0) 0 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_downloadkey (4.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_finder (4.0.0) 1 | plg_multifactorauth_yubikey (3.2.0) 0 | plg_multifactorauth_totp (3.2.0) 0 | plg_multifactorauth_email (4.2.0) 0 | plg_multifactorauth_fixed (4.2.0) 0 | plg_multifactorauth_webauthn (4.2.0) 0 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_installer_folderinstaller (3.6.0) 1 | plg_installer_override (4.0.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_webinstaller (4.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_workflow_featuring (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_task_demo_tasks (4.1) 1 | plg_task_requests (4.1) 1 | plg_task_site_status (4.1) 1 | plg_task_check_files (4.1) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_api-authentication_token (4.0.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 1 | plg_user_profile (3.0.0) 1 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_token (3.9.0) 1 | plg_user_terms (3.9.0) 0 | plg_finder_tags (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_behaviour_taggable (4.0.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_accessibility (4.0.0) 0 | plg_system_jooa11y (4.2.0) 1 | plg_system_shortcut (4.2.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_skipto (4.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_cache (3.0.0) 0 | plg_system_httpheaders (4.0.0) 0 | plg_system_updatenotification (3.5.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_schedulerunner (4.1) 1 | plg_system_logout (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_languagefilter (3.0.0) 1 | plg_system_task_notification (4.1) 1 | plg_system_debug (3.0.0) 1 | plg_system_languagecode (3.0.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_actionlogs (3.9.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_webauthn (4.0.0) 0 |
3rd Party:: AcyMailing - Search emails in Jooml (7.9.7) ? | Search - Events Booking (4.3.0) 0 | PLG_ACTIONLOG_ADMINTOOLS (7.1.11) 0 | Action Log - Events Booking (4.3.0) 1 | Content - Events Booking Category (4.3.0) 1 | Content - Events Booking Speakers (4.3.0) 1 | Content - Events Booking Content Re (4.3.0) ? | Content - Events Booking Event (4.3.0) 1 | Content - Events Booking Registrati (4.3.0) ? | Content - Events Booking Stip Easy (4.3.0) ? | plg_quickicon_gantry5 (5.5.14) 1 | Button - Event (4.3.0) 1 | Button - Individual Registration Fo (4.3.0) ? | Installer - Events Booking (4.3.0) 1 | Events Booking SMS - Clockwork (4.3.0) 0 | Events Booking SMS - Textlocal (4.3.0) 0 | Events Booking SMS - Clickatell (4.3.0) 0 | plg_editors_codemirror (5.65.6) 1 | plg_editors_tinymce (5.10.5) 1 | User - Events Booking (4.3.0) 1 | Events Booking - Map (4.3.0) 1 | Events Booking - Joomsocial (4.3.0) 0 | Events Booking - Easy Profile (4.3.0) 1 | Events Booking - Auto register (4.3.0) 0 | Events Booking - Additional Dates (4.3.0) 0 | Events Booking - Registrant List (4.3.0) 1 | Events Booking - Membership Pro (4.3.0) 0 | Events Booking - Waiting List (4.3.0) 1 | Events Booking - Fields Assignment (4.3.0) 0 | Events Booking - Ticket Types (4.3.0) 1 | Events Booking - Google Structured (4.3.0) ? | Events Booking - New Event Notifica (4.3.0) ? | Events Booking - CB (4.3.0) 0 | Events Booking - AcyMailing (4.3.0) 1 | Events Booking - Easysocial (4.3.0) 0 | Events Booking - Fee Fields Generat (4.3.0) ? | Events Booking - Userprofile (4.3.0) 1 | Events Booking - Jcomments (4.3.0) 0 | Events Booking - Gallery (4.3.0) 1 | Events Booking - Mailchimp (4.3.0) 0 | Events Booking - Agendas (4.3.0) 0 | Events Booking - Full Event Notific (4.3.0) ? | Events Booking - Joomla Groups (4.3.0) 0 | Events Booking - Sponsors (4.3.0) 0 | Events Booking - Zoom (4.3.0) 0 | Events Booking - Auto Coupon Genera (4.3.0) ? | Events Booking - Move Registrants (4.3.0) 0 | Events Booking - Contact Enhanced (4.3.0) 0 | Events Booking - Speakers (4.3.0) 0 | Events Booking - Attachments (4.3.0) 1 | Events Booking - Event Dependencies (4.3.0) 0 | Events Booking - System (DO NOT UNP (4.3.0) ? | Smart Search - Events Booking (-) 1 | plg_gantry5_preset (5.5.14) 0 | EB Registration History (4.3.0) 0 | AcyMailing - Joomla integration (7.9.7) 1 | Events Booking - Payment Reminder (4.3.0) 0 | AcyMailing - Override Joomla emails (7.9.7) 1 | System - JRealtime Analytics Plugin (3.7.2) 1 | PLG_SYSTEM_ADMINTOOLS (7.1.11) 1 | System - Events Booking SMS (4.3.0) 0 | System - Email Registrants (4.3.0) 0 | Events Booking - Reminder (4.3.0) 0 | Events Booking - Offline Payment Ha (4.3.0) ? | AcyMailing - JCE integration (7.9.7) 1 | plg_system_gantry5 (5.5.14) 1 |
Templates Discovered :: wrote:Templates :: Site :: rt_aurora (1.5.0) 1 | g5_myriad (2.5.0) 1 | cassiopeia (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 13103
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Upgraded and all works, except users -> manage?

Post by sozzled » Mon Nov 21, 2022 8:36 pm

Thank you for the FPA report. If I were you, I would go to System » Maintenance » Database to see if there are any issue there and fix them.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?”
Walking the talk: https://j4xdemo.enduring.com.au
:)

Jukkis-wc
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Nov 21, 2022 7:44 pm

Re: Upgraded and all works, except users -> manage?

Post by Jukkis-wc » Mon Nov 21, 2022 8:47 pm

All seem to be OK with DB's.

Very confused, as very seldom something works almost.. =)
As, pointed out the user management works also as intended except when choosing "enabled" users.

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 13103
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Upgraded and all works, except users -> manage?

Post by sozzled » Mon Nov 21, 2022 8:57 pm

I'm sorry; I don't have any other suggestions at this time. The error message suggests there's an issue with the database but I don't have any experience with MariaDB 10.5.15.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?”
Walking the talk: https://j4xdemo.enduring.com.au
:)

Jukkis-wc
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Nov 21, 2022 7:44 pm

Re: Upgraded and all works, except users -> manage?

Post by Jukkis-wc » Thu Nov 24, 2022 1:41 pm

It fixed by itself or caused by PHP 8.1, not sure if related, but got some issues with latest version and all works when using 8.0.


Post Reply

Return to “Administration Joomla! 4.x”