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
Action table for type '12' was not found during Actions archiving #11623
Comments
Did you change anything on that day? Maybe added a plugin or changed the tracking code to track additional stuff? |
No I didn't changed anything on that day. Neither on server side nor on tracking side. I can still see all the visits in the realtime log. |
Can you check that the Events plugin is activated for you? |
Hi @mattab, |
@JanST123 have you experienced this issue again, or was it just a one-off? |
Hi @mattab ,
I can provide you with a database dump, if it can help you debugging this issue. |
Ok thanks for confirming. We will investigate in the next few weeks, and may ask for a DB dump if needed then. cc @sgiehl would be great to understand and tackle that issue sometime soon (we can move to next release if we don't make it in this one) |
@JanST123 I'll try to tackle that issue. Could you please send a database dump to stefan@piwik.org. That might make it easier to reproduce the issue. Thx. |
@sgiehl You've got mail :) |
@JanST123 thx. will have a look |
Ok. I was able to identify the problem and why the archiving fails. |
That may happen because of my event tracking implementation where the category is always the search term the user recently entered. |
Maybe event_category could be set to an empty string when not passed and event_name is given? |
Thought of something similar. But actually it's not empty string, as |
It needs to be fixed in core to have it fixed for all trackers. However, we should trim the category in the tracker and throw an error there as well and not even send the request to Piwik. Wouldn't we need to return The doc says "e_c" must not be empty in https://developer.piwik.org/api-reference/tracking-api which actually applies to a category with whitespace. I would personally remove the trim as I don't think there should be such logic but also happy with any solution. Removing the trim might screw the data for people who have been tracking with leading / trailing whitespace so maybe throwing an https://github.com/piwik/piwik/blob/3.x-dev/plugins/Events/Actions/ActionEvent.php#L38 would probably stay as it is. |
@tsteur proposed some changes to fix that. Maybe you could have a short look. |
Hi,
I started using Piwik a week ago, tracking 2 websites.
The archiving cron runs every hour.
Now I recognized that the archiving stopped working for one of the two websites 4 days ago. It worked for both websites before (see the screenshot: https://drive.google.com/file/d/0B7Ss7W8DbUYtNm9rOFkzbUxFMTQ/view?usp=sharing)
Here is the full output from the archiving job:
Edit: This is the system summary. System-check is all green. I did not install any additional plugins. If you need additional information please ask. :)
The text was updated successfully, but these errors were encountered: