Jump to content

Recent Topics


Adriano Faria
 Share

Recommended Posts

  • 2 weeks later...

SELECT forums_topics.tid FROM `forums_topics`  LEFT JOIN `forums_forums` ON forums_topics.forum_id=forums_forums.id WHERE forums_forums.password IS NULL AND forums_forums.can_view_others=1 AND forums_forums.club_id IS NULL AND ( forums_forums.id NOT IN('3','4','5','6','7','8','9','10','11','12','13','14','15','16','18','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','82','155','156','157','158','159','162','171','172','173','174','175','176','177','178','180','181','183','186','187','188','189','192','214','215','216','217','218','220','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265') ) AND forums_topics.approved < 2 AND forums_topics.approved!=-2 AND forums_topics.approved!=-3 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_topics.forum_id IN(4,6,9,10,11,12,13,14,15,16,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,157,158,159,160,161,162,163,164,166,167,168,169,170,171,173,174,175,176,177,178,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,260,261,262,263,264,265,266,267,272) AND ( forums_forums.password IS NULL OR ( FIND_IN_SET(4,forums_forums.password_override) ) ) AND forums_forums.min_posts_view<=3263 ORDER BY last_post DESC LIMIT 5
Column 'last_post' in order clause is ambiguous

 

#0 /var/www/html/105119/system/Db/Select.php(383): IPS\_Db->preparedQuery('/*s290805::s290...', Array, true)
#1 /var/www/html/105119/system/Db/Select.php(441): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 /var/www/html/105119/system/Content/Item.php(3136): iterator_to_array(Object(IPS\Db\Select))
#4 /var/www/html/105119/applications/forums/sources/Topic/Topic.php(302): IPS\Content\_Item::getItemsWithPermission(Array, 'last_post DESC', '5', 'read', true, 0, Object(IPS\Member), true, false, false, false, NULL, false, true, true, true, false)
#5 /var/www/sitefiles/s290805/applications/recenttopics/sources/Topic/Topic.php(43): IPS\forums\_Topic::getItemsWithPermission(Array, 'last_post DESC', '5', 'read')
#6 /var/www/html/105119/system/Theme/Theme.php(860) : eval()'d code(18): IPS\recenttopics\_Topic::getRecentTopics()
#7 /var/www/html/105119/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_recenttopics_front_index->recentTopics()
#8 /var/www/html/105119/system/Theme/Theme.php(860) : eval()'d code(2053): IPS\Theme\_SandboxedTemplate->__call('recentTopics', Array)
#9 /var/www/html/105119/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_forums_front_index->index()
#10 /var/www/html/105119/applications/forums/modules/front/forums/index.php(201): IPS\Theme\_SandboxedTemplate->__call('index', Array)
#11 /var/www/html/105119/system/Dispatcher/Controller.php(101): IPS\forums\modules\front\forums\_index->manage()
#12 /var/www/html/105119/applications/forums/modules/front/forums/index.php(52): IPS\Dispatcher\_Controller->execute()
#13 /var/www/html/105119/system/Dispatcher/Dispatcher.php(152): IPS\forums\modules\front\forums\_index->execute()
#14 /var/www/html/105119/index.php(13): IPS\_Dispatcher->run()
#15 {main}

Screen Shot 2020-11-12 at 00.31.39.png

Edited by typography
Link to comment
Share on other sites

  • 3 weeks later...
  • 1 month later...
On 9/22/2020 at 3:04 PM, Adriano Faria said:

It seems ok to me:

I never said I would. You said you had added a link to it. Do it again. I have no interest in add this link.


I found that THIS reinstall worked for me. Now I can see the app. However, only I can see it. My users can't. When I try to allow all users to see it, then they can't see it. 

1 minute ago, mcmastadon said:


I found that THIS reinstall worked for me. Now I can see the app. However, only I can see it. My users can't. When I try to allow all users to see it, then they can't see it. 

Actually, I figured it out. I reinstalled it.

Link to comment
Share on other sites

  • 1 month later...
  • 3 months later...

I noticed a much longer load time when using the "Recent Topics" app/plugin.  Is there a way I can optimize it?  When I use the IPS Topics Feed, it does not have the same effect. 

 

Edited by GoGators
Link to comment
Share on other sites

Topics Feed is a widget and it is cached. It doesn’t query the DB at every page load as mine does.

Recent Topics isn’t a widget and it loads the latest 5 topics (with replies) you have permission to view. I know a board with more than 1,000,000 posts that runs it just fine.

Can you share your URL? Message if you don’t want to share it publicity. 

Link to comment
Share on other sites

  • 1 month later...
On 6/24/2021 at 12:14 PM, GoGators said:

I noticed a much longer load time when using the "Recent Topics" app/plugin.  Is there a way I can optimize it?  When I use the IPS Topics Feed, it does not have the same effect. 

 

I'm having the same problem, on the forum home where the widget appears, it's taking a long time to load
 

On 6/24/2021 at 12:42 PM, Adriano Faria said:

Topics Feed is a widget and it is cached. It doesn’t query the DB at every page load as mine does.

Recent Topics isn’t a widget and it loads the latest 5 topics (with replies) you have permission to view. I know a board with more than 1,000,000 posts that runs it just fine.

Can you share your URL? Message if you don’t want to share it publicity. 

here is the forum url https://xtibia.com/forum/

Link to comment
Share on other sites

5 minutes ago, Gustavo Pereira said:

I'm having the same problem, on the forum home where the widget appears, it's taking a long time to load

Yes, well I disabled the plugin because of this.  I am presently using the default Topic Feed Block as a replacement.

Link to comment
Share on other sites

2 minutes ago, GoGators said:

Yes, well I disabled the plugin because of this.  I am presently using the default Topic Feed Block as a replacement.

I never got an answer:

On 6/24/2021 at 12:42 PM, Adriano Faria said:

Topics Feed is a widget and it is cached. It doesn’t query the DB at every page load as mine does.

Recent Topics isn’t a widget and it loads the latest 5 topics (with replies) you have permission to view. I know a board with more than 1,000,000 posts that runs it just fine.

Can you share your URL? Message if you don’t want to share it publicity. 

 

Link to comment
Share on other sites

Posted (edited)
On 8/9/2021 at 1:06 PM, GoGators said:

Yes, well I disabled the plugin because of this.  I am presently using the default Topic Feed Block as a replacement.

 

On 8/9/2021 at 1:27 PM, GoGators said:

I temporarily enabled it so you can see.  Click on any of the other apps and you can see they load quickly.  This app does not.  

https://the-armory.net/

I have also changed to the default theme/style

I honestly don't see any slowness there:

- As a guest:

- Logged as a user:

Is it slow the way you said?

Tested on latest Firefox, Chrome and Edge.

You have to remember that this isn't a widget, so it isn't cached. It queries the DB at every page load.

Edited by Adriano Faria
Removed videos
Link to comment
Share on other sites

On 8/9/2021 at 4:31 PM, Adriano Faria said:

Is it slow the way you said?

Since I changed to PHP 8, it seems be loading faster now.  It's only a few ms' slower and within acceptable performance, but that's because it's calling the DB as you stated.  For future speed tests, you might try one of these sites.  

https://gtmetrix.com/

https://www.webpagetest.org/

https://developers.google.com/speed/pagespeed/insights/

Also, would you please remove the YouTube videos of my website.

Thanks in advance.  🙂

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...