Jump to content

Articles error after upgrade

Featured Replies

Posted

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}

articleserror.png

 

EDIT: Removing the sidebar boxes seemed to of fixed it. Anyone know why the boxes are doing that?

Edited by g1nt3r

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.