I just installed piwik 0.5.5 on a local development server to try it out.
Specs:
XAMPP on a windows XP machine
MySQL 5.1.33-community
Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i
PHP 5.2.9
No issues during installation (I selected mysqli instead of PDO; otherwise standard install). There is basically no traffic data for the site since it’s a development server (< 10 hits from me clicking around to test it).
But the app takes forever to do anything! Clicking dashboard and the widgets or pages load over the course of minutes. I mean, I clicked it before writing this forum post and it still hasn’t loaded. It eventually does load, but what do I have setup incorrectly here? The same system/db, etc. handles tables with hundreds of thousands of rows no problem. The demo on piwik.org works fine for me.
I tried truncating the archive tables, but it did not improve things. This occurs in firefox / IE / chrome. I have one website set up on it (http : // localhost/mydevdir). I put the standard JS tracking into two php files.
I don’t think the archiving / cron route is a reasonable thing to consider speeding things up since it crawls when there is no data to load! Any help would be greatly appreciated - I would really like to get this working and get away from GA.
i forgot i never did try and figure out why but xampp does not like .htaccess files
i renamed them all to 1.htaccess and it works fine now. it was giving a 500 error(always has with xampp too) in some cases it displayed some it did not.
it works now.
i did upgrade to 06.rc1 works great
there are a lot of htaccess files under most of the sub dir one level down from piwik structure.
hope this helps someone and ill see about why xampp dont like them sometime
may want to pout a note in the docs for this or a sticky problem solver for others that come across this.
I’m having the same issue, I tried to rename the .htaccess files, but that did not help. I’m still trying to figure out why it is doing this. If I debug the project in (netbeans), it runs fine. but as soon as I try to hit the site outside of netbeans it’s doing the samething, “timing out”.
Ok, after digging around, it “appeared”(from a gut feel) that php was in some sort or “wait” state, like a “breakpoint” was hit. So I started digging around with xdebug and commenting out xdebug settings in my php.ini file one by one. Once I commented out this one:
;xdebug.remote_autostart=1
It started to work properly.
In case anyone else runs in to this and the .htaccess solution doesn’t seem to help, check that setting.