Cannot log in to Joomla frontend
From Joomla! Documentation
A small number of users have reported not being able to log in to the frontend of Joomla!
What is the cause
This seems to only occur when the users have a corrupt asset table. This is usually due to a faulty migration from Joomla 1.5.
How to fix
As a first step, click the rebuild icon in any categories view and see if this solves the problem.
If this does not solve, look at your asset table in your database. If there is more than one parent_id with a value of 0 this indicates a corrupt table. Only the root asset is allowed to have parent_id=0.
To fix you can manually or with an SQL theory change the parent ids. If the broken assets are categories the parent should be set to the id number for that component (for example usually the id for com_content is 8). (They can also be set to have a parent of another category in the same component.)
For something besides a category(articles for example), set the parent either to a category id or to the id for the extension if the extension does not use categories.