Adriano Faria Posted November 2, 2020 Author Share Posted November 2, 2020 6 hours ago, typography said: I'm getting a display error on my forum - it's showing on three different threes (one of them is the default theme). Any advice? Also, FWIW, I've made sure all themes etc. are up to date, but I'm still getting stuck with the notice. Post the log entry for this error. Link to comment
typography Posted November 12, 2020 Share Posted November 12, 2020 (edited) 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} Edited November 12, 2020 by typography Link to comment
Adriano Faria Posted November 12, 2020 Author Share Posted November 12, 2020 What's New in Version 1.1.3: Fix error reported. Link to comment
Kooyot Posted November 30, 2020 Share Posted November 30, 2020 (edited) @Adriano Faria Hello, I just bought the application today. I set everything up in the settings, the application is obviously turned on and it does not show up in "Block management" to add it to the home page. Do you know anyone what could be the reason? Quote Problem solved! Edited November 30, 2020 by devv Adriano Faria 1 Link to comment
Adriano Faria Posted November 30, 2020 Author Share Posted November 30, 2020 I know. This is not a widget so it won’t show up in Block Manager. Choose the groups and it will show up in the index. Kooyot 1 Link to comment
OGXbox Posted December 2, 2020 Share Posted December 2, 2020 On 10/29/2020 at 10:59 AM, Adriano Faria said: Couldn't reproduce in my onlline board. I'll install it today later on a fresh install to see how it goes. I'll reply back. Did you ever get anywhere on this? Link to comment
Adriano Faria Posted December 2, 2020 Author Share Posted December 2, 2020 No, works fine to me and it seems for others too. A version was released in novemeber, 12. Are you using latest version? Link to comment
mcmastadon Posted January 26, 2021 Share Posted January 26, 2021 Please assist: I can't figure out how to even use the application. It is installed and enabled, but I don't see how to make it work on my forum. Is there a manual or a video I can follow? Link to comment
mcmastadon Posted January 26, 2021 Share Posted January 26, 2021 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
Adriano Faria Posted January 26, 2021 Author Share Posted January 26, 2021 There’s notes different here: install it and chose which groups can see it. That’s all. Link to comment
Adriano Faria Posted March 4, 2021 Author Share Posted March 4, 2021 What's New in Version 1.1.4 Compatibility version with Tabbed Forums Index. Link to comment
GoGators Posted June 24, 2021 Share Posted June 24, 2021 (edited) 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 June 24, 2021 by GoGators Link to comment
Adriano Faria Posted June 24, 2021 Author Share Posted June 24, 2021 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
Gustavo Pereira Posted August 9, 2021 Share Posted August 9, 2021 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/ GoGators 1 Link to comment
Adriano Faria Posted August 9, 2021 Author Share Posted August 9, 2021 3 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 here is the forum url https://xtibia.com/forum/ Send a message with ACP access. I’ll debug the app in your install later. Link to comment
GoGators Posted August 9, 2021 Share Posted August 9, 2021 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
Adriano Faria Posted August 9, 2021 Author Share Posted August 9, 2021 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
GoGators Posted August 9, 2021 Share Posted August 9, 2021 13 minutes ago, Adriano Faria said: I never got an answer: 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 Link to comment
Adriano Faria Posted August 9, 2021 Author Share Posted August 9, 2021 Mobile device now. Can’t do much. Send a message with ACP access so I can debug it. 👍 Link to comment
Adriano Faria Posted August 9, 2021 Author Share Posted August 9, 2021 (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 August 14, 2021 by Adriano Faria Removed videos Link to comment
GoGators Posted August 14, 2021 Share Posted August 14, 2021 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
Anton N Posted October 5, 2021 Share Posted October 5, 2021 Can the block position be on the right? Link to comment
Adriano Faria Posted October 5, 2021 Author Share Posted October 5, 2021 Just now, Anton Nikolaykin said: Can the block position be on the right? No: On 1/8/2019 at 7:48 AM, Adriano Faria said: Block position: Before of After forums categories This is not a widget. It's a "hardcoded" block. Link to comment
uA_Y_C_A Posted January 4, 2022 Share Posted January 4, 2022 [[Template recenttopics/front/index/recentTopics is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]] After the update 😞 Link to comment
Adriano Faria Posted January 4, 2022 Author Share Posted January 4, 2022 6 minutes ago, uA_Y_C_A said: [[Template recenttopics/front/index/recentTopics is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]] After the update 😞 No crystal ball here. Update to what? Also, post the content of the log error. A generic message like that tells me nothing about the issue. Link to comment
Recommended Posts