Migrate to docker - Githubissues

shindelhu commented 7 years ago

Hi,

We are using Snipe-It in our company for years now without a problem. Lately we decide to move the actual v 2.1.0-41 installed instance to the newest 3.6.3 in docker enviroment. I've managed to make the new one to work, but not able to migrate data. I was trying to import an sql dump to the mysql conatiner, which didn't work well. I read all the related documentations, but not able to do this. Could you please divert me to the right direction? :)

Thank in advance.

snipe commented 7 years ago

Can you explain what you mean by "didn't work well"? What actually happened? What errors are you seeing?

shindelhu commented 7 years ago

There is no actual error. When I was importing the .sql file to the mysql container's database, after the login screen I got error 500. I read that the database structure has been changed between ver 2 and 3, so I would need to run some script for the migration, I just don't know, how to do that, when I have a working older version on one server and a new version with docker on another with an empty database!? Thanks

snipe commented 7 years ago

after the login screen I got error 500

So, there is an error then. Please turn on debugging or provide the contents of your app error log so we can see what the error is.

I read that the database structure has been changed between ver 2 and 3, so I would need to run some script for the migration, I just don't know, how to do that

https://snipe-it.readme.io/docs/upgrading-to-v3#section-step-7-migrate-the-database

shindelhu commented 7 years ago

Never mind that error. Am I right that I'd need to copy over a full sql dump to the new server and run php artisan migrate on my new server? Forget about app key and setting, I just care about data, as this is a test server to work paralel with the existing one?

snipe commented 7 years ago

Yes, per the documentation, you'll need to run migrations. If you're doing this on a test server, you'd copy your existing database over and run migrations on the test database.

shindelhu commented 7 years ago

OK, I've copied over the sql file, ran the migrate command and received an error about tables already exist. So I found a comment, where they said to drop the database, re-create it, do the import then run again the migrate command, so I did that. Now I got this, after the login with debug mode on:

HELP PLS:

Whoops, looks like something went wrong.

4/4 ErrorException in Connection.php line 729: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'min_amt' in 'where clause' (SQL: select * from consumables where min_amt is not null and consumables.deleted_at is null) (View: /var/www/html/resources/views/layouts/default.blade.php) (View: /var/www/html/resources/views/layouts/default.blade.php) in Connection.php line 729 at CompilerEngine->handleViewException(object(ErrorException), '1') in compiled.php line 15319 at PhpEngine->evaluatePath('/var/www/html/storage/framework/views/7d4141c784d83c852bb95c75279d5403742cbc15.php', array('env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15354 at CompilerEngine->get('/var/www/html/resources/views/dashboard.blade.php', array('__env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15186 at View->getContents() in compiled.php line 15174 at View->renderContents() in compiled.php line 15158 at View->render() in compiled.php line 16405 at Response->setContent(object(View)) in compiled.php line 15901 at Response->construct(object(View)) in compiled.php line 8373 at Router->prepareResponse(object(Request), object(View)) in compiled.php line 9466 at ControllerDispatcher->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 9467 at ControllerDispatcher->callWithinStack(object(DashboardController), object(Route), object(Request), 'getIndex') in compiled.php line 9454 at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\DashboardController', 'getIndex') in compiled.php line 8524 at Route->runController(object(Request)) in compiled.php line 8511 at Route->run(object(Request)) in compiled.php line 8225 at Router->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 45 at Authenticate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForTwoFactor.php line 49 at CheckForTwoFactor->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForTwoFactor), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckLocale.php line 42 at CheckLocale->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckLocale), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3225 at VerifyCsrfToken->handle(object(Request), object(Closure)) at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13213 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13150 at EncryptCookies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 8226 at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8217 at Router->dispatchToRoute(object(Request)) in compiled.php line 8207 at Router->dispatch(object(Request)) in compiled.php line 2419 at Kernel->Illuminate\Foundation\Http{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49 at Debugbar->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForDebug.php line 25 at CheckForDebug->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForDebug), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in TrustProxies.php line 46 at TrustProxies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(TrustProxies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForSetup.php line 27 at CheckForSetup->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForSetup), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in NosniffGuard.php line 17 at NosniffGuard->handle(object(Request), object(Closure)) at call_user_func_array(array(object(NosniffGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in XssProtectHeader.php line 17 at XssProtectHeader->handle(object(Request), object(Closure)) at call_user_func_array(array(object(XssProtectHeader), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in FrameGuard.php line 17 at FrameGuard->handle(object(Request), object(Closure)) at call_user_func_array(array(object(FrameGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13474 at ShareErrorsFromSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 11964 at StartSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForMaintenanceMode.php line 145 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 2366 at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2350 at Kernel->handle(object(Request)) in index.php line 60 3/4 ErrorException in Connection.php line 729: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'min_amt' in 'where clause' (SQL: select * from consumables where min_amt is not null and consumables.deleted_at is null) (View: /var/www/html/resources/views/layouts/default.blade.php) in Connection.php line 729 at CompilerEngine->handleViewException(object(QueryException), '2') in compiled.php line 15319 at PhpEngine->evaluatePath('/var/www/html/storage/framework/views/3d7e7b45ea030eae9e1ff05338363fe3be6c180b.php', array('env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'obLevel' => '1', 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15354 at CompilerEngine->get('/var/www/html/resources/views/layouts/default.blade.php', array('__env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'obLevel' => '1', 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15186 at View->getContents() in compiled.php line 15174 at View->renderContents() in compiled.php line 15158 at View->render() in 7d4141c784d83c852bb95c75279d5403742cbc15.php line 199 at include('/var/www/html/storage/framework/views/7d4141c784d83c852bb95c75279d5403742cbc15.php') in compiled.php line 15317 at PhpEngine->evaluatePath('/var/www/html/storage/framework/views/7d4141c784d83c852bb95c75279d5403742cbc15.php', array('env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15354 at CompilerEngine->get('/var/www/html/resources/views/dashboard.blade.php', array('env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15186 at View->getContents() in compiled.php line 15174 at View->renderContents() in compiled.php line 15158 at View->render() in compiled.php line 16405 at Response->setContent(object(View)) in compiled.php line 15901 at Response->__construct(object(View)) in compiled.php line 8373 at Router->prepareResponse(object(Request), object(View)) in compiled.php line 9466 at ControllerDispatcher->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 9467 at ControllerDispatcher->callWithinStack(object(DashboardController), object(Route), object(Request), 'getIndex') in compiled.php line 9454 at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\DashboardController', 'getIndex') in compiled.php line 8524 at Route->runController(object(Request)) in compiled.php line 8511 at Route->run(object(Request)) in compiled.php line 8225 at Router->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 45 at Authenticate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForTwoFactor.php line 49 at CheckForTwoFactor->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForTwoFactor), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckLocale.php line 42 at CheckLocale->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckLocale), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3225 at VerifyCsrfToken->handle(object(Request), object(Closure)) at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13213 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13150 at EncryptCookies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 8226 at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8217 at Router->dispatchToRoute(object(Request)) in compiled.php line 8207 at Router->dispatch(object(Request)) in compiled.php line 2419 at Kernel->Illuminate\Foundation\Http{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49 at Debugbar->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForDebug.php line 25 at CheckForDebug->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForDebug), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in TrustProxies.php line 46 at TrustProxies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(TrustProxies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForSetup.php line 27 at CheckForSetup->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForSetup), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in NosniffGuard.php line 17 at NosniffGuard->handle(object(Request), object(Closure)) at call_user_func_array(array(object(NosniffGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in XssProtectHeader.php line 17 at XssProtectHeader->handle(object(Request), object(Closure)) at call_user_func_array(array(object(XssProtectHeader), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in FrameGuard.php line 17 at FrameGuard->handle(object(Request), object(Closure)) at call_user_func_array(array(object(FrameGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13474 at ShareErrorsFromSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 11964 at StartSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForMaintenanceMode.php line 145 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 2366 at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2350 at Kernel->handle(object(Request)) in index.php line 60 2/4 QueryException in Connection.php line 729: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'min_amt' in 'where clause' (SQL: select from consumables where min_amt is not null and consumables.deleted_at is null) in Connection.php line 729 at Connection->runQueryCallback('select from consumables where min_amt is not null and consumables.deleted_at is null', array(), object(Closure)) in Connection.php line 685 at Connection->run('select from consumables where min_amt is not null and consumables.deleted_at is null', array(), object(Closure)) in Connection.php line 349 at Connection->select('select from consumables where min_amt is not null and consumables.deleted_at is null', array(), true) in Builder.php line 1610 at Builder->runSelect() in Builder.php line 1596 at Builder->get(array('')) in Builder.php line 625 at Builder->getModels(array('')) in Builder.php line 316 at Builder->get() in Helper.php line 426 at Helper::checkLowInventory() in 3d7e7b45ea030eae9e1ff05338363fe3be6c180b.php line 242 at include('/var/www/html/storage/framework/views/3d7e7b45ea030eae9e1ff05338363fe3be6c180b.php') in compiled.php line 15317 at PhpEngine->evaluatePath('/var/www/html/storage/framework/views/3d7e7b45ea030eae9e1ff05338363fe3be6c180b.php', array('env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'obLevel' => '1', 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15354 at CompilerEngine->get('/var/www/html/resources/views/layouts/default.blade.php', array('env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'obLevel' => '1', 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15186 at View->getContents() in compiled.php line 15174 at View->renderContents() in compiled.php line 15158 at View->render() in 7d4141c784d83c852bb95c75279d5403742cbc15.php line 199 at include('/var/www/html/storage/framework/views/7d4141c784d83c852bb95c75279d5403742cbc15.php') in compiled.php line 15317 at PhpEngine->evaluatePath('/var/www/html/storage/framework/views/7d4141c784d83c852bb95c75279d5403742cbc15.php', array('__env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15354 at CompilerEngine->get('/var/www/html/resources/views/dashboard.blade.php', array('env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15186 at View->getContents() in compiled.php line 15174 at View->renderContents() in compiled.php line 15158 at View->render() in compiled.php line 16405 at Response->setContent(object(View)) in compiled.php line 15901 at Response->construct(object(View)) in compiled.php line 8373 at Router->prepareResponse(object(Request), object(View)) in compiled.php line 9466 at ControllerDispatcher->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 9467 at ControllerDispatcher->callWithinStack(object(DashboardController), object(Route), object(Request), 'getIndex') in compiled.php line 9454 at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\DashboardController', 'getIndex') in compiled.php line 8524 at Route->runController(object(Request)) in compiled.php line 8511 at Route->run(object(Request)) in compiled.php line 8225 at Router->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 45 at Authenticate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForTwoFactor.php line 49 at CheckForTwoFactor->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForTwoFactor), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckLocale.php line 42 at CheckLocale->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckLocale), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3225 at VerifyCsrfToken->handle(object(Request), object(Closure)) at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13213 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13150 at EncryptCookies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 8226 at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8217 at Router->dispatchToRoute(object(Request)) in compiled.php line 8207 at Router->dispatch(object(Request)) in compiled.php line 2419 at Kernel->Illuminate\Foundation\Http{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49 at Debugbar->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForDebug.php line 25 at CheckForDebug->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForDebug), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in TrustProxies.php line 46 at TrustProxies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(TrustProxies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForSetup.php line 27 at CheckForSetup->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForSetup), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in NosniffGuard.php line 17 at NosniffGuard->handle(object(Request), object(Closure)) at call_user_func_array(array(object(NosniffGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in XssProtectHeader.php line 17 at XssProtectHeader->handle(object(Request), object(Closure)) at call_user_func_array(array(object(XssProtectHeader), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in FrameGuard.php line 17 at FrameGuard->handle(object(Request), object(Closure)) at call_user_func_array(array(object(FrameGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13474 at ShareErrorsFromSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 11964 at StartSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForMaintenanceMode.php line 145 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 2366 at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2350 at Kernel->handle(object(Request)) in index.php line 60 1/4 PDOException in Connection.php line 333: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'min_amt' in 'where clause' in Connection.php line 333 at PDO->prepare('select from consumables where min_amt is not null and consumables.deleted_at is null') in Connection.php line 333 at Connection->Illuminate\Database{closure}(object(MySqlConnection), 'select from consumables where min_amt is not null and consumables.deleted_at is null', array()) in Connection.php line 722 at Connection->runQueryCallback('select from consumables where min_amt is not null and consumables.deleted_at is null', array(), object(Closure)) in Connection.php line 685 at Connection->run('select from consumables where min_amt is not null and consumables.deleted_at is null', array(), object(Closure)) in Connection.php line 349 at Connection->select('select from consumables where min_amt is not null and consumables.deleted_at is null', array(), true) in Builder.php line 1610 at Builder->runSelect() in Builder.php line 1596 at Builder->get(array('')) in Builder.php line 625 at Builder->getModels(array('*')) in Builder.php line 316 at Builder->get() in Helper.php line 426 at Helper::checkLowInventory() in 3d7e7b45ea030eae9e1ff05338363fe3be6c180b.php line 242 at include('/var/www/html/storage/framework/views/3d7e7b45ea030eae9e1ff05338363fe3be6c180b.php') in compiled.php line 15317 at PhpEngine->evaluatePath('/var/www/html/storage/framework/views/3d7e7b45ea030eae9e1ff05338363fe3be6c180b.php', array('__env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'obLevel' => '1', 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15354 at CompilerEngine->get('/var/www/html/resources/views/layouts/default.blade.php', array('env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'obLevel' => '1', 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15186 at View->getContents() in compiled.php line 15174 at View->renderContents() in compiled.php line 15158 at View->render() in 7d4141c784d83c852bb95c75279d5403742cbc15.php line 199 at include('/var/www/html/storage/framework/views/7d4141c784d83c852bb95c75279d5403742cbc15.php') in compiled.php line 15317 at PhpEngine->evaluatePath('/var/www/html/storage/framework/views/7d4141c784d83c852bb95c75279d5403742cbc15.php', array('env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15354 at CompilerEngine->get('/var/www/html/resources/views/dashboard.blade.php', array('__env' => object(Factory), 'app' => object(Application), 'MaintenanceModeEnabled' => false, 'MaintenanceModeTimestamp' => object(Carbon), 'MaintenanceModeMessage' => 'We're currently working on the site, please try again later!', 'errors' => object(ViewErrorBag), 'debug_in_production' => true, 'signedIn' => true, 'user' => object(User), 'asset_stats' => array('total' => '638', 'rtd' => array('total' => '124', 'percent' => '19'), 'pending' => array('total' => '2', 'percent' => '0'), 'deployed' => array('total' => '493', 'percent' => '77'), 'undeployable' => array('total' => '1', 'percent' => '0'), 'archived' => array('total' => '19', 'percent' => '3')), 'snipeSettings' => object(Setting))) in compiled.php line 15186 at View->getContents() in compiled.php line 15174 at View->renderContents() in compiled.php line 15158 at View->render() in compiled.php line 16405 at Response->setContent(object(View)) in compiled.php line 15901 at Response->construct(object(View)) in compiled.php line 8373 at Router->prepareResponse(object(Request), object(View)) in compiled.php line 9466 at ControllerDispatcher->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 9467 at ControllerDispatcher->callWithinStack(object(DashboardController), object(Route), object(Request), 'getIndex') in compiled.php line 9454 at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\DashboardController', 'getIndex') in compiled.php line 8524 at Route->runController(object(Request)) in compiled.php line 8511 at Route->run(object(Request)) in compiled.php line 8225 at Router->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 45 at Authenticate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForTwoFactor.php line 49 at CheckForTwoFactor->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForTwoFactor), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckLocale.php line 42 at CheckLocale->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckLocale), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3225 at VerifyCsrfToken->handle(object(Request), object(Closure)) at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13213 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13150 at EncryptCookies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 8226 at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8217 at Router->dispatchToRoute(object(Request)) in compiled.php line 8207 at Router->dispatch(object(Request)) in compiled.php line 2419 at Kernel->Illuminate\Foundation\Http{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49 at Debugbar->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForDebug.php line 25 at CheckForDebug->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForDebug), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in TrustProxies.php line 46 at TrustProxies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(TrustProxies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForSetup.php line 27 at CheckForSetup->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForSetup), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in NosniffGuard.php line 17 at NosniffGuard->handle(object(Request), object(Closure)) at call_user_func_array(array(object(NosniffGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in XssProtectHeader.php line 17 at XssProtectHeader->handle(object(Request), object(Closure)) at call_user_func_array(array(object(XssProtectHeader), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in FrameGuard.php line 17 at FrameGuard->handle(object(Request), object(Closure)) at call_user_func_array(array(object(FrameGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13474 at ShareErrorsFromSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 11964 at StartSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForMaintenanceMode.php line 145 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in compiled.php line 9948 at Pipeline->then(object(Closure)) in compiled.php line 2366 at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2350 at Kernel->handle(object(Request)) in index.php line 60

snipe commented 7 years ago

Can you show me the contents of your migrations table?

shindelhu commented 7 years ago

After the migration script I got this:

[Illuminate\Database\QueryException] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'password_resets' already exists (SQL: create table password_resets (email varchar(255) not null, token varchar(255) not null, created_at timestamp not null) def ault character set utf8 collate utf8_unicode_ci engine = InnoDB)

[PDOException] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'password_resets' already exists

shindelhu commented 7 years ago

| migration +--------------------------------------------- | 2012_12_06_225921_migration_cartalyst_sentry | 2012_12_06_225929_migration_cartalyst_sentry | 2012_12_06_225945_migration_cartalyst_sentry | 2012_12_06_225988_migration_cartalyst_sentry | 2013_03_23_193214_update_users_table | 2013_11_13_075318_create_models_table | 2013_11_13_075335_create_categories_table | 2013_11_13_075347_create_manufacturers_table | 2013_11_15_015858_add_user_id_to_categories | 2013_11_15_112701_add_user_id_to_manufacturers | 2013_11_15_190327_create_assets_table | 2013_11_15_190357_create_licenses_table | 2013_11_15_201848_add_license_name_to_licenses | 2013_11_16_040323_create_depreciations_table | 2013_11_16_042851_add_depreciation_id_to_models | 2013_11_16_084923_add_user_id_to_models | 2013_11_16_103258_create_locations_table | 2013_11_16_103336_add_location_id_to_assets | 2013_11_16_103407_add_checkedout_to_to_assets | 2013_11_16_103425_create_history_table | 2013_11_17_054359_drop_licenses_table | 2013_11_17_054526_add_physical_to_assets | 2013_11_17_055126_create_settings_table | 2013_11_17_062634_add_license_to_assets | 2013_11_18_134332_add_contacts_to_users | 2013_11_18_142847_add_info_to_locations | 2013_11_18_152942_remove_location_id_from_asset | 2013_11_18_164423_set_nullvalues_for_user | 2013_11_19_013337_create_asset_logs_table | 2013_11_19_061409_edit_added_on_asset_logs_table | 2013_11_19_062250_edit_location_id_asset_logs_table | 2013_11_20_055822_add_soft_delete_on_assets | 2013_11_20_121404_add_soft_delete_on_locations | 2013_11_20_123137_add_soft_delete_on_manufacturers | 2013_11_20_123725_add_soft_delete_on_categories | 2013_11_20_130248_create_status_labels | 2013_11_20_130830_add_status_id_on_assets_table | 2013_11_20_131544_add_status_type_on_status_labels | 2013_11_20_134103_add_archived_to_assets | 2013_11_21_002321_add_uploads_table | 2013_11_21_024531_remove_deployable_boolean_ | 2013_11_22_075308_add_option_label_to_settings_table | 2013_11_22_213400_edits_to_settings_table | 2013_11_25_013244_create_licenses_table | 2013_11_25_031458_create_license_seats_table | 2013_11_25_032022_add_type_to_actionlog_table | 2013_11_25_033008_delete_bad_licenses_table | 2013_11_25_033131_create_new_licenses_table | 2013_11_25_033534_add_licensed_to_licenses_table | 2013_11_25_101308_add_warrantee_to_assets_table | 2013_11_25_104343_alter_warranty_column_on_assets | 2013_11_25_150450_drop_parent_from_categories | 2013_11_25_151920_add_depreciate_to_assets | 2013_11_25_152903_add_depreciate_to_licenses_table | 2013_11_26_211820_drop_license_from_assets_table | 2013_11_27_062510_add_note_to_asset_logs_table | 2013_12_01_113426_add_filename_to_asset_log | 2013_12_06_094618_add_nullable_to_licenses_table | 2013_12_10_084038_add_eol_on_models_table | 2013_12_12_055218_add_manager_to_users_table | 2014_01_28_031200_add_qr_code_to_settings_table | 2014_02_13_183016_add_qr_text_to_settings_table | 2014_05_24_093839_alter_default_license_depreciation_id | 2014_05_27_231658_alter_default_values_licenses | 2014_06_19_191508_add_asset_name_to_settings | 2014_06_20_004847_make_asset_log_checkedout_to_nullable | 2014_06_20_005050_make_asset_log_purchasedate_to_nullable | 2014_06_24_003011_add_suppliers | 2014_06_24_010742_add_supplier_id_to_asset | 2014_06_24_012839_add_zip_to_supplier | 2014_06_24_033908_add_url_to_supplier | 2014_07_08_054116_add_employee_id_to_users | 2014_07_09_134316_add_requestable_to_assets | 2014_07_17_085822_add_asset_to_software | 2014_07_17_161625_make_asset_id_in_logs_nullable | 2014_08_12_053504_alpha_0_4_2_release | 2014_08_17_083523_make_location_id_nullable | 2014_10_16_200626_add_rtd_location_to_assets | 2014_10_24_000417_alter_supplier_state_to_32 | 2014_10_24_015641_add_display_checkout_date | 2014_10_28_222654_add_avatar_field_to_users_table | 2014_10_29_045924_add_image_field_to_models_table | 2014_11_01_214955_add_eol_display_to_settings | 2014_11_04_231416_update_group_field_for_reporting | 2014_11_05_212408_add_fields_to_licenses | 2014_11_07_021042_add_image_to_supplier | 2014_11_20_203007_add_username_to_user | 2014_11_20_223947_add_auto_to_settings | 2014_11_20_224421_add_prefix_to_settings | 2014_11_21_104401_change_licence_type | 2014_12_09_082500_add_fields_maintained_term_to_licenses | 2015_02_04_155757_increase_user_field_lengths | 2015_02_07_013537_add_soft_deleted_to_log | 2015_02_10_040958_fix_bad_assigned_to_ids | 2015_02_10_053310_migrate_data_to_new_statuses | 2015_02_11_044104_migrate_make_license_assigned_null | 2015_02_11_104406_migrate_create_requests_table | 2015_02_12_001312_add_mac_address_to_asset | 2015_02_12_024100_change_license_notes_type | 2015_02_17_231020_add_localonly_to_settings | 2015_02_19_222322_add_logo_and_colors_to_settings | 2015_02_24_072043_add_alerts_to_settings | 2015_02_25_022931_add_eula_fields | 2015_02_25_204513_add_accessories_table | 2015_02_26_091228_add_accessories_user_table | 2015_02_26_115128_add_deleted_at_models | 2015_02_26_233005_add_category_type | 2015_03_01_231912_update_accepted_at_to_acceptance_id | 2015_03_05_011929_add_qr_type_to_settings | 2015_03_18_055327_add_note_to_user | 2015_04_29_234704_add_slack_to_settings | 2015_05_04_085151_add_parent_id_to_locations_table | 2015_05_22_124421_add_reassignable_to_licenses | 2015_06_10_003314_fix_default_for_user_notes | 2015_06_10_003554_create_consumables | 2015_06_15_183253_move_email_to_username | 2015_06_23_070346_make_email_nullable | 2015_06_26_213716_create_asset_maintenances_table | 2015_07_04_212443_create_custom_fields_table | 2015_07_09_014359_add_currency_to_settings_and_locations | 2015_07_21_122022_add_expected_checkin_date_to_asset_logs | 2015_07_24_093845_add_checkin_email_to_category_table | 2015_07_25_055415_remove_email_unique_constraint | 2015_07_29_230054_add_thread_id_to_asset_logs_table | 2015_07_31_015430_add_accepted_to_assets | 2015_09_09_195301_add_custom_css_to_settings | 2015_09_21_235926_create_custom_field_custom_fieldset | 2015_09_22_000104_create_custom_fieldsets | 2015_09_22_003321_add_fieldset_id_to_assets | 2015_09_22_003413_migrate_mac_address | 2015_09_28_003314_fix_default_purchase_order | 2015_10_01_024551_add_accessory_consumable_price_info | 2015_10_12_192706_add_brand_to_settings | 2015_10_22_003314_fix_defaults_accessories | 2015_10_23_182625_add_checkout_time_and_expe | 2015_11_05_061015_create_companies_table | 2015_11_05_061115_add_company_id_to_consumables_table | 2015_11_05_183749_image | 2015_11_06_092038_add_company_id_to_accessories_table | 2015_11_06_100045_add_company_id_to_users_table | 2015_11_06_134742_add_company_id_to_licenses_table | 2015_11_08_035832_add_company_id_to_assets_table | 2015_11_08_222305_add_ldap_fields_to_settings | 2015_11_15_151803_add_full_multiple_companie | 2015_11_26_195528_import_ldap_settings | 2015_11_30_191504_remove_fk_company_id | 2015_12_21_193006_add_ldap_server_cert_ignor | 2015_12_30_233509_add_timestamp_and_userId_t | 2015_12_30_233658_add_timestamp_and_userId_t | 2016_01_28_041048_add_notes_to_models | 2016_02_19_070119_add_remember_token_to_users_table +--------------------------------------------- 151 rows in set (0.00 sec) | batch | -----------------------------+-------+ _install_users | 1 | _install_groups | 1 | _install_users_groups_pivot | 1 | _install_throttle | 1 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | from_status_labels | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | cted_checkout_date_to_assets | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | s_support_to_settings_table | 2 | | 2 | | 2 | e_to_settings_table | 2 | o_custom_fields | 2 | o_custom_fieldsets | 2 | | 2 | | 3 | -----------------------------+-------+

snipe commented 7 years ago

Did you get any errors running migrations that last time? You should have many more than that, so I'm wondering if something broke somewhere in the migration so that it didn't finish running.

migration   batch
2012_12_06_225921_migration_cartalyst_sentry_install_users  1
2012_12_06_225929_migration_cartalyst_sentry_install_groups 1
2012_12_06_225945_migration_cartalyst_sentry_install_users_groups_pivot 1
2012_12_06_225988_migration_cartalyst_sentry_install_throttle   1
2013_03_23_193214_update_users_table    1
2013_11_13_075318_create_models_table   1
2013_11_13_075335_create_categories_table   1
2013_11_13_075347_create_manufacturers_table    1
2013_11_15_015858_add_user_id_to_categories 1
2013_11_15_112701_add_user_id_to_manufacturers  1
2013_11_15_190327_create_assets_table   1
2013_11_15_190357_create_licenses_table 1
2013_11_15_201848_add_license_name_to_licenses  1
2013_11_16_040323_create_depreciations_table    1
2013_11_16_042851_add_depreciation_id_to_models 1
2013_11_16_084923_add_user_id_to_models 1
2013_11_16_103258_create_locations_table    1
2013_11_16_103336_add_location_id_to_assets 1
2013_11_16_103407_add_checkedout_to_to_assets   1
2013_11_16_103425_create_history_table  1
2013_11_17_054359_drop_licenses_table   1
2013_11_17_054526_add_physical_to_assets    1
2013_11_17_055126_create_settings_table 1
2013_11_17_062634_add_license_to_assets 1
2013_11_18_134332_add_contacts_to_users 1
2013_11_18_142847_add_info_to_locations 1
2013_11_18_152942_remove_location_id_from_asset 1
2013_11_18_164423_set_nullvalues_for_user   1
2013_11_19_013337_create_asset_logs_table   1
2013_11_19_061409_edit_added_on_asset_logs_table    1
2013_11_19_062250_edit_location_id_asset_logs_table 1
2013_11_20_055822_add_soft_delete_on_assets 1
2013_11_20_121404_add_soft_delete_on_locations  1
2013_11_20_123137_add_soft_delete_on_manufacturers  1
2013_11_20_123725_add_soft_delete_on_categories 1
2013_11_20_130248_create_status_labels  1
2013_11_20_130830_add_status_id_on_assets_table 1
2013_11_20_131544_add_status_type_on_status_labels  1
2013_11_20_134103_add_archived_to_assets    1
2013_11_21_002321_add_uploads_table 1
2013_11_21_024531_remove_deployable_boolean_from_status_labels  1
2013_11_22_075308_add_option_label_to_settings_table    1
2013_11_22_213400_edits_to_settings_table   1
2013_11_25_013244_create_licenses_table 1
2013_11_25_031458_create_license_seats_table    1
2013_11_25_032022_add_type_to_actionlog_table   1
2013_11_25_033008_delete_bad_licenses_table 1
2013_11_25_033131_create_new_licenses_table 1
2013_11_25_033534_add_licensed_to_licenses_table    1
2013_11_25_101308_add_warrantee_to_assets_table 1
2013_11_25_104343_alter_warranty_column_on_assets   1
2013_11_25_150450_drop_parent_from_categories   1
2013_11_25_151920_add_depreciate_to_assets  1
2013_11_25_152903_add_depreciate_to_licenses_table  1
2013_11_26_211820_drop_license_from_assets_table    1
2013_11_27_062510_add_note_to_asset_logs_table  1
2013_12_01_113426_add_filename_to_asset_log 1
2013_12_06_094618_add_nullable_to_licenses_table    1
2013_12_10_084038_add_eol_on_models_table   1
2013_12_12_055218_add_manager_to_users_table    1
2014_01_28_031200_add_qr_code_to_settings_table 1
2014_02_13_183016_add_qr_text_to_settings_table 1
2014_05_24_093839_alter_default_license_depreciation_id 1
2014_05_27_231658_alter_default_values_licenses 1
2014_06_19_191508_add_asset_name_to_settings    1
2014_06_20_004847_make_asset_log_checkedout_to_nullable 1
2014_06_20_005050_make_asset_log_purchasedate_to_nullable   1
2014_06_24_003011_add_suppliers 1
2014_06_24_010742_add_supplier_id_to_asset  1
2014_06_24_012839_add_zip_to_supplier   1
2014_06_24_033908_add_url_to_supplier   1
2014_07_08_054116_add_employee_id_to_users  1
2014_07_09_134316_add_requestable_to_assets 1
2014_07_17_085822_add_asset_to_software 1
2014_07_17_161625_make_asset_id_in_logs_nullable    1
2014_08_12_053504_alpha_0_4_2_release   1
2014_08_17_083523_make_location_id_nullable 1
2014_10_16_200626_add_rtd_location_to_assets    1
2014_10_24_000417_alter_supplier_state_to_32    1
2014_10_24_015641_add_display_checkout_date 1
2014_10_28_222654_add_avatar_field_to_users_table   1
2014_10_29_045924_add_image_field_to_models_table   1
2014_11_01_214955_add_eol_display_to_settings   1
2014_11_04_231416_update_group_field_for_reporting  1
2014_11_05_212408_add_fields_to_licenses    1
2014_11_07_021042_add_image_to_supplier 1
2014_11_20_203007_add_username_to_user  1
2014_11_20_223947_add_auto_to_settings  1
2014_11_20_224421_add_prefix_to_settings    1
2014_11_21_104401_change_licence_type   1
2014_12_09_082500_add_fields_maintained_term_to_licenses    1
2015_02_04_155757_increase_user_field_lengths   1
2015_02_07_013537_add_soft_deleted_to_log   1
2015_02_10_040958_fix_bad_assigned_to_ids   1
2015_02_10_053310_migrate_data_to_new_statuses  1
2015_02_11_044104_migrate_make_license_assigned_null    1
2015_02_11_104406_migrate_create_requests_table 1
2015_02_12_001312_add_mac_address_to_asset  1
2015_02_12_024100_change_license_notes_type 1
2015_02_17_231020_add_localonly_to_settings 1
2015_02_19_222322_add_logo_and_colors_to_settings   1
2015_02_24_072043_add_alerts_to_settings    1
2015_02_25_022931_add_eula_fields   1
2015_02_25_204513_add_accessories_table 1
2015_02_26_091228_add_accessories_user_table    1
2015_02_26_115128_add_deleted_at_models 1
2015_02_26_233005_add_category_type 1
2015_03_01_231912_update_accepted_at_to_acceptance_id   1
2015_03_05_011929_add_qr_type_to_settings   1
2015_03_18_055327_add_note_to_user  1
2015_04_29_234704_add_slack_to_settings 1
2015_05_04_085151_add_parent_id_to_locations_table  1
2015_05_22_124421_add_reassignable_to_licenses  1
2015_06_10_003314_fix_default_for_user_notes    1
2015_06_10_003554_create_consumables    1
2015_06_15_183253_move_email_to_username    1
2015_06_23_070346_make_email_nullable   1
2015_06_26_213716_create_asset_maintenances_table   1
2015_07_04_212443_create_custom_fields_table    1
2015_07_09_014359_add_currency_to_settings_and_locations    1
2015_07_21_122022_add_expected_checkin_date_to_asset_logs   1
2015_07_24_093845_add_checkin_email_to_category_table   1
2015_07_25_055415_remove_email_unique_constraint    1
2015_07_29_230054_add_thread_id_to_asset_logs_table 1
2015_07_31_015430_add_accepted_to_assets    1
2015_09_09_195301_add_custom_css_to_settings    1
2015_09_21_235926_create_custom_field_custom_fieldset   1
2015_09_22_000104_create_custom_fieldsets   1
2015_09_22_003321_add_fieldset_id_to_assets 1
2015_09_22_003413_migrate_mac_address   1
2015_09_28_003314_fix_default_purchase_order    1
2015_10_01_024551_add_accessory_consumable_price_info   1
2015_10_12_192706_add_brand_to_settings 1
2015_10_22_003314_fix_defaults_accessories  1
2015_10_23_182625_add_checkout_time_and_expected_checkout_date_to_assets    1
2015_11_05_061015_create_companies_table    1
2015_11_05_061115_add_company_id_to_consumables_table   1
2015_11_05_183749_image 1
2015_11_06_092038_add_company_id_to_accessories_table   1
2015_11_06_100045_add_company_id_to_users_table 1
2015_11_06_134742_add_company_id_to_licenses_table  1
2015_11_08_035832_add_company_id_to_assets_table    1
2015_11_08_222305_add_ldap_fields_to_settings   1
2015_11_15_151803_add_full_multiple_companies_support_to_settings_table 1
2015_11_26_195528_import_ldap_settings  1
2015_11_30_191504_remove_fk_company_id  1
2015_12_21_193006_add_ldap_server_cert_ignore_to_settings_table 1
2015_12_30_233509_add_timestamp_and_userId_to_custom_fields 1
2015_12_30_233658_add_timestamp_and_userId_to_custom_fieldsets  1
2016_01_28_041048_add_notes_to_models   1
2016_02_19_070119_add_remember_token_to_users_table 1
2016_02_19_073625_create_password_resets_table  1
2016_03_02_193043_add_ldap_flag_to_users    1
2016_03_02_220517_update_ldap_filter_to_longer_field    1
2016_03_08_225351_create_components_table   1
2016_03_09_024038_add_min_stock_to_tables   1
2016_03_10_133849_add_locale_to_users   1
2016_03_10_135519_add_locale_to_settings    1
2016_03_11_185621_add_label_settings_to_settings    1
2016_03_22_125911_fix_custom_fields_regexes 1
2016_04_28_141554_add_show_to_users 1
2016_05_16_164733_add_model_mfg_to_consumable   1
2016_05_19_180351_add_alt_barcode_settings  1
2016_05_19_191146_add_alter_interval    1
2016_05_19_192226_add_inventory_threshold   1
2016_05_20_024859_remove_option_keys_from_settings_table    1
2016_05_20_143758_remove_option_value_from_settings_table   1
2016_06_01_140218_add_email_domain_and_format_to_settings   1
2016_06_22_160725_add_user_id_to_maintenances   1
2016_07_13_150015_add_is_ad_to_settings 1
2016_07_14_153609_add_ad_domain_to_settings 1
2016_07_22_003348_fix_custom_fields_regex_stuff 1
2016_07_22_054850_one_more_mac_addr_fix 1
2016_07_22_143045_add_port_to_ldap_settings 1
2016_07_22_153432_add_tls_to_ldap_settings  1
2016_07_27_211034_add_zerofill_to_settings  1
2016_08_02_124944_add_color_to_statuslabel  1
2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings 1
2016_08_09_002225_add_manufacturer_to_licenses  1
2016_08_12_121613_add_manufacturer_to_accessories_table 1
2016_08_23_143353_add_new_fields_to_custom_fields   1
2016_08_23_145619_add_show_in_nav_to_status_labels  1
2016_08_30_084634_make_purchase_cost_nullable   1
2016_09_01_141051_add_requestable_to_asset_model    1
2016_09_02_001448_create_checkout_requests_table    1
2016_09_04_180400_create_actionlog_table    1
2016_09_04_182149_migrate_asset_log_to_action_log   1
2016_09_19_235935_fix_fieldtype_for_target_type 1
2016_09_23_140722_fix_modelno_in_consumables_to_string  1
2016_09_28_231359_add_company_to_logs   1
2016_10_14_130709_fix_order_number_to_varchar   1
2016_10_16_015024_rename_modelno_to_model_number    1
2016_10_16_015211_rename_consumable_modelno_to_model_number 1
2016_10_16_143235_rename_model_note_to_notes    1
2016_10_16_165052_rename_component_total_qty_to_qty 1
2016_10_19_145520_fix_order_number_in_components_to_string  1
2016_10_27_151715_add_serial_to_components  1
2016_10_27_213251_increase_serial_field_capacity    1
2016_10_29_002724_enable_2fa_fields 1
2016_10_29_082408_add_signature_to_acceptance   1
2016_11_01_030818_fix_forgotten_filename_in_action_logs 1
2016_11_13_020954_rename_component_serial_number_to_serial  1
2016_11_16_172119_increase_purchase_cost_size   1
2016_11_17_161317_longer_state_field_in_location    1
2016_11_17_193706_add_model_number_to_accessories   1
2016_11_24_160405_add_missing_target_type_to_logs_table 1
2016_12_07_173720_increase_size_of_state_in_suppliers   1

shindelhu commented 7 years ago

Nope, I just got this, then I ran drop the tables, then the database and start it again, as I wrote earlier. Don't spend to many time to debug this, it doesn't worth it. ;) I can delete the containers and database here anytime. Could you just give me some to do list to achieve, what I wrote above: get a working dockerized Snipe-It and migrate data from an existing, older not dockerized environment?

Thanks

snipe commented 7 years ago

I would probably use the upgrade guide to upgrade a non-docker instance, and then migrate that to a docker instance.

shindelhu commented 7 years ago

Nice point, but sounds too easy! ;) We like challenge.

shindelhu commented 7 years ago

Hi @snipe ,

As per your recommendation yesterday, I've upgraded our prod server, as it stated in the documentation, but got an 500 error after the login screen:

The problem is, that I've turned on the debugging mode, but it doesn't show anything on that page.

Could you tell me, what can I do with it?

Here is my migrations table's content, in case you need: mysql> select * from migrations; +--------------------------------------------------------------------------+-------+ | migration | batch | +--------------------------------------------------------------------------+-------+ | 2012_12_06_225921_migration_cartalyst_sentry_install_users | 1 | | 2012_12_06_225929_migration_cartalyst_sentry_install_groups | 1 | | 2012_12_06_225945_migration_cartalyst_sentry_install_users_groups_pivot | 1 | | 2012_12_06_225988_migration_cartalyst_sentry_install_throttle | 1 | | 2013_03_23_193214_update_users_table | 2 | | 2013_11_13_075318_create_models_table | 2 | | 2013_11_13_075335_create_categories_table | 2 | | 2013_11_13_075347_create_manufacturers_table | 2 | | 2013_11_15_015858_add_user_id_to_categories | 2 | | 2013_11_15_112701_add_user_id_to_manufacturers | 2 | | 2013_11_15_190327_create_assets_table | 2 | | 2013_11_15_190357_create_licenses_table | 2 | | 2013_11_15_201848_add_license_name_to_licenses | 2 | | 2013_11_16_040323_create_depreciations_table | 2 | | 2013_11_16_042851_add_depreciation_id_to_models | 2 | | 2013_11_16_084923_add_user_id_to_models | 2 | | 2013_11_16_103258_create_locations_table | 2 | | 2013_11_16_103336_add_location_id_to_assets | 2 | | 2013_11_16_103407_add_checkedout_to_to_assets | 2 | | 2013_11_16_103425_create_history_table | 2 | | 2013_11_17_054359_drop_licenses_table | 2 | | 2013_11_17_054526_add_physical_to_assets | 2 | | 2013_11_17_055126_create_settings_table | 2 | | 2013_11_17_062634_add_license_to_assets | 2 | | 2013_11_18_134332_add_contacts_to_users | 2 | | 2013_11_18_142847_add_info_to_locations | 2 | | 2013_11_18_152942_remove_location_id_from_asset | 2 | | 2013_11_18_164423_set_nullvalues_for_user | 2 | | 2013_11_19_013337_create_asset_logs_table | 2 | | 2013_11_19_061409_edit_added_on_asset_logs_table | 2 | | 2013_11_19_062250_edit_location_id_asset_logs_table | 2 | | 2013_11_20_055822_add_soft_delete_on_assets | 2 | | 2013_11_20_121404_add_soft_delete_on_locations | 2 | | 2013_11_20_123137_add_soft_delete_on_manufacturers | 2 | | 2013_11_20_123725_add_soft_delete_on_categories | 2 | | 2013_11_20_130248_create_status_labels | 2 | | 2013_11_20_130830_add_status_id_on_assets_table | 2 | | 2013_11_20_131544_add_status_type_on_status_labels | 2 | | 2013_11_20_134103_add_archived_to_assets | 2 | | 2013_11_21_002321_add_uploads_table | 2 | | 2013_11_21_024531_remove_deployable_boolean_from_status_labels | 2 | | 2013_11_22_075308_add_option_label_to_settings_table | 2 | | 2013_11_22_213400_edits_to_settings_table | 2 | | 2013_11_25_013244_create_licenses_table | 2 | | 2013_11_25_031458_create_license_seats_table | 2 | | 2013_11_25_032022_add_type_to_actionlog_table | 2 | | 2013_11_25_033008_delete_bad_licenses_table | 2 | | 2013_11_25_033131_create_new_licenses_table | 2 | | 2013_11_25_033534_add_licensed_to_licenses_table | 2 | | 2013_11_25_101308_add_warrantee_to_assets_table | 2 | | 2013_11_25_104343_alter_warranty_column_on_assets | 2 | | 2013_11_25_150450_drop_parent_from_categories | 2 | | 2013_11_25_151920_add_depreciate_to_assets | 2 | | 2013_11_25_152903_add_depreciate_to_licenses_table | 2 | | 2013_11_26_211820_drop_license_from_assets_table | 2 | | 2013_11_27_062510_add_note_to_asset_logs_table | 2 | | 2013_12_01_113426_add_filename_to_asset_log | 2 | | 2013_12_06_094618_add_nullable_to_licenses_table | 2 | | 2013_12_10_084038_add_eol_on_models_table | 2 | | 2013_12_12_055218_add_manager_to_users_table | 2 | | 2014_01_28_031200_add_qr_code_to_settings_table | 2 | | 2014_02_13_183016_add_qr_text_to_settings_table | 2 | | 2014_05_24_093839_alter_default_license_depreciation_id | 2 | | 2014_05_27_231658_alter_default_values_licenses | 2 | | 2014_06_19_191508_add_asset_name_to_settings | 2 | | 2014_06_20_004847_make_asset_log_checkedout_to_nullable | 2 | | 2014_06_20_005050_make_asset_log_purchasedate_to_nullable | 2 | | 2014_06_24_003011_add_suppliers | 2 | | 2014_06_24_010742_add_supplier_id_to_asset | 2 | | 2014_06_24_012839_add_zip_to_supplier | 2 | | 2014_06_24_033908_add_url_to_supplier | 2 | | 2014_07_08_054116_add_employee_id_to_users | 2 | | 2014_07_09_134316_add_requestable_to_assets | 2 | | 2014_07_17_085822_add_asset_to_software | 2 | | 2014_07_17_161625_make_asset_id_in_logs_nullable | 2 | | 2014_08_12_053504_alpha_0_4_2_release | 2 | | 2014_08_17_083523_make_location_id_nullable | 2 | | 2014_10_16_200626_add_rtd_location_to_assets | 2 | | 2014_10_24_000417_alter_supplier_state_to_32 | 2 | | 2014_10_24_015641_add_display_checkout_date | 2 | | 2014_10_28_222654_add_avatar_field_to_users_table | 2 | | 2014_10_29_045924_add_image_field_to_models_table | 2 | | 2014_11_01_214955_add_eol_display_to_settings | 2 | | 2014_11_04_231416_update_group_field_for_reporting | 2 | | 2014_11_05_212408_add_fields_to_licenses | 2 | | 2014_11_07_021042_add_image_to_supplier | 2 | | 2014_11_20_203007_add_username_to_user | 2 | | 2014_11_20_223947_add_auto_to_settings | 2 | | 2014_11_20_224421_add_prefix_to_settings | 2 | | 2014_11_21_104401_change_licence_type | 2 | | 2014_12_09_082500_add_fields_maintained_term_to_licenses | 2 | | 2015_02_04_155757_increase_user_field_lengths | 2 | | 2015_02_07_013537_add_soft_deleted_to_log | 2 | | 2015_02_10_040958_fix_bad_assigned_to_ids | 2 | | 2015_02_10_053310_migrate_data_to_new_statuses | 2 | | 2015_02_11_044104_migrate_make_license_assigned_null | 2 | | 2015_02_11_104406_migrate_create_requests_table | 2 | | 2015_02_12_001312_add_mac_address_to_asset | 2 | | 2015_02_12_024100_change_license_notes_type | 2 | | 2015_02_17_231020_add_localonly_to_settings | 2 | | 2015_02_19_222322_add_logo_and_colors_to_settings | 2 | | 2015_02_24_072043_add_alerts_to_settings | 2 | | 2015_02_25_022931_add_eula_fields | 2 | | 2015_02_25_204513_add_accessories_table | 2 | | 2015_02_26_091228_add_accessories_user_table | 2 | | 2015_02_26_115128_add_deleted_at_models | 2 | | 2015_02_26_233005_add_category_type | 2 | | 2015_03_01_231912_update_accepted_at_to_acceptance_id | 2 | | 2015_03_05_011929_add_qr_type_to_settings | 2 | | 2015_03_18_055327_add_note_to_user | 2 | | 2015_04_29_234704_add_slack_to_settings | 2 | | 2015_05_04_085151_add_parent_id_to_locations_table | 2 | | 2015_05_22_124421_add_reassignable_to_licenses | 2 | | 2015_06_10_003314_fix_default_for_user_notes | 2 | | 2015_06_10_003554_create_consumables | 2 | | 2015_06_15_183253_move_email_to_username | 2 | | 2015_06_23_070346_make_email_nullable | 2 | | 2015_06_26_213716_create_asset_maintenances_table | 2 | | 2015_07_04_212443_create_custom_fields_table | 2 | | 2015_07_09_014359_add_currency_to_settings_and_locations | 2 | | 2015_07_21_122022_add_expected_checkin_date_to_asset_logs | 2 | | 2015_07_24_093845_add_checkin_email_to_category_table | 2 | | 2015_07_25_055415_remove_email_unique_constraint | 2 | | 2015_07_29_230054_add_thread_id_to_asset_logs_table | 2 | | 2015_07_31_015430_add_accepted_to_assets | 2 | | 2015_09_09_195301_add_custom_css_to_settings | 2 | | 2015_09_21_235926_create_custom_field_custom_fieldset | 2 | | 2015_09_22_000104_create_custom_fieldsets | 2 | | 2015_09_22_003321_add_fieldset_id_to_assets | 2 | | 2015_09_22_003413_migrate_mac_address | 2 | | 2015_09_28_003314_fix_default_purchase_order | 2 | | 2015_10_01_024551_add_accessory_consumable_price_info | 2 | | 2015_10_12_192706_add_brand_to_settings | 2 | | 2015_10_22_003314_fix_defaults_accessories | 2 | | 2015_10_23_182625_add_checkout_time_and_expected_checkout_date_to_assets | 2 | | 2015_11_05_061015_create_companies_table | 2 | | 2015_11_05_061115_add_company_id_to_consumables_table | 2 | | 2015_11_05_183749_image | 2 | | 2015_11_06_092038_add_company_id_to_accessories_table | 2 | | 2015_11_06_100045_add_company_id_to_users_table | 2 | | 2015_11_06_134742_add_company_id_to_licenses_table | 2 | | 2015_11_08_035832_add_company_id_to_assets_table | 2 | | 2015_11_08_222305_add_ldap_fields_to_settings | 2 | | 2015_11_15_151803_add_full_multiple_companies_support_to_settings_table | 2 | | 2015_11_26_195528_import_ldap_settings | 2 | | 2015_11_30_191504_remove_fk_company_id | 2 | | 2015_12_21_193006_add_ldap_server_cert_ignore_to_settings_table | 2 | | 2015_12_30_233509_add_timestamp_and_userId_to_custom_fields | 2 | | 2015_12_30_233658_add_timestamp_and_userId_to_custom_fieldsets | 2 | | 2016_01_28_041048_add_notes_to_models | 2 | | 2016_02_19_070119_add_remember_token_to_users_table | 3 | | 2016_02_19_073625_create_password_resets_table | 3 | | 2016_03_02_193043_add_ldap_flag_to_users | 3 | | 2016_03_02_220517_update_ldap_filter_to_longer_field | 3 | | 2016_03_08_225351_create_components_table | 3 | | 2016_03_09_024038_add_min_stock_to_tables | 3 | | 2016_03_10_133849_add_locale_to_users | 3 | | 2016_03_10_135519_add_locale_to_settings | 3 | | 2016_03_11_185621_add_label_settings_to_settings | 3 | | 2016_03_22_125911_fix_custom_fields_regexes | 3 | | 2016_04_28_141554_add_show_to_users | 3 | | 2016_05_16_164733_add_model_mfg_to_consumable | 3 | | 2016_05_19_180351_add_alt_barcode_settings | 3 | | 2016_05_19_191146_add_alter_interval | 3 | | 2016_05_19_192226_add_inventory_threshold | 3 | | 2016_05_20_024859_remove_option_keys_from_settings_table | 3 | | 2016_05_20_143758_remove_option_value_from_settings_table | 3 | | 2016_06_01_140218_add_email_domain_and_format_to_settings | 3 | | 2016_06_22_160725_add_user_id_to_maintenances | 3 | | 2016_07_13_150015_add_is_ad_to_settings | 3 | | 2016_07_14_153609_add_ad_domain_to_settings | 3 | | 2016_07_22_003348_fix_custom_fields_regex_stuff | 3 | | 2016_07_22_054850_one_more_mac_addr_fix | 3 | | 2016_07_22_143045_add_port_to_ldap_settings | 3 | | 2016_07_22_153432_add_tls_to_ldap_settings | 3 | | 2016_07_27_211034_add_zerofill_to_settings | 3 | | 2016_08_02_124944_add_color_to_statuslabel | 3 | | 2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings | 3 | | 2016_08_09_002225_add_manufacturer_to_licenses | 3 | | 2016_08_12_121613_add_manufacturer_to_accessories_table | 3 | | 2016_08_23_143353_add_new_fields_to_custom_fields | 3 | | 2016_08_23_145619_add_show_in_nav_to_status_labels | 3 | | 2016_08_30_084634_make_purchase_cost_nullable | 3 | | 2016_09_01_141051_add_requestable_to_asset_model | 3 | | 2016_09_02_001448_create_checkout_requests_table | 3 | | 2016_09_04_180400_create_actionlog_table | 3 | | 2016_09_04_182149_migrate_asset_log_to_action_log | 3 | | 2016_09_19_235935_fix_fieldtype_for_target_type | 3 | | 2016_09_23_140722_fix_modelno_in_consumables_to_string | 3 | | 2016_09_28_231359_add_company_to_logs | 3 | | 2016_10_14_130709_fix_order_number_to_varchar | 3 | | 2016_10_16_015024_rename_modelno_to_model_number | 3 | | 2016_10_16_015211_rename_consumable_modelno_to_model_number | 3 | | 2016_10_16_143235_rename_model_note_to_notes | 3 | | 2016_10_16_165052_rename_component_total_qty_to_qty | 3 | | 2016_10_19_145520_fix_order_number_in_components_to_string | 3 | | 2016_10_27_151715_add_serial_to_components | 3 | | 2016_10_27_213251_increase_serial_field_capacity | 3 | | 2016_10_29_002724_enable_2fa_fields | 3 | | 2016_10_29_082408_add_signature_to_acceptance | 3 | | 2016_11_01_030818_fix_forgotten_filename_in_action_logs | 3 | | 2016_11_13_020954_rename_component_serial_number_to_serial | 3 | | 2016_11_16_172119_increase_purchase_cost_size | 3 | | 2016_11_17_161317_longer_state_field_in_location | 3 | | 2016_11_17_193706_add_model_number_to_accessories | 3 | | 2016_11_24_160405_add_missing_target_type_to_logs_table | 3 | | 2016_12_07_173720_increase_size_of_state_in_suppliers | 3 | +--------------------------------------------------------------------------+-------+ 207 rows in set (0.00 sec)

Thanks

shindelhu commented 7 years ago

Hi @snipe,

I've found the issue, I was reading through documentation and the forum, and found, that the storage folder's right has to be checked. So I did that, and the laravel.log file was owned by the root, changed to apache and voila, it works.

Thanks

This can be closed now.

shindelhu commented 7 years ago

Hi @snipe,

As I wrote earlier, I've managed to get the update work on our prod server. Now as you recommended, copied over the sql file to the test docker environment and wanted to migrate data. First I faced the issue, there is no compose.phar file in the conatiner, so I've copied over one. Now, when I ran php composer.phar install --no-dev --prefer-source I got this:

Loading composer repositories with package information Installing dependencies from lock file Package operations: 0 installs, 0 updates, 33 removals

Removing squizlabs/php_codesniffer (2.6.2)
Removing phpspec/phpspec (2.5.1)
Removing phpspec/php-diff (v1.0.2)
Removing mockery/mockery (0.9.5)
Removing hamcrest/hamcrest-php (v1.2.2)
Removing fzaninotto/faker (v1.6.0)
Removing codeception/codeception (2.1.11)
Removing facebook/webdriver (1.1.3)
Removing phpunit/phpunit (4.8.27)
Removing phpspec/prophecy (v1.6.1)
Removing phpdocumentor/reflection-docblock (3.1.0)
Removing phpdocumentor/type-resolver (0.2)
Removing phpdocumentor/reflection-common (1.0)
Removing webmozart/assert (1.1.0)
Removing phpunit/php-code-coverage (2.2.4)
Removing phpunit/php-token-stream (1.4.8)
Removing phpunit/php-file-iterator (1.4.1)
Removing phpunit/php-timer (1.0.8)
Removing phpunit/phpunit-mock-objects (2.3.8)
Removing doctrine/instantiator (1.0.5)
Removing phpunit/php-text-template (1.2.1)
Removing sebastian/comparator (1.2.0)
Removing sebastian/diff (1.4.1)
Removing sebastian/environment (1.3.8)
Removing sebastian/exporter (1.2.2)
Removing sebastian/recursion-context (1.0.2)
Removing sebastian/global-state (1.1.1)
Removing sebastian/version (1.0.6)
Removing symfony/browser-kit (v3.1.3)
Removing symfony/css-selector (v3.1.3)
Removing symfony/dom-crawler (v3.1.3)
Removing symfony/yaml (v3.1.3)
Removing codeception/c3 (2.0.7) Generating autoload files

[ErrorException] md5_file(/var/www/html/vendor/codeception/c3/c3.php): failed to open stream: No such file or directory

Could you help me with this?

Thanks

shindelhu commented 7 years ago

I got this sorted after the upgrade by this : https://github.com/snipe/snipe-it/issues/2497. I close it now.

Thanks

snipe / snipe-it

Migrate to docker #3462