Dashboard is broken

[joku]

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

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

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

[vipsoft]

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

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

[vipsoft]

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.

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

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

[vipsoft]

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

[vipsoft]

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

[vipsoft]

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

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

[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

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

[vipsoft]

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

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

[vipsoft]

Or is this unnecessary now?

Closing...let 0.2.36 feedback begin...

[matt]

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]

[vipsoft]

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

[vipsoft]

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.

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