Hi, recently, after I migrated Piwik database, and calling an API, I got this following error:
but if the parameter "trigger=archivephp" is removed, the API works fine, how do I deal with this issue? Is there any corruptions happened during auto-archiving? Thanks
Do you have any 3rd party plugins installed? Or is it maybe possible that the "Events" plugin is disabled? You can check in "Administration => Plugins"
"Events" plugin is already activated, and yup, I have 3rd party plugins: bottracker, advancecampaignreporting, and referrersmanager
Do you maybe see any errors in the webserver (apache / nginx )log if you have access to these? Maybe try to disable the other plugins and try to re-run it. Maybe it works then? Afterwards you can enable it again. Just to make sure it's not related to any of these plugins
No errors were found in the log, And I have disabled the plugin, re-ran the archives, and still have the same error. So it's not related to any of these plugins I think.
Can you maybe try to update the file
plugins/Actions/Archiver.php like this:
It may help
Thanks, I have done your suggestion but unfortunately, it didn't help
So, I did the migration on 25th October 2016, and the archiving has gone wrong, if I requested the API.get method with archivephp trigger between 26th October 2016 till now, the log_link_visit_action.idaction_event_category is not detected even though it has occurred in the database
and when I requested between 25th October 2016 until now, it gave a different error like this
@milexjaro can you undo the change again? The query was wrong and falsely reported the column is missing.
I'm not really sure what the error could be and it's hard to guess. Is it maybe possible to get access to your server including database?
I asked this already in first comment ;)
Apparently I've tried to undo the change again, and an API call from 26th October now gives the same error like from 25th October.
Sure, I will make an identical sandbox, and will notify you if the sandbox is ready, thanks
Update: after I've tried to undo the change again, the archiving went well for 'day' period, other than that (week, month, year) didn't work at all, still have error action '11' not found.
In this case you might need to invalidate the reports for the days you experience this error and then maybe try again http://piwik.org/faq/how-to/faq_155/ The FAQ might help to invalidate reports. Otherwise a sandbox to test would be great