#
User_4343977

Question: Sorting categories

**Answer:**provided by

and there's one more bug, in admin panel ->manage->categories it's impossible to select order of categories, the order is not saved, and it's quite random. It sometimes remember order of main categories, but never subcategories.

Question: Sorting categories

**Answer:**provided by

Thanks for and answer. I have 3 main categories and in one main category there are 10 subcategories. Even with reloading it's impossible to order them properly. I was thinking about setting the order numbers directly into database, but can't figure out what is the mechanism of assigning numbers of categories and subcategories. If someone know that could you tell ? When I figure it out I'll post the solution :) thanks

Question: Sorting categories

**Answer:**provided by

I have a solution. I'll explain it on example (I added 2 screenshots) To order categories manually you have to change values in 3 columns in pligg_categories in your Database. First column to look for is category_order. The numbers depends on the number of main categories you have.

1.Add 1 to number of main categories you want to have.

2. Change sign to have a negative number.

The number you get is a value for the first main category from the left (if you look at front end).

I had 3 main cateogries therefore 3+1 = 4, so my value for category order column is -4 for 'main category 1'

For next category you have to add 1 to the previous value.

As you can see on attachment 'pligg_category in DB' my Main categories have values -4, -3, -2 .

Sub categories are ordered from 0 to n-1 for each Main category.

Now you have to fill 'rgt' and 'lft' columns with values.

I think the columns are abbreviations of left and right because as you can see on attachment 'Front End' the values from rgt are for right side of each category button, and lft for left side. So please number your categories as you wish them to look.

WARNING ( I have a sub category under Main cateogry 2, so watch for that when you analyze my screenshots).

I hope it'll do the trick unless Pligg guys improve source files.

1.Add 1 to number of main categories you want to have.

2. Change sign to have a negative number.

The number you get is a value for the first main category from the left (if you look at front end).

I had 3 main cateogries therefore 3+1 = 4, so my value for category order column is -4 for 'main category 1'

For next category you have to add 1 to the previous value.

As you can see on attachment 'pligg_category in DB' my Main categories have values -4, -3, -2 .

Sub categories are ordered from 0 to n-1 for each Main category.

Now you have to fill 'rgt' and 'lft' columns with values.

I think the columns are abbreviations of left and right because as you can see on attachment 'Front End' the values from rgt are for right side of each category button, and lft for left side. So please number your categories as you wish them to look.

WARNING ( I have a sub category under Main cateogry 2, so watch for that when you analyze my screenshots).

I hope it'll do the trick unless Pligg guys improve source files.

Answer:provided by user_4343977 17 days agocomment search, user search and tag search

don't work, which is quite sad.

Will there be some bugfixes anytime soon ?