Hi,
I’ve also used the internal upgrade function. After the problem occurs, I’ve tried a completely new installation (all files in the piwik directory deleted, new files copied). Same problem.
I afraid I don’t have any kind of solution for this problem (Cannot use object of type Piwik_DataTable_Row as array in … Actions.php), but I have some more (unanalysed) details:
I’m faceing the same problem since a manual upgrade from 0.4.5 to 0.5 (and still face it since I’ve upgraded to 0.5.3 today):
after coping the new piwikfiles to a clean directory on my webserver I tried to start the upgrade procedure via browser. But this did not work, the script seemed do do nothing. So I’ve updated my tables manual to (took the sql from core/Updates/…)
the problem is not browserspecific, since it can be observed within the archivescript, too: archive.sh
PHP Fatal error: Cannot use object of type Piwik_DataTable_Row as array in /…/id/piwik/plugins/Actions/Actions.php on line 380
Fatal error: Cannot use object of type Piwik_DataTable_Row as array in /…/piwik/plugins/Actions/Actions.php on line 380
since the archivescript dosen’t work I could run the archive-cronjobs and my DB-tables growed massively over the last days. I had to remove the piwik-pixel from our pages.
Interesting observation: If I choose a date before the upgrade, that’s look at old data, all widgets work great. Only new data is affected by this bug.
Hmmm, after disableing and reenableing the action-plugin the errormessages are gone. But now I have no data in “actions/pages” and/or “actions/page title”.
the archve-script runs extremely fast and produces a notice followed by an backtrace:
Notice: Array to string conversion in /..../piwik/core/Log.php on line 169
Backtrace -->#0 [...]
Assuming you have the default settings (browser-triggered archiving), disabling the Actions plugin would have resulted in archives generated without calling the hooks in the Actions plugin. That’s why you have no data.
Assuming you aren’t pruning your log_visit table, to regenerate the archives, you have to activate the Actions plugin, and manually drop the archive_blob and archive_numeric tables (or delete specific rows) for the desired period.
This seems to be data-specific. Would you mind changing line 380 of plugins/Actions/Actions.php, from:
first of all, thanks for the fast fix regarding the second problem. I’ve applied it to my archive.sh and…there is the first problem again, fine.
I’m using php 5.2.9. And yes, it seems that I’ve lost my enable_browser_archiving_triggering = false during the updateprocess, so the default configuration is active currently.
And last, but not least the debug output from the modified Action.php (same on dashboard and from archive.sh):
After an Upgrade to 0.5.3 i get no longer the error message from above. For the dates 2009-12-14 and 2009-12-15 I see for the statistic Actions > Pages the message “No data for this table.”. For today (2009-12-16) I get data and statistics. So maybe the reason for the problems on 2009-12-14 and 2009-12-15 are some corrupt data in the database?
I’ve changed nothing on the system since my posting in the morning. But now i get the same error for todays statistics: “Fatal error: Cannot use object of type Piwik_DataTable_Row as array in /homepages/26/d283610669/htdocs/app/webroot/stat/plugins/Actions/Actions.php on line 380”
I’ve made an upgrade to 0.5.4 in the morning. As I saw the patch is included in that version.
Statistics (Visitors, Refererers, Goals, …) for everything in the past are working, except the Actions statistics for the current month (12/2009). Error message “No data for this table.” (No matter if i select day, week or month as period).
If I select the day statistics for today, then i get on every statistic/widget “Fatal error: Cannot use object of type Piwik_DataTable_Row as array in /path/to/piwik/plugins/Actions/Actions.php on line 385”. If i deactivate the Actions plugin, then every other statistic for today works fine.
I have already deleted the tables piwik_archive_blob_2009_12 and piwik_archive_numeric_2009_12 to rebuild these tables, but that was not helpful.
/var/www/stat/htdocs/piwik/misc/cron/archive.sh
Fatal error: Cannot use object of type Piwik_DataTable_Row as array in /var/www/stat/htdocs/piwik/plugins/Actions/Actions.php on line 385