jp Posted February 25, 2019 Posted February 25, 2019 Hi I have just upgraded to 4.4, however, receive and error every so often. I am still trying to work out what triggers the error as it doesn't happen all the time. I thought I had upgraded all my third party apps to 4.4 compatible versions. Sorry, there is a problem Something went wrong. Please try again. Error code: EX1052 SELECT forums_topics.tid FROM `ipb_forums_topics` AS `forums_topics` LEFT JOIN `ipb_forums_forums` AS `forums_forums` ON ( forums_forums.password IS NULL OR ( FIND_IN_SET(4,forums_forums.password_override) ) ) AND forums_forums.min_posts_view<=936 AND forums_topics.forum_id=forums_forums.id WHERE forums_forums.password IS NULL AND forums_forums.can_view_others=1 AND ( forums_topics.approved=1 OR ( forums_topics.approved=0 AND ( forums_topics.starter_id=34142 ) ) ) AND forums_topics.approved!=-2 AND forums_topics.approved!=-3 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_topics.forum_id IN(16,20,21,27,28,30,31,33,34,36,37,39,40,42,44,45,49,52,53,54,55,56,57,58,60,64,66,69,70,71,72) ORDER BY posts desc LIMIT 3 IPS\Db\Exception: Column 'posts' in order clause is ambiguous (1052) #0 /var/www/html/r264089/system/Db/Select.php(373): IPS\_Db->preparedQuery('/*IPS\\Content\\_...', Array, true) #1 /var/www/html/r264089/system/Db/Select.php(436): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 /var/www/html/r264089/system/Content/Item.php(2853): iterator_to_array(Object(IPS\Db\Select)) #4 /var/www/html/r264089/applications/forums/sources/Topic/Topic.php(296): IPS\Content\_Item::getItemsWithPermission(Array, 'posts desc', 3, 'read', false, 0, Object(IPS\Member), true, false, false, false, NULL, false, true, true, true, false) #5 /var/www/html/r264089/plugins/tdbposts/widgets/TDBPosts.php(382): IPS\forums\_Topic::getItemsWithPermission(Array, 'posts desc', 3, 'read', false) #6 /var/www/html/r264089/system/Widget/Widget.php(765): IPS\plugins\tdbposts\widgets\_TDBPosts->render() #7 /var/www/html/r264089/system/Theme/Theme.php(840) : eval()'d code(16419): IPS\_Widget->__toString() #8 /var/www/html/r264089/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->widgetContainer('sidebar', 'vertical') #9 /var/www/html/r264089/system/Theme/Theme.php(840) : eval()'d code(13916): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #10 /var/www/html/r264089/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->sidebar('right') #11 /var/www/html/r264089/system/Theme/Theme.php(840) : eval()'d code(6250): IPS\Theme\_SandboxedTemplate->__call('sidebar', Array) #12 /var/www/html/r264089/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->globalTemplate('27449a9e43cc976...', '\n\n\n\n\n\n\n<div cla...', Array) #13 /var/www/html/r264089/system/Dispatcher/Dispatcher.php(172): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #14 /var/www/html/r264089/system/Dispatcher/Standard.php(118): IPS\_Dispatcher->finish() #15 /var/www/html/r264089/system/Dispatcher/Front.php(575): IPS\Dispatcher\_Standard->finish() #16 /var/www/html/r264089/system/Dispatcher/Dispatcher.php(154): IPS\Dispatcher\_Front->finish() #17 /var/www/html/r264089/index.php(13): IPS\_Dispatcher->run() #18 {main} any ideas?
Daniel F Posted February 25, 2019 Posted February 25, 2019 this seems to be an issue with the TDBPosts widget (whatever this is:D ) I would suggest to disable all your 3rd plugins )
jp Posted February 25, 2019 Author Posted February 25, 2019 I've disabled the block I had for TDB Posts and I think that might have fixed it.
Daniel F Posted February 25, 2019 Posted February 25, 2019 Thanks for confirmation.Well, the plugin isn't marked as 4.4 compatible 😉 That's something to keep in mind for the next upgrade! We've introduced the compatibility feature in the marketplace exactly for this use case 🙂
jp Posted March 5, 2019 Author Posted March 5, 2019 yep, I understand that thanks. I have lots of apps and plugins and thought I had checked off all of them but this one slipped through the cracks.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.