Support Forum

Featured topics and posts

YO Younès
Younès
Member

I installed Featured topics and posts plugin, I selected some featured topics, but I can’t find the list on the forum?
how can I find this list please?

18 Answers

New Answer

MP Mr Papa
Mr Papa
Member

have you seen this:  https://simple-press.com/documentation/codex/plugins/our-plugins/available-plugins/plugin-featured-topics/

have you added the template tag to your theme to display the list?

YO Younès
Younès
Member

No I didn’t add it yet

I saw the link but I can not find Use Template Tags sp_FeaturedTopicsTag ()”

MP Mr Papa
Mr Papa
Member

sorry, what cant you find?

you would add the template tag, sp_FeaturedTopicsTag($args=”), with any options passed as $args, to your sp theme in the location you want it to display…

YO Younès
Younès
Member

Can you tell me for eg. where i have to add it please?

Sorry, but I’m newbie.

MP Mr Papa
Mr Papa
Member

where do you want it to display??  need to know where you want the output in order to help on where to add the tag…

YO Younès
Younès
Member

No matter where lets do it in the groups (add the topics list in each group) or in main sp header.

I will see the logic and may be i will be able to change it in the futur by my self.

Thanks in advance.

 

BR

MP Mr Papa
Mr Papa
Member

not sure what you mean by in groups, so lets do the header, after the breadcrumbs….  open your spHead.php template file of your sp theme (think you have a child)…

after:

    sp_SectionStart('tagClass=spPlainSection spLeft', 'breadCrumbs');
        sp_BreadCrumbs('tagClass=spLeft spBreadCrumbs&tree=0&truncate=35&homeIcon=&icon=', 'Home');
    sp_SectionEnd('', 'breadCrumbs');

add in the template tag, with a bit of html for organization:

    sp_InsertBreak();
    sp_SectionStart('tagClass=spPlainSection');
        sp_FeaturedTopicsTag ('tagClass=spFeaturedTopics');
    sp_SectionEnd();

then  you can just style it yourself…  or move it elsewhere…

YO Younès
Younès
Member

it does not work, I have an error message telling me that it is not compatible with my database

MP Mr Papa
Mr Papa
Member

what is the relation of the error to the image which is code???

as to the code, did you use the raw code button or just copy the post??  the latter may mess up the quotes – cant tell from image… but that would not be a db error…

on forum – toolbox – error log, you can get more info on the db error…

do you have some featured topics listed in the forum – components – featured topics??

RI RickyMcG
RickyMcG
Member

I’m having a similar problem … “Invalid Database Query” alert.

I’ve checked the code numerous times. Seems fine.

Here’s the error log:

file: /problem-with-post-edit-buttonome/m0nst3r/public_html/wp-content/plugins/simple-press/forum/content/classes/sp-list-post-class.php

line: 154

function: select

error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) AND ouj2wu4b1u_sfposts.forum_id IN (1,2,3,4,5,6) ORDER BY ouj2wu4b1u_sfposts.p’ at line 3

SELECT ouj2wu4b1u_sfposts.post_id, post_content, post_date, ouj2wu4b1u_sfposts.topic_id, ouj2wu4b1u_sfposts.forum_id, ouj2wu4b1u_sfposts.user_id, guest_name, post_status, post_index, forum_name, forum_slug, forum_disabled, ouj2wu4b1u_sfforums.group_id, group_name, topic_name, topic_slug, ouj2wu4b1u_sftopics.post_count, topic_opened, display_name FROM ouj2wu4b1u_sfposts JOIN ouj2wu4b1u_sfforums ON ouj2wu4b1u_sfforums.forum_id = ouj2wu4b1u_sfposts.forum_id JOIN ouj2wu4b1u_sfgroups ON ouj2wu4b1u_sfgroups.group_id = ouj2wu4b1u_sfforums.group_id JOIN ouj2wu4b1u_sftopics ON ouj2wu4b1u_sftopics.topic_id = ouj2wu4b1u_sfposts.topic_id LEFT JOIN ouj2wu4b1u_sfmembers ON ouj2wu4b1u_sfmembers.user_id = ouj2wu4b1u_sfposts.user_id WHERE ouj2wu4b1u_sftopics.post_id = ouj2wu4b1u_sfposts.post_id AND ouj2wu4b1u_sfposts.topic_id IN () AND ouj2wu4b1u_sfposts.forum_id IN (1,2,3,4,5,6) ORDER BY ouj2wu4b1u_sfposts.post_id DESC LIMIT 5

RI RickyMcG
RickyMcG
Member

So, I got things to work by changing the function call to:

 sp_FeaturedPostsTag();
MP Mr Papa
Mr Papa
Member

you switched from featured topics to featured posts… two different things… but if its giving you what you want, then great!