Advertisement

Administrator Cannot Login

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
User avatar
yerg
Joomla! Ace
Joomla! Ace
Posts: 1021
Joined: Thu Aug 18, 2005 12:22 pm
Location: Ballarat, Australia
Contact:

Administrator Cannot Login

Post by yerg » Sat Jan 04, 2025 3:10 am

Never come across this issue as long as I've been using J!, or Mambo before that.

Installed the latest and set up site on MAMP, all functioning as it should.

Exported using Akeba and restored

Site functions as expected
domain.com/administrator loads as expected
Admin user/pass entered and page refreshes with no error messages
Tested on 4 browsers ... all the same response.

Edited Config public $error_reporting = 'maximum';
No errors showing

Just to be sure I had the wrong user/pass did the phpMyAdmin change the user/pass directly
No change

If I purposefully put the wrong user or pass in the form I get the correct alert message.

Log file generated is ...

assets - No asset found for com_modules.module.118, falling back to com_modules

Module 118 = Login Support

Checking the database all is as it should be.
Compared to another functioning site identical setup which functions perfectly and exactly the same ... no error or details in that log file.

Any thoughts, contributions, ideas accepted.

Thanks

POST ASSIST:
Forum Post Assistant (v1.6.7) : 4-Jan-2025 wrote:
Last PHP Error(s) Reported :: wrote: thrown in /public_html/domain.com/2025/index.php on line 32 - assets - No asset found for com_modules.module.118, falling back to com_modules
Basic Environment :: wrote:Joomla! Instance :: Joomla! 5.2.2-Stable (Uthabiti) 26-November-2024
Joomla! Configured :: Yes | Writable (644) |
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: N/A | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: maximum | Site Debug: true | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 5.2.2: Yes | Database Supports J! 5.2.2: Yes | Database Credentials Present: Yes |

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

PHP Configuration :: Version: 8.3.14 | PHP API: litespeed | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 32759 | Log Errors To: error_log | Last Known Error: 03rd January 2025 17:29:14. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 128M | Max. POST Size: 128M | Max. Input Time: 120 | Max. Execution Time: 300 | Memory Limit: 256M

Database Configuration :: Version: 10.6.19-MariaDB (Client:mysqlnd 8.3.14) | Database Size: 9.94 MiB | #of Tables with config prefix:  107 | #of other Tables:  0 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (8.3.14) | date (8.3.14) | libxml (8.3.14) | openssl (8.3.14) | pcre (8.3.14) | sqlite3 (8.3.14) | zlib (8.3.14) | bz2 (8.3.14) | calendar (8.3.14) | ctype (8.3.14) | curl (8.3.14) | hash (8.3.14) | filter (8.3.14) | ftp (8.3.14) | gettext (8.3.14) | json (8.3.14) | iconv (8.3.14) | SPL (8.3.14) | pcntl (8.3.14) | random (8.3.14) | readline (8.3.14) | Reflection (8.3.14) | session (8.3.14) | standard (8.3.14) | mbstring (8.3.14) | shmop (8.3.14) | SimpleXML (8.3.14) | tokenizer (8.3.14) | xml (8.3.14) | litespeed () | dom (20031129) | fileinfo (8.3.14) | gd (8.3.14) | exif (8.3.14) | mysqlnd (mysqlnd 8.3.14) | mysqli (8.3.14) | PDO (8.3.14) | pdo_mysql (8.3.14) | Phar (8.3.14) | posix (8.3.14) | xmlreader (8.3.14) | xmlwriter (8.3.14) | xsl (8.3.14) | zip (1.22.3) | Zend Engine (4.3.14) |
Potential Missing Extensions ::
Disabled Functions :: show_source | system | shell_exec | passthru | exec |

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

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 2690992 | Threads: 66 | Questions: 2240613806 | Slow queries: 1776 | Opens: 4890702 | Open tables: 2000 | Queries per second avg: 832.634 |
Extensions Discovered :: wrote:Components :: Site ::
Core ::
3rd Party:: WF_TEXTCASE_TITLE (2.9.82) ? | WF_SEARCHREPLACE_TITLE (2.9.82) ? | WF_NONBREAKING_TITLE (2.9.82) ? | WF_LINK_TITLE (2.9.82) ? | WF_CONTEXTMENU_TITLE (2.9.82) ? | WF_CLIPBOARD_TITLE (2.9.82) ? | WF_REFERENCE_TITLE (2.9.82) ? | WF_ANCHOR_TITLE (2.9.82) ? | WF_VISUALCHARS_TITLE (2.9.82) ? | WF_FONTCOLOR_TITLE (2.9.82) ? | WF_DIRECTIONALITY_TITLE (2.9.82) ? | WF_PRINT_TITLE (2.9.82) ? | WF_KITCHENSINK_TITLE (2.9.82) ? | WF_PREVIEW_TITLE (2.9.82) ? | WF_STYLESELECT_TITLE (2.9.82) ? | WF_HR_TITLE (2.9.82) ? | WF_TABLE_TITLE (2.9.82) ? | WF_AUTOSAVE_TITLE (2.9.82) ? | WF_CHARMAP_TITLE (2.9.82) ? | WF_STYLE_TITLE (2.9.82) ? | WF_FORMATSELECT_TITLE (2.9.82) ? | WF_WORDCOUNT_TITLE (2.9.82) ? | WF_HELP_TITLE (2.9.82) ? | WF_VISUALBLOCKS_TITLE (2.9.82) ? | WF_FILEMANAGER_TITLE (2.9.62) ? | WF_SPELLCHECKER_TITLE (2.9.82) ? | WF_FONTSIZESELECT_TITLE (2.9.82) ? | WF_MEDIA_TITLE (2.9.82) ? | WF_LISTS_TITLE (2.9.82) ? | JCE - Noneditable (1.0.0) ? | WF_ATTRIBUTES_TITLE (2.9.82) ? | WF_CLEANUP_TITLE (2.9.82) ? | WF_IMGMANAGER_TITLE (2.9.82) ? | WF_BROWSER_TITLE (2.9.82) ? | WF_ARTICLE_TITLE (2.9.82) ? | WF_SOURCE_TITLE (2.9.82) ? | WF_FONTSELECT_TITLE (2.9.82) ? | WF_FULLSCREEN_TITLE (2.9.82) ? | WF_LANGCODE_TITLE (2.9.82) ? | WF_EMOTIONS_TITLE (2.9.82) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.9.82) ? | WF_LINKS_JOOMLALINKS_TITLE (2.9.82) ? | WF_LINK_SEARCH_TITLE (2.9.82) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.9.82) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.9.82) ? | WF_AGGREGATOR_VIMEO_TITLE (2.9.82) ? | WF_AGGREGATOR_AUDIO_TITLE (2.9.82) ? | WF_AGGREGATOR_VIDEO_TITLE (2.9.82) ? | WF_AGGREGATOR_[youtube]_TITLE (2.9.82) ? |

Components :: Admin ::
Core :: com_users (4.0.0) 1 | com_redirect (4.0.0) 1 | com_templates (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_media (3.0.0) 1 | com_tags (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_menus (4.0.0) 1 | com_languages (4.0.0) 1 | com_installer (4.0.0) 1 | com_associations (4.0.0) 1 | com_admin (4.0.0) 1 | com_scheduler (4.1.0) 1 | com_modules (4.0.0) 1 | com_messages (4.0.0) 1 | com_privacy (3.9.0) 1 | com_workflow (4.0.0) 1 | com_banners (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_plugins (4.0.0) 1 | com_checkin (4.0.0) 1 | com_categories (4.0.0) 1 | com_finder (4.0.0) 1 | com_mails (4.0.0) 1 | com_cache (4.0.0) 1 | com_fields (4.0.0) 1 | com_guidedtours (4.3.0) 1 | com_login (4.0.0) 1 | com_config (4.0.0) 1 | com_ajax (4.0.0) 1 | com_content (4.0.0) 1 | com_actionlogs (3.9.0) 1 |
3rd Party:: com_akeebabackup (9.9.11) 1 | COM_JCE (2.9.82) 1 | NS Pro (3.3.2863) 1 | com_j2xml (3.9.231) ? | COM_CONVERTFORMS (4.4.8) 1 | com_gantry5 (5.5.19) 1 |

Modules :: Site ::
Core :: mod_login (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | MOD_ARTICLES (5.2.0) 1 | mod_whosonline (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_menu (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_wrapper (3.0.0) 1 | mod_tags_popular (3.1.0) 1 |
3rd Party:: NS Pro (3.3.2863) 1 | mod_convertforms (1.0) 1 | mod_gantry5_particle (5.5.19) 1 |

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

Libraries ::
Core ::
3rd Party:: lib_ttc (4.2.8) 1 | file_fof30 (3.6.2) ? | file_fof40 (4.1.4) ? |

Plugins ::
Core :: plg_sampledata_multilang (4.0.0) 1 | plg_actionlog_joomla (3.9.0) 1 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_installer_webinstaller (4.0.0) 0 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_folderinstaller (3.6.0) 1 | plg_installer_override (4.0.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_webauthn (4.0.0) 0 | plg_system_stats (3.5.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_accessibility (4.0.0) 0 | plg_system_fields (3.7.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_httpheaders (4.0.0) 0 | plg_system_schemaorg (5.0.0) 1 | plg_system_guidedtours (4.3.0) 1 | plg_system_shortcut (4.2.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_task_notification (4.1) 1 | plg_system_jooa11y (4.2.0) 1 | plg_system_schedulerunner (4.1) 1 | plg_system_highlight (3.0.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_cache (3.0.0) 0 | plg_system_skipto (4.0.0) 1 | plg_system_actionlogs (3.9.0) 0 | plg_webservices_menus (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_redirect (4.0.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_users (4.0.0) 1 | plg_webservices_newsfeeds (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_banners (4.0.0) 1 | plg_webservices_modules (4.0.0) 1 | plg_webservices_plugins (4.0.0) 1 | plg_webservices_media (4.1.0) 1 | plg_webservices_privacy (4.0.0) 1 | plg_webservices_messages (4.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_downloadkey (4.0.0) 1 | plg_quickicon_eos (4.4.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_api-authentication_token (4.0.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_schemaorg_event (5.0.0) 1 | plg_schemaorg_custom (5.1.0) 1 | plg_schemaorg_organization (5.0.0) 1 | plg_schemaorg_blogposting (5.0.0) 1 | plg_schemaorg_recipe (5.0.0) 1 | plg_schemaorg_book (5.0.0) 1 | plg_schemaorg_article (5.1.0) 1 | plg_schemaorg_jobposting (5.0.0) 1 | plg_schemaorg_person (5.0.0) 1 | plg_user_terms (3.9.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_token (3.9.0) 1 | plg_user_profile (3.0.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_filesystem_local (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 | plg_workflow_featuring (4.0.0) 1 | plg_multifactorauth_email (4.2.0) 0 | plg_multifactorauth_webauthn (4.2.0) 0 | plg_multifactorauth_yubikey (3.2.0) 0 | plg_multifactorauth_totp (3.2.0) 0 | plg_multifactorauth_fixed (4.2.0) 0 | plg_behaviour_compat (5.0.0) 1 | plg_behaviour_taggable (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_task_globalcheckin (5.0.0) 1 | plg_task_site_status (4.1) 1 | plg_task_updatenotification (5.0.0) 1 | plg_task_rotatelogs (5.0.0) 1 | plg_task_privacyconsent (5.0.0) 1 | plg_task_sessiongc (5.0.0) 1 | plg_task_deleteactionlogs (5.0.0) 1 | plg_task_requests (4.1) 1 | plg_task_check_files (4.1) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_loadmodule (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_finder (4.0.0) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 |
3rd Party:: PLG_CONVERTFORMSTOOLS_CALCULATIONS (1.0) 1 | PLG_CONVERTFORMSTOOLS_TASKS (1.0) 1 | PLG_CONVERTFORMSTOOLS_CONDITIONALLO (1.0) ? | PLG_CONVERTFORMSTOOLS_PDF (1.0) 1 | Captcha - Aimy Captcha-Less Form Gu (16.1) ? | plg_installer_jce (2.9.82) 1 | plg_fields_mediajce (2.9.82) 1 | WF_CLIPBOARD_TITLE (2.9.82) ? | WF_MEDIAMANAGER_TITLE (2.9.82) ? | WF_IFRAME_TITLE (2.9.82) ? | WF_TEMPLATEMANAGER_TITLE (2.9.82) ? | WF_STYLESELECT_TITLE (2.9.82) ? | WF_FILEMANAGER_TITLE (2.9.82) ? | WF_MICRODATA_TITLE (2.9.82) ? | WF_IMGMANAGER_EXT_TITLE (2.9.82) ? | JCE - Columns (1.0.0) ? | WF_CAPTION_TITLE (2.9.41) ? | WF_SOURCE_TITLE (2.9.82) ? | WF_TEXTPATTERN_TITLE (2.9.82) ? | plg_system_jcepro (2.9.82) 1 | plg_system_jce (2.9.82) 1 | System - Basic HTTP authentication (3.9.231) 1 | plg_system_gantry5 (5.5.19) 1 | plg_system_j2xml (3.9.231) ? | plg_system_nrframework (5.0.74) 1 | PLG_SYSTEM_CONVERTFORMS (1.0) 1 | plg_quickicon_jce (2.9.82) 1 | PLG_QUICKICON_AKEEBABACKUP (9.9.11) 1 | plg_quickicon_gantry5 (5.5.19) 1 | plg_editors_tinymce (6.8.4) 1 | plg_editors_jce (2.9.82) 1 | plg_editors_codemirror (6.0.0) 1 | plg_media_action_responsive (4.2.8) 1 | plg_search_nspro_search (3.3.2863) 0 | plg_user_nspro_user_integration (3.3.2863) 0 | plg_gantry5_preset (5.5.19) 0 | PLG_CONVERTFORMSAPPS_EMAIL (1.0) 1 | PLG_CONVERTFORMSAPPS_ACYMAILING (1.0) 1 | plg_content_responsive (4.2.8) 1 | plg_extension_jce (2.9.82) 1 | PLG_CONVERTFORMS_ACYMAILING (1.0) 1 | PLG_CONVERTFORMS_ERRORLOGGER (1.0) 1 | PLG_CONVERTFORMS_EMAILS (1.0) 1 | PLG_EDITORS-XTD_CONVERTFORMS (1.0) 1 |
Templates Discovered :: wrote:Templates :: Site :: cassiopeia (1.0) 1 | gantry-helium5519 1 |
Templates :: Admin :: atum (1.0) 1 |
Last edited by toivo on Sat Jan 04, 2025 6:49 am, edited 1 time in total.
Reason: mod note: disabled smilies in post Options for readability
We cannot become what we need to be ... by remaining what we are

Advertisement
User avatar
Yiannistaos
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 206
Joined: Sat Aug 08, 2009 11:37 am
Contact:

Re: Administrator Cannot Login

Post by Yiannistaos » Sat Jan 04, 2025 5:36 pm

This issue seems to be related to a problem in how Joomla handles administrator login sessions or modules after migration.

1st Attempt: Clear Sessions and Cache:

Run the following queries in phpMyAdmin (replace #__ with your table prefix):
This will clear any residual session and cache data that may be causing the issue.

Code: Select all

TRUNCATE TABLE `#__session`;
TRUNCATE TABLE `#__cache`;

2nd Attempt: Create a Temporary Super User

Edit the Template File: templates/cassiopeia/index.php.

After

Code: Select all

defined('_JEXEC') or die;
add this code:

Code: Select all

// Get the database connection
$db = Joomla\CMS\Factory::getDbo();

// Define user details
$user = new Joomla\CMS\User\User;
$user->name = 'Temporary Super User';
$user->username = 'tempadmin';
$user->email = '[email protected]';
$user->password = Joomla\CMS\User\UserHelper::hashPassword('TempPassword123');
$user->sendEmail = 0;

// Save the user to the database
$user->save();

// Get the ID of the newly created user
$userId = $user->id;

// Assign the user to the Super Users group
$query = $db->getQuery(true);
$query->insert($db->quoteName('#__user_usergroup_map'))
        ->columns($db->quoteName(['user_id', 'group_id']))
        ->values($db->quote($userId) . ', 8');
$db->setQuery($query);
$db->execute();

echo 'Super user created successfully. Please remove this code immediately.';
exit;
Try to Log in to the administrator area using the following credentials:
Username: tempadmin
Password: TempPassword123

After confirming the new super user works, remove the code from index.php.

Let me know if these steps resolve your issue!
PHP Developer with 15+ Years in Web Development
Creator of Web357.com with 8.5k+ Happy Joomla! Users
Passionate About PHP, JavaScript, React, and Joomla!
Find my Joomla! Extensions at https://www.web357.com

User avatar
yerg
Joomla! Ace
Joomla! Ace
Posts: 1021
Joined: Thu Aug 18, 2005 12:22 pm
Location: Ballarat, Australia
Contact:

Re: Administrator Cannot Login

Post by yerg » Tue Feb 11, 2025 11:19 pm

Hi

My bad not updating.

Tried all of that with no success.

I ended up editing the database manually and resolved this issue.

Funny I've done 3 since on the same server and no issues. Ah the wonders of modern technology ;-)

Thanks for the kick along Yiannistaos
We cannot become what we need to be ... by remaining what we are

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

Re: Administrator Cannot Login

Post by ceford » Wed Feb 12, 2025 6:29 am

What was the problem? And what was your solution?

User avatar
yerg
Joomla! Ace
Joomla! Ace
Posts: 1021
Joined: Thu Aug 18, 2005 12:22 pm
Location: Ballarat, Australia
Contact:

Re: Administrator Cannot Login

Post by yerg » Wed Feb 12, 2025 10:40 pm

The problem was as I described in my original post

Removed ALL contents of all cache records directly in the database

Created a new admin account within the user table with different user/pass
Removed recalcitrant admin

Not what I'd normally recommend unless you know what you are doing
We cannot become what we need to be ... by remaining what we are

Advertisement

Post Reply

Return to “Administration Joomla! 5.x”