Migrating docker snipeit to new docker host, migrating external snipeit db to new external db server

[lerroot]

Hello:

We are migrating an older snipeit install (docker container; using external db server). The plan is to create a new snipeit container on a new docker host using a new external mysql db created from a dump of the older mysql db we currently use.

Instructions here:
https://snipe-it.readme.io/docs/docker

include comments like "We are currently rewriting this article. The below information could be outdated.", especially regarding the .env file and external db use. So my first question must be:
What are the correct .env parameters? Is the listed info at https://snipe-it.readme.io/docs/docker indeed outdated?

We are migrating from:
snipeit version v6.1.2 - build 10938 (master)
docker version: 24.0.5
(docker host is on OS Centos 7.9)
external db server version:
mysql 5.7.22

to:
latest docker install with latest snipeit container available on Rocky Linux 9.5 host OS.
external db server version:
mysql 8.0.34

Initial/Additional questions (in addition to my initial question above):

1. Do I need to use docker compose or can i just continue with docker (run) and rely solely on the .env file (as I use with Centos 7.9 snipeit docker container version v6.1.2)?
2. For docker run command: is --link snipe-mysql:mysql needed if using an external db server?
3. What is the complete procedure for migrating our old external mysql snipeit db from our mysql 5.7.22 server to our mysql 8.0.34 server? What is the timing regarding migrating that db and starting up the new snipeit container? Is mysqldump sufficient? What special flags if any are required for dumping/importing to new db server via mysqldump?
4. What additional considerations/steps are needed, if any, to what is listed at https://snipe-it.readme.io/docs/docker ?

Please let me know any additional relevant information in addition to answers to my questions above. Thank you.

[lerroot]

hi- would someone please comment on my questions? thank you.
EDIT: so far this is looking easier than i thought- setting up db, mailer now. using a dump from prior snipeit installation. i will update this thread if i run into a specific issue. thank you.

[lerroot]

OK- I fired up the new container. I ran through the installation web checklist- db up and mailer running; new admin user created. Then i took an .sql dump from the older snipeIT install (created via the admin->backups section of the older snipeit install) and imported it with the new container stopped. I did not make any admin/setup changes- I simply imported the .sql.

Restarted new container. At login screen I entered the new admin user and password (not same as older snipeIT install) and received a Server Error 500 window. What is the proper troubleshoot routine now?

[snipe]

https://snipe-it.readme.io/docs/installation-issues#/

Always include logs when you're running into 500 errors. I cannot possibly tell you what's wrong without those.

As a wild guess though, I'd assume you need to run migrations.
https://snipe-it.readme.io/docs/database-issues#/ (click on the docker tab in that first section for docker instructions)

[lerroot]

Hi-

Apologies- here's the result when I ran:
php artisan migrate

from inside the new container:

`root@2186e20a0597:/var/www/html# php artisan migrate

                                                                  APPLICATION IN PRODUCTION.                                                                       

┌ Are you sure you want to run this command? ──────────────────┐
│ Yes │
└──────────────────────────────────────────────────────────────┘

INFO Running migrations.

2018_08_08_100000_create_telescope_entries_table ..................................................................................... 2.59ms FAIL
[2025-09-08 12:21:28] production.ERROR: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'telescope_entries' already exists in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:571
Stack trace:
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(571): PDOStatement->execute()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database{closure}()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\Database\Connection->run()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\Database\Connection->statement()
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(418): Illuminate\Database\Schema\Builder->build()
#7 /var/www/html/database/migrations/2018_08_08_100000_create_telescope_entries_table.php(24): Illuminate\Database\Schema\Builder->create()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(507): Illuminate\Database\Migrations\Migration@anonymous->up()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(432): Illuminate\Database\Migrations\Migrator->runMethod()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(441): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->runMigration()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(798): Illuminate\Console\View\Components\Task->render()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->write()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(211): Illuminate\Database\Migrations\Migrator->runUp()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(138): Illuminate\Database\Migrations\Migrator->runPending()
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\Database\Migrations\Migrator->run()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations{closure}()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\Database\Migrations\Migrator->usingConnection()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#27 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#29 /var/www/html/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#30 /var/www/html/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#31 /var/www/html/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#33 /var/www/html/artisan(33): Illuminate\Foundation\Console\Kernel->handle()
#34 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'telescope_entries' already exists (Connection: mysql, SQL: create table telescope_entries (sequence bigint unsigned not null auto_increment primary key, uuid char(36) not null, batch_id char(36) not null, family_hash varchar(191) null, should_display_on_index tinyint(1) not null default '1', type varchar(20) not null, content longtext not null, created_at datetime null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
Stack trace:
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\Database\Connection->run()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\Database\Connection->statement()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(418): Illuminate\Database\Schema\Builder->build()
#5 /var/www/html/database/migrations/2018_08_08_100000_create_telescope_entries_table.php(24): Illuminate\Database\Schema\Builder->create()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(507): Illuminate\Database\Migrations\Migration@anonymous->up()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(432): Illuminate\Database\Migrations\Migrator->runMethod()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(441): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->runMigration()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(798): Illuminate\Console\View\Components\Task->render()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->write()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(211): Illuminate\Database\Migrations\Migrator->runUp()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(138): Illuminate\Database\Migrations\Migrator->runPending()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\Database\Migrations\Migrator->run()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations{closure}()
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\Database\Migrations\Migrator->usingConnection()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#25 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#27 /var/www/html/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#28 /var/www/html/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#29 /var/www/html/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#31 /var/www/html/artisan(33): Illuminate\Foundation\Console\Kernel->handle()
#32 {main}
[2025-09-08 12:21:28] production.ERROR: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'telescope_entries' already exists (Connection: mysql, SQL: create table telescope_entries (sequence bigint unsigned not null auto_increment primary key, uuid char(36) not null, batch_id char(36) not null, family_hash varchar(191) null, should_display_on_index tinyint(1) not null default '1', type varchar(20) not null, content longtext not null, created_at datetime null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) {"exception":"[object] (Illuminate\Database\QueryException(code: 42S01): SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'telescope_entries' already exists (Connection: mysql, SQL: create table telescope_entries (sequence bigint unsigned not null auto_increment primary key, uuid char(36) not null, batch_id char(36) not null, family_hash varchar(191) null, should_display_on_index tinyint(1) not null default '1', type varchar(20) not null, content longtext not null, created_at datetime null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\Database\Connection->run()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\Database\Connection->statement()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(418): Illuminate\Database\Schema\Builder->build()
#5 /var/www/html/database/migrations/2018_08_08_100000_create_telescope_entries_table.php(24): Illuminate\Database\Schema\Builder->create()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(507): Illuminate\Database\Migrations\Migration@anonymous->up()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(432): Illuminate\Database\Migrations\Migrator->runMethod()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(441): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->runMigration()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(798): Illuminate\Console\View\Components\Task->render()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->write()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(211): Illuminate\Database\Migrations\Migrator->runUp()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(138): Illuminate\Database\Migrations\Migrator->runPending()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\Database\Migrations\Migrator->run()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}()
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\Database\Migrations\Migrator->usingConnection()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#25 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#27 /var/www/html/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#28 /var/www/html/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#29 /var/www/html/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#31 /var/www/html/artisan(33): Illuminate\Foundation\Console\Kernel->handle()
#32 {main}

[previous exception] [object] (PDOException(code: 42S01): SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'telescope_entries' already exists at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:571)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(571): PDOStatement->execute()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\Database\Connection->run()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\Database\Connection->statement()
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(418): Illuminate\Database\Schema\Builder->build()
#7 /var/www/html/database/migrations/2018_08_08_100000_create_telescope_entries_table.php(24): Illuminate\Database\Schema\Builder->create()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(507): Illuminate\Database\Migrations\Migration@anonymous->up()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(432): Illuminate\Database\Migrations\Migrator->runMethod()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(441): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->runMigration()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(798): Illuminate\Console\View\Components\Task->render()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->write()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(211): Illuminate\Database\Migrations\Migrator->runUp()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(138): Illuminate\Database\Migrations\Migrator->runPending()
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\Database\Migrations\Migrator->run()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\Database\Migrations\Migrator->usingConnection()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#27 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#29 /var/www/html/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#30 /var/www/html/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#31 /var/www/html/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#33 /var/www/html/artisan(33): Illuminate\Foundation\Console\Kernel->handle()
#34 {main}
"}

Illuminate\Database\QueryException

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'telescope_entries' already exists (Connection: mysql, SQL: create table telescope_entries (sequence bigint unsigned not null auto_increment primary key, uuid char(36) not null, batch_id char(36) not null, family_hash varchar(191) null, should_display_on_index tinyint(1) not null default '1', type varchar(20) not null, content longtext not null, created_at datetime null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
821▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
822▕ );
823▕ }
824▕
➜ 825▕ throw new QueryException(
826▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
827▕ );
828▕ }
829▕ }

  +8 vendor frames 

9 database/migrations/2018_08_08_100000_create_telescope_entries_table.php:24
Illuminate\Database\Schema\Builder::create()
+25 vendor frames

35 artisan:33
Illuminate\Foundation\Console\Kernel::handle()

`

So- not sure how to resolve the "Table 'telescope_entries' already exists" error. Infos here:
https://snipe-it.readme.io/docs/database-issues#/
do not seem to address this specific issue. Please let me know how to proceed. Thank you.

[lerroot]

ok as per a comment here:
#9412
from MaxVRAM
on Sep 6, 2021

I had to drop several empty tables that kept throwing errors like:
"Base table or view already exists: 1050 Table 'telescope_entries' already exists"

Now the new container runs and no longer throws the 500 error.

[lerroot]

New instance runs- but the images are all missing. For example, under "Assets" then "Device Image" there is a url but no image. Clicking on the URL states (for example):
Failed to load image: http://anim-docker:8000/uploads/models/assetmodel-qTFpjH9szVXLcRXkoO.jpg

What are the steps to troubleshoot this?

[lerroot]

I had to copy manually and chown manually files from old instance from:
/var/lib/docker/volumes/snipe-vol/_data/data/private_uploads
and
/var/lib/docker/volumes/snipe-vol/_data/data/uploads
to the new instance.

looks good so far. will advise upon more testing.