Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Closed
trilobit-gmbh opened this issue Jan 9, 2014 · 5 comments
Closed

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

trilobit-gmbh opened this issue Jan 9, 2014 · 5 comments
Assignees
@mattab
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone
2.1

Comments

@trilobit-gmbh
Copy link

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
Copy link
Author

Attachment:
annotations-bug.png

@sgiehl
Copy link
Member

sgiehl commented Jan 10, 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
Copy link
Author

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";}}

@trilobit-gmbh
Copy link
Author

Attachment:
piwik-2-system-check.png

@mattab
Copy link
Member

mattab commented Jan 30, 2014

In 27e59ba: Fixes #4496

@trilobit-gmbh trilobit-gmbh added this to the 2.1 - Piwik 2.1 milestone Jul 8, 2014
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
@tsteur @mattab
Fixes matomo-org#4496
27e59ba
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mattab mattab

Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Milestone
2.1
Development

No branches or pull requests
3 participants
@mattab @sgiehl @trilobit-gmbh