Setting
'archiving_ranking_query_row_limit' to 0 (no limit) causes archiving
process not to process Actions and display an error.
The following errors shows up during archiving:
Notice:</strong> <i>Undefined index: type</i> in
<b>/home/ehealth/public_html/piwik/plugins/Actions/ArchivingHelper.php</b>
on line <b>49</b>
<br /><br />Backtrace --><div style="font-family:Courier;font-
size:10pt"><br />
<a href='/0'>#0</a> Piwik_ErrorHandler(...) called at
[/home/ehealth/public_html/piwik/plugins/Actions/ArchivingHelper.php:49]<br
/>
<a href='/1'>#1</a> Piwik_Actions_ArchivingHelper::updateActionsTableWithRowQuery(...)
called at
[/home/ehealth/public_html/piwik/plugins/Actions/Archiving.php:478]<br />
<a href='/2'>#2</a> Piwik_Actions_Archiving->archiveDayQueryProcess(...) called at
[/home/ehealth/public_html/piwik/plugins/Actions/Archiving.php:282]<br />
<a href='/3'>#3</a> Piwik_Actions_Archiving->archiveDayActionsTime(...) called at
[/home/ehealth/public_html/piwik/plugins/Actions/Archiving.php:100]<br />
<a href='/4'>#4</a> Piwik_Actions_Archiving->archiveDay(...) called at
[/home/ehealth/public_html/piwik/plugins/Actions/Actions.php:592
...
var_dump'ing $row at plugins/Actions/ArchivingHelper.php:36, shows:
array(6) {
["idaction"]=>
string(7) "1792657"
[17]=>
string(1) "1"
[19]=>
string(1) "1"
[20]=>
string(1) "3"
[21]=>
string(3) "279"
[22]=>
string(1) "0"
}
so we have a problem with translation of keys in the row.
Proposal
To record more or all data, set this number to very high limit ie. 100000 or 1 million.
In 4b4277b3acab454b69ded4557deba3271ff93b9b: Fixes #3482, apply quick fix so Piwik works when ranking query is disabled and added test for disabled ranking query. Added FIXME comment to make sure underlying issue is eventually dealt with.