Ask, reply and learn. Join the community of Akaunting.

New Discussion

Akaunting Trying to Recreate Database on boot

Matt Dezzi   ( User )

Commented 2 months ago

Hello, I have Akaunting installed in docker on an Unraid system. I've successfully created the database and logged in on the first install. However, on subsequent restarts of the docker container, the logs have a lot of errors like the following:

Setting locale US_EN
Creating database tables
Connecting to database [email protected]:3306

In Connection.php line 822:

SQLSTATE[HY000]: General error: 1005 Can't create table `akaunting`.`sxx_me
dia` (errno: 121 "Duplicate key on write or update") (Connection: mysql, SQ
L: alter table `sxx_media` add constraint `original_media_id` foreign key (
`original_media_id`) references `sxx_media` (`id`) on delete set null)

It appears that the container is trying to recreate all the database tables as if it were being run for the first time. What am I doing wrong here?

Please login or register to leave a response.

Showing 1 to 1 of 1 discussions