Support Forum
Support Forum
Offline
The code is fine and it is working fine on my dev system.
So... what Simple:Press plugins - if any - are you using please?
 |
YELLOW
SWORDFISH
|
Offline
Quite a lot:
Here's the list:
Admin Bar
Announce
Answers Topic
Birthdays
Editor Tiny...
File Uploader...
Font Resizer
Language and Theme Selection (not active)
Mentions
Post Preview
Profnity Filter
Ranks Information
Share This (not active)
Subscriptions
Template Tags and Widgets
Unaswered Topics
Watches
...maybe it was easier to list the ones I do not use
My forum (in Italian) is: MsPforum
Offline
No... nothing there should be interfering. I asked because some plugins will also modify the base query but that all still looks fine.
I am puzzled bit intrigued.
Can you try one more thing? Put the new code file in place. Go to the forum admin > toolbox > error log and clear it out (button at bottom). Run one of your forums in form view (list of topics). I assume it will be 'damaged'. Revisit the error log (reload the panel) to see if any fatal errors occurred.
|
YELLOW
SWORDFISH
|
Offline
Andy, this is what I see in the error log after having done what you said:
file: /membri/mspforum/mspforum/wp-content/plugins/simple-press/forum/content/classes/sp-forum-view-class.php
line: 319
function: select
error: Unknown column 'spf_sftopics.topic_id' in 'order clause'
SELECT avwp_sftopics.forum_id, forum_slug, forum_name, forum_status, group_id, topic_count, forum_icon, topic_icon, topic_icon_new, topic_icon_locked, topic_icon_pinned, forum_desc, forum_rss, forum_rss_private, parent, children, forum_message, forum_disabled, keywords, avwp_sftopics.topic_id, topic_slug, topic_name, topic_status, topic_pinned, topic_opened, avwp_sftopics.post_id, avwp_sftopics.post_count FROM avwp_sftopics JOIN avwp_sfforums ON avwp_sftopics.forum_id = avwp_sfforums.forum_id WHERE avwp_sfforums.forum_id=6 ORDER BY topic_pinned DESC, spf_sftopics.topic_id DESC LIMIT 0, 12
My forum (in Italian) is: MsPforum
Offline
Sono un idiota!
I am so sorry. I forgot all about the WP table prefix, The line if code that I gave you:
$db->orderby = 'topic_pinned DESC, spf_sftopics.topic_id DESC';
should be:
$db->orderby = 'topic_pinned DESC, '.SFTOPICS.'.topic_id DESC';
!
|
YELLOW
SWORDFISH
|
Offline
Funzionaaaaaaaaaaaaaaa
And your spelling was absolutely perfect
Thanks a lot!!!
My forum (in Italian) is: MsPforum
Offline
Excellent. And again - sorry for my stupidity!
|
YELLOW
SWORDFISH
|
Offline
Don't worry Andy, I have done much worse, trust me!
My forum (in Italian) is: MsPforum
All RSS1 Guest(s)