New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
No widgets are displayed, "Oops ... problem during the request" #657
Comments
I have to correct one details: Now i am really wondering why the stats are not shown… |
Another thing i found out: I enabled debug mode for SQL queries and called Piwik for the getBrowser-Widget. First, i did it for a date that did not show any results: Firefox offered me to download an empty index.php… thus nothing was given back. So, if this is the origin of my problems: how could things turn that Piwik is in a state like this? And how can i fix it? Btw: The problematic SQL-Query: SELECT idarchive, value, name, UNIX_TIMESTAMP(date1) as timestamp FROM piwik_archive_numeric_2009_04 WHERE idsite = 1 AND date1 = ‘2009-04-13’ AND date2 = ‘2009-04-13’ AND period = 1 AND ( (name = ‘done’ AND value = 1)OR name = ‘nb_visits’) AND UNIX_TIMESTAMP(ts_archived) >= UNIX_TIMESTAMP(‘2009-04-13’) ORDER BY ts_archived DESC |
Please make sure you uploaded ./libs/open-flash-chart/open-flash-chart.swf in binary mode. |
what’s your website url? I think the problem might be that archiving timesout in your server. make sure you have setup auto-archiving as http://piwik.org/docs/setup-auto-archiving/ |
and try to refresh your browser cache. vipsoft, do you know if there is a way we could force user’s browser to refresh all piwik cache after piwik upgrades, to make sure they pick up the new javascripts? this might be a problem when we push the new piwik.js if people start using the new OO interface but users’ browsers still have the old piwik.js cached. |
Replying to [vipsoft](comment:4): > Please make sure you uploaded ./libs/open-flash-chart/open-flash-chart.swf in binary mode. I trust in Dolphin ;) Since in other cases (see above) the charts are generated the files are copied correctly. Replying to [matt](comment:5): Auto archiving is not set up, since i have no shell or root access to the server. I will talk to our admin about this. But see below. Replying to [matt](comment:6): Already done, with no effect. My problem concretizes: obviously only on April, 13th something has gone wrong. Today i run the sql query from comment:2 against the dates of today and yesterday: almost everythin worked fine. Only the charts and views involving April 13th are broken. This includes Last visits graph but also month and year (and week) views. |
The archive.sh looks for the php-binary “php5”, which leads to an empty result on our server, because the bin is simply php (/usr/local/bin/php). Maybe the script should catch this case and look for “php” if the result is empty. However, my problem still exists. Does no one really have an idea how i can repair the database at least manually? I thought about removing the (noew > 560) lines with the same values and add the ‘done’-row, but i don’t feel confident about it, since i have not much insight in Piwik, yet. Could this work or would i crash something doing so? |
Blizzz we'd be happy to patch archive.sh to make it work in your use case as well. can you please have a look and provide a patch? |
this is not a bug but a case where archiving was timing out. we might want to improve the error message to let users know they can setup auto archiving. |
Attachment: Patch for misc/cron/archive.sh |
Replying to matt:
I'm glad to and uploaded the diff few minutes ago. However, my problem still exists and hence the last visits graph (and other) are not too unimportant i'd be good to solve this. If this is not the place to trace and solve it, where should i report it? |
Okay, i almost solved by setting the name=done-row from value=2 to value=1 with this query: update piwik_archive_numeric_2009_04 set value=1 where idarchive between 195 and 1175 and date1='2009-04-13' and date2='2009-04-13' and name='done' i can access all statistics again, but following for 13th april with period=day: |
After updating to 0.2.33 (and now 0.2.34) the widgets are not shown any longer. On Opera the message “Oops … problem during the request, try again” appears. Firefox`s error console prints:
Fehler: uncaught exception: [“Node cannot be inserted at the specified point in the hierarchy” code: “3” nsresult: “0×80530003 (NS_ERROR_DOM_HIERARCHY_REQUEST_ERR)” location: “http://MYDOMAIN/MYPATH/libs/jquery/jquery.js Line: 12”](Exception…)
and
Error: No element found
Sourcefile: http://MYDOMAIN/MYPATH/index.php?module=Referers&action=getSearchEngines&idSite=1&period=day&date=2009-04-13
Zeile: 1
However, new entries are stored into the database, obviously. Another point is, that the widgets are shown, when i select a date before the update to 0.2.33. I guess, some changed in the database, though not correctly (i think i read somewhere something about utf-8, not sure).
How can i fix it?
The text was updated successfully, but these errors were encountered: