{"action":"created","issue":{"url":"https://api.github.com/repos/NetCommons3/NetCommons3/issues/753","repository_url":"https://api.github.com/repos/NetCommons3/NetCommons3","labels_url":"https://api.github.com/repos/NetCommons3/NetCommons3/issues/753/labels{/name}","comments_url":"https://api.github.com/repos/NetCommons3/NetCommons3/issues/753/comments","events_url":"https://api.github.com/repos/NetCommons3/NetCommons3/issues/753/events","html_url":"https://github.com/NetCommons3/NetCommons3/issues/753","id":189277085,"number":753,"title":"「動画」を同じページに配置し、動画を再生したとき、新着情報でエラー","user":{"login":"s-nakajima","id":4422735,"avatar_url":"https://avatars.githubusercontent.com/u/4422735?v=3","gravatar_id":"","url":"https://api.github.com/users/s-nakajima","html_url":"https://github.com/s-nakajima","followers_url":"https://api.github.com/users/s-nakajima/followers","following_url":"https://api.github.com/users/s-nakajima/following{/other_user}","gists_url":"https://api.github.com/users/s-nakajima/gists{/gist_id}","starred_url":"https://api.github.com/users/s-nakajima/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/s-nakajima/subscriptions","organizations_url":"https://api.github.com/users/s-nakajima/orgs","repos_url":"https://api.github.com/users/s-nakajima/repos","events_url":"https://api.github.com/users/s-nakajima/events{/privacy}","received_events_url":"https://api.github.com/users/s-nakajima/received_events","type":"User","site_admin":false},"labels":[{"id":438863804,"url":"https://api.github.com/repos/NetCommons3/NetCommons3/labels/110%E3%83%AD%E3%82%B8%E3%83%83%E3%82%AF%E3%81%AE%E8%AA%A4%E3%82%8A","name":"110ロジックの誤り","color":"e99695","default":false},{"id":303680672,"url":"https://api.github.com/repos/NetCommons3/NetCommons3/labels/zz%20Topics","name":"zz Topics","color":"fbca04","default":false},{"id":303680839,"url":"https://api.github.com/repos/NetCommons3/NetCommons3/labels/zz%20Videos","name":"zz Videos","color":"fbca04","default":false}],"state":"open","locked":false,"assignee":{"login":"s-nakajima","id":4422735,"avatar_url":"https://avatars.githubusercontent.com/u/4422735?v=3","gravatar_id":"","url":"https://api.github.com/users/s-nakajima","html_url":"https://github.com/s-nakajima","followers_url":"https://api.github.com/users/s-nakajima/followers","following_url":"https://api.github.com/users/s-nakajima/following{/other_user}","gists_url":"https://api.github.com/users/s-nakajima/gists{/gist_id}","starred_url":"https://api.github.com/users/s-nakajima/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/s-nakajima/subscriptions","organizations_url":"https://api.github.com/users/s-nakajima/orgs","repos_url":"https://api.github.com/users/s-nakajima/repos","events_url":"https://api.github.com/users/s-nakajima/events{/privacy}","received_events_url":"https://api.github.com/users/s-nakajima/received_events","type":"User","site_admin":false},"assignees":[{"login":"s-nakajima","id":4422735,"avatar_url":"https://avatars.githubusercontent.com/u/4422735?v=3","gravatar_id":"","url":"https://api.github.com/users/s-nakajima","html_url":"https://github.com/s-nakajima","followers_url":"https://api.github.com/users/s-nakajima/followers","following_url":"https://api.github.com/users/s-nakajima/following{/other_user}","gists_url":"https://api.github.com/users/s-nakajima/gists{/gist_id}","starred_url":"https://api.github.com/users/s-nakajima/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/s-nakajima/subscriptions","organizations_url":"https://api.github.com/users/s-nakajima/orgs","repos_url":"https://api.github.com/users/s-nakajima/repos","events_url":"https://api.github.com/users/s-nakajima/events{/privacy}","received_events_url":"https://api.github.com/users/s-nakajima/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2016-11-15T01:44:45Z","updated_at":"2016-11-21T14:12:54Z","closed_at":null,"body":"http://www.netcommons.org/bbciuf2f0-18477/#_18477\r\n\r\n「新着」を配置している場合、以下エラーが表示される場合がある。発生するのは「動画」を同じページに配置し、動画を再生したときに見られます。\r\n\r\n環境--------------------------------------------------------\r\nPHP 5.6\r\nApache/2.2.15\r\nMariaDB10.1.17\r\n\r\nエラー内容--------------------------------------------------------\r\nDatabase Error\r\nError:  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'TopicReadable.topic_id' in 'where clause'\r\nSQL Query:  SELECT `Topic`.`id`, `Topic`.`language_id`, `Topic`.`room_id`, `Topic`.`block_id`, `Topic`.`frame_id`, `Topic`.`content_key`, `Topic`.`content_id`, `Topic`.`category_id`, `Topic``plugin_key`, `Topic`.`title`, `Topic`.`title_icon`, `Topic`.`summary`, `Topic`.`search_contents`, `Topic`.`counts`, `Topic`.`path`, `Topic`.`public_type`, `Topic`.`publish_start`, `Topic`.`publish_end`, `Topic`.`is_no_member_allow`, `Topic`.`is_answer`, `Topic`.`is_in_room`, `Topic`.`answer_period_start`, `Topic`.`answer_period_end`, `Topic`.`is_active`, `Topic`.`is_latest`, `Topic`.`status`, `Topic`.`created_user`, `Topic`.`created`, `Topic`.`modified_user`, `Topic`.`modified`, `Block`.`id`, `Block`.`key`, `Block`.`name`, `Category`.`id`, `Category`.`key`, `Category`.`name`, `Frame`.`id`, `Frame`.`key`, `Frame`.`name`, `Language`.`id`, `Language`.`code`, `Room`.`id`, `Room`.`space_id`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name`, `Plugin`.`id`, `Plugin`.`key`, `Plugin`.`name`, `TopicUserStatus`.`id`, `TopicUserStatus`.`topic_id`, `TopicUserStatus`.`user_id`, `TopicUserStatus`.`read`, `TopicUserStatus`.`answered` FROM `nc3`.`topics` AS `Topic` LEFT JOIN `nc3`.`blocks` AS `Block` ON (`Topic`.`block_id` = `Block`.`id`) LEFT JOIN `nc3`.`categories` AS `Category` ON (`Topic`.`category_id` = `Category`.`id`) LEFT JOIN `nc3`.`frames` AS `Frame` ON (`Topic`.`frame_id` = `Frame`.`id`) LEFT JOIN `nc3`.`languages` AS `Language` ON (`Topic`.`language_id` = `Language`.`id`) LEFT JOIN `nc3`.`rooms` AS `Room` ON (`Topic`.`room_id` = `Room`.`id`) LEFT JOIN `nc3`.`users` AS `TrackableCreator` ON (`Topic`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `nc3`.`users` AS `TrackableUpdater` ON (`Topic`.`modified_user` = `TrackableUpdater`.`id`) INNER JOIN `nc3`.`rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Topic`.`room_id` AND `RoomsLanguage`.`language_id` = 2) INNER JOIN `nc3`.`plugins` AS `Plugin` ON (`Plugin`.`key` = `Topic`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `nc3`.`topic_user_statuses` AS `TopicUserStatus` ON (`TopicUserStatus`.`topic_id` = `Topic`.`id` AND `TopicUserStatus`.`user_id` = 6) WHERE NOT (`TopicReadable`.`topic_id` IS NULL) AND `Topic`.`language_id` = 2 AND ((`Block`.`public_type` = 1) OR (((`Block`.`public_type` = 2) AND (((`Block`.`publish_start` <= '2016-11-01 08:29:05') OR (`Block`.`publish_start` IS NULL))) AND (((`Block`.`publish_end` >= '2016-11-01 08:29:05') OR (`Block`.`publish_end` IS NULL))))) OR (`Block`.`room_id` = (12))) AND ((((`Topic`.`room_id` = (12)) AND (`Topic`.`is_latest` = '1'))) OR (((`TopicReadable`.`user_id` = 6) AND (`Topic`.`is_active` = '1') AND (`Topic`.`is_in_room` = '0'))) OR (((`Topic`.`created_user` = 6) AND (`Topic`.`is_latest` = '1'))) OR (((((`Topic`.`room_id` IN (1, 10, 18, 22, 20, 3, 16)) OR (`TopicReadable`.`user_id` = 6))) AND (`Topic`.`created_user` != 6) AND (`Topic`.`is_active` = '1') AND (((`Topic`.`public_type` IN (1, 2)) AND (`Topic`.`publish_start` <= '2016-11-01 08:29:05') AND (((`Topic`.`publish_end` >= '2016-11-01 08:29:05') OR (`Topic`.`publish_end` IS NULL)))))))) AND `Topic`.`room_id` = 1 AND `Block`.`key` IN ('0', 'da9eaa395d5bdf4d2b3e305d4d28d95f') AND `Topic`.`publish_start` >= '2016-10-02 08:29:05' ORDER BY `Topic`.`publish_start` desc, `Topic`.`id` desc LIMIT 1000 \r\n\r\nNotice:  If you want to customize this error message, create app/View/Errors/pdo_error.ctp\r\n\r\nStack Trace\r\n•CORE/Cake/Model/Datasource/DboSource.php line 468 → PDOStatement->execute(array) \r\n•CORE/Cake/Model/Datasource/DboSource.php line 434 → DboSource->_execute(string, array) \r\n•CORE/Cake/Model/Datasource/DboSource.php line 671 → DboSource->execute(string, array, array) \r\n•CORE/Cake/Model/Datasource/DboSource.php line 1120 → DboSource->fetchAll(string, boolean) \r\n•CORE/Cake/Model/Model.php line 3038 → DboSource->read(Topic, array) \r\n•CORE/Cake/Model/Model.php line 3010 → Model->_readDataSource(string, array) \r\n•CORE/Cake/Controller/Component/PaginatorComponent.php line 196 → Model->find(string, array) \r\n•APP/Plugin/Topics/Controller/TopicsController.php line 173 → PaginatorComponent->paginate(string) \r\n•APP/Plugin/Topics/Controller/TopicsController.php line 112 → TopicsController->__getTopics(array, array) \r\n•[internal function] → TopicsController->index() \r\n•CORE/Cake/Controller/Controller.php line 491 → ReflectionMethod->invokeArgs(TopicsController, array) \r\n•CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction(CakeRequest) \r\n•CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(TopicsController, CakeRequest) \r\n•CORE/Cake/Core/Object.php line 104 → Dispatcher->dispatch(CakeRequest, CakeResponse, array) \r\n•APP/Plugin/Frames/View/Elements/render_frames.ctp line 30 → Object->requestAction(string, array) \r\n•CORE/Cake/View/View.php line 971 → include(string) \r\n•CORE/Cake/View/View.php line 933 → View->_evaluate(string, array) \r\n•CORE/Cake/View/View.php line 1224 → View->_render(string, array) \r\n•CORE/Cake/View/View.php line 418 → View->_renderElement(string, array, array) \r\n•APP/Plugin/Boxes/View/Elements/render_boxes.ctp line 26 → View->element(string, array) \r\n•CORE/Cake/View/View.php line 971 → include(string) \r\n•CORE/Cake/View/View.php line 933 → View->_evaluate(string, array) \r\n•CORE/Cake/View/View.php line 1224 → View->_render(string, array) \r\n•CORE/Cake/View/View.php line 418 → View->_renderElement(string, array, array) \r\n•APP/Plugin/Pages/View/Elements/page_minor.ctp line 18 → View->element(string, array) \r\n•CORE/Cake/View/View.php line 971 → include(string) \r\n•CORE/Cake/View/View.php line 933 → View->_evaluate(string, array) \r\n•CORE/Cake/View/View.php line 1224 → View->_render(string, array) \r\n•CORE/Cake/View/View.php line 418 → View->_renderElement(string, array, array) \r\n•APP/Plugin/Pages/View/Helper/PageLayoutHelper.php line 130 → View->element(string) \r\n•[internal function] → PageLayoutHelper->beforeLayout(string) \r\nCORE/Cake/Utility/ObjectCollection.php line 128 → call_user_func_array(array, array) \r\n•CORE/Cake/View/HelperCollection.php line 200 → ObjectCollection->trigger(CakeEvent, array, array) \r\n•[internal function] → HelperCollection->trigger(CakeEvent) \r\n•CORE/Cake/Event/CakeEventManager.php line 243 → call_user_func(array, CakeEvent) \r\n•CORE/Cake/View/View.php line 524 → CakeEventManager->dispatch(CakeEvent) \r\n•CORE/Cake/View/View.php line 481 → View->renderLayout(string, string) \r\n•CORE/Cake/Controller/Controller.php line 963 → View->render(null, null) \r\n•CORE/Cake/Routing/Dispatcher.php line 200 → Controller->render() \r\n•CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(VideosController, CakeRequest) \r\n•APP/webroot/index.php line 107 → Dispatcher->dispatch(CakeRequest, CakeResponse)"},"comment":{"url":"https://api.github.com/repos/NetCommons3/NetCommons3/issues/comments/261948500","html_url":"https://github.com/NetCommons3/NetCommons3/issues/753#issuecomment-261948500","issue_url":"https://api.github.com/repos/NetCommons3/NetCommons3/issues/753","id":261948500,"user":{"login":"akagane99","id":2756509,"avatar_url":"https://avatars.githubusercontent.com/u/2756509?v=3","gravatar_id":"","url":"https://api.github.com/users/akagane99","html_url":"https://github.com/akagane99","followers_url":"https://api.github.com/users/akagane99/followers","following_url":"https://api.github.com/users/akagane99/following{/other_user}","gists_url":"https://api.github.com/users/akagane99/gists{/gist_id}","starred_url":"https://api.github.com/users/akagane99/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akagane99/subscriptions","organizations_url":"https://api.github.com/users/akagane99/orgs","repos_url":"https://api.github.com/users/akagane99/repos","events_url":"https://api.github.com/users/akagane99/events{/privacy}","received_events_url":"https://api.github.com/users/akagane99/received_events","type":"User","site_admin":false},"created_at":"2016-11-21T14:12:54Z","updated_at":"2016-11-21T14:12:54Z","body":"> 「新着」を配置している場合、以下エラーが表示される場合がある。発生するのは「動画」を同じページに配置し、動画を再生したときに見られます。\r\n\r\nうーん、再現しませんでした。\r\nhttp://nc3dev2.nakazii-co.jp/nc3/video\r\n"}}
{"actor":{"display_login":"akagane99"}}