Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Loading…

Annotations, unserialize() [function.unserialize]: Error at offset #4496

Closed
trilobit-gmbh opened this Issue · 5 comments

3 participants

trilobit-gmbh Stefan Giehl Matthieu Aubry
trilobit-gmbh

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

Stefan Giehl
Collaborator

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

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";}}
Matthieu Aubry
Owner

In 27e59ba: Fixes #4496

trilobit-gmbh trilobit-gmbh added this to the 2.1 - Piwik 2.1 milestone
Matthieu Aubry mattab was assigned by trilobit-gmbh
Philip Taffner sabl0r referenced this issue from a commit in sabl0r/piwik
Thomas Steur tsteur Fixes #4496 27e59ba
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.