Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.This is my views configuration
And output is
I can see the output when logged in. To see the output as anonymous user I set in permission page as " View user information : Anonymous " and got the below error.
The website encountered an unexpected error. Please try again later.</br></br><em class="placeholder">Drupal\Core\Database\DatabaseExceptionWrapper</em>: Exception in No of users[no_of_users]: SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause: SELECT users_field_data.uid AS uid, COUNT(user__roles.roles_target_id) AS user__roles_roles_target_id
FROM
{users_field_data} users_field_data
LEFT JOIN {user__roles} user__roles ON users_field_data.uid = user__roles.entity_id; Array
(
)
in <em class="placeholder">Drupal\views\Plugin\views\query\Sql->execute()</em> (line <em class="placeholder">1496</em> of <em class="placeholder">core/modules/views/src/Plugin/views/query/Sql.php</em>). <pre class="backtrace">Drupal\views\ViewExecutable->execute(NULL) (Line: 1451)
Drupal\views\ViewExecutable->render() (Line: 117)
Drupal\views\Plugin\views\display\Block->execute() (Line: 1627)
Drupal\views\ViewExecutable->executeDisplay('block_1', Array) (Line: 77)
Drupal\views\Element\View::preRenderViewElement(Array) (Line: 59)
Drupal\views\Plugin\Block\ViewsBlock->build() (Line: 203)
Drupal\block\BlockViewBuilder::preRender(Array)
call_user_func('Drupal\block\BlockViewBuilder::preRender', Array) (Line: 378)
Drupal\Core\Render\Renderer->doRender(Array) (Line: 450)
Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 195)
Drupal\Core\Render\Renderer->render(Array) (Line: 490)
Drupal\Core\Template\TwigExtension->escapeFilter(Object, Array, 'html', NULL, 1) (Line: 340)
__TwigTemplate_4a80d2e940672d7ecd680f8b0a6d32e7ae7f79a8c4ad5a379b2fdd15200feed9->block_footer(Array, Array) (Line: 215)
Twig_Template->displayBlock('footer', Array, Array) (Line: 90)
__TwigTemplate_4a80d2e940672d7ecd680f8b0a6d32e7ae7f79a8c4ad5a379b2fdd15200feed9->doDisplay(Array, Array) (Line: 432)
Twig_Template->displayWithErrorHandling(Array, Array) (Line: 403)
Twig_Template->display(Array) (Line: 411)
Twig_Template->render(Array) (Line: 64)
twig_render_template('themes/qgm/templates/system/page.html.twig', Array) (Line: 384)
Drupal\Core\Theme\ThemeManager->render('page', Array) (Line: 437)
Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 195)
Drupal\Core\Render\Renderer->render(Array) (Line: 490)
Drupal\Core\Template\TwigExtension->escapeFilter(Object, Array, 'html', NULL, 1) (Line: 90)
__TwigTemplate_e1a9dbb34caa1c133cb544a7069db1587b57988d97401f143244d11a5c570367->doDisplay(Array, Array) (Line: 432)
Twig_Template->displayWithErrorHandling(Array, Array) (Line: 403)
Twig_Template->display(Array) (Line: 411)
Twig_Template->render(Array) (Line: 64)
twig_render_template('themes/bootstrap/templates/system/html.html.twig', Array) (Line: 384)
Drupal\Core\Theme\ThemeManager->render('html', Array) (Line: 437)
Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 195)
Drupal\Core\Render\Renderer->render(Array) (Line: 147)
Drupal\Core\Render\MainContent\HtmlRenderer->Drupal\Core\Render\MainContent\{closure}() (Line: 582)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 148)
Drupal\Core\Render\MainContent\HtmlRenderer->renderResponse(Array, Object, Object) (Line: 90)
Drupal\Core\EventSubscriber\MainContentViewSubscriber->onViewRenderArray(Object, 'kernel.view', Object) (Line: 108)
Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('kernel.view', Object) (Line: 158)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 68)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 57)
Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 99)
Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 1, 1) (Line: 78)
Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 50)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23)
Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 657)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)
</pre>
| Comment | File | Size | Author |
|---|
Comments
Comment #2
dbjpanda CreditAttribution: dbjpanda commentedComment #3
Dubs CreditAttribution: Dubs as a volunteer and at Drupology commentedI had the same issue. To work around you can add an aggregated field that groups together and will always have the same value, e.g. User Entity Type, and then hide that field. This will add the GROUP BY clause to your view.
I realise this isn't a fix, but it should make the view display what you need.
Comment #4
smokrisSteps to reproduce the error on a fresh Drupal 8 site (tested with Drupal 8.5.2, PHP 7.1.15, and MySQL 5.6.37):
Number (Integer)fieldIt generates this query:
…which results in this error:
Comment #5
sic CreditAttribution: sic commentedsame error when counting webform submissions on entity id filter
Comment #6
gustavo.contreras CreditAttribution: gustavo.contreras commentedGood morning, I have the same error, in a clean installation of Drupal 8.6.10 without contributed modules, when I'm going to agregate a numeric field.
Comment #7
jukka792 CreditAttribution: jukka792 as a volunteer commentedSame error trying to count the amount of nodes with aggregation.
Drupal 8.8.5
Comment #8
mmbdomi CreditAttribution: mmbdomi commentedHaving the same issue, any solution ?
Comment #9
brulain CreditAttribution: brulain commented+1
Comment #10
mmbdomi CreditAttribution: mmbdomi commentedHello,
I got this working by
grouping bythe right field.Every other time I was
grouping bywith the wrong field, that is why the issue was occurring, you need to make sure that you aregrouping bythe right fields.Comment #11
mmbdomi CreditAttribution: mmbdomi commentedThere are 3 images that are not related to my comment (group-by.jpg only related one), I do not know how they got attached, can someone remove them then remove this comment ?
thank you