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

Yup - works OK with main record and reviews, not comments.

Front-end view:

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.

 

I have the same issue, any ideas on when this can be patched?

This is still an open bug report at present. We hope to have this resolved as soon as possible

This issue was fixed in a recent patch.