Database Problem with installing flarum on xampp

KuneneSandziso

Hi, I'm having problems installimg flarum in localhost. It says enter database password, when I do the following error shows:
Something went wrong: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'title' (SQL: ALTER TABLE trxdiscussions ADD FULLTEXT title (title))

askvortsov

KuneneSandziso Is this a fresh install? If so, looks like a migration got partially applied. Try deleting/recreating the database, deleting config.php, and installing again via the CLI (php flarum install)

KuneneSandziso

askvortsov I did but it still gives the same error. I've tried re-installing flarum and creating new databases but each time I go to the GUI install on my browser, there's always somekind of sql error.

askvortsov

KuneneSandziso what version of mysql are you using? Also, have you tried installing via the CLI instead of the GUI?

KuneneSandziso

Yes I've tried using CLI [composer install]
here's the version as they appeared in phpmyadmin
Apache/2.4.46 (Win64) OpenSSL/1.1.1j PHP/8.0.3
Database client version: libmysql - mysqlnd 8.0.3

askvortsov

KuneneSandziso what's the DB server version?

KuneneSandziso

askvortsov 10.4.18 MariaDB