{"action":"closed","issue":{"url":"https://api.github.com/repos/piwik/piwik/issues/8824","labels_url":"https://api.github.com/repos/piwik/piwik/issues/8824/labels{/name}","comments_url":"https://api.github.com/repos/piwik/piwik/issues/8824/comments","events_url":"https://api.github.com/repos/piwik/piwik/issues/8824/events","html_url":"https://github.com/piwik/piwik/issues/8824","id":107367656,"number":8824,"title":"installation issue on empty database: Unknown table engine 'InnoDB'","user":{"login":"Joey3000","id":3662335,"avatar_url":"https://avatars.githubusercontent.com/u/3662335?v=3","gravatar_id":"","url":"https://api.github.com/users/Joey3000","html_url":"https://github.com/Joey3000","followers_url":"https://api.github.com/users/Joey3000/followers","following_url":"https://api.github.com/users/Joey3000/following{/other_user}","gists_url":"https://api.github.com/users/Joey3000/gists{/gist_id}","starred_url":"https://api.github.com/users/Joey3000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Joey3000/subscriptions","organizations_url":"https://api.github.com/users/Joey3000/orgs","repos_url":"https://api.github.com/users/Joey3000/repos","events_url":"https://api.github.com/users/Joey3000/events{/privacy}","received_events_url":"https://api.github.com/users/Joey3000/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/piwik/piwik/labels/Bug","name":"Bug","color":"fc2929"},{"url":"https://api.github.com/repos/piwik/piwik/labels/not-in-changelog","name":"not-in-changelog","color":"ffffff"},{"url":"https://api.github.com/repos/piwik/piwik/labels/Regression","name":"Regression","color":"fbca04"}],"state":"closed","locked":false,"assignee":{"login":"tsteur","id":273120,"avatar_url":"https://avatars.githubusercontent.com/u/273120?v=3","gravatar_id":"","url":"https://api.github.com/users/tsteur","html_url":"https://github.com/tsteur","followers_url":"https://api.github.com/users/tsteur/followers","following_url":"https://api.github.com/users/tsteur/following{/other_user}","gists_url":"https://api.github.com/users/tsteur/gists{/gist_id}","starred_url":"https://api.github.com/users/tsteur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tsteur/subscriptions","organizations_url":"https://api.github.com/users/tsteur/orgs","repos_url":"https://api.github.com/users/tsteur/repos","events_url":"https://api.github.com/users/tsteur/events{/privacy}","received_events_url":"https://api.github.com/users/tsteur/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/piwik/piwik/milestones/84","html_url":"https://github.com/piwik/piwik/milestones/2.15.0","labels_url":"https://api.github.com/repos/piwik/piwik/milestones/84/labels","id":1202482,"number":84,"title":"2.15.0","description":"","creator":{"login":"mattab","id":466765,"avatar_url":"https://avatars.githubusercontent.com/u/466765?v=3","gravatar_id":"","url":"https://api.github.com/users/mattab","html_url":"https://github.com/mattab","followers_url":"https://api.github.com/users/mattab/followers","following_url":"https://api.github.com/users/mattab/following{/other_user}","gists_url":"https://api.github.com/users/mattab/gists{/gist_id}","starred_url":"https://api.github.com/users/mattab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattab/subscriptions","organizations_url":"https://api.github.com/users/mattab/orgs","repos_url":"https://api.github.com/users/mattab/repos","events_url":"https://api.github.com/users/mattab/events{/privacy}","received_events_url":"https://api.github.com/users/mattab/received_events","type":"User","site_admin":false},"open_issues":32,"closed_issues":246,"state":"open","created_at":"2015-07-10T13:26:16Z","updated_at":"2015-10-01T20:44:01Z","due_on":"2015-10-14T11:00:00Z","closed_at":null},"comments":17,"created_at":"2015-09-20T02:42:40Z","updated_at":"2015-10-01T20:44:01Z","closed_at":"2015-10-01T20:44:01Z","body":"I get the following error on installation of piwik-2.15.0-b8 (from builds.piwik.org) after the database configuration page, **if the database is empty before installation**:\r\n`SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB'`\r\n\r\nIf, on the other hand, the installation is done with a database previously used by piwik-2.14.3, it succeeds without problems. piwik-2.14.3 installs without problems with an empty DB.\r\n\r\nThat is all on a remote server with PHP 5.5.22, MySQL 5.1.73 with PDO\\MYSQL.\r\n\r\nNotes:\r\n- I install over FTP, first deleting all files of a previous installation.\r\n- Installation is done into subdirectory /p.\r\n- As with any other Piwik version before, I patch Piwik by prepending \"@\" to ini_set() in all cases where it is missing. (Simply by searching for \"ini_set\" if all files.) I.e. with piwik-2.15.0-b8:\r\n\r\n```\r\nFile size mismatch: /[...]/p/core/testMinimumPhpVersion.php (expected length: 9295, found: 9299)\r\nFile size mismatch: /[...]/p/libs/Zend/Session.php (expected length: 27322, found: 27324)\r\nFile size mismatch: /[...]/p/libs/Zend/Validate/Hostname.php (expected length: 36092, found: 36094)\r\nFile size mismatch: /[...]/p/libs/Zend/Validate/StringLength.php (expected length: 7008, found: 7010)\r\n```\r\n\r\nWhereby in the above /core/testMinimumPhpVersion.php, the ini_set presence check block gets commented out entirely.\r\n\r\nThe reason for the patch is that \"ini_set\" is disabled for security reasons - it's a shared host. But that doesn't seem to have any impact here."}}