Actions

J2.5

Difference between revisions of "Users Cannot Login in 2.5.13"

From Joomla! Documentation

(No need for changing root, that is what id>1 is for)
Line 13: Line 13:
 
To fix you can manually or with an sql query 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.)
 
To fix you can manually or with an sql query 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.)
  
SQL queries:
+
SQL query:
 
<source lang="sql">UPDATE `prefix_assets` SET `parent_id`=1 WHERE `parent_id`=0 AND id>1
 
<source lang="sql">UPDATE `prefix_assets` SET `parent_id`=1 WHERE `parent_id`=0 AND id>1
UPDATE `prefix_assets` SET `parent_id`=0 WHERE `title` = 'Root Asset'</source>
+
</source>
 
Note: change prefix to your database extension (Global configuration > Server > Database Settings > Database Tables Prefix)
 
Note: change prefix to your database extension (Global configuration > Server > Database Settings > Database Tables Prefix)
  

Revision as of 04:41, 9 August 2013

A small number of users have reported not being able to login to the front end in Joomla 2.5.13.

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.

To check this, 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.
SELECT count(*) FROM `#__assets` WHERE parent_id = 0
Apply your own prefix instead of #_.

There should only be 1, only the root asset is allowed to have parent_id=0.

To fix you can manually or with an sql query 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.)

SQL query:

UPDATE `prefix_assets` SET `parent_id`=1 WHERE `parent_id`=0 AND id>1

Note: change prefix to your database extension (Global configuration > Server > Database Settings > Database Tables Prefix)

For something besides a category, set the parent either to a category id or to the id for the extension if the extension does not use categories.

Additional information: Fixing the assets table and AssetFix