No data shown after update 2.8.1 -> 2.9.1


#1

No data is shown after updating to 2.9.1. No new and no old statistics. No error messages.

Piwik was running for years with no problems at all. But those range of updates in the last time (and lots of problems after installing them) are nightmare!
Just my 5ct.


(Matthieu Aubry) #2

Hi there, it’s strange because there is no relationship between upgrade and viewing data unless we introduced a bug, but it works fine. Have you setup the cron script and is it running fine? How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo

strange that you don’t see all stats, is it for all websites?
do you see visitors in the Visitors> Visitor log?


(hpsam) #3

Hi,

I have a similar result after auto upgrade from 2.1.0 to 2.9.1 (database upgraded without errors from command line).
No data shown.
I can connect and view users settings but none of my 3 sites are listed in parameters pages “Sites”.
Stats are compiled every night by a cron job.

I have done a rollback on code and database and all is come back.

Tomorrow I m going test a manual update to the latest 2.8

@+


(Matthieu Aubry) #4

Strange that your websites were not listed after the upgrade, this should not happen. If you try again the upgrade to 2.9.1 can you paste the output of piwik_site table? it lists all websites.

if there is a bug in piwik when upgrading we would for sure like to go down to the problem and solve it for all users :slight_smile:


(hpsam) #5

My 3 sites are all in the table.


"idsite","name","main_url","ts_created","timezone","currency","excluded_ips","excluded_parameters","excluded_user_agents","sitesearch","sitesearch_keyword_parameters","sitesearch_category_parameters","group","type","keep_url_fragment","ecommerce"
"1","1900anosjours","http://1900anosjours.hpsam.info","2008-06-22 15:31:36","UTC+1","EUR",,,,"1",,,,"website","0","0"
"2","guppysam","http://leconte-sylvain.hpsam.info","2008-06-22 15:35:08","UTC+1","EUR",,,,"1",,,,"website","0","0"
"3","Montagne","http://montagne.hpsam.info","2008-07-21 23:22:19","UTC+1","EUR",,,,"1",,,,"website","0","0"

I open the javascript debug console and see an error with angularjs


Error: [$injector:nomod] http://errors.angularjs.org/1.2.26/$injector/nomod?p0=piwikApp
...d]))return!1;return!0}}else{if(ta(b))return ta(a)?isNaN(b.getTime())&&isNaN(a.ge..

From file


index.php?module=Proxy&action=getCoreJs&cb=32e31b7b5eb9096a7121f881b06f491e

I use Nginx to serve jpg|jpeg|gif|css|png|js|ico|swf|mp3 and Apache2 for other file like php and html.
I test with https : no Nginx as proxy all by Apache2 same result.

I search the wiki for problems with angularjs :

  • Empty browser cache => no result
    And I check in console it’s a 200 response and not a 304 Not modified so no cache.
  • Empty /tmp folder => all contents rebuild, but same error
  • Failed to load HTML file => I haven’t this error
  • problem with pagespeed and in JS file => no pagespeed module installed and no html head tag found in JS.

I check :

  • No php errors in logs during update or after

I create a test site “testks2.hpsam.info/piwik/” in http or https (self sign certificate) if you want to check something.
angularjs error also appened on connection page.

During one clic update, 2 databases upgrade occured :


La base de données de Piwik sera mise à jour depuis la version 2.1.0 vers la version 2.9.1.

Les dimensions suivantes vont être mises à jour: log_visit.user_id.


Votre base de données est expirée et doit être mise à jour avant de pouvoir continuer.

Les dimensions suivantes vont être mises à jour: log_visit.config_device_model, log_visit.config_device_brand, log_visit.config_device_type, log_visit.config_os_version, log_link_visit_action.idaction_content_interaction, log_link_visit_action.idaction_content_name, log_link_visit_action.idaction_content_piece, log_link_visit_action.idaction_content_target.

Regards


(Matthieu Aubry) #6

It looks like a problem with the Creation of the JS file. can you compare your file index.php?module=Proxy&action=getCoreJs

with the one from the demo: http://demo.piwik.org/index.php?module=Proxy&action=getCoreJs ?

Are they both as big?

if not, maybe there was an error while generating this file (although I see you say there is no error logged in web server error log file)


(hpsam) #7

The file at http://testks2.hpsam.info/piwik/index.php?module=Proxy&action=getCoreJs is very different.
There are 77ko missing in my file. Part of the file are in the 2 files but not at the same place.
Like this one with a bug (found in the 2 files) in comments generation :


var JSON;if(!JSON){JSON={}}(function(){function f(n){...
/** echo  * @license echo  * while read i do echo  *  done echo
*/
!function(){var Color,K,PITHIRD,TWOPI,...
chroma.brewer=brewer={OrRd:["#fff7ec"...

It is some lines before jScrollPane code in my file and after AngularJS and ng-dialog in demo file.

This part is also not at the same place


var Piwik_Popover=(...

Later in the files they are too many différences to detail them.

But différences can come from the activated plugins.


(Matthieu Aubry) #8

Ok there may be an issue that some files may not be uploaded properly. If you go to Diagnostics -> System Check do you see some message ?


(hpsam) #9

I forgot to say it, but I have already done this check.
The only warn is for LOAD DATA INFILE refused for piwik database user.
All others points are OK.


(Matthieu Aubry) #10

Ok my last idea is that you try to edit config/config.ini.php

then remove from there all the lines below [Plugins] category

then replace with these plugins in this order:


[Plugins]
Plugins[] = "CorePluginsAdmin"
Plugins[] = "CoreAdminHome"
Plugins[] = "CoreHome"
Plugins[] = "CoreVisualizations"
Plugins[] = "Proxy"
Plugins[] = "API"
Plugins[] = "ExamplePlugin"
Plugins[] = "Widgetize"
Plugins[] = "Transitions"
Plugins[] = "LanguagesManager"
Plugins[] = "Actions"
Plugins[] = "Dashboard"
Plugins[] = "MultiSites"
Plugins[] = "Referrers"
Plugins[] = "UserSettings"
Plugins[] = "DevicesDetection"
Plugins[] = "Goals"
Plugins[] = "SEO"
Plugins[] = "Events"
Plugins[] = "UserCountry"
Plugins[] = "VisitsSummary"
Plugins[] = "VisitFrequency"
Plugins[] = "VisitTime"
Plugins[] = "VisitorInterest"
Plugins[] = "ExampleAPI"
Plugins[] = "ExampleRssWidget"
Plugins[] = "Provider"
Plugins[] = "Feedback"
Plugins[] = "Login"
Plugins[] = "UsersManager"
Plugins[] = "SitesManager"
Plugins[] = "Installation"
Plugins[] = "CoreUpdater"
Plugins[] = "CoreConsole"
Plugins[] = "ScheduledReports"
Plugins[] = "UserCountryMap"
Plugins[] = "Live"
Plugins[] = "CustomVariables"
Plugins[] = "PrivacyManager"
Plugins[] = "ImageGraph"
Plugins[] = "Annotations"
Plugins[] = "MobileMessaging"
Plugins[] = "Overlay"
Plugins[] = "SegmentEditor"
Plugins[] = "Insights"
Plugins[] = "ZenMode"
Plugins[] = "LeftMenu"
Plugins[] = "Morpheus"
Plugins[] = "Contents"
Plugins[] = "DBStats"

then delete tmp/ folder in piwik

then try again?

If it works now, can you please add a comment in this related bug report: Make sure core plugins are always loaded in same order · Issue #6529 · matomo-org/matomo · GitHub


(hpsam) #11

That’s the solution, thanks.

Before the modification my plugins order list was:
Plugins[] = "API"
Plugins[] = "Widgetize"
Plugins[] = "Dashboard"
Plugins[] = "Referers"
Plugins[] = "UserSettings"
Plugins[] = "UserCountry"
Plugins[] = "VisitsSummary"
Plugins[] = "VisitFrequency"
Plugins[] = "VisitTime"
Plugins[] = "VisitorInterest"
Plugins[] = "Provider"
Plugins[] = "Login"
Plugins[] = "UsersManager"
Plugins[] = "SitesManager"
Plugins[] = "Installation"
Plugins[] = "LanguagesManager"
Plugins[] = "MultiSites"
Plugins[] = "UserCountryMap"
Plugins[] = "CustomVariables"
Plugins[] = "PrivacyManager"
Plugins[] = "CoreHome"
Plugins[] = "CoreUpdater"
Plugins[] = "CoreAdminHome"
Plugins[] = "CorePluginsAdmin"
Plugins[] = "Proxy"
Plugins[] = "Actions"
Plugins[] = "SegmentEditor"
Plugins[] = "CoreConsole"
Plugins[] = "CoreVisualizations"
Plugins[] = "Referrers"
Plugins[] = "ScheduledReports"
Plugins[] = "Events"
Plugins[] = "Morpheus"
Plugins[] = "ReferrersManager"
Plugins[] = "ZenMode"
Plugins[] = "LeftMenu"
Plugins[] = "DevicesDetection"
Plugins[] = “Contents”