Error on API call - lastX days


(stripslashes) #1

Hi,

sice an update to 0.2.33 one of my API call isn’t woking corrent:

/piwik/index.php?module=API&method=Actions.getActions&idSite=1&period=day&date=last5&format=PHP&prettyDisplay=true&token_auth=key

is returning the following error:

Notice: Undefined property: Piwik_DataTable::$rows in /var/www/web105/html/piwik/core/DataTable.php on line 587 Backtrace -->#0 Piwik_ErrorHandler(8, Undefined property: Piwik_DataTable::$rows, /var/www/web105/html/piwik/core/DataTable.php, 587, Array ()) called at [/var/www/web105/html/piwik/core/DataTable.php:587] #1 Piwik_DataTable->getRowsCount() called at [/var/www/web105/html/piwik/core/DataTable.php:319] #2 Piwik_DataTable->setRowsCountBeforeLimitFilter() called at [/var/www/web105/html/piwik/core/API/DataTableGenericFilter.php:122] #3 Piwik_API_DataTableGenericFilter->applyGenericFilters(Piwik_DataTable Object ([] => 1,[] => 0,[] => 1,[] => ,[] => nb_visits,[] => Array ([0] => Array ([className] => ReplaceSummaryRowLabel,[parameters] => Array ())),[] => 0,[] => ,[] => )) called at [/var/www/web105/html/piwik/core/API/DataTableGenericFilter.php:81] #4

After that follows a lot of data, so much that the browser will hang up. I get this error with every API call with &date=lastX. When i enter a date instead of “lastX” it works.

Can anybody help me with this? If not, can i downgrade to the last version? In the last versiopn everything works fine.

Thanks.


(Matthieu Aubry) #2

it’s working fine piwik.org using 0.2.33 http://piwik.org/demo/index.php?module=API…6230b7758626d86

one thing you can try is: backup your DB, then delete all your piwik_archive_* tables which will force the archiving to re-process all your reports.


(stripslashes) #3

[quote=matthieu @ Apr 8 2009, 10:46 PM]backup your DB, then delete all your piwik_archive_* tables which will force the archiving to re-process all your reports.[/quote]didn’t change anything style_emoticons/<#EMO_DIR#>/sad.gif another ideas?


(Matthieu Aubry) #4

make sure all files are properly uploaded ? delete all files (except config.ini.php) + reupload the latest release?


(stripslashes) #5

after renewing all the files i already get the error style_emoticons/<#EMO_DIR#>/sad.gif
A new installtion works fine, bite i need the data in the database.
Any solutions?


(Matthieu Aubry) #6

if you downgrade to 0.2.32 (http://builds.piwik.org/piwik-0.2.32.zip) does it work better?


(stripslashes) #7

yes! works fine with 0.2.32


(Matthieu Aubry) #8

I’ve fixed the issue. Please apply the simple patch on http://dev.piwik.org/trac/changeset/1079 (move the “$this->setTableDeleted($id);” line before the "destroy($this->tables[$id]); ")