jDownloads Support Forum

Older Versions => jDownloads 3.2 (Support ended) => Bugs => Topic started by: schmatzler on 07.01.2015 00:47:54

Title: Sub-category files counting #3 - [Solved - Not really a bug!!!]
Post by: schmatzler on 07.01.2015 00:47:54
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 :)
Title: Re: Sub-category files counting #3
Post by: Arno on 07.01.2015 08:50:21
Uff.... sorry again.  :-\
I will check this (more extensively this time) later today. I will then post here a fix...
Title: Re: Sub-category files counting #3
Post by: Arno on 07.01.2015 12:52:30
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?
Title: Re: Sub-category files counting #3
Post by: schmatzler on 07.01.2015 23:08:39
Hello,

thanks for the reply :) Caching is turned off. I will send you a backup via PM.
Title: Re: Sub-category files counting #3
Post by: ColinM on 08.01.2015 02:13:47
@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
Title: Re: Sub-category files counting #3
Post by: Arno on 08.01.2015 12:02:21
@ 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
8) 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.
Title: Re: Sub-category files counting #3
Post by: schmatzler on 08.01.2015 19:26:33
That worked. Although when moving the downloads into a different category, the folders were emptied. Good thing that I do daily backups :P

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! :)
Title: Re: Sub-category files counting #3 - [Solved - Not really a bug!!!]
Post by: Arno on 08.01.2015 19:43:03
QuoteI 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.  ;)