jDownloadsownloads.com


Author Topic: Problem with a very large category (above 38000 categories)  (Read 573 times)

0 Members and 1 Guest are viewing this topic.

Offline nzy182

  • Newbie
  • *
  • Posts: 11
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
« Last Edit: 09.11.2017 08:30:29 by nzy182 »

Offline ColinM

  • Moderator
  • *
  • Posts: 3.541
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

Offline nzy182

  • Newbie
  • *
  • Posts: 11
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.

Offline ColinM

  • Moderator
  • *
  • Posts: 3.541
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

Offline nzy182

  • Newbie
  • *
  • Posts: 11
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)

Offline ColinM

  • Moderator
  • *
  • Posts: 3.541
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

Offline Arno

  • Administrator
  • ***
  • Posts: 12.244
    • jDownloads.com
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.
« Last Edit: 19.10.2017 11:54:27 by Arno »
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline nzy182

  • Newbie
  • *
  • Posts: 11
Hi for the time being i have solved this pull-down problem by adding attribute size:
Code: [Select]
<select id = "jform_parent_id" name = "jform [parent_id]" class = "inputbox" aria-invalid = "false">to
Code: [Select]
<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

Offline ColinM

  • Moderator
  • *
  • Posts: 3.541
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

Offline nzy182

  • Newbie
  • *
  • Posts: 11
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