Closed GoogleCodeExporter closed 9 years ago
more info: pathfile_id is a rubbish:
uguu=> select * from paths where tree_id = 13 and parent_id = 2 and
parentfile_id = 544;
tree_id | treepath_id | parent_id | parentfile_id | path | items | size
---------+-------------+-----------+---------------+---------------------------+
-------+------------
13 | 3730 | 2 | 544 | anime/Kannagi =Ayako= | 13 | 2334016664
13 | 4596 | 2 | 544 | anime/Kanamemo =polished= | 13 | 3910392927
(2 rows)
uguu=> select tree_id,treepath_id,pathfile_id,treedir_id,name from files where
tree_id = 13 and treepath_id = 2 and name in ('Kannagi =Ayako=', 'Kanamemo
=polished=');
tree_id | treepath_id | pathfile_id | treedir_id | name
---------+-------------+-------------+------------+---------------------
13 | 2 | 581 | 4596 | Kanamemo =polished=
13 | 2 | 582 | 3730 | Kannagi =Ayako=
Original comment by ruslan.savchenko
on 30 Aug 2010 at 7:15
what i mean is "parentfile_id is a rubbish". This should be fixed.
Original comment by ruslan.savchenko
on 30 Aug 2010 at 7:16
fixed in revision 3d31206d43
Original comment by ruslan.savchenko
on 1 Sep 2010 at 5:10
Original issue reported on code.google.com by
ruslan.savchenko
on 30 Aug 2010 at 7:01