Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted June 15, 20231 yr 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
June 15, 20231 yr 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.
June 16, 20231 yr This is still an open bug report at present. We hope to have this resolved as soon as possible