Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
themes-topic
Sub-Forums not showing in correct order
Avatar
foxy7
Member
Free Members
sp_UserOfflineSmall Offline
Dec 14, 2013 - 8:22 pm

PM

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 14, 2013 - 10:42 pm

sorry, what does pm mean?  did you send a pm?  just to yellow swordfish?

to get the db table, you will want to use phpmyadmin or db tool of your choice... and then extract the wp_sfforums table...  your wp db prefix might be other than wp_

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Dec 16, 2013 - 6:26 am

OK - database table received thanks. You have a fringe case here but there is an easy fix and we will include this in the next update (which will be 5.4.1). If you want to apply it now then (using the current 5.4.0 file):

The code file needed is /simple-press/forum/content/classes/sp-forum-view-class.php

The function that contains the code to be edited is sp_forumview_query()

You need to locate the line of code that is literally:

foreach($topSubs as $topSub) {

Note that this code appears twice and BOTH instances require the following change. Before editing these lines should be found at line numbers 404 and 499.

Immediately BEFORE the above line of code - add the new line:

sort($topSubs);

and that should resolve things.

 

andy-signature.png
YELLOW
SWORDFISH
Avatar
foxy7
Member
Free Members
sp_UserOfflineSmall Offline
Dec 16, 2013 - 7:37 am

Amazing, that did it!! :D

However it's not possible to move the subforums, they will either move to some random position or not move at all. Also as mentioned in #10, the main forums will move to random positions. Any easy fix available for these too? 

EDIT: Actually, the subforums does show "in order" now on the website. But when I try change the ordering, it will not show on the website, as the previous one is frozen.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Dec 16, 2013 - 8:17 am

To be honest I rather suspect that the main problem here is the sheer number of forums and subforums you have defined. We have a task already planned to rewrite the positioning code and I think it is probably being overwhelmed. Which makes it difficult for me to offer a quick and simple solution. And I do apologise for that.

One quick and dirty way of doing this is to go into the database and edit the data direct but it's not really a very satisfactory way of changing things.

Let me talk it over with colleagues here. But - meanwhile - I am not sure I fully understand your last sentence. What do you mean by 'frozen' please? Can you expand on that?

andy-signature.png
YELLOW
SWORDFISH
Avatar
foxy7
Member
Free Members
sp_UserOfflineSmall Offline
Dec 16, 2013 - 8:45 am

Okay, I see. Well, at least I can work with it for now, assuming I won't make any mistakes and have to change positions. The direct datachange is also a good alternative, but as you say, not really a satisfactory way of doing it.. 

What I meant with my last sentence was just this:

Tried change positions, but showed other:

http://s150.photobucket.com/us.....1.png.html

Shows correctly here though:

http://s150.photobucket.com/us.....4.png.html

No change in the subforums:

http://s150.photobucket.com/us.....3.png.html

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Dec 16, 2013 - 9:02 am

I have started a topic off here to discuss possible solutions.

I have also now realised that the fix I gave you is not going to be suitable as a permanent fix for this so i need to take another look at that. Hopefully if all goes well - later today.

andy-signature.png
YELLOW
SWORDFISH
Avatar
foxy7
Member
Free Members
sp_UserOfflineSmall Offline
Dec 16, 2013 - 9:10 am

That sounds very good, thanks a lot! 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 16, 2013 - 9:54 pm

will let you know what we come up with... 

Avatar
foxy7
Member
Free Members
sp_UserOfflineSmall Offline
Jan 6, 2014 - 4:00 am

Can you give me an update on this?

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626