** Dump SQL at login page only **

[0] Fix | Delete

[1] Fix | Delete

1) Use MYSQLI

[2] Fix | Delete

2) Delete tables ending with 'archive_blob_2010_03', 'archive_numeric_2010_03' (If any)

[3] Fix | Delete

3) Add this in SQL

[4] Fix | Delete

INSERT INTO `[[dbprefix]]user_language` VALUES('[[admin_username]]', '[[language]]', 0); {add 0 for "use_12_hour_clock" that's the default value} from 2.16.0 in last Language table

[5] Fix | Delete

4) Choose Timezone America/New york

[6] Fix | Delete

5) Choose Not an Ecommerce site

[7] Fix | Delete

6) We have added a CRON Job for the script because it requires if there is huge data for the site.

[8] Fix | Delete

7) Make script where Database ENGINE is InnoDB

[9] Fix | Delete

8) make changes in upgrade.php if script ask for writable permission for config file.

[10] Fix | Delete

9) In version 3.0.1 we have added files to be deleted in the pre_unzip() function, because of file integrity check warnings while upgrade. Please check in the next version.

[11] Fix | Delete

10) PHP REQUIREMENT LINK : https://piwik.org/docs/requirements/#required-configuration-to-run-piwik

[12] Fix | Delete

11) Delete the files or folders(if any) from original zip which fails integrity check during manual installation.

[13] Fix | Delete

12) Keep 'useridsalt' value blank in `[[dbprefix]]option` table. It will genreate on visiting setting tab post loging in.

[14] Fix | Delete

13) Remove 'SET time_zone = "+00:00";' line from SQL. This is to solve login issue on windows. ( piwik unable to login if registered date is greater than the date when user login )

[15] Fix | Delete

14) Check and Move robots.txt and favicon.ico from manual to zip (Since 3.9.0) We handle this in install.php

[16] Fix | Delete

15) Keep "anonymous default token" value same in "user_token_auth" table because this is random value for anonymous user.

[17] Fix | Delete

16) Important: Give permissions to 'lang' folder on Non-SUPHP server while manual installation, as .htaccess is created inside it, else System check throws error that, We found that the above URLs are accessible via the browser, but we recommend they should not be. If possible, please restrict access to them.

[18] Fix | Delete