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

internal error when generating a report from an event. #6631

Closed
FafnerKeyZee opened this issue Nov 20, 2020 · 1 comment
Closed

internal error when generating a report from an event. #6631

FafnerKeyZee opened this issue Nov 20, 2020 · 1 comment
Labels
needs triage This issue has been automatically labelled and needs further triage

Comments

@FafnerKeyZee
Copy link
Contributor

Work environment

Questions Answers
Type of issue Bug
OS version (server) Ubuntu 20.04.1 LTS
OS version (client)
PHP version 7.4
MISP version / git hash v2.4.134 (5656771)
Browser

Expected behavior

Generate a report

Actual behavior

When generating a report, after selecting the filters, we got an internal error. If we remote the "tag" filter, it works fine.

Steps to reproduce the behavior

CF Actual behavior

Logs, screenshots, configuration dump, ...

2020-11-20 09:25:36 Error: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tags' in 'where clause'
Request URL: /eventReports/reportFromEvent/72231
Stack Trace:
#0 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(502): PDOStatement->execute()
#1 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(468): DboSource->_execute()
#2 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(715): DboSource->execute()
#3 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Datasource/DboSource.php(1226): DboSource->fetchAll()
#4 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(3053): DboSource->read()
#5 /var/www/MISP/app/Lib/cakephp/lib/Cake/Model/Model.php(3025): Model->_readDataSource()
#6 /var/www/MISP/app/Model/Attribute.php(3490): Model->find()
#7 /var/www/MISP/app/Lib/EventReport/ReportFromEvent.php(44): Attribute->fetchAttributes()
#8 /var/www/MISP/app/Lib/EventReport/ReportFromEvent.php(66): ReportFromEvent->getAttributes()
#9 /var/www/MISP/app/Model/EventReport.php(905): ReportFromEvent->generate()
#10 /var/www/MISP/app/Controller/EventReportsController.php(347): EventReport->getReportFromEvent()
#11 [internal function]: EventReportsController->reportFromEvent()
#12 /var/www/MISP/app/Lib/cakephp/lib/Cake/Controller/Controller.php(499): ReflectionMethod->invokeArgs()
#13 /var/www/MISP/app/Lib/cakephp/lib/Cake/Routing/Dispatcher.php(193): Controller->invokeAction()
#14 /var/www/MISP/app/Lib/cakephp/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke()
#15 /var/www/MISP/app/webroot/index.php(92): Dispatcher->dispatch()
#16 {main}

@FafnerKeyZee FafnerKeyZee added the needs triage This issue has been automatically labelled and needs further triage label Nov 20, 2020
@mokaddem
Copy link
Contributor

Thanks a lot for the report!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
needs triage This issue has been automatically labelled and needs further triage
Projects
None yet
Development

No branches or pull requests

2 participants