Hi Adriano, can you check for this issue please, this error desappear when I desable Quizzes and Classified apps.
SELECT SQL_CALC_FOUND_ROWS * FROM( ( SELECT 'IPS\\forums\\Topic' AS class, forums_topics.tid AS id, GREATEST( IFNULL( forums_topics.last_post, 0 ), IFNULL( forums_topics.last_real_post, 0 ), IFNULL( forums_topics.last_post, 0 ), IFNULL( forums_topics.start_date, 0 )) AS date, forums_topics.starter_id AS author, 10 AS hidden FROM `forums_topics` LEFT JOIN `forums_forums` ON forums_topics.forum_id=forums_forums.id WHERE forums_forums.collab_id=1 AND forums_topics.forum_id IN(1,6,7,8,9,10,11,12,13,15,16,17,18,20,21,22,23,25) AND forums_topics.state!='link' ) UNION ( SELECT 'IPS\\gallery\\Album\\Item' AS class, gallery_albums.album_id AS id, GREATEST( IFNULL( gallery_albums.album_last_img_date, 0 ), IFNULL( gallery_albums.album_last_comment, 0 ), IFNULL( gallery_albums.album_last_review, 0 ), IFNULL( gallery_albums.album_last_img_date, 0 )) AS date, gallery_albums.album_owner_id AS author, 10 AS hidden FROM `gallery_albums` LEFT JOIN `gallery_categories` ON gallery_albums.album_category_id=gallery_categories.category_id WHERE gallery_categories.category_collab_id=1 AND gallery_albums.album_category_id IN(1,3,6) ) UNION ( SELECT 'IPS\\cms\\Records1' AS class, cms_custom_database_1.primary_id_field AS id, GREATEST( IFNULL( cms_custom_database_1.record_last_comment, 0 ), IFNULL( cms_custom_database_1.record_last_comment, 0 ), IFNULL( cms_custom_database_1.record_last_review, 0 ), IFNULL( cms_custom_database_1.record_publish_date, 0 )) AS date, cms_custom_database_1.member_id AS author, 10 AS hidden FROM `cms_custom_database_1` LEFT JOIN `cms_database_categories` ON cms_custom_database_1.category_id=cms_database_categories.category_id WHERE cms_database_categories.category_collab_id=1 AND cms_custom_database_1.category_id IN(1,4,5,6) ) UNION ( SELECT 'IPS\\blog\\Entry' AS class, blog_entries.entry_id AS id, GREATEST( IFNULL( blog_entries.entry_last_update, 0 ), IFNULL( blog_entries.entry_last_update, 0 ), IFNULL( blog_entries.entry_date, 0 )) AS date, blog_entries.entry_author_id AS author, 10 AS hidden FROM `blog_entries` LEFT JOIN `blog_blogs` ON blog_entries.entry_blog_id=blog_blogs.blog_id WHERE blog_blogs.blog_collab_id=1 ) UNION ( SELECT 'IPS\\calendar\\Event' AS class, calendar_events.event_id AS id, GREATEST( IFNULL( calendar_events.event_lastupdated, 0 ), IFNULL( calendar_events.event_last_comment, 0 ), IFNULL( calendar_events.event_last_review, 0 ), IFNULL( calendar_events.event_saved, 0 )) AS date, calendar_events.event_member_id AS author, 10 AS hidden FROM `calendar_events` LEFT JOIN `calendar_calendars` ON calendar_events.event_calendar_id=calendar_calendars.cal_id WHERE calendar_calendars.cal_collab_id=1 AND calendar_events.event_calendar_id IN(1) ) UNION ( SELECT 'IPS\\downloads\\File' AS class, downloads_files.file_id AS id, GREATEST( IFNULL( downloads_files.file_updated, 0 ), IFNULL( downloads_files.file_last_comment, 0 ), IFNULL( downloads_files.file_last_review, 0 ), IFNULL( downloads_files.file_submitted, 0 )) AS date, downloads_files.file_submitter AS author, 10 AS hidden FROM `downloads_files` LEFT JOIN `downloads_categories` ON downloads_files.file_cat=downloads_categories.cid WHERE downloads_categories.ccollab_id=1 AND downloads_files.file_cat IN(1) ) UNION ( SELECT 'IPS\\quizzes\\Quiz' AS class, quizzes_quizzes.quizz_id AS id, GREATEST( IFNULL( quizzes_quizzes.quizz_updated, 0 ), IFNULL( quizzes_quizzes.quizz_last_comment, 0 ), IFNULL( quizzes_quizzes.quizz_last_review, 0 ), IFNULL( quizzes_quizzes.quizz_submitted, 0 )) AS date, quizzes_quizzes.quizz_mid AS author, 10 AS hidden FROM `quizzes_quizzes` LEFT JOIN `quizzes_categories` ON quizzes_quizzes.quizz_cat=quizzes_categories.q_cid WHERE quizzes_categories.q_ccollab_id=1 AND quizzes_quizzes.quizz_cat=0 )) derivedTable ORDER BY date DESC LIMIT 0,1
IPS\Db\Exception: Unknown column 'quizzes_categories.q_ccollab_id' in 'where clause' (1054)
#0 /var/www/html/r276798/system/Db/Select.php(371): IPS\_Db->preparedQuery('/*IPS\\collab\\_C...', Array, true)
#1 /var/www/html/r276798/system/Db/Select.php(433): IPS\Db\_Select->runQuery()
#2 /var/www/html/r276798/applications/collab/sources/Collab/Collab.php(911): IPS\Db\_Select->rewind()
#3 /var/www/html/r276798/system/Theme/Theme.php(809) : eval()'d code(2989): IPS\collab\_Collab->getLatestContent(1)
#4 /var/www/html/r276798/system/Theme/SandboxedTemplate.php(56): IPS\Theme\class_collab_front_components->collabRow(Object(IPS\Helpers\Table\Content), Array, Array)
#5 /var/www/html/r276798/system/Theme/Theme.php(809) : eval()'d code(681): IPS\Theme\_SandboxedTemplate->__call('collabRow', Array)
#6 /var/www/html/r276798/system/Theme/SandboxedTemplate.php(56): IPS\Theme\class_collab_front_components->categoryTable(Object(IPS\Helpers\Table\Content), Array, Array, NULL, true)
#7 [internal function]: IPS\Theme\_SandboxedTemplate->__call('categoryTable', Array)
#8 /var/www/html/r276798/system/Helpers/Table/Table.php(543): call_user_func(Array, Object(IPS\Helpers\Table\Content), Array, Array, NULL, true)
#9 /var/www/html/r276798/system/Theme/Theme.php(809) : eval()'d code(70): IPS\Helpers\Table\_Table->__toString()
#10 /var/www/html/r276798/system/Theme/SandboxedTemplate.php(56): IPS\Theme\class_collab_front_layouts->category(Object(IPS\collab\Category), Object(IPS\Helpers\Table\Content))
#11 /var/www/html/r276798/applications/collab/modules/front/collab/categories.php(236): IPS\Theme\_SandboxedTemplate->__call('category', Array)
#12 /var/www/html/r276798/applications/collab/modules/front/collab/categories.php(53): IPS\collab\modules\front\collab\_categories->_category(Object(IPS\collab\Category))
#13 /var/www/html/r276798/system/Dispatcher/Controller.php(96): IPS\collab\modules\front\collab\_categories->manage()
#14 /var/www/html/r276798/applications/collab/modules/front/collab/categories.php(25): IPS\Dispatcher\_Controller->execute()
#15 /var/www/html/r276798/system/Dispatcher/Dispatcher.php(146): IPS\collab\modules\front\collab\_categories->execute()
#16 /var/www/html/r276798/index.php(12): IPS\_Dispatcher->run()
#17 {main}