@trilobit-gmbh opened this issue on January 9th 2014

After Upgrading from last 1.x-Version to Version 2.0.2 annotations in visitor summary view are not working.

Error output is (see attached file, too):

unserialize() [function.unserialize]: Error at offset 268 of 2185 bytes in /kunden/176974_69214/rp-hosting/804/804/analytics2.trilobit.net/plugins/Annotations/AnnotationList.php on line 319

Backtrace --> #0 Piwik\Error::errorHandler(...) called at [:] #1 unserialize(...) called at [/kunden/176974_69214/rp-hosting/804/804/analytics2.trilobit.net/plugins/Annotations/AnnotationList.php:319] #2 Piwik\Plugins\Annotations\AnnotationList->getAnnotationsForSite(...) called at [/kunden/176974_69214/rp-hosting/804/804/analytics2.trilobit.net/plugins/Annotations/AnnotationList.php:62] #3 Piwik\Plugins\Annotations\AnnotationList->__construct(...) called at [/kunden/176974_69214/rp-hosting/804/804/analytics2.trilobit.net/plugins/Annotations/API.php:226] #4 Piwik\Plugins\Annotations\API->getAnnotationCountForDates(...) called at [:] #5 call_user_func_array(...) called at [/kunden/176974_69214/rp-hosting/804/804/analytics2.trilobit.net/core/API/Proxy.php:212] #6 Piwik\API\Proxy->call(...) called at [/kunden/176974_69214/rp-hosting/804/804/analytics2.trilobit.net/core/API/Request.php:220] #7 Piwik\API\Request->process(...) called at [/kunden/176974_69214/rp-hosting/804/804/analytics2.trilobit.net/core/API/Request.php:306] #8 Piwik\API\Request::processRequest(...) called at [/kunden/176974_69214/rp-hosting/804/804/analytics2.trilobit.net/plugins/Annotations/Controller.php:210] #9 Piwik\Plugins\Annotations\Controller->getEvolutionIcons(...) called at [:] #10 call_user_func_array(...) called at [/kunden/176974_69214/rp-hosting/804/804/analytics2.trilobit.net/core/FrontController.php:117] #11 Piwik\FrontController->dispatch(...) called at [/kunden/176974_69214/rp-hosting/804/804/analytics2.trilobit.net/index.php:71]

Upgrade has been processed by command line. Keywords: Annotation

@trilobit-gmbh commented on January 9th 2014

Attachment: annotations-bug.png

@trilobit-gmbh commented on January 13th 2014
@sgiehl commented on January 10th 2014

Have you done a php upgrade aswell, or was it Piwik only.

I'm not able to reproduce that error on any of my installations. Maybe the data in your database got corrupted. Could you send us the value of the database record holding the annotations. They are stored in the piwik_option table with the option_name "X_annotations" (X needs to be replaced by the id of your site in piwik) Maybe that would help to analyze the problem.

@trilobit-gmbh commented on January 13th 2014

PHP Version Upgrade not necessary, running already

PHP 5.3.19 (cli) (built: Dec  5 2012 14:31:02)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies

System check is green, too (see screenshot attachement)

Value of database record is

a:15:{i:0;a:4:{s:4:"date";s:10:"2013-03-05";s:4:"note";s:18:"Newsletter 2013-03";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:1;a:4:{s:4:"date";s:10:"2013-04-29";s:4:"note";s:90:"Verffentlichung Beitrag \"Unitas ist ffentlich!\" mit Kommunikation ber FB";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:2;a:4:{s:4:"date";s:10:"2013-05-06";s:4:"note";s:69:"Verffentlichung Robert Schuman Microsite mit Kommunikation ber FB";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:3;a:4:{s:4:"date";s:10:"2013-05-06";s:4:"note";s:27:"Versand Newsletter Mai 2013";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:4;a:4:{s:4:"date";s:10:"2013-05-12";s:4:"note";s:45:"Ende der 136. Generalversammlung in Stuttgart";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:5;a:4:{s:4:"date";s:10:"2013-06-06";s:4:"note";s:27:"Newsletter 6-2013 versendet";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:6;a:4:{s:4:"date";s:10:"2013-05-27";s:4:"note";s:60:"UV-Stellungnahme zu BC in Eisenach ber Facebook publiziert";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:7;a:4:{s:4:"date";s:10:"2013-06-27";s:4:"note";s:65:"Einladung zur Vorortsbergabe verffentlicht und auf FB geteilt";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:8;a:4:{s:4:"date";s:10:"2013-07-02";s:4:"note";s:33:"Newsletter 7/2013 verffentlicht";s:7:"starred";s:1:"0";s:4:"user";s:5:"admin";}i:9;a:4:{s:4:"date";s:10:"2013-07-15";s:4:"note";s:37:"Unitas 3/2013 online, auf FB promoted";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:10;a:4:{s:4:"date";s:10:"2013-08-07";s:4:"note";s:40:"Newsletter August 2013 verschickt/online";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:11;a:4:{s:4:"date";s:10:"2013-08-24";s:4:"note";s:56:"NL-Versand Bewerber- und Assessment-Center-Training 2013";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:12;a:4:{s:4:"date";s:10:"2013-11-06";s:4:"note";s:19:"November-Newsletter";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:13;a:4:{s:4:"date";s:10:"2013-12-04";s:4:"note";s:60:"Newsletter 12-2013 verffentlicht und versendet (21:45 Uhr)";s:7:"starred";i:0;s:4:"user";s:5:"admin";}i:14;a:4:{s:4:"date";s:10:"2014-01-01";s:4:"note";s:18:"Newsletter 01/2014";s:7:"starred";i:0;s:4:"user";s:5:"admin";}}
@mattab commented on January 30th 2014

In 27e59bac9a15a3c3be7254f42b4856e42b9e92a1: Fixes #4496

This issue was closed on January 30th 2014
Powered by GitHub Issue Mirror