Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP

Loading…

Dashboard is broken #714

Closed
anonymous-piwik-user opened this Issue · 24 comments

4 participants

@anonymous-piwik-user

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
@anonymous-piwik-user

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...".

@anonymous-piwik-user

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.
@robocoder
Collaborator

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...

@anonymous-piwik-user

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?

@robocoder
Collaborator

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.

@anonymous-piwik-user

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?

@anonymous-piwik-user

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)

@robocoder
Collaborator

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.)

@robocoder
Collaborator

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

@robocoder
Collaborator

[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.

@anonymous-piwik-user

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.

@anonymous-piwik-user

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

@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.

@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
@till

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

@robocoder
Collaborator

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

@robocoder
Collaborator

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.

@robocoder
Collaborator

Or is this unnecessary now?

Closing...let 0.2.36 feedback begin...

@mattab
Owner

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]

@robocoder
Collaborator

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

@till

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

@robocoder
Collaborator

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

@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.

@anonymous-piwik-user

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.

@anonymous-piwik-user anonymous-piwik-user added this to the RobotRock milestone
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.