Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#714 closed Bug (fixed)

Dashboard is broken

Reported by: joku Owned by:
Priority: major Milestone: RobotRock
Component: Core Keywords:
Cc: Sensitive:

Description

After upgrading to 0.2.35 dashboard just shows "Loading data" infinitely. Browser cache deleted and browser restarted. Not using any proxies. No reverse proxies or other caching mechanisms (even restarted apache2 to ensure that there is no caching). Tested with different browsers on different computers (Opera, Firefox 3.0, Ubuntu & Windows XP & Mac OS X).

Upgraded with following process:

  • Moved old piwik folder
  • unzipped new release
  • Moved (with permissions) config and tmp folders from old folder to new
  • Upgraded database (automatic wizard).
  • Removed browser cache and restarted browser

Change History (26)

comment:1 Changed 5 years ago by joku

Ohfuck. Forget to remove tmp/templates_c contents. This fixes loading data. Everything else but Dashboard main page works fine.

Main page loads Widgets (default configuration, default widgets) but contents are just "Loading widget, please wait...".

comment:2 Changed 5 years ago by joku

Fixed. Dashboard widget which shows visits per day (on left top, I think) showed 'Widget Not Found'. After that was deleted everything (?) works. Why whole dashboard fails if there is one missing widget? Last Visits Graph works after re-added.

From my point of view upgrade process was a bit clunky:

  • Nowhere was notice about tmp/templates_c folder (my default action was just unzip latest.zip and overwrite files -> templates_c were kept)
  • Was Last Visits Graph widget removed/renamed or something as it was broken and required removing & readding? Default plugins installed, no customization etc.

comment:3 Changed 5 years ago by vipsoft (robocoder)

Browser cache problem to be addressed in #712 (related to #660).

We can call Smarty's clear_compiled_tpl() to clear the templates_c files (perhaps in Updater?), to force these to be recompiled.

Yes, in [1072], getLastVisitsGraph was renamed to getEvolutionGraph. We could try to fix the piwik_user_dashboard table...

comment:4 Changed 5 years ago by joku

Another question is that (already bolded at my previous comment) why whole dashboard completely fails (every widget just shows 'Loading...') when there is one missing widget installed? Should this be separate ticket?

comment:5 Changed 5 years ago by vipsoft (robocoder)

This is because your dashboard is trying to load a widget by name -- which in my comment stated had been renamed. When you added the widget back, the dashboard used the new name.

comment:6 Changed 5 years ago by vipsoft (robocoder)

  • Milestone set to 1- RobotRock

comment:7 Changed 5 years ago by RHihn

I got the same problem after upgrading to 0.2.35.
My dashboard displays only the "loading data" text until infinity but the other pages display the data as they should.
I also tried everything: deleting the templates, deleting the browsers cache and restarting apache.
The "add widget" function is also not working.
Any fixes for this?

comment:8 follow-up: Changed 5 years ago by joku

RHihn: as said, try to delete widgets that say 'Widget not found'. At least for me that helped (widgets can be added back using Add Widget)

comment:9 Changed 5 years ago by vipsoft (robocoder)

Note: [1119] is necessary because Smarty 2.6.22 does not recompile templates if there are one or more output filters. (Undocumented behaviour; determined this by code inspection.)

comment:10 Changed 5 years ago by vipsoft (robocoder)

Oops. Scratch that last comment. Digging further...

comment:11 Changed 5 years ago by vipsoft (robocoder)

[1119] is necessary because the files we distribute in last.zip may be older than the creation timestamps of compiled templates. This is problematic if a user extracts last.zip over an existing installation.

comment:12 in reply to: ↑ 8 Changed 5 years ago by RHihn

Replying to joku:

RHihn: as said, try to delete widgets that say 'Widget not found'. At least for me that helped (widgets can be added back using Add Widget)

The "Add Widget" function doesn't work here.

comment:13 Changed 5 years ago by remy.damour

Hi guys,

Since I upgraded from 0.2.34 to 0.2.35, piwik is completely down (not only dashboard, but all pages). No data gets displayed and dashboard widgets are stuck to 'Loading widget, please wait...' message.

I completely emptied /piwik/tmp directory but it did not change anything.
I have no 'widget not found' error.

How can I fix it?
It would be nice to have a 0.2.36 realease pretty soon to fix this issue.

Regards,
Remy

comment:14 Changed 5 years ago by till

I get "Widget not found" as well. But can anyone please tell me how to update this? I don't know which widget I need to reinstall.

comment:15 follow-up: Changed 5 years ago by till

To answer myself:

UPDATE  `piwik_user_dashboard`
SET  `layout` =  'VisitsSummary.getEvolutionGraph~VisitorInterest.getNumberOfVisitsPerVisitDuration~UserSettings.getBrowser|Referers.getKeywords~Referers.getWebsites|Referers.getSearchEngines~VisitTime.getVisitInformationPerServerTime|' WHERE
CONVERT(  `piwik_user_dashboard`.`login` USING utf8 ) =  'YOUR-USERNAME-HERE'
AND  `piwik_user_dashboard`.`iddashboard` =1 LIMIT 1 ;

Now I get:

C:\Users\John\Documents\flash\svn\data-files\data-47.txt

comment:16 Changed 5 years ago by till

I had to clear the cache again and then the message disappeared. I see graphs. =)

comment:17 Changed 5 years ago by vipsoft (robocoder)

[1122] fixes widget hanging with "loading" message where non-native json_encode() double escapes the double quotes.

comment:18 follow-up: Changed 5 years ago by vipsoft (robocoder)

matt: as a quick fix, what about deleting the rows in piwik_user_dashboard (during an update script). The dashboard plugin will recreate from a default layout.

comment:19 Changed 5 years ago by vipsoft (robocoder)

  • Resolution set to fixed
  • Status changed from new to closed

Or is this unnecessary now?

Closing...let 0.2.36 feedback begin...

comment:20 in reply to: ↑ 18 Changed 5 years ago by matt (mattab)

Replying to vipsoft:

matt: as a quick fix, what about deleting the rows in piwik_user_dashboard (during an update script). The dashboard plugin will recreate from a default layout.

patched in [1128]

comment:21 Changed 5 years ago by vipsoft (robocoder)

re: [1128] I was thinking of dropping lastVisitsGraph.

comment:22 Changed 5 years ago by till

I had executed the above query and since I updated to 0.2.37 tonight, the dashboard is broken again. "Widget not found..."

comment:23 Changed 5 years ago by vipsoft (robocoder)

till: you still need to clear your browser cache. If that doesn't work, please open a new ticket.

comment:24 Changed 5 years ago by till

First off, I can't re-open the ticket ('no permission to change ticket fields'). ;-)

Secondly, I cleared the browser cache.

To fix it, I had to delete two orphaned widgets from my dashboard and then it worked. I couldn't figure out why they were not found -- e.g. name-wise. No idea what they were looking for.

comment:25 in reply to: ↑ 15 Changed 5 years ago by aravindc

Replying to till:

To answer myself:

UPDATE  `piwik_user_dashboard`
SET  `layout` =  'VisitsSummary.getEvolutionGraph~VisitorInterest.getNumberOfVisitsPerVisitDuration~UserSettings.getBrowser|Referers.getKeywords~Referers.getWebsites|Referers.getSearchEngines~VisitTime.getVisitInformationPerServerTime|' WHERE
CONVERT(  `piwik_user_dashboard`.`login` USING utf8 ) =  'YOUR-USERNAME-HERE'
AND  `piwik_user_dashboard`.`iddashboard` =1 LIMIT 1 ;

Now I get:

C:\Users\John\Documents\flash\svn\data-files\data-47.txt

I faced the same issue,

  1. i used the above update
  2. cleared tmp/template_c directory
  3. cleared browser cache

Now everything looks fine.

comment:26 Changed 5 years ago by alivenk

Note: See TracTickets for help on using tickets.