installation mysql error

hanakin

when trying to install i get the following error msg during on setup

"Something went wrong: SQLSTATE[42000]: Syntax error or access violation: 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 '-posts ADD FULLTEXT content (content)' at line 1 (SQL: ALTER TABLE flarum-posts ADD FULLTEXT content (content))"

luceos

hanakin what database software and version do you use, can you also provide the php version and your OS? That would help pinpoint the origin of your troubles more easily.

ChristopherKhawand

hanakin
Maybe content is a MYSQL reserved name
Flarum should fix it by making it content
With one back 'before it and One back ' after it
Sorry but flarum is rendering this `

hanakin

i am not installing it on a webhost. I am installing it locally

hanakin

i am using a standard mamp pro setup on my mac so all the out of the box config for it.

apache
php: 7.1.6
mysql: 5.6.35
phpmyadmin: 4.7.3

luceos

It's the first time I see this on a fresh install. This is worth reporting to github.

hanakin

ok but how do i fix it on my end?

Ralkage

I am going to try to replicate this on my end since I like to test locally 9/10th's of the time.