Report Generation Error in Piwik 2.2.1


(Prashant) #1

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


(Matthieu Aubry) #2

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


(Prashant) #3

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,


#4

Hi! i have problem to…

this problem after update to 2.2.1
Plz need hot bugfix!


#5

Hi! me to, same problem …

this problem after update to 2.2.1


#6

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.


#7

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


#8

What are your server version / stats?

Php version / stats?


#9

Server Debian 7.4
Piwik 2.2.1
Php 5.3.2


#10

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.


#11

Sorry, my version is PHP 5.4.4-14+deb7u8


#12

Maybe manually replace the geoip dat file from a site that is working?

Also check if there is a gz update?


#13

I’m use php 5.3.2 , GeoIP (PECL) , last update db geoip today. OS centos 6
have same problem…


#14

sorry , php-5.4.26-1 to , and have same problem


#15

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.


#16

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


#17

ok you have 2 databases. Make sure you follow instructions on how to update the settings in case they are wrong.

http://piwik.org/faq/how-to/faq_165/


#18

Also to ensure the right city database see here.

http://forum.piwik.org/read.php?2,109716


#19

ОК .

  1. everything worked before the update to 2.2.1 from 2.2.0
  2. i check you post, all normal, path to module and path to db geoip
  3. i use geoipLite 1V , need use 1V or 2V geoip dat ?
    for example :
    1V ; http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz
    2V: http://geolite.maxmind.com/download/geoip/database/GeoLite2-City-CSV.zip

#20

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.