Also: see the FAQ (How to - Analytics Platform - Matomo) on how to regenerate the archives (assuming you haven’t pruned your logs).
i already tried to regenerate the archives, but that did not solve the problem.
after testing different date ranges it seems that it is the data for a specific day (april 23) that is causing this problems. i can not see the stats for this day on my dashboard - when selecting this date all widgets on my dashboard show a 500 error. in the apache error logs only a “premature end of headers” shows up - the php error logs shows nothing.
can i regenerate the data for this specific date only?
I’m a little tied up right now … can you try:
delete from piwik_archive_blob_2009_04 where date1 <= ‘2009-04-23’ and ‘2009-04-23’ <= date2;
delete from piwik_archive_numeric_2009_04 where date1 <= ‘2009-04-23’ and ‘2009-04-23’ <= date2;
set: always_archive_data_period=1
go to that date (2009-04-23) in your piwik dashboard
then set this back to: always_archive_data_period=0
still no change… there must be something in the collected data for this day that crashes the script.
The last option is to dump the log entries from piwik_log_visit for that day, tar it up, and email it to us. (matt: can you weigh in on this? are there any other tables we should be looking at?)
did you try updating your PHP version ?
if yes, and if you have an issue with your data, please prepare a copy of your Database (without the piwik_archive tables) for the date concerned. Try to load it on a new piwik installation and check that it sill gives the error. then please post it here or on one of your server and let us know.
same problem here of broken visits-graph, servertime-graph… (piwik 0.4 on PHP 5.2.0). but only in ie7 (7.0.5730.13 with flash 9.0…):
Open Flash Chart
IO ERROR
Loading test data
Error #2032
exact the same graphs work in ff3 on same machine. (i did clear cache, …)
Install 0.4.1rc1 in a fresh dir and see if you still have this problem.
I’m running my Piwik through An Apache https->http reverse proxy and can’t replicate your problem with IE7, Opera, Safari, or FF3.
[quote=vipsoft @ Jun 17 2009, 02:27 PM]Install 0.4.1rc1 in a fresh dir and see if you still have this problem.
I’m running my Piwik through An Apache https->http reverse proxy and can’t replicate your problem with IE7, Opera, Safari, or FF3.[/quote]
i’m trying. but our code itself is mounted read only on the webservers (/data/code/…) , so i have to set the tempdirs outside.
but somehow there is a bug. i set “compile_dir = /data/bla/…” in my config.inc.php but piwik complains about it as it breaks my path:
"the $compile_dir ‘/data/code/…//data/bla/…/templates_c’ does not exist, or is not a directory."
it looks like the absolute path of the piwikfiles (code) is added in front of my compile_dir path!
btw: we run a pound reverseproxy, 2 apaches, shared code ro mounted from storage. currently every machine has its own tmp dirs (not shared). we run an administration to our application on it with several hundred administrators working concurrently without any lags or other effects i see in piwik: sometimes it takes really long to load the json or the dashboard. sometimes it never gets those.
i managed to get 0.4.1-rc1 to work, by copying the code to both machines so i did not need to set compile_dir.
but still the same with ie7 (2 different machines, always cache cleared,…) : http://toastbrot.ch/piwik2.png .
ff3 works sometimes. some elements take terribly long and after 60s of proxytimeout i see the same errors.
i’m now trying older versions…
hm. interesting: when i remove one node from balancer, the performance massively increases in the piwik-backend (means i always get all widgets and stuff in no time. this might be another case to investigate, but i can workaround that myself).
but back to my main problem. i still get those errors in ie7 and ie6 (now flash10) with 0.4 and 0.4.1-rc1:
Open Flash Chart
IO ERROR
Loading test data
Error #2032
on any chart!
on ff3, ff2, safari-windows, opera 9.64 all works as expected, even with 0.4
any hint on this?
it looks like these open flash charts do have a problem with ssl (on certain conditions). when i call whole piwik without ssl all works fine. our ssl-chain is valid, and none of the browsers complains about our ssl (even ie6 & 7 tell me its valid).
maybe this solves that issue that is still inside 0.4.1-rc1:
http://forums.openflashchart.com/viewtopic.php?f=4&t=723
http://forums.openflashchart.com/viewtopic…?f=8&t=1104
(besides the bug described above of an invalid compile-dir path)
shall i open bug-issues for those?
you can open a ticket but it may already be fixed in svn.
I also have this problem and I am a noob at this stuff.
I need help that I can understand.
Open Flash Chart
IO ERROR
Loading test data
Error #2032
Fixed in svn. Unfortunately, I don’t have a cumulative patch for this one.
what is svn and how to I find it to fix my problem ?
Is anyone here able to speak layman’s terms free of acronyms and random code?
Please help me to fix my piwik.
thank you so much.
svn (or subversion) is the software we use to store the Piwik source code.
You can browse the source code at dev.piwik.org
[quote=vipsoft @ Jun 24 2009, 05:22 PM]svn (or subversion) is the software we use to store the Piwik source code.
You can browse the source code at dev.piwik.org[/quote]
Okay, I appreciate you taking the time to respond. Honestly I do, but perhaps I am not being clear about this. I am not a programmer I am a noob . Why would I browse source code ? What on earth would I be looking for? Surely you can understand why this isn’t of any help whatsoever to me.
I am looking for simple step by step instructions of what I need to do to fix the problem.
If I need to replace a file with a new version or a line of code can you please just break it down for me and tell me which file or what line to replace and with what replacement?
[size=12pt]
What do I do to fix this problem [/size]?
Please do not think I am being rude. I have much respect for what you do and I am very grateful
Thank you so very much.
J
Honestly, the fact that you refer to yourself as a noob scares the sh*t outta me…
Obligatory disclaimer: Make a back-up. Use the following information at your own risk.
If you don’t have a subversion client, you might find one here: http://subversion.tigris.org/
If you get the command line client, you could run this command to download a snapshot of the Piwik source code:
svn co http://dev.piwik.org/svn/trunk
Assuming you did the above successfully, you’ll probably find a folder called “trunk” in your current directory. From here on, it’s all specific to your environment, i.e., we can’t help you. But whatever you do from this point, do not simply copy the folder’s contents over an existing Piwik installation.
[quote=vipsoft @ Jun 24 2009, 05:49 PM]Honestly, the fact that you refer to yourself as a noob scares the sh*t outta me…
Obligatory disclaimer: Make a back-up. Use the following information at your own risk.
If you don’t have a subversion client, you might find one here: http://subversion.tigris.org/
If you get the command line client, you could run this command to download a snapshot of the Piwik source code:
svn co http://dev.piwik.org/svn/trunk
Assuming you did the above successfully, you’ll probably find a folder called “trunk” in your current directory. From here on, it’s all specific to your environment, i.e., we can’t help you. But whatever you do from this point, do not simply copy the folder’s contents over an existing Piwik installation.[/quote]
I appreciate your help but at this point to be frank my thoughts are "screw it"
I will stick with Google Analytics. At least it will work properly and I won’t be asked to rummage around though source code.
This is the least user friendly support I have had. “search around aimlessly though our source code and fix it yourself” is hardly the support I had hoped for.
perhaps this thread will serve to solve this issue for someone else but for me this is useless.
thanks anyway, best of luck
J