@anonymous-piwik-user opened this issue on April 14th 2009

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: "0x80530003 (NS_ERROR_DOM_HIERARCHY_REQUEST_ERR)" location: "http://MYDOMAIN/MYPATH/libs/jquery/jquery.js Line: 12"

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-piwik-user commented on April 21st 2009

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

@anonymous-piwik-user commented on April 14th 2009

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-piwik-user commented on April 14th 2009

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

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

@mattab commented on April 15th 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 commented on April 15th 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-piwik-user commented on April 15th 2009

Replying to vipsoft:

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: 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: 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-piwik-user commented on April 20th 2009

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 commented on April 20th 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 commented on April 20th 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-piwik-user commented on April 21st 2009

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-piwik-user commented on April 22nd 2009

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 on July 30th 2009
Powered by GitHub Issue Mirror