SQLSTATE[42S21]: Column already exists

[Michael K]

I am trying to install Mumara Campaigns on Debian 12.9. PHP version is 8.3. MySQL version is mysql-community-server 8.4.4. All installation requirements are listed ok but after the install it gives us error. SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'user_id' (Connection: mysql, SQL: alter table broadcast_links add user_id bigint unsigned not null after id)

 

[far00q]

I am trying to install Mumara Campaigns on Debian 12.9. PHP version is 8.3. MySQL version is mysql-community-server 8.4.4. All installation requirements are listed ok but after the install it gives us error. SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'user_id' (Connection: mysql, SQL: alter table broadcast_links add user_id bigint unsigned not null after id)

It seems that the Database has already been created in first installation attempt which is causing conflict. Please check your database. And I suggested deleting all tables in the database and then install Mumara again.