8000 Filtering by Latest Status throws error · Issue #5 · chuckdrew/mailgun_magento · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Filtering by Latest Status throws error 8000 #5

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.

Sign up for GitHub

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

Jump to bottom
Open
clivewalkden opened this issue Jun 7, 2016 · 2 comments
Open

Filtering by Latest Status throws error #5

clivewalkden opened this issue Jun 7, 2016 · 2 comments

Comments

@clivewalkden
Copy link

Thanks for making this plugin, i've encountered a bug in the admin system which throws an sql error when you try using the search filter Latest Status. To recreate the issues go to the Email Activity admin page and enter Failed into the Latest Status and hit search.

Should see this message generated in logs

"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'current_status' in 'where clause', query was: SELECT COUNT(*) FROM `mailgun_email_tracking` AS `main_table`
 LEFT JOIN `mailgun_email_tracking_event` AS `me1` ON main_table.id = me1.email_id
 LEFT JOIN `mailgun_email_tracking_event` AS `me2` ON (main_table.id = me2.email_id AND (me1.timestamp < me2.timestamp OR me1.timestamp = me2.timestamp AND me1.id < me2.id)) WHERE (me2.id IS NULL) AND (`current_status` LIKE '%Failed%')";

Let me know if you need any more info.
@chuckdrew
Copy link
Owner

Thanks @clivewalkden ! I'll look into this.

@szepeviktor
Copy link

@chuckdrew This times out for me.
In table mailgun_email_tracking_event there are 20+ identical rows for a single event: for 484 emails there are 624,066 events.

@spirillen spirillen mentioned this issue Feb 7, 2025
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@chuckdrew @szepeviktor @clivewalkden
0