All visitors have the same IP address and Provider. How do I track individual IPs?

If you are seeing that all your visitors are correctly tracked in Piwik but that they all have the same IP address, read on. In your ‘Visitor Log’ report, if all your visitors have the same IP address or the same Provider, this FAQ will provide a solution.

Why do I see the same IP everywhere?
In most cases this IP address (that is set to all visitors) is either the IP of the Piwik server itself or maybe the IP of a proxy server or a firewall between your website’s visitors and the server hosting your website. Sometimes the IP address will be set as

How do I fix this issue?
1. Your Piwik server may actually be hosted behind a proxy. To configure Piwik to track IP address correctly when using a Proxy server, read this FAQ to configure Piwik to read the correct IP address. As explained in this FAQ you may add lines in your Piwik config file to tell Piwik where to read the IP address.
2. Are you using the Tracking API? You may also experience this problem when you are using one of the Tracking API clients to record visits and actions. You may use the method setIP() to overwrite the IP address manually. See the reference.

Piwik tracks far fewer visits than other web analytics tools, but tracks the same number of pageviews.

If you use other web analytics tools on your website, in some rare cases you may find that Piwik tracks far fewer visits than other tools.

While there are explanations for small differences, sometimes Piwik will track fewer visits but about the same number of pageviews (actions). When this happens, it shows that the algorithm attributing Visits to particular pageviews is not working as expected.

If your website visitors are visiting from one IP address (eg. they connect from the same offices), then Piwik may mistakenly believe all actions by this IP address are the same. In this case you can set a setting in the config file, make a change to your config file as explained in this FAQ.

The Real Time Visitors World Map is not showing data.

The Real Time Visitor Map is a great tool for Piwik users. It lists, in real-time, all visitors to the website and puts them on the map according to their country and locations (based on country, region, city and/or latitude and longitude).

If the Real Time Map is for you not showing any data, please check the following items:

  • Make sure you have enabled Geo-location with the City database in your Piwik. Geo-location will enable Piwik to try and fetch the following information for each visitor: country, region, city, latitude and longitude. After enabling City Geo-location (for example using the Geoip php or Geoip PECL options), most of your visitors will be geo located and should be displayed on the map!
  • Do you get Javascript errors on the Map? This may occur when your server is not configured to properly serve SVG files. Piwik Maps stores the countries boundaries to draw the map, in SVG files.
    • If you are using Apache webserver, create a .htaccess file, in the piwik/ directory, with the following content:
AddType image/svg+xml svg svgz
AddEncoding gzip svgz
  • If you are using Nginx webserver, in your mime.types file (example mime.types), add the following:
  image/svg+xml svg svgz;

Piwik doesn’t track any visits and pages, and shows “There is no data for this report” in all reports.

There are several possible reasons why Piwik is not tracking your visits properly:

  • Incorrect Piwik tracking code Please check that you can find the Piwik javascript code on your website pages that you wish to track. Sometimes, when you copy paste the javascript code in other softwares, like Word or FrontPage, they may add extra spaces or characters. Make sure the code looks like this example (and that it mentions the right URL of your Piwik installation). In some cases, when you install Piwik on your local test server, the javascript code might contain “localhost” or “”. When you deploy Piwik in production, you have to edit the Javascript code so that it points to your website URL, eg. “”. Also, each Piwik tracking code contains the idsite of your website registered in Piwik. If you only registered one website in Piwik, the idsite found in your Javascript code should be “1”.
  • Make sure you are viewing reports for the correct website and date in Piwik In Piwik, make sure you selected the right website in the website selector. Also, try to look at reports for “today” by changing the date in the date picker. Please wait at least 10 seconds after generating visits on your website: by default Piwik will only process reports every 10 seconds when “today” is selected.
  • Archiving triggered from the browser must be enabled, if it is disabled the Cron script must be configured properly
    In Administration > General Settings, ‘Allow Piwik archiving to trigger when reports are viewed from the browser’ must be set to ‘Yes’. If it is set to ‘No’, you must configure the cron script to automatically archive your web analytics reports, or Piwik will show ‘No Data’. More information about auto archiving.
  • Third party Piwik plugins It is possible that some Third party Piwik plugins could cause problems when tracking your visitors. Please try to disable all the third party plugins you are using to see if it fixes the issue.
  • Browser addons blocking the Piwik Tracking Javascript (NoScript, DoNotTrack, etc.) If you use browsers addons such as Adblock, Adblock plus, NoScript, Ghostery or others, the Piwik Javascript code is not executed in your browser. Try to use a different browser that does not have these extensions, or disable these browser extensions and try again.
  • Piwik by default supports DoNotTrack: please check you haven’t enabled DoNotTrack in your browser options.
  • Do you have logs registered in your Piwik database? If your Piwik tracking code is properly installed, Piwik would record visits in your database. To check if you have logs in your database, go to Piwik > Visitors > Visitor log, and select “today” in the calendar. If you see recent visitor information, it means that the visitor tracking is working, but maybe there is a problem with reports archiving. Note: you can also check if logs are recorded correctly by looking at the table “piwik_log_visit” (using phpMyAdmin for example) and see if there are visits recorded. Alternatively, you can enable the plugin “DBStats”, and then go to the “Database usage” tab in your Piwik administration area, and check if the table piwik_log_visit has any rows.
  • Testing Piwik with disabled Javascript By default, Piwik only tracks visitors with javascript enabled. When you are testing that Piwik tracks visits properly make sure you have javascript enabled. If you need help with javascript tracking check out docs/javascript-tracking. If you need to use a tracking method which doesn’t involve javascript have a look at docs/tracking-api.
  • Piwik displays a red cross (on IE) or a broken image icon on your tracked pages, instead of the 1*1 transparent Pixel Check out this FAQ answer.
  • Access to piwik.php fails If your host uses mod_security to block requests containing URLs (eg. hosts like HostGator, The Planet), check out the Piwik and mod_security FAQ. If you use HTTP Authentication (Basic or Digest) on your Piwik files, you should exclude piwik.php and piwik.js from this authentication, or visitors on your website would be prompted with the authentication popup.
  • Tracking https (SSL) pages If you install the Piwik Javascript Tracking tag on https:// pages, then the tracking requests will be sent to Piwik via https. This means that the server you installed Piwik on must be able to handle these https requests, or no data will be tracked. See also Piwik and SSL tracking and checking that Piwik SSL Server is correctly configured.
  • Local copy of piwik.js outdated Some users make a local copy of piwik.js on a different server than their Piwik installation. This is not officially supported and causes issues when the piwik.js bundled with Piwik is updated and not compatible with the previous version (for example, this is the case in Piwik 0.5.5). Please check that your Piwik JS tracking code is exactly the one given in the Piwik admin screen.
  • Using Piwik latest version If you are still seeing “No data”, please make sure you are using the latest version of Piwik (if not, update now).
  • Check your webserver error logs If all else fails, it is possible that there is a server misconfiguration preventing Piwik from tracking your visits or processing reports. Often, there will be an error in the webserver error logs (apache logs, IIS logs, nginx logs, etc.). Please check that your PHP is configured to log errors: (php.ini should contain log_errors = On and error_log = /path/to/log). The messages in the webserver error log will help you find the source of the problem, for example search for the error message on this website.

Visits from search engines or campaigns are not recorded, Piwik shows “There is no data for this report” for all Referrers reports.

There are a few possible explanations:

  • Are your pages tagged correctly?
    If you click on your website in a search result, and look at your page source, can you see the Piwik tracking code? Make sure the Piwik tracking code is installed on all the pages you want to track, and is not within an iframe. We advise to put the Piwik code just before the </body> tag.
  • Are you using a redirect on your website landing page?
    If you are using a redirect, the visitor browser may lose the referer information. If you are tracking campaigns, and the landing page has a redirect, the URL loaded after the redirection will have lost the URL parameters. Make sure that your visitors arrive directly on the page with the Piwik tracking code installed.
  • Piwik only records 1 referer by visit, which means that only the first referer used to access the website will be recorded.
    If you search for a keyword in a search engine, click on your website in the search engine results, and land on a page with the Piwik tracker, you may expect to see the keyword in your Piwik reports.
    However, if you visited your website less than 30 minutes ago, Piwik will recognize you as an known visitor on the website, will record your page view, but will not update your visit referer. Piwik only record the first referer of a visit. When testing Piwik and search engine detection, make sure you make the test more than 30 minutes after your last page view on your website.
  • Check that the Piwik domain name in your Javascript tracking code is correct (this URL is in the second line of the Piwik tracking code). There have been cases of missing referrers when the Piwik JS code in the pages points to a URL that returns a 302 response instead of the final destination. It seems that some webserver compromise the tracking request when such redirects occur. Check in particular if the URL (doesn’t) contains “www.”. Also, if the server does an automatic redirection from http to https which also affects tracking requests to piwik.php, it might create problems such as missing referer data. Make such any http->https redirection excludes piwik.php requests.

Piwik doesn’t track Downloads and Outlinks on my website.

Piwik should automatically track clicks on Download files (with a known extension, eg. jpg, png, exe, zip, etc.) and clicks on Outlinks (links to other websites) using Javascript click handlers. There are a few reasons why this could fail:

  • Conflicting Javascript code
    In some rare cases, Download and Outlink tracking doesn’t work in Piwik is because your page is using another Javascript script or library which sets click handlers as well. If a third-party click handler returns a value, it is causing the browser to cancel other registered click handlers. Instead they should return false. Most scripts and libraries are doing it correctly, but you might have to manually edit your Javascript code to return false in onclick events.
  • Piwik doesn’t respond fast enough and user is redirected to the click target
    Piwik click handler works by adding a small delay during which the request is sent to the Piwik server. If somehow the request doesn’t reach the server within this delay, the request will be not be tracked and the user will be redirected to the clicked download file or to the external website. You can increase this delay, from the default of 500ms (0.5 second), by adding the following in the Javascript code, after the piwik.getTracker(..) line:

    _paq.push([‘setLinkTrackingTimer’, 750]); // increase to 750 milliseconds

  • You’re using Safari, Chrome, or some other WebKit-based browser.
    There is a known WebKit bug (feature?) that interrupts the tracking request. One workaround is to add the target=”_blank” attribute to anchor elements.

Piwik doesn’t detect accurately the Country and/or Continent of my visitors.

To improve Visitor Country detection, you should configure Geo Location in Piwik (click to learn more).

If you are not using Geo Location, Piwik is guessing your location from the language locale disclosed by the browser, e.g. en-us -> country is set to USA, fr-fr -> country is set to France, etc. In some cases, Piwik will guess the location when the region is omitted, e.g., fr -> France. This can be disabled from config/global.ini.php (or overridden in your config.ini.php):

enable_language_to_country_guess = 0

If you want to improve the country detection accuracy in Piwik, setup Geo Location now.

Piwik is slow! It takes a long time to load widgets, reports and pages.

There are a few possible reasons that Piwik could be slow to load:

I get ‘Oops… there was a problem during the request.’ or ‘Internal Server Error’ or ‘500 error’ or the ‘White screen of death’. How do I proceed?

Piwik may in rare cases display an error such as Internal Server Error or a 500 server error. This sometimes shows up as a white page, sometimes called the ‘White screen of death’. When you have such problem, please follow the following steps:

  1. Such error or white page indicates that there is a problem on the server: check in your web server error log file for an error message.
  2. When you find an error message in your server error log, then search for this message in the Piwik FAQ.
  3. If you do not find the answer in a FAQ, maybe it is a bug in Piwik. Search for the message in our issue tracker here.
  4. If you still have a problem and could not resolve it with those steps, please ask in the forums.

Piwik does not track visits on SSL / HTTPS pages.

When Piwik does not record your secure SSL traffic, you need to check that your Piwik server is correctly configured to be accessed over SSL / HTTPS.

Statistics from Piwik and my other web analytics tool (log analyzer, webalizer or javascript based) are different, why?

There could be a various number of reasons why Piwik numbers are different from your other web analytics solution.

  • Identifying Visitors: Piwik uses a javascript based tracker, and keeps count of unique visitors using a first party uuid cookie, as well as a visitor recognition heuristics algorithm (based on IP address and user settings). Some other tools only use cookies, only use IP, or a combination: we found that the way Piwik tracks visitors gives us really good accuracy and avoids creating artificial visits.
  • Tracking method: Other softwares (such as AWStats, Webalizer, Analog, etc.) or custom server-side script would record all traffic, including search bots or spam bots. Check that you are comparing Piwik with a similar web analytics tool
  • Bots and Spiders tracking: By default Piwik uses a Javascript tracker which automatically only records “real” human activity and excludes all bot activity. This leads to more accurate reports. If you compare Piwik to Google Analytics and notice a large discrepancies (over 5%) you may try to disable bot tracking in GA. To do this in Google Analytics go to Admin settings and navigate to View Settings under the View panel. Find the checkbox “Exclude traffic from known bots and spiders” and select it. Then both Piwik and Google Analytics will exclude all bot traffic. (PS: Piwik can be configured to enable tracking of search engine bots).
  • Hits vs Visits: Log analyzers softwares will typically report “hits”. Hits generally count all http requests to your websites: pages, images, css, javascript files, etc. Piwik reports page views, unique visitors, visits, etc. which are expected to be much less than the number of hits.
  • Record loaded page: when the Piwik javascript code is located at the end of the page, Piwik will only record page views for page that are finished loading. Log Analyzers would also record page requests that have been “cancelled”, eg. when the user hits the Back button before the page is displayed.
  • Position and presence of Javascript tag: when comparing Javascript-based statistics (eg. number of unique visitors), you have to make sure that both javascript tags are present on all pages you want to track. Also, it is better to put all tracking codes at the end of your pages, just before the </body> tag.
  • DoNotTrack support: Piwik by default respects the DoNotTrack setting. If visitors have selected not to be tracked in their browser, Piwik will not collect information about them. If you suspect many of your users are using DoNotTrack, you can disable it in the Privacy settings. This features works in the JavaScript tracker. When importing logs all visitors and actions will be tracked as DoNotTrack is not available in server log files.

Concerning Google Analytics, several users compared Piwik and Google Analytics numbers, and found very similar statistics: on significant traffic, differences were always less than 5 percent.

Conservative counting is definitely best – it makes your statistics more realistic on what you are trying to measure. Most analytics packages are used to measure relative upswings, we recommend using the same tool for all measurements and relative comparisons.

See also the FAQ: Piwik tracks fewer visits than other web analytics tools, but tracks the same number of pageviews.

After I updated Piwik, it stopped working (blank page, widgets not loading, error message, etc.). How can I fix this?

When you upgrade Piwik to the latest version, it sometimes happen that Piwik stops working — especially when the User Interface is not working (blank white page, widgets not loading, error message, etc.).

There are a few things to check that will most likely resolve the User Interface issue you are having:

  • 1) Delete your browser cache or try to access your Piwik with a different browser. If it still does not work…
  • 2) Delete all files in piwik/tmp/*. After deleting the files and directories, refresh the page. If it still does not work…
  • 3) Activate the display of PHP errors in your web server configuration. This may turn your white page into a useful error message page.
  • 4) Check your web server error logs. Maybe your error log will contain an explanation for the problem. If the log file has no Piwik related error…
  • 5) Reupload all Piwik files from the latest version. Sometimes, there are errors while uploading files and some of your Piwik files were maybe not overwritten by the latest version. Upload all files again, and check in your FTP software that the upload was successful.

Also, check out the other FAQs in this “Troubleshooting” category, as there might be other solutions for your problem.

If it still does not work, please search the Piwik Forums or search this website, and if there is no post about your problem, please create a new topic.

How do I configure my server to let Piwik serve HTML files?

For Piwik to work correctly, your web browser should be able to download from your Piwik server a set of HTML files. This FAQ explains what are various ways to configure your server to deliver Piwik HTML files.

To test whether your server can serve HTML, visit this URL: (replace with your Piwik URL). If this HTML page on your server looks the same as this page then your server is configured properly to serve HTML files!

If the test does not succeed then you need to enable your server to correctly serve HTML files for Piwik:

  • if you are using Apache as webserver, put AddHandler text/html .html in the <directory> section of the Apache host config. Restart the webserver.
  • if you are using Nginx, check out the Piwik-Nginx configuration. Note: make sure you replace the corresponding line in the piwik-nginx configuration with your own domain(s): valid_referers none blocked *; (if that is too much of a hassle for you then just comment out the valid_referers block.)
  • if you are using the module Pagespeed in your server, please note that (pagespeed extension does not work with Piwik). You may disable pagespeed for Piwik by adding this to the apache config: ModPagespeedDisallow "path_to_piwik_here"
  • if you still have issues serving HTML files, verify that your server does not redirect requests from index.php to index or from index.php to /. Such redirects may cause loss of POST variables causing issues.
  • if you still have issues serving HTML files, try to recursively change permission on the path/to/piwik/plugins folder (chmod -R 755 plugins/)

If you have other suggestions to add to this list, please use the form in this page.

Note: if you get the error message client denied by server configuration then you are experiencing this issue. You may follow the list of suggestions above to get it resolved.

The graphs (pie chart, bar chart, evolution graph) are not showing in my Piwik.

If you are not seeing Graphs in Piwik, the most likely reason is that you are using Piwik < 1.5 which are using Flash graphs, and you do not have Flash enabled in your browser.

As of Piwik 1.5, graphs in Piwik are drawn using open source technologies supported in all modern browsers: see Canvas and Jquery graphs blog post.

The sparklines (small graphs) are not showing in my Piwik.

The GD library is not installed on your server. This library is required to produce the sparklines. Please ask your system administrator or your web host to install php5-gd for you.

On linux, you can install php-gd by executing apt-get install php5-gd on debian type systems, then restart your webserver.

If you are using Apache webserver and a module called mod_security, please disable this mod_security module as it may sometimes cause Sparklines graphs to not display.

Piwik reporting UI doesn’t have any css style or, the menu text appears on a white background, or I get JavaScript errors in the Piwik UI. How to fix this display problem?

Firstly, when you experience this issue please check that any Adblocker extension in your web browser is disabled, as it may mistakenly block the Piwik Javascript or CSS files.

If after disabling all adblockers you still experience the issue, read on.

To improve performance, Piwik tries to automatically combine all CSS stylesheets and Javascript files into two large files, instead of having to download 20 individual files. However, on some webhosts, PHP scripts have a max execution time and if the server is overloaded, the script that merges all files together can take more than the time limit.

  • Ask your webhost to increase the max_execution_time in your php.ini file, for example to 30 seconds.
  • If you can’t change this setting, you can alternatively disable the feature to combine together CSS and JS files. To disable this feature, edit your config/config.ini.php and add the following:
    disable_merged_assets = 1

(if you are using Piwik 2.4.1 or earlier, set this setting under the [Debug] category)
Then, delete your browser cache and refresh Piwik: after a few seconds, it should display correctly again!

How do I configure Piwik on a server without Internet?

Piwik tracking, reporting, API doe not require access to the Internet, and will happily function without access to Internet.

However starting in Piwik 2.0, the new Marketplace feature calls the Marketplace API (hosted at and If there is no internet connection when Piwik tries to call the API, when you visit any page in the Admin of Piwik, you may experience the following error message: curl_exec: Connection timed out after 3000 milliseconds or curl_exec: couldn't connect to host or this error: Warning: file_get_contents ( failed to open stream: HTTP request failed!

To prevent this error, you may disable the “Marketplace” plugin in Admin > Plugins.

You can still download free plugins, as well as purchase premium plugins, directly on the Marketplace. After you download or purchase plugin(s) on the Marketplace, you can install them manually in your Piwik.

When tracking visits on an intranet website, Piwik assigns all page views to a few visitors who have very high page views count. How to fix it?

On Intranet websites, often most users have the same IP address, and often the same browser and configuration settings. This causes Piwik to believe that most page views come from the same visitor. To fix this on Intranet websites, see this FAQ: Enabling Piwik on Intranet websites.

The Piwik Javascript code shows a red cross (on IE) or a broken image icon instead of the 1*1 transparent Pixel, what is the issue?

When Piwik is showing a red cross image, or a broken image icon, it means that tracking visits is failing on your Piwik installation. It is not expected and should be investigated to fix the root of the problem as soon as possible (in the meantime, your visits are most likely not recorded).

To see where the error comes from, open your website in Firefox, right click on the broken image icon, and click on “View Image”. This should redirect you to the URL “…” and the error message should be showing.

If the error message mentions MySQL, the error might come from a broken mysql instance or tables. Try to “repair” your MySQL tables (using phpMyAdmin for example).
If the error mentions “failed to open stream: No such file or directory” this might be caused by missing Piwik files. Make sure all Piwik files are properly uploaded.
For other errors, try to search on the search engine on
You can also try the Piwik support forums for more help.

How do I configure Piwik when mod_security (or CA SiteMinder) is enabled?

Unfortunately, Piwik is not compatible with the Apache web server module mod_security nor with CA SiteMinder. If your web host uses mod_security to block requests containing URLs (eg. hosts like HostGator, The Planet), you should contact your provider to have your Piwik application whitelisted and have mod_security disabled for Piwik.

With mod_security (or CA SiteMinder) is enabled Piwik will look like it works but these security modules create major bugs in Piwik, including major data loss as requests are mistakenly discarded by the server! For more information, see this ticket on Piwik issue tracker.

Some of the error messages you may see in Apache error log when using mod_security include client denied by server configuration:. When the other tool CA Siteminder is enabled, you may get: Due to the presence of characters known to be used in Cross Site Scripting attacks, access is forbidden. This web site does not allow Urls which might include embedded HTML tags..

Almost all reports and dates are working fine except one or a small number of days/weeks/months/date ranges which display zero visit. How do I fix this issue and restore the missing data?

In rare cases, Piwik will show “no data” for a subset of data, for example for one day, one week or one month, while other periods will work fine and report all data as expected.

How to solve this problem?

Congratulations! you should have now restored the missing data and likely prevented this issue from occurring in the future.

The numbers from Transitions don’t match other numbers shown in Piwik. Why?

The Transitions Plugin gives you a report that shows the things your visitors did directly before and after viewing a certain page. There are few cases, where the data displayed in Transitions is slightly off compared to what you might expect.

The number of pageviews shown in the pages report doesn’t match the number of pageviews in the Transitions popover. There are several possible explanations:

  • Since the pages report is pre-archived, it shows the numbers of time the archiving was launched. Transitions doesn’t use the archives but retrieves the number directly from the logs. So if you have more pageviews in Transitions and you are viewing a period that includes today, this might be why the numbers don’t match.
  • The pages report sometimes aggregates multiple URLs into one row. For example when you track multiple domains, and will both end up in the row /home.html in the pages report. Transitions is based on unique URLs and will open on the URL with most pageviews that was aggregated into the row of the pages report. So if had more pageviews that, Transitions will open on the URL and show only statistics for this page.
  • Before version 1.9, Piwik recorded URLs with the hash part (e.g. but didn’t show the hash part in the pages report. When you have tracked pages with different hash parts, the previous bullet point applies and you will see Transitions for the unique URL that had most pageviews of all the URLs aggregated into the row of the pages report you clicked on.

Another case of odd numbers is when the sum of the groups on the left does not equal the total number of pageviews. If you think that this is the case, first make sure that you have included the page reloads in your calculation. If the numbers still don’t match, read on.

This can happen when there were downloads or outlinks tracked directly before views of the page in the center. We could have added a group on the left “From Downloads” and “From Outlinks” but we decided not to, as it would make the interface more complex unnecessarily. Since we didn’t want to add the missing pageviews to any of the other numbers, the sum of all groups that are shown might differ from the total number of pageviews.

The main limitation of Transitions is that it only works on the period of time you still have the logs for. If you have set up Piwik to delete old logs, the pages report will still contain data from before because the reports were archived. Since Transitions reads its data directly from the logs it can only work if you still have the logs.

Another reason for an apparent case of incomplete data, is connected to the truncation of reports. Piwik doesn’t necessarily report every unique URL on your website, but instead there is a limit for the maximum number of rows in the pages report (which can be changed). Usually that’s not a problem because the number is high and if you haven’t heard about it yet, it probably doesn’t apply to you. But if this happens on your data, there might the case that for some days of a period, the page is listed under Others but not for other days. The report for the period is the sum of the daily reports and therefore it can happen, that a URL is “missing” on some days and not on others. The sum of the pageviews will be too low in the actions report but Transitions reports the number of pageviews correctly. It can do so because it doesn’t use the archives but the logs.

We hope you enjoy the Transitions feature. We appreciate if you let us know what you think about it!

How do I check that my Piwik SSL Server is correctly configured?

If your website has HTTPS / SSL pages, to ensure that all your visitors actions will be tracked on all browsers, you need to check that your SSL Server is correctly configured. We recommend to take the SSL Server test, for the URL of your SSL Piwik server. In particular you should check that “Chain issues” is “None”, otherwise some browsers (for example on Mobile devices) will not connect to your Piwik SSL Server and you will lose some visitor tracking data.

How do I delete historical Piwik data? (purge old logs and/or old processed reports)

Piwik tracks visitors activity, and then computes aggregated reports. The settings page lets you

  • 1) Delete the Tracking Logs and / or….
  • 2) Delete the old processed stats reports

1) Delete old Tracking Logs

You can configure Piwik to automatically delete your older tracking logs from the database. Deleting old logs has many advantages: 1) it will free significant database space, 2) which will slightly increase performance, 3) for Privacy reasons, it is sometimes recommended to keep detailed logs only for 6 months or so, and remove older data.

To configure Log delete in Piwik, login as the Super User, click on Administration > Privacy > Delete old visitor logs from database. You can then configure to Delete logs older than N days, and execute the log purging every day, every week or every month. When ‘Delete old logs’ is enabled, only the raw logs of activity will be deleted from the database. Specifically, only the Mysql tables starting with piwik_log_* are affected.

Important: When you enable automatic log deletion, you must ensure that all previous daily reports have been processed, so that no data is lost. See this FAQ for more information.

Deleted data: All deleted data is lost forever.

Transitions report: The Transitions report is processed in real time, using the logs. When deleting old log data, the report will display transitions only for the days that still have log data.

Unique visitors metrics: The Unique visitors metrics for Weeks, Months, Years will be available only for those date ranges that still have log data.

If you have properly setup the auto archiving script (see important note), you will still access all historical reports (even when logs are deleted).

You can also delete old logs data by using a console command. Read this FAQ for more information: How do I delete old visitors statistics for a given website and/or date?

2) Delete old reports data

If your Mysql database space is limited, you can also Delete old reports in Piwik > Administration > Privacy. You can choose to keep daily, weekly, monthly and / or yearly data. We recommend keeping monthly and yearly data as an interesting dataset.
If you enable any of the 2 features to delete old data, the Database estimate size will refresh and give you an idea how much space you would save using the feature. If you cannot wait for the next automatic tasks schedule, you can also force the purge by clicking on ‘Purge Now’.

I would like to import an existing Users database (login, password, emails) in Piwik, but the usernames and passwords are more permissive than what Piwik allows. How do I disable the checks on the Logins & Passwords?

When you automatically import your existing userbase in Piwik using the UsersManager API, you might want to disable the check of minimum length and valid characters for the User’s login and password.
In particular, Piwik requires a password at least 6 characters long, and a login string that must contain only valid characters (ie. letters, @, etc.).
You can disable these checks by adding in the file config/config.ini.php the following:

disable_checks_usernames_attributes = 1

Piwik doesn’t show me when new updates are available, and the SEO plugin doesn’t work.

Your firewall may be blocking outbound HTTP requests. If you have a HTTP proxy (e.g., squid), you can configure the forward proxy as follows.
Edit your config/config.ini.php and add the following:

host =      ; Proxy host: the host name of your proxy server (mandatory)
port =      ; Proxy port: the port that the proxy server listens to. There is no standard default, but 80, 1080, 3128, and 8080 are popular
username =      ; Proxy username: optional; if specified, password is mandatory
password =      ; Proxy password: optional; if specified, username is mandatory

Once configured, Piwik will contact external hostnames using this proxy server.

“Segmentation fault Error”. Piwik reporting or via cron crashes with Segmentation Fault error. What to do?

Unfortunately, Segmentation fault Piwik errors mean that the lower level software has crashed in some unexpected fashion. In this case, most likely PHP or some of its specific modules (PDO, mysqli, etc.). It is possible to overcome this issue by updating these softwares.
If you get the Segmentation fault error, the solution is to:

  • Upgrade Piwik and make sure to use the latest version
  • upgrade PHP to the latest version
  • upgrade PDO (and/or mysqli) to the latest version.
  • you may also try to switch from PDO_MYSQL to MYSQLI in the config/config.ini.php ; edit the line “adapter = […]”
  • if you still get the error, try disabling extensions such as eAccelerator, xcache and/or Suhosin, if you are using one of them.
  • if you still get the segmentation fault error at this point, try the suggestion in this issue (if it works for you, please post a comment in this issue).

You should now have a working Piwik instance that does not crash, congratulations.

I get the error message: “Fatal error: require_once() [function.require]: Failed opening required XYZ in /path/piwik/XYZ.php on line X”. How can I get Piwik to work?

This error message means that PHP couldn’t include a file that Piwik requires. Please make sure all Piwik files are correctly uploaded on your server. You can reupload the missing files by looking at the error message, or reupload all Piwik files and try again: this should work!

How do I fix the error “Parse error: syntax error, unexpected T_STRING in …”

If you get this error, this means that the PHP running on your webserver is too old. Please ask your webhost or sysadmin to upgrade your PHP to the latest PHP version: see Piwik requirements for further details.

If you have trouble running Piwik, consider using one of our Official Piwik Hosting solutions.

How do I solve issue ‘An error occurred: Cannot connect to the database’?

When Piwik displays an error message An error occurred: Cannot connect to the database this means that Piwik was not able to connect to your Mysql database.

To solve this problem you can:

  • Contact your system administrators and ask them to verify that the Mysql server is up and running
  • If your Mysql server is up and running, maybe the username or password used to connect has changed? To update the Mysql connection information, edit your configuration file config/config.ini.php to view and edit your connection details.

What should I do when I get the error message: SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (11)

This means that Piwik could not connect to your MySQL database. If you are on a dedicated server, you can try to restart the Mysql server by running, for example,

/etc/init.d/mysql restart

. If you are on a shared web hosting, we recommend contacting your web host and ask them to investigate why it fails to connect to the Mysql server.

I get the error “Warning: gzuncompress() [function.gzuncompress]: data error” when looking at my Piwik reports.

This error happens in very rare cases where, for some unknown reasons, the data was not properly recorded in the database. In Piwik, all reports data is compressed (gzip) and then stored in the tables piwik_archive_*.

To fix this issue, look at the error message and search for “piwik_archive_blob”. For example, if the error looks like:

#0 Piwik_ErrorHandler(2, gzuncompress() [function.gzuncompress]: data error, /path/piwik/core/Archive/Single.php, 250, Array ([name] => Referers_searchEngineByKeyword,[typeValue] => blob,[table] => piwik_archive_blob_2009_05,[...]

You can find “piwik_archive_blob_2009_05”. Please delete this table in your Piwik database. Piwik will process it again next time you are viewing reports. This will fix the issue.

Emails sent from Piwik use the email address, how do I specify my domain name instead?

By default Piwik will try to detect the current Hostname and use it in all emails sent. In some cases, the hostname cannot be detected and Piwik will use “”. You can specify your domain name to appear in From: email addresses by adding the following lines in your config/config.ini.php file:

defaultHostnameIfEmpty =

This will affect all emails sent from Piwik: Password reminder, Email reports. You can also change the default email address “From:” in PDF reports emails.

Piwik reports this error and fails: “Fatal error: Allowed memory size of X bytes exhausted (tried to allocate X bytes)”. What should I do?

You must increase PHP memory limit. See this page for more info.

Piwik reports this error and doesn’t continue: “Fatal error: Maximum execution time of 30 seconds exceeded in …”

Your PHP is configured to stop running a script after some time, generally 30 seconds. When Piwik is used on a websites with few thousands visits per day, then this limit might not be high enough. To fix this, modify in your php.ini the max_execution_time value to zero (which means no time limit):

max_execution_time = 0

This will ensure that Piwik always has enough time to process your analytics reports.

How do I fix the error “Mysql Server has gone away”?

The MySQL server has gone away (error 2006) has two main causes and solutions:

  • Server timed out and closed the connection. To fix, check that wait_timeout mysql variable in your my.cnf configuration file is large enough.
  • Server dropped an incorrect or too large packet. If mysqld gets a packet that is too large or incorrect, it assumes that something has gone wrong with the client and closes the connection. To fix, you can increase the maximal packet size limit max_allowed_packet in my.cnf file, eg. set max_allowed_packet = 128M, then restart your MySQL server: sudo /etc/init.d/mysql restart

How do I fix the error Warning – Error while sending QUERY packet?

The MySQL server error “Warning – Error while sending QUERY packet” has two main causes and solutions. Please check this FAQ for the solution.

Graphs in PDF/HTML reports and/or Piwik Mobile do not display characters correctly in my language (display squares instead).

To display unicode characters in the Static image graphs, please see this FAQ.

When I use force_ssl=1, I get “Too many redirects”. Also when I use https, CSV/PDF reports and graphs don’t work.

If you’re not using a reverse proxy, but using https with a web server that doesn’t set the HTTPS environment variable, you can either set assume_secure_protocol=1 or reconfigure your web server.
For example, lighttpd should be configured with setenv.add-environment = ( "HTTPS" => "on" ). Similarly, nginx users should use something like fastcgi_param HTTPS on;.

I get the error Warning: Unexpected character in input: ‘\’ (ASCII=92) state=1

When you get an error message similar to Warning: Unexpected character in input: '\' (ASCII=92) state=1 this means that your PHP version is not high enough. See this FAQ for more information.

Why am I getting a warning about an untrusted hostname?

Most of the time this warning is displayed, just after you have just migrated Piwik to a new URL or server, and the new hostname you use will not be the same as the stored one. In this case, ask your Piwik Administrator to update the Piwik Hostname in Settings > General Settings.

(for geeks only) How does this message improve security?

This warning is a security feature Piwik provides to make Piwik more robust and prevent the so-called “Host Injection” vulnerability. Attackers could try to send fake hostnames to Piwik in an attempt to get users to reset their password through an attacker’s server. If users do that, the attacker could gain access to Piwik. Piwik protects against this type of attack by storing a list of trusted hostnames and checking if the ‘Host’ HTTP header in any request is in this list. If it doesn’t match, we show you a warning.

You can also disable the trusted host security check if for some reason you get this warning a lot, for example if you use Piwik with a changing set of hostnames. To do so,edit your config/config.ini.php and add the following below [General]


This feature was developed as a “Security Best Practise”, following a suggestion by a security researcher working with Piwik through our Security Research program.

When included in an IFrame, Piwik reports do not load. How do I allow Piwik reports to load from within an iframe?

By default, for security reasons, Piwik prevents standard pages and reports to be included in an iframe.
If you wish to include widgets in your website or app, we recommend you use the standard “Widgets” mechanism.
If you wish to include the whole Piwik in an iframe, edit your config/config.ini.php under the category [General] add the following line:


If you also wish to enable the “Settings” pages (Manage websites, Users, etc.) to load in an iframe you can also add the setting:


See also: How do I enable users to login into Piwik inside an iframe?

I get the error: Table piwik_log_x is marked as crashed and last (automatic?) repair failed.

When you get the error Table piwik_log_visit is marked as crashed and last (automatic?) repair failed. it means that the Mysql tables got partially corrupt and must be repaired. This problem may occur for various reasons (such as missing space on the disk) but it should occur very rarely.

It is possible to solve this problem by connecting to your Mysql server and executing the following queries:

REPAIR TABLE piwik_log_visit;

(replace piwik_log_visit with the name of your crashed table as it appears in the error message)

This may not work, in which case use the following solution:

cd /var/lib/mysql/your_piwik_database
myisamchk -r -v -f ./your_table_repair

Your tables should now be repaired and Piwik up and running!

How do I reset the visualisations settings stored for a specific user, or for all users?

When you use Piwik and view the information displayed in any report, there are options you can use to configure how the data is displayed. For example you may change: the number of rows displayed in the report, the column being sorted, the visualisation being used (table, graph, treemap, etc.), etc. When a user changes one of these settings in any report, these settings are saved by Piwik so that the next time the user views this report, the report will be displayed as it was last configured by the user.

In some rare cases, you may want to reset these stored settings so that all of Piwik reports will be displayed with the default settings.

To reset the report settings for a particular user my-username run the following SQL query:

DELETE FROM piwik_option WHERE option_name LIKE "viewDataTableParameters_my-username%";

To reset the report settings for all users at once, run the following SQL query:

DELETE FROM piwik_option WHERE option_name LIKE "viewDataTableParameters_%";

How do I correctly track my very long Page URLs and Page Titles without truncating any characters?

By default, Piwik will truncate Page URLs and Page Titles after 1024 characters (1 Kb). If you are tracking Page Titles or Page URLs that are longer than 1024 characters, Piwik will truncate (cut off) the extra characters. To make sure that Piwik correctly tracks even your long Page Urls and Page titles, edit your config/config.ini.php and add the following:

page_maximum_length = 2048

After making the change, Piwik will track up to 2048 characters in your Page URLs and Page Titles. You may adjust the value appropriately for your use case.

I’m a developer, how do I enable logging (and / or SQL profiling) in Piwik?

There are a few possibilities with regards to debug logging in Piwik.

  • Enable logging in the Tracker can be useful to debug Tracking issues or improvements. See the documentation page about enabling Debug logging in the piwik.php tracker
  • Enable logging in the Piwik UI: by default, Piwik logs messages in the UI (using notification boxes). If you want additional logging details, or if you want to enable logging to a file you can edit your config.ini.php and set the following options:

    ; Possible values are "screen" (default value), "file" and "database" (logs to tables logger_*)
    log_writers[] = file
    ; Possible values are ERROR, WARN, INFO, DEBUG
    log_level = WARN
    ; if configured to log to file, log entries will be written to this file
    logger_file_path = tmp/logs/piwik.log

All logging configuration options can be found in config/global.ini.php

Important notes:

  • The Monolog Plugin must be activated in your Piwik server, you can check it by going to Administration > Plugins.
  • Once you have enabled logging, you can easily view & search the logs by using our LogViewer plugin: learn more in How do I view Piwik application logs?
  • You may also enable SQL logging & profiling to see the list of SQL queries executed by Piwik on any given page or widget. First, enable logging on screen (see point above). Then, edit your config.ini.php and add the following:

    enable_sql_profiler = 1

Piwik will then output all SQL queries, group them by unique query, and show the total time spent as well as average time spent on each query.

I get the error message: “Fatal error: Class ‘not found in …”. What’s wrong?

This issue is generally caused by missing files in your piwik directory. To fix this issue, please reupload all files from the latest Piwik version to your server.

If after re-uploading all the files from the latest version you still experience this issue, try to restart the web server.

If you still have the issue after doing those two steps, it may be a bug in Piwik. Please create a bug report.

How do I fix the error ‘Unable to find the wrapper “https” – did you forget to enable it when you configured PHP?’

To solve this error, you need to install the OpenSSL package for PHP on your webserver.

On a FreeBSD server, you may need to install the following package: php53_openssl and restart your webserver.

On a Windows server, open your php.ini config file and simply uncomment the following line:


and restart the webserver. The error should be resolved.

How do I disable the OPTIMIZE queries which take too long on my server?

When Piwik is setup to delete old logs, after the log deletion, we will run OPTIMIZE queries to claim the lost Mysql space on the database tables. These queries can be very slow to run and can cause problems on extremely large Piwik servers. If you see SQL queries and the server load going up out of control, with queries queueing because of an OPTIMIZE TABLE query, we recommend to disable all OPTIMIZE TABLE queries. To do so, edit config/config.ini.php and add:


Note: Piwik will never OPTIMIZE table which are Innodb, we will only OPTIMIZE tables of the Myisam type.

How do I get LOAD DATA INFILE to work on my server?

Piwik processes huge amount of data and then stores this data in the database. For improved performance, Piwik tries to import a lot of data in the database at once using a Mysql feature called “LOAD DATA INFILE”. You can check whether your server supports this performance improvement in Administration > System Check menu. The system checks two commands: LOAD DATA INFILE and LOAD DATA LOCAL INFILE. It’s enough if either one of these work.

If you are not seeing a green tick under “Database abilities”, try the following troubleshooting steps:

  • Check that the sql user that Piwik is using has the permission to import the files: GRANT FILE on *.* to piwik@localhost
  • Check the “mysqld” process can access the file created in the tmp/assets directory in the piwik-installation:
    • give the process mysqld executable-access (+x) to files in path/to/piwik/tmp/assets/* and all parent folders.
    • check that the request isn’t blocked by apparmor or any other security-software when accessing this folder. If you are using Ubuntu, you may have to disable apparmor which prevents mysql from accessing files in path/to/piwik/tmp/*
      Edit the file /etc/apparmor.d/usr.sbin.mysqld and add the following path in the file: /path/to/piwik/tmp/assets/* rw,
      Then restart apparmor with sudo /etc/init.d/apparmor restart
    • in your Mysql configuration (my.cnf) set the following options: [mysqld] local-infile and [mysql] local-infile

Then restart Mysql.

If the LOAD DATA INFILE is still not working, try the following:

  • update to the latest PHP version, or use the mysqli client (there are some known bugs with older PDO clients for mysql)
  • and/or switch the client to adapter=MYSQLI in the config/config.ini.php
  • and/or disable in your php configuration php.ini the options open_basedir and safe_mode. Restart webserver.
  • on Ubuntu / Debian servers, you may try to uninstall php5-mysql package and install instead php5-mysqlnd: sudo apt-get install php5-mysqlnd

If you still cannot make LOAD DATA INFILE work, you can disable this feature completely. This is not recommended for medium to high traffic Piwik where this feature should be enabled. To disable LOAD DATA INFILE add to your config.ini.php file under [General] section: enable_load_data_infile=0

How do I make sure Search engines robots do not index Piwik server?

To make sure search engines will not crawl any request to your Piwik, create a file robots.txt at the root of your Piwik server with the following content:

User-agent: *
Disallow: /

How do I fix the error ‘Fatal error: Maximum function nesting level of ‘100’ reached, aborting!’?

If you get the following error: Fatal error: Maximum function nesting level of '100' reached, aborting! in core:archive console output or in the Piwik UI, you can solve this problem by editing the Xdebug PHP extension settings in php.ini or xdebug.ini and add the following: xdebug.max_nesting_level=500. After making the change, restart your web server.

I get: PHP Fatal error Call to undefined function imagecreatefrompng()

If you get the error PHP Fatal error: Call to undefined function Piwik\\Plugins\\CoreAdminHome\\imagecreatefrompng() it means that you need to install the GD extension for PHP. The GD extension is required for Piwik to generate report graphs, generate sparklines graphs, as well as to upload a custom logo. To check whether the GD extension is installed on your server, go to Piwik > Administration > System Check.

How do I report a bug in Piwik?

If you think you have found a bug, please read our guide on how to submit a bug report.

We appreciate if you take the time to report bugs that you experience with Piwik. With your help, we will build the most reliable analytics platform!

Learn more about our Quality Assurance efforts.

Any questions?

Many answers and more information about Piwik You can find here:

We are social

Follow us: