?
avatar cdekok
cdekok
7 Aug 2013

It seems between 2.5.9 and 2.5.14 login stopped working because this query.

        // If the asset identifier is numeric assume it is a primary key, else lookup by name.
        if (is_numeric($asset))
        {
            $query->where('(a.id = ' . (int) $asset . ($recursive ? ' OR a.parent_id=0' : '') . ')');
        }
        else
        {
            $query->where('(a.name = ' . $db->quote($asset) . ($recursive ? ' OR a.parent_id=0' : '') . ')');
        }

Now

        // If the asset identifier is numeric assume it is a primary key, else lookup by name.
        if (is_numeric($asset))
        {
            $query->where('(a.id = ' . (int) $asset . ')');
        }
        else
        {
            $query->where('(a.name = ' . $db->quote($asset) . ')');
        }
avatar Mech7 Mech7 - open - 7 Aug 2013
avatar Mech7
Mech7 - comment - 7 Aug 2013

Somebody closed this, not very helpfull!
#1554

Anyway it seems that $rootId = $assets->getRootId(); returns false.
Looking at getRootId() it does some weird stuff first it loads a bunch or records on a query with parent_id = 0 then it tries to do a fallback on a queyr where left = 0 only the root item in the database has a left = 1

Ok I found the problem, it was because a faulty migration: http://docs.joomla.org/J2.5:Users_Cannot_Login_in_2.5.13

avatar Bakual
Bakual - comment - 27 Aug 2013

Please close the issue since you figured out your problem and it isn't a code issue.

avatar zero-24 zero-24 - close - 27 Aug 2013
avatar Mech7
Mech7 - comment - 27 Aug 2013

It still is a code issue if sites break with a minor upgrade ;)

avatar Bakual
Bakual - comment - 27 Aug 2013

The issue was caused by a faulty upgrade from Joomla 1.5. Probably by using a buggy JUpgrade. It isn't a Joomla issue :)

avatar zero-24 zero-24 - change - 7 Jul 2015
Labels Added: ?
Build staging

Add a Comment

Login with GitHub to post a comment