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

Error archiving data #7564

Closed
lexsanchez opened this issue Mar 28, 2015 · 8 comments
Closed

Error archiving data #7564

lexsanchez opened this issue Mar 28, 2015 · 8 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Milestone

Comments

@lexsanchez
Copy link

When I run the command to archive shows me the following error.

Got invalid response from API request: http://xxx.xxx.xxx.xxx/piwik/index.php?module=API&method=API.get&idSite=3&period=day&date=la st52&format=php&token_auth=removed&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:66:"Action table for type '11' was not found during Ac tions archiving.";}

@mattab
Copy link
Member

mattab commented Mar 29, 2015

Hi @lexsanchez

can you try upgrade to 2.12.1 and check if this error still occurs?

@lexsanchez
Copy link
Author

Hi Mattab:

The error occurs even taking the version 2.12.1, have reviewed more thoroughly and think the problem is that the table log_action not have some records that need to archive data.

I will review the database backups of days earlier to see if I can find those records that are needed in the table log_action.

@mattab
Copy link
Member

mattab commented Apr 8, 2015

Hi @lexsanchez any update? if anyone else has the bug also please +1 as I couldn't yet see how this code path could be triggered

@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Apr 8, 2015
@mattab mattab added this to the Mid term milestone Apr 8, 2015
@lexsanchez
Copy link
Author

Hi @mattab, while continuing with the same problem, I've done a merge of data a day before problem with the data that is currently generating and still sends me the same error.

I have tried the system skips the record found, for the system to continue with other records, but even abort the operation.

@mattab
Copy link
Member

mattab commented Apr 8, 2015

@lexsanchez for now maybe you want to work around this issue by changing this line:
https://github.com/piwik/piwik/blob/2.12.1/plugins/Actions/ArchivingHelper.php#L368
into return false; - this hopefully would let you continue the archiving of reports. (I didn't test so if not let me know)

@lexsanchez
Copy link
Author

Hi @mattab, I made the change in the line 368 and run the command file shows me the following error:

Response was 'PHP Fatal error: Call to a member function isSummaryRow() on a non-object in /opt/bitnami/apps/piwik/htdocs/plugins/Actions/ArchivingHelper.php on line 111 a:2:{s:6:"result";s:5:"error";s:7:"message";s:56:"Call to a member function isSummaryRow() on a non-object";}'

@mattab
Copy link
Member

mattab commented Apr 14, 2015

@lexsanchez sorry I didn't test again but maybe try return new Row(); instead

@mattab mattab closed this as completed Sep 11, 2015
@mattab mattab added the worksforme The issue cannot be reproduced and things work as intended. label Sep 11, 2015
@mattab
Copy link
Member

mattab commented Sep 11, 2015

@lexsanchez if you still have this problem with latest piwik, please create new issue, thx

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Development

No branches or pull requests

2 participants