_users table is empty after installing joomla4rc5 Topic is solved

General questions relating to Joomla! 4.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
Tom22
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Jul 31, 2021 2:45 pm

_users table is empty after installing joomla4rc5

Post by Tom22 » Sat Jul 31, 2021 2:56 pm

I cannot log in after installing joomla 4 rc5, because the _users table of the database is empty.
What can cause this?

It's on xampp, apache 2.4, php 7.2.5, 10.1.32-MariaDB

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27716
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: _users table is empty after installing joomla4rc5

Post by imanickam » Sat Jul 31, 2021 3:10 pm

Welcome to the Joomla Forum!

Hope you had followed the steps as documented at https://docs.joomla.org/J4.x:Installing_Joomla.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator

Eegan - Support the poor and underprivileged

Tom22
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Jul 31, 2021 2:45 pm

Re: _users table is empty after installing joomla4rc5

Post by Tom22 » Sat Jul 31, 2021 3:20 pm

Thank you!
I had a "Successful install", the site works, just I cannot log in. So I found that the _users table is empty, and now I'm clueless.

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27716
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: _users table is empty after installing joomla4rc5

Post by imanickam » Sat Jul 31, 2021 3:51 pm

Good. Make sure that you are reviewing the table in the correct database. Also, while logging in make sure that you provide the username and password that you have provided for the site - not the database.

Another suggestion is to create a separate directory under the folder htdocs and install Joomla in that directory. Make sure to provide a different database name. This would provide you with another Joomla site to play with.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator

Eegan - Support the poor and underprivileged

Tom22
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Jul 31, 2021 2:45 pm

Re: _users table is empty after installing joomla4rc5

Post by Tom22 » Sat Jul 31, 2021 3:55 pm

I will try it. Is there any installation log file, that could be checked?

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27716
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: _users table is empty after installing joomla4rc5

Post by imanickam » Sat Jul 31, 2021 4:04 pm

You could review the files in the directory \administrator\logs.

Check what is there in the table xyz_action_logs (where xyz_ is the database prefix of the installation).
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator

Eegan - Support the poor and underprivileged

Tom22
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Jul 31, 2021 2:45 pm

Re: _users table is empty after installing joomla4rc5

Post by Tom22 » Sat Jul 31, 2021 4:15 pm

The _action_logs table is empty.
I found an error.php in the \administrator\logs directory with this content, but it does not help:

#
#<?php die('Forbidden.'); ?>
#Date: 2021-07-31 13:04:06 UTC
#Software: Joomla! 4.0.0-rc5 Release Candidate [ Mañana ] 27-July-2021 22:41 GMT

#Fields: datetime priority clientip category message
2021-07-31T13:04:06+00:00 INFO 127.0.0.1 joomlafailure Username and password do not match or you do not have an account yet.
2021-07-31T13:04:33+00:00 INFO 127.0.0.1 joomlafailure Username and password do not match or you do not have an account yet.

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27716
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: _users table is empty after installing joomla4rc5

Post by imanickam » Sat Jul 31, 2021 4:18 pm

With your second installation, if the same problem exists then we may have to have check whether the issue is with the database engine.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator

Eegan - Support the poor and underprivileged

Tom22
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Jul 31, 2021 2:45 pm

Re: _users table is empty after installing joomla4rc5

Post by Tom22 » Sat Jul 31, 2021 5:39 pm

It seems that I am not able to make a correct install. I tried it with a new database and in a new folder, but I have the same issue. I attached an image of phpmyadmin with the exact version numbers on the right.
You do not have the required permissions to view the files attached to this post.

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27716
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: _users table is empty after installing joomla4rc5

Post by imanickam » Sun Aug 01, 2021 2:26 am

I have tested a new installation of Joomla! 3 RC5 using WAMP Server with the following environment:
Apache 2.4.46
PHP 7.2.25
Maria DB 10.1.44

The installation went fine and I could access the backend. Also, there is a row for the Super User created during the installation in the table _users.

I have also tested by adding another administrator user account using the procedure documented at https://docs.joomla.org/How_do_you_reco ... rator_User and it works fine.

What I would suggest is to follow the procedure documented in the above link and see what happens.

Note:
Be known that PHP 7.2 is obsolete. It is no longer supported. I would suggest going for PHP 7.4 as the support for PHP 7.3 would end on 6 Dec 2021.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator

Eegan - Support the poor and underprivileged

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 40244
Joined: Sat Apr 05, 2008 9:58 pm

Re: _users table is empty after installing joomla4rc5

Post by Webdongle » Sun Aug 01, 2021 10:58 am

Suggest you use wamp not xampp. The php version can be changed on the fly in wamp.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

Tom22
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Jul 31, 2021 2:45 pm

Re: _users table is empty after installing joomla4rc5

Post by Tom22 » Sun Aug 01, 2021 4:28 pm

I installed a newer version of xampp with Apache 2.4.48, PHP 7.3.29, 10.4.20-MariaDB.
Now the joomla 4 rc5 installation seems to work well, I can log in.
Thank you for your help!

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 40244
Joined: Sat Apr 05, 2008 9:58 pm

Re: _users table is empty after installing joomla4rc5

Post by Webdongle » Sun Aug 01, 2021 5:25 pm

php 7.3.x is not supported any more and security updates only the next 4 months.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

Tom22
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Jul 31, 2021 2:45 pm

Re: _users table is empty after installing joomla4rc5

Post by Tom22 » Sun Aug 01, 2021 6:10 pm

Thanks, but now at least I know that joomla 4 works on php 7.3


Post Reply

Return to “General Questions/New to Joomla! 4.x”