Duplicate key name 'action_logs_action_date_index'

[ansgarit-tech]

Hello. Several parts of SnipeIT is not available anymore. Searching for or clicking on assets generate 500 Server error. User list is empty. Checking in and out still works though.

SnipeIT log says the following:
INFO Running migrations.
2025_03_06_152922_copy_created_at_to_action_date_in_action_logs 10.74ms FAIL
Illuminate\Database\QueryException
SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'action_logs_action_date_index' (Connection: mysql, SQL: alter table action_logs add index action_logs_action_date_index(action_date))

How can i fix this? Thank you.

[ansgarit-tech]

I realise I haven't given much info. I'm not sure what info I need to give though. I noticed the error last week but didn't have time to look into it until now. I'm running SnipeIT on docker with mariadb with automatic upgrades on both. Current version is v8.2.2-pre build 19319 (ga36afbcb2).

I saw a similar issue (to me anyway) here https://snipe-it.readme.io/docs/database-issues , "Column already exists: 1060 Duplicate column name" but need some guidance before I attempt that solution.

Snipe-IT Documentation

Database Errors

Most database issues are database-version related, or migrations related. Running migrations is always necessary to make sure your schema is up to date with the database schema the code is expecting. Unknown column 'generation_expression' in 'field list' If you run into the error Column not found: 1…

[snipe]

You'd want something like INSERT INTO migrations (migration, batch) VALUES('2025_03_06_152922_copy_created_at_to_action_date_in_action_logs', 10);

then run migrations again.

[ansgarit-tech]

Thank you. Am I to run this in the MariaDB docker command line? I did that (copy paste as one line) and got:
syntax error near unexpected token `('

[ansgarit-tech]

For anyone following a guide on youtube on how to set up SnipeIT on docker and have no idea how to interact with a database from the command line- you have to use the mysql tool to run the command.

Log in to your MariaDB-server:
mysql -u [username] -p

Choose your database:
USE [database name];

Run your SQL-command, in my case:
INSERT INTO migrations (migration, batch) VALUES('2025_03_06_152922_copy_created_at_to_action_date_in_action_logs', 10);

[snipe]

Did that resolve your issue?

[ansgarit-tech]

Yes! I ran php artisan migrate after that in SnipeIT docker command line with no errors and as far as I can see all is good now.

[snipe]

Excellent - glad you're sorted :)