If I can jump on this thread since my problem is similar… I just installed Piwik last week and I’m beginning to notice a measurable sluggish behavior of my vps server. Checked and the “server load” was throwing up a caution flag. I see that my database is reaching the 15K visitors range so I’ve been trying to run the cron to archive the data. Took a bit to figure the path correctly but finally figured it out. Now the cron will run, but I get an error on the cron email report…
Error in the last Piwik archive.php run:
archive.php expects the argument --url to be set to your Piwik URL, for example: --url=http://example.org/piwik/
--help for more information
When trying to fix the cron path earlier, the tech support person from my hosting company changed a line in the /core/CronArchive.php file.
The line is…
/path/to/cli/php \"" . @$_SERVER['argv'] . "\" --url=http://my domain/Piwik/ [arguments]
“my domain” changed above for privacy.
Anyway, I believe this is what may be causing my error. I should have saved a copy of the original file before they tinkered with it, but like a fool, I didn’t.
Can someone tell me what the original code is for that line. I remember it being something generic.
EDIT: I found the original file and restored it but that didn’t solve my problem.
/path/to/cli/php \"" . @$_SERVER['argv'] . "\" --url=http://your-website.org/path/to/piwik/ [arguments]
Still get the exact same error message.