Support

Admin Tools

#9989 Deleted superadmin ID in php and cannot login to front

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by nicholas on Monday, 08 August 2011 08:11 CDT

Monday, 08 August 2011 07:19 CDT

user43553
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? yes
Have I searched the forum before posting? yes
Have I read the documentation before posting (which pages?)? No
Joomla! version: 1.5.23
PHP version: (unknown)latest
MySQL version: (unknown) latest
Host: (optional, but it helps us help you) akooka.com
Admin Tools version: (unknown) latest


Description of my issue:
Hi there. I am unable to login to my front end. i get this message:404 Not Found

The server can not find the requested page:

drrenata.virtality.co.za/index.php (port 443)

Please forward this error screen to drrenata.virtality.co.za's WebMaster.
Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at drrenata.virtality.co.za Port 443.

I was uable to log in the back-end with my superadmin id then went to the back-end phpmyadmin to ensure that the username was correct... I used the super admin login to get in, did not work. Deleted the Superadmin id in the back phpmyadmin and now the front end does not work. The super admin in the back-end still shows activated...Please help:(

Monday, 08 August 2011 07:24 CDT

nicholas
Please send me a Personal Message with the following information:
- Control Panel access to your site (hostname, username, password)
- Super Administrator username and password

Please note that by deleting the Super Administrator record in your database using phpMyAdmin you have basically bricked your site. I will have to create a new user account manually so that you can login to your site again.

Side note: Never, EVER, delete anything using phpMyAdmin unless you a. have a fully up-to-date and tested backup and b. know exactly what you're doing. Using phpMyAdmin to delete stuff is like unscrewing the cover of your laptop and using a pair of scissors to cut cables: it usually has the exact opposite effect than what you'd like ;)

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 08 August 2011 07:30 CDT

user43553
mmm... Yes I see I have made a bit of an F.A. Cup here thanks will send you that message.

Monday, 08 August 2011 07:32 CDT

nicholas
He he! The first thing I had done to my 80286 computer back in '92 was to accidentally format its MS-DOS startup floppies, just one hour after taking it out of its box. Don't worry, mistakes like that happen. How do you think we all learnt not to do these mistakes... again? :D

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 08 August 2011 07:51 CDT

user43553
ya, I guess.. mistakes = wisdom & knowledge :) I have sent you the info as a message.

Monday, 08 August 2011 08:04 CDT

nicholas
Hi!

Your issue had nothing to do with any of our software. In your login module you had enabled the "Encrypt form" option, but your site does not support HTTPS. Once I disabled that option, everything works. Check it out yourself.

Thankfully, you had deleted the correct user (the unused old administrator record) from the database, so you didn't screw anything up in the process :)

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 08 August 2011 08:10 CDT

user43553
Thank you for helping me! You are awesome! have a great day!

Monday, 08 August 2011 08:11 CDT

nicholas
You're welcome!

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!