Skip to content
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

Closed
anonymous-matomo-user opened this issue Apr 14, 2009 · 12 comments
Closed
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Milestone

Comments

@anonymous-matomo-user
Copy link

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?

@anonymous-matomo-user
Copy link
Author

I have to correct one details:
The day view works for the days until last sunday (incl.), from Monday on the dashboard is empty.
The update from 0.2.32 to 0.2.33 has been done on Thursday and the update from 0.2.34 today.

Now i am really wondering why the stats are not shown…

@anonymous-matomo-user
Copy link
Author

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.
With a working date, i got a result and the query overview as well. Then i hacked the first query it into phpmyadmin (no shell access here) and compared it for working and not working dates. The result is: On the working dates, exactly two rows are given back. One with ‘done’ and one with ‘nb_visits’ as values for the name-column. On the other hand, passing a not working date returned a resultset of 341 rows. It looks kind of suspicious to me ;)

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

@robocoder
Copy link
Contributor

Please make sure you uploaded ./libs/open-flash-chart/open-flash-chart.swf in binary mode.

@mattab
Copy link
Member

mattab commented Apr 15, 2009

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/

@mattab
Copy link
Member

mattab commented Apr 15, 2009

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.

@anonymous-matomo-user
Copy link
Author

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):
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/

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):
and try to refresh your browser cache.

Already done, with no effect.
However, the browser can be adviced not to use the cache with an adequate header, cf. example 2 of http://de.php.net/header

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.

@anonymous-matomo-user
Copy link
Author

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?

@mattab
Copy link
Member

mattab commented Apr 20, 2009

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?

@mattab
Copy link
Member

mattab commented Apr 20, 2009

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.

@anonymous-matomo-user
Copy link
Author

Attachment: Patch for misc/cron/archive.sh
archive.diff

@anonymous-matomo-user
Copy link
Author

Replying to matt:

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?

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?

@anonymous-matomo-user
Copy link
Author

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:
Visitors -> Location & provider -> Providers
Actions -> Pages, Outlinks, Downloads
which is not nice, but i can live with that i think.

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Projects
None yet
Development

No branches or pull requests

3 participants