SQL error while trying to newly install flarum on xampp

EvilExecutor

Hey Flarum!

Today I needed to install Flarum on my Local host. After doing the normal procedure (of installing flarum) it unexpectedly said that Flarum has an Update (Once the installation and configs completed) to provide the database password.

I provided the Xampp databse default password which is blank and hit update. But it throwed me this error Something went wrong: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'title' (SQL: ALTER TABLE fl_discussions ADD FULLTEXT title (title))

I'm using xampp 7.2.34 version and my databse configuration are as below
Server: 127.0.0.1 via TCP/IP Server type: MariaDB Server connection: SSL is not being used Documentation Server version: 10.4.14-MariaDB - mariadb.org binary distribution Protocol version: 10 User: root@localhost Server charset: UTF-8 Unicode (utf8mb4)

I tried re-installing flarum too but I'm stuck in the same place. Idk why or how there could be a update just after newly installing Flarum in both those instances.

Each and every effort to help me fix this is really appreciated.

Thanks.
EE.

clarkwinkelmann

EvilExecutor it would appear that Flarum failed to complete the installation the first time, assumed the missing database tables were due to an upgrade being available, and offering you the update screen. The problem is that some of the migrations were probably half-applied and running them again led to this error.

You should check whether any error happens right at the end of the first installation. Maybe the PHP execution time or memory is too limited for the script to finish the installation properly.

To try again with the same database, you'll need to manually delete all tables from the database with a tool like phpMyAdmin.

EvilExecutor

EDIT: The problem was in the max_execution_time. It was set to 2 minutes. Increasing that value upto 10 minutes and the pushing the memory limit upto 1024MB fixed the problem. Thanks @clarkwinkelmann