Got error when creating a project in Docker

[wyujie]

Creating user works, but creating a project encounters the following SQL error:

2017/04/17 10:23:28 [Recovery] panic recovered:
POST /api/projects HTTP/1.1
Host: localhost:9000
Accept: application/json, text/plain, */*
Accept-Encoding: gzip, deflate, br
Accept-Language: en-US,en;q=0.8,zh-CN;q=0.6,zh;q=0.4,zh-TW;q=0.2
Cache-Control: no-cache
Connection: keep-alive
Content-Length: 12
Content-Type: application/json;charset=UTF-8
Cookie: JSESSIONID.ebf2b5d6=18m0zky36rdgiihix72ry7zju; screenResolution=1920x1080; session=.eJxNzEELgjAUAOC_Eu_caeJF8GAsxeC9YczkeREqi21ZUMHaxP9ex74f8M0wmDNkM6yOkAHGJmAsJ9RtRMmeRRuVrAMJTEnsDNvNjQULtC6
HZQ2n1_MyvB9uvP8Ve4f2mrCuBVZ1QrI0HA-GZPHpu94o7byqaOptE6jDFPXWU5H_uuULS1otKQ.C9B91Q.kQiRBMaDVHay_XFCEvVO-EhqYpo; semaphore=MTQ5MjQyNDUwNnxQOG94b1FfZnl0bXlVSDdFWHYyU3VrQkliMy12Y1ZsMFcwZDFsaVd6U25hTkhXM
mJCcU9yTkNHRkxXRTBIXzVhbWZPUVpIMV91S3RrbVRULV83TUh1WXM9fKeVuHWw2PbXdSyqzO8JiEjKprxx56RdzPwaGiMGDIpb
Origin: http://localhost:9000
Referer: http://localhost:9000/
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36


Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'admin=1' at line 1
/usr/local/Cellar/go/1.8/libexec/src/runtime/panic.go:489 (0x42875f)
/Users/m/p/go/src/github.com/bugsnag/bugsnag-go/bugsnag.go:52 (0x6d3e23)
/usr/local/Cellar/go/1.8/libexec/src/runtime/asm_amd64.s:514 (0x452b68)
/usr/local/Cellar/go/1.8/libexec/src/runtime/panic.go:489 (0x42875f)
/Users/m/p/go/src/github.com/ansible-semaphore/semaphore/api/projects/projects.go:42 (0x8dc95d)
/Users/m/p/go/src/github.com/gin-gonic/gin/context.go:97 (0x7a56fa)
/Users/m/p/go/src/github.com/gin-gonic/gin/logger.go:72 (0x7b3d6f)
/Users/m/p/go/src/github.com/gin-gonic/gin/context.go:97 (0x7a56fa)
/Users/m/p/go/src/github.com/ansible-semaphore/semaphore/cli/main.go:72 (0x914232)
/Users/m/p/go/src/github.com/gin-gonic/gin/context.go:97 (0x7a56fa)
/Users/m/p/go/src/github.com/gin-gonic/gin/recovery.go:45 (0x7b4a9a)
/Users/m/p/go/src/github.com/gin-gonic/gin/context.go:97 (0x7a56fa)
/Users/m/p/go/src/github.com/gin-gonic/gin/gin.go:284 (0x7ab890)
/Users/m/p/go/src/github.com/gin-gonic/gin/gin.go:265 (0x7ab1ab)
/usr/local/Cellar/go/1.8/libexec/src/net/http/server.go:2568 (0x6a2732)
/usr/local/Cellar/go/1.8/libexec/src/net/http/server.go:1825 (0x69e9a2)
/usr/local/Cellar/go/1.8/libexec/src/runtime/asm_amd64.s:2197 (0x455291)

2017/04/17 10:23:28 notifying bugsnag: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'admin=1' at l
ine 1
2017/04/17 10:23:28 bugsnag.Notify: not notifying in development

[matejkramny]

What's your MySQL and Semaphore version?

[wyujie]

Hi, @matejkramny,

Semaphore: 2.2.0
MySQL: 8.0

Thx.

[matejkramny]

Looks like an issue with mysql 8

[matejkramny]

looks like admin is a reserved key word in mysql 8