Alanaktion / phproject

A high performance full-featured project management system
https://www.phproject.org
GNU General Public License v3.0
388 stars 106 forks source link

Not working with MySQL server 8.0 #328

Closed sergyu91ma closed 6 years ago

sergyu91ma commented 7 years ago

Please update queries from project to work with MySQL server 8.0.

Alanaktion commented 7 years ago

Since MySQL 8.0 does not have a general availability release yet, I'm not considering this a bug yet, but I'll look into it.

sergyu91ma commented 7 years ago

The most common error is the word --role-- which is a reserved keyword in MySQL 8.0 and needs to be replaced with `role` in queries. I did this locally on my server.