0.5.3 bug: page-titles and pages output still swapped!

Support & Bugs
21

you can manually change this behavior by applying the following patch:

Index: plugins/Actions/Actions.php
===================================================================
--- plugins/Actions/Actions.php    (revision 1721)
+++ plugins/Actions/Actions.php    (working copy)
@@ -228,7 +228,7 @@
         $dataTable = Piwik_ArchiveProcessing_Day::generateDataTable($this->actionsTablesByType[Piwik_Tracker_Action::TYPE_ACTION_URL]);
         $this->deleteInvalidSummedColumnsFromDataTable($dataTable);
         $s = $dataTable->getSerialized( $this->maximumRowsInDataTableLevelZero, $this->maximumRowsInSubDataTable, $this->columnToSortByBeforeTruncation );
-        $archiveProcessing->insertBlobRecord('Actions_actions_url', $s);
+        $archiveProcessing->insertBlobRecord('Actions_actions', $s);
         destroy($dataTable);
 
         $dataTable = Piwik_ArchiveProcessing_Day::generateDataTable($this->actionsTablesByType[Piwik_Tracker_Action::TYPE_DOWNLOAD]);
@@ -246,7 +246,7 @@
         $dataTable = Piwik_ArchiveProcessing_Day::generateDataTable($this->actionsTablesByType[Piwik_Tracker_Action::TYPE_ACTION_NAME]);
         $this->deleteInvalidSummedColumnsFromDataTable($dataTable);
         $s = $dataTable->getSerialized( $this->maximumRowsInDataTableLevelZero, $this->maximumRowsInSubDataTable, $this->columnToSortByBeforeTruncation );
-        $archiveProcessing->insertBlobRecord('Actions_actions', $s);
+        $archiveProcessing->insertBlobRecord('Actions_actions_url', $s);
         destroy($dataTable);
 
         unset($this->actionsTablesByType);

It will work only for stats that have not been processed yet. You would have to manually apply the change after each Piwik upgrade if you wish to keep this behavior.

22

thanx for the patch. i’ll try it.

but so you do not understand the problem you create with the data moving to another category? and this means you’re not going to fix that?

23

i patched like you proposed and recreated complete archive (removed archive_* tables). it does not fix the problem i’m describing here!

i’m not shure if you got the point of the whole problem!

its NOT about new data that is processed AFTER upgrade!
It is about OLD data (recorded by piwik_action_name) that was shown under pages and now is not shown there anymore!

even after applying your patch i still do not see OLD pages under pages! i still see them under page-titles!

24

no one else cares about that buggy-change which is even visible in demo-piwik?

old urls that were visible under pages before upgrade to 0.5 and now are gone (this is wrong!):
piwik.org/demo/index.php?module=CoreHome&action=index&idSite=1&period=day&date=2009-12-07#module=Actions&action=getPageUrls&idSite=1&period=day&date=2009-12-07

old urls that were visible under pages are now under page-titles after upgrade to 0.5 (this is wrong!):
piwik.org/demo/index.php?module=CoreHome&action=index&idSite=1&period=day&date=2009-12-07#module=Actions&action=getPageTitles&idSite=1&period=day&date=2009-12-07

new urls after upgrade are visible under pages (this is correct!):
piwik.org/demo/index.php?module=CoreHome&action=index&idSite=1&period=day&date=2009-12-08#module=Actions&action=getPageUrls&idSite=1&period=day&date=2009-12-08

new page-titles after upgrade are visible under page-titles (this is correct!):
piwik.org/demo/index.php?module=CoreHome&action=index&idSite=1&period=day&date=2009-12-08#module=Actions&action=getPageTitles&idSite=1&period=day&date=2009-12-08

if one views a period where inside the upgrade to 0.5 was made, one sees a mix of page-titles and urls under page-titles (this is wrong!):
piwik.org/demo/index.php?module=CoreHome&action=index&idSite=1&period=week&date=2009-12-08#module=Actions&action=getPageTitles&idSite=1&period=week&date=2009-12-08

hopefully one of the developers now gets the point of the problem. i really do not understand why you do changes like this. its simply wrong!

greets.ivo

25

no one?