Upgraded to 4.4 and receive error

[jp]

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]

this seems to be an issue with the 

 TDBPosts

widget (whatever this is:D ) I would suggest to disable all your 3rd plugins )

[jp]

I've disabled the block I had for TDB Posts and I think that might have fixed it. 

 

[Daniel F]

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]

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.