@anonymous-piwik-user opened this Issue on May 14th 2009

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 commented on May 14th 2009

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 commented on May 14th 2009

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 commented on May 14th 2009 Contributor

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 commented on May 14th 2009

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 commented on May 14th 2009 Contributor

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 commented on May 14th 2009

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 commented on May 15th 2009

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 commented on May 15th 2009 Contributor

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 commented on May 15th 2009 Contributor

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

@robocoder commented on May 15th 2009 Contributor

[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 commented on May 15th 2009

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 commented on May 15th 2009

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 commented on May 15th 2009

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 commented on May 15th 2009

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 commented on May 15th 2009

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

@robocoder commented on May 16th 2009 Contributor

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

@robocoder commented on May 16th 2009 Contributor

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 commented on May 16th 2009 Contributor

Or is this unnecessary now?

Closing...let 0.2.36 feedback begin...

@mattab commented on May 16th 2009 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 commented on May 16th 2009 Contributor

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

@till commented on May 17th 2009

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

@robocoder commented on May 17th 2009 Contributor

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

@till commented on May 17th 2009

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 commented on May 28th 2009

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.

This Issue was closed on August 4th 2009
Powered by GitHub Issue Mirror