June 15 in Technical Problems
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()
This started happening after upgrading to 4.7.11.
Yup - works OK with main record and reviews, not comments.
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.
Started 1 hour ago
Started 13 hours ago
Started 2 hours ago