Error mentioning someone in Pages application after upgrading to 4.7.11

[shiobi]

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

[Nathan Explosion]

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

Front-end view:

[Marc]

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.

 

[Joey_M]

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

[Marc]

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

[Stuart Silvester]

This issue was fixed in a recent patch.