Sub-category files counting #3 - [Solved - Not really a bug!!!]

[schmatzler]

I'm sorry to bother you again, guys

I've updated to the latest beta and the problem from my last thread still exists. There is one category and all subcategories in it that show zero files, but there are a lot in them.

You can see it here: http://www.i-war2.com/downloads/category/6-mods

Everything below the "Group Mods" section seems to be empty, but it isn't.

Thanks for checking

[Arno]

Uff.... sorry again. 
I will check this (more extensively this time) later today. I will then post here a fix...

[Arno]

Maybe can you create a backup from jD (with the backup function on the jD tools page) and send me for it a download link via PM?
It would much be easier for me to test it with your structure.  

It is not so easy for me to reproduce your bug here.
Use you the Joomla cache option?

[schmatzler]

Hello,

thanks for the reply Caching is turned off. I will send you a backup via PM.

[ColinM]

@Arno
Just an observation but the one that goes wrong, Group mods, has the 'no files are available for tis category' at the end of the list. The other two do not have that message
Colin

[Arno]

@ Colin,
many thanks for your note. But i think i have found the problem.

@ schmatzler,
thanks for the backup file.
Can it be that you had imported the jD data from the older 1.9.x series?

Fact is, that in your case you have sub categories which have a lower ID number as the parent category. This is very unlogical and normally not possible.
But this is normally not possible and the reason for the wrong calculation. Therefore it is not possible for me to reproduce this wrong result it here. Only with your backup file.

How can we solve this?

To change the calculation for this is not a good idea.
So you should do this:

1) you should have a backup from your currently jD upload folder (default: /jdownloads) but not stringently required
2) create a backup from the jD tables
3) go to the jd configuration and set the download area offline (TAB: Frontend)
4) go to the categories in backend
5) change the name/title from the category: Group Mods to Group Mods old
6) create a new category with the title 'Group Mods' and select as parent category again 'Mods'
7) select now all subcategories from the older 'Group Mods old' and click on the batch icon on top
select move and as target category now the new created 'Group Mods'
9) when you get not any errors, you can now delete the old category 'Group Mods'
10) finally set the download area again online and check the result.

I think this is done all in 5 minutes.  

When you find another subcategories which have an lower ID as the parents, you should change it in the same way.

[schmatzler]

That worked. Although when moving the downloads into a different category, the folders were emptied. Good thing that I do daily backups

I started up the website with JDownloads 3.2.19 - but I made a little mistake first. I created some of the categories, accidentially deleted JDownloads and when I copied it back, I restored only some of the database files. I guess that caused the numbering to go wrong.

Thanks for the help again!

[Arno]

I started up the website with JDownloads 3.2.19 - but I made a little mistake first. I created some of the categories, accidentially deleted JDownloads and when I copied it back, I restored only some of the database files. I guess that caused the numbering to go wrong.

Yes this can be the reason. So i think we have solved your problem finally.
But note, that a wrong ID structure can also be the reason for other problems. As example when you will define different permission settings.
So please consider this when you should find later other problems.