shiobi Posted June 15 Share Posted June 15 Hello. When you are trying to mention someone in a comment on Pages application, the following error appears in System Logs: SELECT user FROM `forocms_database_comments` AS `cms_database_comments` WHERE comment_approved = 1 AND comment_record_id=12316 AND cms_database_comments.user IN(SELECT core_members.member_id FROM `forocore_members` AS `core_members` WHERE core_members.name LIKE CONCAT( 'as', '%' )) LIMIT 10 IPS\Db\Exception: Unknown column 'user' in 'field list' (1054) #0 /var/www/html/system/Db/Select.php(388): IPS\_Db->preparedQuery() #1 /var/www/html/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 /var/www/html/system/Content/Statistics.php(160): iterator_to_array() #4 /var/www/html/applications/core/modules/front/system/editor.php(356): IPS\cms\_Records->mostRecent() #5 /var/www/html/system/Dispatcher/Controller.php(107): IPS\core\modules\front\system\_editor->mention() #6 /var/www/html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /var/www/html/index.php(13): IPS\_Dispatcher->run() #8 {main} This started happening after upgrading to 4.7.11. Thanks Link to comment Share on other sites More sharing options...
Nathan Explosion Posted June 15 Share Posted June 15 Yup - works OK with main record and reviews, not comments. Front-end view: Link to comment Share on other sites More sharing options...
Marc Stridgen Posted June 15 Share Posted June 15 Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release. Link to comment Share on other sites More sharing options...
Joey_M Posted June 15 Share Posted June 15 I have the same issue, any ideas on when this can be patched? Link to comment Share on other sites More sharing options...
Marc Stridgen Posted June 16 Share Posted June 16 This is still an open bug report at present. We hope to have this resolved as soon as possible Joey_M 1 Link to comment Share on other sites More sharing options...
Stuart Silvester Posted June 20 Share Posted June 20 This issue was fixed in a recent patch. SeNioR- and SJ77 2 Link to comment Share on other sites More sharing options...
Recommended Posts