thanks for report. Im confused and don't know why this query does not work for you:

ALTER IGNORE TABLE piwik_log_visit ADD `location_provider` VARCHAR( 100 ) NULL

maybe something changed in MySQL 5.7.5... anyone else experiencing this issue?

Issue found. See the removed features here: https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html

The IGNORE clause for ALTER TABLE has been removed as of MySQL 5.7.

Consequently, piwik as it is today cannot be installed on MySQL 5.7+. A grep on the codebase yielded the IGNORE clause only in the Updates directory and the Provider plugin. Maybe there's a quick fix?

@tsteur can we maybe remove IGNORE or work around this, for Mysql 5.7 compat?

I think we can sometimes remove them and sometimes we have to workaround it like this: http://www.tocker.ca/2013/11/06/the-future-of-alter-ignore-table-syntax.html

alter ignore seems to be used quite a few times and I don't know why they are sometimes used and whether there could be actually duplicates

Thanks for looking into it team. I would be satisfied with closing the issue if you want to create a new issue specifically to address MySQL 5.7 support. My needs are met just by rolling back to an older version of MySQL.

@ToBeReplaced feel free to create a new issue for Mysql 5.7 support, cheers

I'm reopening this one as it makes it easier to work on MySQL 5.7 support