Report Generation Error in Piwik 2.2.1

mailo · May 7, 2014, 5:33pm

What do we do now? how to solve the problem?

lesjokolat · May 7, 2014, 5:37pm

If its not working now with 2 databases i would remove geoip file and start with just geocity lite and get it working.

mailo · May 7, 2014, 5:42pm

NO , geoip work, i see this in web piwik.
Problem with Report Generation to email

API returned an error: Trying to add two strings values in DataTable\Row::sumRowArray: ‘85,71%’ + ‘85,71%’ at Row.php:581
I do not understand where does geoip

lesjokolat · May 7, 2014, 5:52pm

Hi sorry as I feel I have led you astray without explaining.

The error seems tied to geoip co ordinates.

My thought the cities or ip data base was corrupt or conflicting.

If you just had geocity and not geoip does the error go away? The message points me to the geoip being an issue.

mailo · May 7, 2014, 6:40pm

I think that there is clearly a problem in the code. since everything worked fine in version 2.2.0.
how to rollback to the previous version?

i use next rpm
mod_geoip-1.2.7-1.el6.x86_64
php-pecl-geoip-1.0.8-6.el6.remi.5.4.x86_64

and

/etc/php.d/geoip.ini:extension=geoip.so
/etc/php.ini:geoip.custom_directory=/var/www/html/piwik/misc

[root@stats ~]# ll /var/www/html/piwik/misc/GeoIPCity.dat
-rw-r–r-- 1 apache apache 17614327 Май 7 21:03 /var/www/html/piwik/misc/GeoIPCity.dat

how i get geoip db

wget http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz
gunzip GeoLiteCity.dat.gz
mv GeoLiteCity.dat GeoIPCity.dat

and… everything worked fine in version 2.2.0.

now if i try Report Generation to email , i have error
API returned an error: Trying to add two strings values in DataTable\Row::sumRowArray: ‘85,71%’ + ‘85,71%’ at Row.php:581

If i try get pdf report , i have next error

+++++++++

[root@stats ~]# rpm -qa |grep php
php-cli-5.4.26-1.el6.remi.x86_64
php-pdo-5.4.26-1.el6.remi.x86_64
php-pear-1.9.4-23.el6.remi.noarch
php-mysql-5.4.26-1.el6.remi.x86_64
php-5.4.26-1.el6.remi.x86_64
php-common-5.4.26-1.el6.remi.x86_64
php-process-5.4.26-1.el6.remi.x86_64
php-xml-5.4.26-1.el6.remi.x86_64
php-gd-5.4.26-1.el6.remi.x86_64
php-pecl-geoip-1.0.8-6.el6.remi.5.4.x86_64
php-mbstring-5.4.26-1.el6.remi.x86_64
[root@stats ~]# uname -r
2.6.32-431.11.2.el6.x86_64
[root@stats ~]# cat /etc/redhat-release
CentOS release 6.5 (Final)

matthieu · May 7, 2014, 11:34pm

API returned an error: Trying to add two strings values in DataTable\Row::sumRowArray: ‘85,71%’ + ‘85,71%’ at Row.php:581
This is a bug report for this bug: http://dev.piwik.org/trac/ticket/4706

please comment on that ticket #4706 with explanation how we can reproduce this bug (what steps you take to get this error message?) Thanks!

bankcircle · May 8, 2014, 6:06am

i’ve just upgraded to piwik 2.2.1 & this error happens. Send Reports Now is working after geoip data link is corrected.
Somebody post the comment to the track as cudn’t find way to post there

output of cron demon:

INFO CoreConsole[2014-05-07 20:06:09] [58bd0] SCHEDULED TASKS INFO CoreConsole[2014-05-07 20:06:09] [58bd0] Starting Scheduled tasks…
INFO CoreConsole[2014-05-07 20:06:14] [58bd0] ERROR: Got invalid response from API request: http:///index.php?module=API&method=CoreAdminHome.runScheduledTasks&format=csv&convertToUnicode=0&token_auth=***&trigger=archivephp. Response was 'task,output
API.sendReport_1,ERROR: API returned an error: Trying to add two strings values in DataTable\Row::sumRowArray: ‘0%’ + ‘0%’ at Row.php:581