HI,
New to Piwik. Report Geneartion error while trying to generate report manually as cron didn’t send the report today.
Also, have updated to 2.2.1 just before that .
API returned an error: Trying to add two strings values in DataTable\Row::sumRowArray: ‘0%’ + ‘0%’ at Row.php:581
Can you please post your full error message + full backtrace in this ticket: Trying to add two strings values in DataTable\Row::sumRowArray · Issue #4706 · matomo-org/matomo · GitHub
Seems the error is with Ip geolocation url which i’ve put to be the Geolite 2.
Cron execution error report:
INFO CoreConsole[2014-05-07 04:06:10] [a8add] SCHEDULED TASKS INFO CoreConsole[2014-05-07 04:06:10] [a8add] Starting Scheduled tasks…
INFO CoreConsole[2014-05-07 04:06:12] [a8add] Error: Encountered unsupported archive type ‘mmdb.gz’.
task,output
GeoIPAutoUpdater.update,ERROR: Encountered unsupported archive type ‘mmdb.gz’.
INFO CoreConsole[2014-05-07 04:06:12] [a8add] done INFO CoreConsole[2014-05-07 04:06:12] [a8add]
Not sure, but reports are being generated today after the change. Still, cron is not delivering the reports.
Also, piwik error log shows this:
[06-May-2014 12:47:37 UTC] PHP Fatal error: Call to a member function getFirstRow() on a non-object in /home//public_html/analytics/plugins/API/RowEvolution.php on line 357
[07-May-2014 05:32:55 UTC] PHP Fatal error: Call to a member function getFirstRow() on a non-object in /home/*/public_html/analytics/plugins/API/RowEvolution.php on line 357
The earlier error has gone now and reports are being executed manually.
Rgds,
Hi! me to, same problem …
this problem after update to 2.2.1
Just guessing here but make sure you are using teh geolite version og geoip and not another version.
http://dev.maxmind.com/geoip/legacy/geolite/
Could be this is causing the issue.
Yes, it’s the correct version. The issue is strange because for some web sites the report is generated, but for other web sites, that are configured on the same piwik server, I have the problem…already tried to delete and recreate the report…
“API returned an error: Trying to add two strings values in DataTable\Row::sumRowArray: ‘0%’ + ‘100%’ at Row.php:581”
(using "Send Report now " or direct “Donwload”)
please, fix the problem… :S :S
What are your server version / stats?
Php version / stats?
Server Debian 7.4
Piwik 2.2.1
Php 5.3.2
Your php version is a large part of your problem. in my opinion the very least it should be at 5.3.3 but any 5.4 or 5.5 would do nicely.
Sorry, my version is PHP 5.4.4-14+deb7u8
Maybe manually replace the geoip dat file from a site that is working?
Also check if there is a gz update?
I’m use php 5.3.2 , GeoIP (PECL) , last update db geoip today. OS centos 6
have same problem…
sorry , php-5.4.26-1 to , and have same problem
How are you guys updating the dat file(you are remembering to rename it to a .dat file yes?) Is it the automatic update? Are you downloading in a ftp client then copying over?
I would make sure its not being corrupted use a good ftp client ensure its encodng is ok then upload it to server.
5.3.2 if possible i would update your php.
sorry , i use php-5.4.26-1 to , and have same problem
now i download http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz , gunzip and rename, but the problem remained
-rw-r–r-- 1 apache apache 17614327 Май 7 21:03 GeoIPCity.dat
-rw-r–r-- 1 apache apache 17614327 Май 6 23:02 GeoLiteCity.dat
ok you have 2 databases. Make sure you follow instructions on how to update the settings in case they are wrong.
ОК .
I ve oniy used V1
I would try V1 as its been referenced before make sure it works and then if you feel like experimenting try V2.