Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Error "group by" #1894

Closed
xme opened this issue Feb 6, 2017 · 4 comments
Closed

SQL Error "group by" #1894

xme opened this issue Feb 6, 2017 · 4 comments
Labels
S: needs more info Status: needs more information. This issue requires more information from the issue reporter S: stale Status: stale. This issue has had no activity in a long time, it may not be relevant anymore SQL This issue involves SQL programming and databases T: potential bug Type: potential bug. This issue may be a bug

Comments

@xme
Copy link

xme commented Feb 6, 2017

Seems to be a bad day for me :)
Another one:

2017-02-06 15:39:47 Error: [PDOException] SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'misp.GalaxyCluster.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Request URL: /tags/showEventTag/3876?_=1486391974002
Stack Trace:
#0 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(461): PDOStatement->execute(Array)
#1 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(427): DboSource->_execute('SELECT GalaxyC...', Array) #2 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(669): DboSource->execute('SELECT GalaxyC...', Array, Array)
#3 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(1118): DboSource->fetchAll('SELECT `GalaxyC...', false)
#4 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(3031): DboSource->read(Object(GalaxyCluster), Array)
#5 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(3003): Model->_readDataSource('list', Array)
#6 /var/www/MISP/app/Controller/TagsController.php(321): Model->find('list', Array)
#7 [internal function]: TagsController->showEventTag('3876')
#8 /var/www/MISP/app/Lib/cakephp/lib/Cake/Controller/Controller.php(490): ReflectionMethod->invokeArgs(Object(TagsController), Array)
#9 /var/www/MISP/app/Lib/cakephp/lib/Cake/Routing/Dispatcher.php(193): Controller->invokeAction(Object(CakeRequest))
#10 /var/www/MISP/app/Lib/cakephp/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke(Object(TagsController), Object(CakeRequest))
#11 /var/www/MISP/app/webroot/index.php(92): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))
#12 {main}

@FloatingGhost
Copy link
Member

Duplicate of #1732

@xme
Copy link
Author

xme commented Feb 6, 2017

Tx for the link!

@xme xme closed this as completed Feb 6, 2017
@iglocska iglocska reopened this Feb 6, 2017
@iglocska
Copy link
Member

iglocska commented Feb 6, 2017

It's a different issue, the idea is to remove any queries that still cause this - which functionality caused the above error?

@BenjaminJoly BenjaminJoly added the T: bug Type: bug report: This issue describes unexpected behaviour label Jan 25, 2018
@enjeck enjeck added S: needs more info Status: needs more information. This issue requires more information from the issue reporter S: stale Status: stale. This issue has had no activity in a long time, it may not be relevant anymore T: potential bug Type: potential bug. This issue may be a bug SQL This issue involves SQL programming and databases and removed T: bug Type: bug report: This issue describes unexpected behaviour labels Dec 2, 2020
@pemontto
Copy link

Seeing these errors when trying to list tags and attributes in a freshly installed instance. Captured in coolacid/docker-misp#79

@adulau adulau closed this as completed Dec 18, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
S: needs more info Status: needs more information. This issue requires more information from the issue reporter S: stale Status: stale. This issue has had no activity in a long time, it may not be relevant anymore SQL This issue involves SQL programming and databases T: potential bug Type: potential bug. This issue may be a bug
Projects
None yet
Development

No branches or pull requests

7 participants