News:

Support for jDownloads 3 has been ended
Since 17 August 2023 Joomla.org has discontinued support for Joomla 3.x. Therefore, we will no longer offer official support for our Joomla 3 jDownloads version 3.9.x from January 2024.
Please update your website to the latest Joomla version (Joomla 4 or Joomla 5) as soon as possible. Afterwards, please update jDownloads to the latest published version. The longer you delay, the more difficult the upgrade process for your website is likely to be.

Main Menu
Support-Forum

Problem with a very large category (above 38000 categories)

Started by nzy182, 16.10.2017 21:38:38

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

nzy182

Hi, how many categories can be created here?
Actually I have about 38k categories (level 2) and 270k categories (lv3), but I have tried earlier by importing 38k categories (level2). After successful imported 38k categories,  I tried to edit or create category but I have problem with displaying list of "parent category". It seems firefox cannot handle list of 35k categories so it causes "unresponsive script".

I hope there is a solution for this or is there an option to display the list of parent categories in order not to directly display the entire category, such as the appearance gradually, or maybe the appearance based on autosearch each alphabet that has been typed?

UPDATED
:
it turns out tens of thousands too much even I try with 5k data will result in loading page on the front end to be very long resulting in failure such as "Error 500 - Internal Server Error"
I hope in the future jdownloads supports a lot of data

[gelöscht durch Administrator]
  •  

ColinM

Hi
38k categories is a lot! It takes some time to create them. I am not sure of the maximum number of Categories. In the database the ID is a 11 digits so there is not a limit in a practical sense.
Think the problem might be with the pulldown list that jD will try to create in the layouts.  I do not think you will want the pulldown - it would slow you up any way!!

In the Categories section of layouts please see which one is selected as the Active one.  It is probably "Standard Categories Layout (3.2)". Whichever one is the active one make a copy and then set the copied one as the Active one.
In the Header section there is a line
    <div class="jd_top_navi_catbox" style="" >{category_listbox}</div>
Just remove that line and it will not attempt to make the long list of categories. (maybe it has an upper limit but anyway it is a slow process).

You also need to to follow the same procedure for the Category section.  The active one is probably "Standard Category Layout (3.2)".
Making a copy means if there is an update to the standard layouts then the copied layouts will not be changed.

If you need a bit of help please first see the documentation layouts section
http://www.jdownloads.net/documentations/category/editing-layouts

Of course I will also help.
Colin
Colin M
  •  

nzy182

hi,
Thank you for your reply. is this for front end?i mean the problem is in my back end. i want create category and edit category but i have problem with that pull-down.
  •  

ColinM

Hi
I thought it was from the Front End you were having a problem!! So yes the suggestion I made was just a Front end one.
To help further I would need super admin access to your backend and also to allow me to add in a file manager component such as eXtplorer so as to see the actual directory structure.
To send me the details by Private Message please click on the small whitesh 'square with a tail' near my name on the forum.

How many top level categories do you have?

Colin
Colin M
  •  

nzy182

I just try it on localhost (just for test) but I can provide backup data for 38k categories,
but I think the problem is in pulldown trying to display all categories (almost 38k cats).
I have 493 top level cats (lv1)
  •  

ColinM

Hi
Yes I also think the problem area is when jD is creating the pulldown for Categories.  In the backend this is on the Downloads page. Will discuss with Arno.
Colin
Colin M
  •  

Arno

Hi,
I think it is not possible to solve your problem shortly. The process to build the select listbox with over 38,000 fields is to long. But it is useless to try it only with the base categories. Sure, you could type in the category id manually but also this modification would be much work and I cannot do it for a single user.

When you will you can send me via PM your categories (backup) data. Maybe can I find another possibility.
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!
  •  

nzy182

Hi for the time being i have solved this pull-down problem by adding attribute size:
<select id = "jform_parent_id" name = "jform [parent_id]" class = "inputbox" aria-invalid = "false">
to
<select size = "30" id = "jform_parent_id" name = "jform [parent_id]" class = "inputbox" aria-invalid = "false">
I have tried it for almost 300k categories but this is not efficient because the addition of this attribute is done through the inspect element feature of firefox so users have to add it everytime they want to edit / add category.

ok i will send you the backup data
  •  

ColinM

Hi
I think the code you have found is for the Front End.  If you look in Config - Front End tab there is a field "Display Category list box in header?" which you can set to No to avoid the list being created.  Alternatively you can in the following question you can set the number of levels to 1
Colin
Colin M
  •  

nzy182

yes my settings for the front end in the "Display Category list box in header?" is "No" but the code is also in the back end
("administrator/index.php?option=com_jdownloads&view=category&layout=edit" and
"administrator/index.php?option=com_jdownloads&view=download&layout=edit")

by the way, I have sent my backup data before but I checked it in "Sent Items" there is no history, maybe there is a mistake here, I will try to reupload, thanks
  •