g1nt3r Posted May 10, 2016 Posted May 10, 2016 So I just upgraded to the newest version (4.1.11.1) and now people are getting this error when accessing articles. A refresh fixes it but I'd much rather people just not get an error when going to an article. SELECT forums_posts.*, forums_topics.* FROM `forums_posts` STRAIGHT_JOIN `forums_topics` ON forums_posts.topic_id=forums_topics.tid AND forums_topics.approved=1 STRAIGHT_JOIN `core_permission_index` ON core_permission_index.app='forums' AND core_permission_index.perm_type='forum' AND core_permission_index.perm_type_id=forums_topics.forum_id AND (( ( FIND_IN_SET(13,perm_2) ) ) OR perm_2='*' ) LEFT JOIN `collab_memberships` ON collab_memberships.member_id=6061 AND collab_memberships.status='active' AND collab_memberships.collab_id=forums_forums.collab_id LEFT JOIN `core_permission_index` AS `collab_core_permission_index` ON collab_core_permission_index.app='forums' AND collab_core_permission_index.perm_type='collab_forum' AND collab_core_permission_index.perm_type_id=forums_forums.id LEFT JOIN `forums_forums` ON forums_topics.forum_id=forums_forums.id AND forums_forums.password IS NULL AND forums_forums.can_view_others=1 AND ( forums_forums.password IS NULL OR ( ( FIND_IN_SET(13,forums_forums.password_override) ) ) ) AND forums_forums.min_posts_view<=138 WHERE ( forums_forums.can_view_others=1 OR forums_topics.starter_id=6061 ) AND ( ( forums_forums.collab_id=0 ) OR ( collab_core_permission_index.perm_2='*' OR ( ISNULL( collab_memberships.id ) AND FIND_IN_SET( '-1', collab_core_permission_index.perm_2 ) ) OR ( collab_memberships.id IS NOT NULL AND CONCAT(",", collab_core_permission_index.perm_2, ",") REGEXP ",(0)," ) ) ) AND queued=0 ORDER BY post_date DESC LIMIT 5 IPS\Db\Exception: Unknown column 'forums_forums.collab_id' in 'on clause' (1054) #0 /home/gintersauce/public_html/system/Db/Select.php(346): IPS\_Db->preparedQuery('SELECT forums_p...', Array) #1 /home/gintersauce/public_html/system/Db/Select.php(541): IPS\Db\_Select->runQuery() #2 /home/gintersauce/public_html/system/Patterns/ActiveRecordIterator.php(62): IPS\Db\_Select->count(false) #3 [internal function]: IPS\Patterns\_ActiveRecordIterator->count() #4 /home/gintersauce/public_html/system/Content/WidgetComment.php(328): count(Object(IPS\Patterns\ActiveRecordIterator)) #5 /home/gintersauce/public_html/system/Widget/Widget.php(755): IPS\Content\_WidgetComment->render() #6 /home/gintersauce/public_html/system/Theme/Theme.php(717) : eval()'d code(12767): IPS\_Widget->__toString() #7 [internal function]: IPS\Theme\class_core_front_global->widgetContainer('sidebar', 'vertical') #8 /home/gintersauce/public_html/system/Theme/SandboxedTemplate.php(57): call_user_func_array(Array, Array) #9 /home/gintersauce/public_html/system/Theme/Theme.php(717) : eval()'d code(10641): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #10 /home/gintersauce/public_html/system/Theme/Theme.php(717) : eval()'d code(10641): IPS\Theme\SandboxedTemplate->widgetContainer('sidebar', 'vertical') #11 [internal function]: IPS\Theme\class_core_front_global->sidebar('right') #12 /home/gintersauce/public_html/system/Theme/SandboxedTemplate.php(57): call_user_func_array(Array, Array) #13 /home/gintersauce/public_html/system/Theme/Theme.php(717) : eval()'d code(4901): IPS\Theme\_SandboxedTemplate->__call('sidebar', Array) #14 /home/gintersauce/public_html/system/Theme/Theme.php(717) : eval()'d code(4901): IPS\Theme\SandboxedTemplate->sidebar('right') #15 [internal function]: IPS\Theme\class_core_front_global->globalTemplate('Falcon Lost - T...', '\n<div id="elCms...', Array) #16 /home/gintersauce/public_html/system/Theme/SandboxedTemplate.php(57): call_user_func_array(Array, Array) #17 /home/gintersauce/public_html/system/Dispatcher/Dispatcher.php(149): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #18 /home/gintersauce/public_html/system/Dispatcher/Dispatcher.php(149): IPS\Theme\SandboxedTemplate->globalTemplate('Falcon Lost - T...', '\n<div id="elCms...', Array) #19 /home/gintersauce/public_html/system/Dispatcher/Standard.php(101): IPS\_Dispatcher->finish() #20 /home/gintersauce/public_html/system/Dispatcher/Front.php(479): IPS\Dispatcher\_Standard->finish() #21 /home/gintersauce/public_html/init.php(435) : eval()'d code(78): IPS\Dispatcher\_Front->finish() #22 /home/gintersauce/public_html/system/Dispatcher/Dispatcher.php(131): IPS\Dispatcher\collab_hook_ipsDispatcherFront->finish() #23 /home/gintersauce/public_html/index.php(13): IPS\_Dispatcher->run() #24 {main} EDIT: Removing the sidebar boxes seemed to of fixed it. Anyone know why the boxes are doing that?
Daniel F Posted May 10, 2016 Posted May 10, 2016 It seems to be an issue with collaboration app 'forums_forums.collab_id'
Recommended Posts
Archived
This topic is now archived and is closed to further replies.