snipe / snipe-it

A free open source IT asset/license management system
https://snipeitapp.com
GNU Affero General Public License v3.0
11.01k stars 3.18k forks source link

Check In, Check out Whoops error related to migrations #5856

Closed wesleytb13 closed 6 years ago

wesleytb13 commented 6 years ago

Expected Behavior (or desired behavior if a feature request)

Check In/Check out Items without an error.


Actual Behavior

I get a Whoops every time we check something in or out and it's not putting a Check In entry in the history of items showing where it was checked in - even though it is marking the items as checked in.

I did some searching for possible fixes and saw where this was related to possibly needing to do a migration and I tried to do a migration and am getting errors when trying to do that. This is where I am getting lost in trying to fix the issue. Not sure how to proceed with the error being given. I found another issue with a similar error and it had something to do with the migration tables not updating properly and the fix was to Insert an entry in the migration table but I didn't want to try that without having someone look at what I am getting first.

Please confirm you have done the following before posting your bug report:


Provide answers to these questions:

(3/3) QueryExceptionSQLSTATE[42S22]: Column not found: 1054 Unknown column 'checkin_counter' in 'field list' (SQL: update assets set checkin_counter = checkin_counter + 1, updated_at = 2018-07-16 13:50:35 where id = 993 and assets.deleted_at is null)

in Connection.php (line 647) at Connection->runQueryCallback('update assets set checkin_counter = checkin_counter + 1, updated_at = ? where id = ? and assets.deleted_at is null', array('2018-07-16 13:50:35', 993), object(Closure))in Connection.php (line 607) at Connection->run('update assets set checkin_counter = checkin_counter + 1, updated_at = ? where id = ? and assets.deleted_at is null',array('2018-07-16 13:50:35', 993), object(Closure))in Connection.php (line 477) at Connection->affectingStatement('update assets set checkin_counter = checkin_counter + 1, updated_at = ? where id = ? and assets.deleted_at is null', array('2018-07-16 13:50:35', 993))in Connection.php (line 416) at Connection->update('update assets set checkin_counter = checkin_counter + 1, updated_at = ? where id = ? and assets.deleted_at is null',array('2018-07-16 13:50:35', 993))in Builder.php (line 2147) at Builder->update(array('checkin_counter' => object(Expression), 'updated_at' => '2018-07-16 13:50:35'))in Builder.php (line 2185) at Builder->increment('checkin_counter', 1, array('updated_at' => '2018-07-16 13:50:35'))in Builder.php (line 773) at Builder->increment('checkin_counter', 1, array())in Model.php (line 428) at Model->incrementOrDecrement('checkin_counter', 1, array(), 'increment')in Model.php (line 391) at Model->increment('checkin_counter', 1)in Loggable.php (line 131) at Asset->logCheckin(object(User), '')in AssetsController.php (line 585) at AssetsController->postCheckin(object(AssetCheckinRequest), '993', null) at call_user_func_array(array(object(AssetsController), 'postCheckin'), array(object(AssetCheckinRequest), 'assetId' => '993', null))in Controller.php (line 55) at Controller->callAction('postCheckin', array(object(AssetCheckinRequest), 'assetId' => '993', null))in ControllerDispatcher.php (line 44) at ControllerDispatcher->dispatch(object(Route), object(AssetsController), 'postCheckin')in Route.php (line 203) at Route->runController()in Route.php (line 160) at Route->run()in Router.php (line 572) at Router->Illuminate\Routing{closure}(object(Request))in Pipeline.php (line 30) at Pipeline->Illuminate\Routing{closure}(object(Request))in Authenticate.php (line 43) at Authenticate->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in CreateFreshApiToken.php (line 49) at CreateFreshApiToken->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForTwoFactor.php (line 49) at CheckForTwoFactor->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckLocale.php (line 42) at CheckLocale->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in VerifyCsrfToken.php (line 65) at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in AddQueuedCookiesToResponse.php (line 37) at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in EncryptCookies.php (line 59) at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in Pipeline.php (line 102) at Pipeline->then(object(Closure))in Router.php (line 574) at Router->runRouteWithinStack(object(Route), object(Request))in Router.php (line 533) at Router->dispatchToRoute(object(Request))in Router.php (line 511) at Router->dispatch(object(Request))in Kernel.php (line 176) at Kernel->Illuminate\Foundation\Http{closure}(object(Request))in Pipeline.php (line 30) at Pipeline->Illuminate\Routing{closure}(object(Request))in Debugbar.php (line 51) at Debugbar->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForDebug.php (line 25) at CheckForDebug->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in TrustProxies.php (line 56) at TrustProxies->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForSetup.php (line 27) at CheckForSetup->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in NosniffGuard.php (line 17) at NosniffGuard->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in ContentSecurityPolicyHeader.php (line 18) at ContentSecurityPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in ReferrerPolicyHeader.php (line 17) at ReferrerPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in XssProtectHeader.php (line 18) at XssProtectHeader->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in FrameGuard.php (line 17) at FrameGuard->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in ShareErrorsFromSession.php (line 49) at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in StartSession.php (line 64) at StartSession->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForMaintenanceMode.php (line 46) at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php (line 148) at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php (line 53) at Pipeline->Illuminate\Routing{closure}(object(Request))in Pipeline.php (line 102) at Pipeline->then(object(Closure))in Kernel.php (line 151) at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php (line 116) at Kernel->handle(object(Request))in index.php (line 58)

Please do not post an issue without answering the related questions above. If you have opened a different issue and already answered these questions, answer them again, once for every ticket. It will be next to impossible for us to help you.

https://snipe-it.readme.io/docs/getting-help

wesleytb13 commented 6 years ago
snipe commented 6 years ago

What's the error you're getting when you run migrations?

wesleytb13 commented 6 years ago

I must have accidentally cut that out with the logs - sorry. I get the following error when I run php artisan migrate:

In Connection.php line 647:

SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'action_logs_target_id_target_type_index ' (SQL: alter table action_logs add index action_logs_target_id_target_type_index(target_id, target_type))

In PDOStatement.php line 107:

SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'action_logs_target_id_target_type_index '

In PDOStatement.php line 105:

SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'action_logs_target_id_target_type_index '

snipe commented 6 years ago

https://snipe-it.readme.io/docs/installation-issues#section-duplicate-key-name-action_logs_target_id_target_type_index