[grey580]

I have changed the order of the categories in the category management page. However my category order does not match the order of categories in the category management page.

Is there a way to refresh the categories? or reset them?

[Yankidank]

Try clearing the template cache by deleting the contents of /templates_c.
Sometimes you have to confirm that the categories shifted in the category manager by revisiting the page. You sometimes need to reset the order for it to catch.

[grey580]

Is there a way to do it directly from the database?
without having to hassle with the management page?
If I can order it manually that would be great.

[Yankidank]

You could open up phpmyadmin and navigate to your pligg_categories table then change the field numbers for "category_order" to reflect the order you want them to display in.

[grey580]

After taking a look at the cat table. i'm seeing. i have
0 for the category parent.
looking at the category order column i see that i have the entries in the right order. But the navigation isn't changing.

Where is the query that controls the display of the navigation? it looks like it's not ordering by the category_order for some reason. I'd like to double check if that is the case.

[Yankidank]

Did you do as I suggested and clear the /templates_c directory? The sidebar content is cached a lot of the time and won't rebuild itself unless you delete the cache.

[grey580]

Absolutely sure did. However that was not the issue.

we are using a template called yournews.
after looking at the mysql query that gets the categories. it seems that it was not ordering by the category order. it was just grabbing the categories with no ordering at all.

after adding an order to the query it worked like a charm.

thank you for helping. i appreciate it.

If anyone else needs this fixed. Follow these steps.
1. In the yournews template folder open dropmenu.tpl
2. look for line 41
3. replace this

PHP Code:

$rq  = "SELECT * FROM ". table_prefix . "categories WHERE category_parent = '0' "; 


with

PHP Code:

$rq  = "SELECT * FROM ". table_prefix . "categories WHERE category_parent = '0' order by category_order "; 


4. look for line 54
5. replace this

PHP Code:

 $rq = "SELECT * FROM ".table_prefix . "categories WHERE category_parent = '".$rez3[$i]["category__auto_id"]."'"; 


with

PHP Code:

 $rq = "SELECT * FROM ".table_prefix . "categories WHERE category_parent = '".$rez3[$i]["category__auto_id"]."'  order by category_order"; 


6. save and upload.

Hope this helps others.

[Yankidank]

Glad it wasn't an issue with Pligg.