Personal API Keys page is empty

[irefuse]

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

• [ X ] I have enabled debug mode
• [ X ] I have read checked the Common Issues page

Describe the bug
When navigating to the "Manage API Keys" page, nothing will display except the words "Personal API Keys." When I turn on debug mode, the page will load fully, but there is a log message that's displayed showing the below:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'snipeit.oauth_personal_access_clients' doesn't exist (SQL: select * from oauth_personal_access_clients order by id desc limit 1)

To Reproduce
Steps to reproduce the behavior:

1. Go to the "Manage API Keys" page
2. Nothing shows up

Expected behavior
being able create API keys

Screenshots

Server (please complete the following information):

• Snipe-IT Version 4.9.0
• OS: Windows Server 2012 R2
• Web Server: IIS 8.5
• PHP Version 7.3.16

Desktop (please complete the following information):

• OS: Windows 10
• Browser: Edge Chromium and Chrome
• Version: 81.0.416.34 and 80.0.3987.146 (respectively)

Error Messages

• WITH DEBUG TURNED ON, if you're getting an error in your browser, include that error
  error
  [2020-03-23 11:01:02] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'snipeit.oauth_access_tokens' doesn't exist (SQL: select * from oauth_access_tokens where user_id = 662) {"userId":662,"email":"","exception":"[object] (Illuminate\Database\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'snipeit.oauth_access_tokens' doesn't exist (SQL: select * from oauth_access_tokens where user_id = 662) at C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664, Doctrine\DBAL\Driver\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'snipeit.oauth_access_tokens' doesn't exist at C:\inetpub\SnipeIT\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:63, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'snipeit.oauth_access_tokens' doesn't exist at C:\inetpub\SnipeIT\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:61)Show months until asset is fully depreciated #55 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
  Disable sorting on action column #56 C:\inetpub\SnipeIT\app\Http\Middleware\NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
  Spaces get filtered out #57 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
  Modal stops passing title/message/href through if modal is canceled #58 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
  Checkin message is wrong #59 C:\inetpub\SnipeIT\app\Http\Middleware\ContentSecurityPolicyHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
  CSRF protect all of the things #60 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\ContentSecurityPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
  DB seed fails when mysql is in strict mode #61 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
  Add 'retired' status #62 C:\inetpub\SnipeIT\app\Http\Middleware\ReferrerPolicyHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
  Asset Notes #63 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\ReferrerPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
  Notifications for when warranties are expiring... #64 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
  Invalid SQL #65 C:\inetpub\SnipeIT\app\Http\Middleware\XssProtectHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
  Broken Gravatar URL in SSL-only environments #66 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
  Patch 1 #67 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
  Fix insecure content warnings #68 C:\inetpub\SnipeIT\app\Http\Middleware\FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
  Initial install script failing on db installation, tries to drop tables that don't exist #69 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
  Modify the Assets and Licenses controllers and database schemas to work #70 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
  Can't edit address fields on locations #71 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
  Add address to location form #72 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
  Email input types #73 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
  change location to status on assets table header #74 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
  License Count misreporting #75 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
  Purchase as separate entity #76 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
  Allow '+' in Model Name & No #77 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
  Expand Manufacturer #78 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
  Services Management Section [big, needs fleshing out] #79 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
  Re-jigger the asset displays to make "more info" more prominent #80 C:\inetpub\SnipeIT\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
  File uploads #81 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Barryvdh\Cors\HandlePreflight->handle(Object(Illuminate\Http\Request), Object(Closure))
  allow more characters in model name (and number) #82 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
  Ignoring production configs #83 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
  Gitignore clean #84 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
  Replace enumeration of files with wildcard #85 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
  Cancel and back buttons on edit forms now take you back properly #86 C:\inetpub\SnipeIT\public\index.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
  Make jquery data tables responsive #87 {main}

• If a stacktrace is provided in the error, include that too.

• Any errors that appear in your browser's error console.
  GET https:///oauth/personal-access-tokens 500 (Internal Server Error)
    | (anonymous) | @ | all.js?id=bf1b244…:4
  -- | -- | -- | --
    | s | @ | all.js?id=bf1b244…:4
    | k | @ | all.js?id=bf1b244…:4
    | T | @ | all.js?id=bf1b244…:4
    | e | @ | all.js?id=bf1b244…:4
    | A | @ | all.js?id=bf1b244…:4
    | A. | @ | all.js?id=bf1b244…:4
    | getTokens | @ | all.js?id=bf1b244…:21
    | i | @ | all.js?id=bf1b244…:5
    | prepareComponent | @ | all.js?id=bf1b244…:21
    | i | @ | all.js?id=bf1b244…:5
    | mounted | @ | all.js?id=bf1b244…:21
    | ut | @ | all.js?id=bf1b244…:5
    | insert | @ | all.js?id=bf1b244…:6
    | b | @ | all.js?id=bf1b244…:7
    | (anonymous) | @ | all.js?id=bf1b244…:7
    | t._update | @ | all.js?id=bf1b244…:7
    | n | @ | all.js?id=bf1b244…:7
    | I3G/.En.get | @ | all.js?id=bf1b244…:6
    | En | @ | all.js?id=bf1b244…:6
    | (anonymous) | @ | all.js?id=bf1b244…:7
    | I3G/.Pt.$mount | @ | all.js?id=bf1b244…:7
    | I3G/.Pt.$mount | @ | all.js?id=bf1b244…:7
    | I3G/.Pt._init | @ | all.js?id=bf1b244…:7
    | Pt | @ | all.js?id=bf1b244…:5
    | (anonymous) | @ | api:651
  api:1 Uncaught (in promise) U {url: "https:///oauth/personal-access-tokens", ok: false, status: 500, statusText: "Internal Server Error", headers: W, …}body: {message: "SQLSTATE[42S02]: Base table or view not found: 114…from oauth_access_tokens where user_id = 662)", exception: "Illuminate\Database\QueryException", file: "C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Database\Connection.php", line: 664, trace: Array(87)}bodyText: "{↵ "message": "SQLSTATE[42S02]: Base table or v"headers: W {map: {…}}ok: falsestatus: 500statusText: "Internal Server Error"url: "https://snipeit.smartcu.org/oauth/personal-access-tokens"data: (...)proto: Object

• Confirm whether the error is reproducible on the demo: https://snipeitapp.com/demo.
  demo has this feature disabled.

• Include any additional information you can find in storage/logs and your webserver's logs.
  [2020-03-23 11:01:02] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'snipeit.oauth_access_tokens' doesn't exist (SQL: select * from oauth_access_tokens where user_id = 662) {"userId":662,"email":"[email protected]","exception":"[object] (Illuminate\Database\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'snipeit.oauth_access_tokens' doesn't exist (SQL: select * from oauth_access_tokens where user_id = 662) at C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664, Doctrine\DBAL\Driver\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'snipeit.oauth_access_tokens' doesn't exist at C:\inetpub\SnipeIT\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:63, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'snipeit.oauth_access_tokens' doesn't exist at C:\inetpub\SnipeIT\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:61)
  [stacktrace]
  #0 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select * from ...', Array, Object(Closure)) #1 C:\\inetpub\\SnipeIT\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(333): Illuminate\\Database\\Connection->run('select * from ...', Array, Object(Closure))
  Ability for admin to check out an asset to a user #2 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1719): Illuminate\Database\Connection->select('select * from `...', Array, true)
  Add reports - depreciation, people with no assets, etc #3 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1704): Illuminate\Database\Query\Builder->runSelect()
  Add category back to Models blade/controller #4 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(481): Illuminate\Database\Query\Builder->get(Array)
  Needs sexy dashboard summary #5 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(465): Illuminate\Database\Eloquent\Builder->getModels(Array)
  Disallow models/depreciations/categories to be deleted if they have assets associated #6 C:\inetpub\SnipeIT\vendor\laravel\passport\src\TokenRepository.php(52): Illuminate\Database\Eloquent\Builder->get()
  Add location to users, propagate those to assets #7 C:\inetpub\SnipeIT\vendor\laravel\passport\src\Http\Controllers\PersonalAccessTokenController.php(49): Laravel\Passport\TokenRepository->forUser(662)
  Figure out how to handle multi-seat licenses #8 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(48): Laravel\Passport\Http\Controllers\PersonalAccessTokenController->forUser(Object(Illuminate\Http\Request))
  Search box isn't hooked up to anything #9 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Route.php(212): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Laravel\Passport\Http\Controllers\PersonalAccessTokenController), 'forUser')
  Improve UI of category display to show nesting #10 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Route.php(169): Illuminate\Routing\Route->runController()
  Build-out ACLs to set who can view which sections (reports, etc) #11 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Router.php(658): Illuminate\Routing\Route->run()
  A user (non-admin) should be able to request an asset [$15] #12 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Column sorting on table displays #13 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Auth\Middleware\Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Add "clone" option in edit screen for assets #14 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
  Option to mark assets as requestable. #15 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Child assets linked to parent assets (HDD, replacement parts, etc) [$100] #16 C:\inetpub\SnipeIT\vendor\laravel\passport\src\Http\Middleware\CreateFreshApiToken.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Add warrantee field to assets/models #17 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Laravel\Passport\Http\Middleware\CreateFreshApiToken->handle(Object(Illuminate\Http\Request), Object(Closure))
  Move validation out of the controllers and into the models where it belongs #18 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Seed database with models, manufacturers, categories, etc. #19 C:\inetpub\SnipeIT\app\Http\Middleware\CheckForTwoFactor.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Import functions for users, assets, models, etc #20 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\CheckForTwoFactor->handle(Object(Illuminate\Http\Request), Object(Closure))
  Merge licenses table into assets table #21 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Fix depreciation on model vs asset #22 C:\inetpub\SnipeIT\app\Http\Middleware\CheckLocale.php(42): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Support multiple companies [$500 awarded] #23 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\CheckLocale->handle(Object(Illuminate\Http\Request), Object(Closure))
  Tighten up checkin/checkout UX #24 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Show number of assets for each asset model in listing page #25 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(68): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Handle errors more sanely when nothing in the DB #26 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
  Depreciation fix #27 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Fix tables on mobile #28 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Integrate barcode generation #29 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
  Confirmation screens on delete #30 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Fixing bootstrap process with default values. #31 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(66): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Added confirmation popups for deletes #32 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
  Add notion of lost, stolen, out for deployment, RTD, etc #33 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Update asset index/view blade to reflect new status  #34 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Add CSV export for reports #35 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Router.php(660): Illuminate\Pipeline\Pipeline->then(Object(Closure))
  Make the Edit Profile page look less assy #36 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Router.php(635): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
  incorrect command chown in README #37 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Router.php(601): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
  Develop #38 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Router.php(590): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
  Implement settings  #39 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
  Settings edit #40 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
  Add asset_type to Asset controller #41 C:\inetpub\SnipeIT\vendor\barryvdh\laravel-debugbar\src\Middleware\InjectDebugbar.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Fix delete-check on licenses #42 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Barryvdh\Debugbar\Middleware\InjectDebugbar->handle(Object(Illuminate\Http\Request), Object(Closure))
  Fix checkout for licenses #43 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Fix depreciation report with new licenses structure #44 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  When you soft-delete a user, should free up all associated resources  #45 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
  Fix miscount on assets in user view #46 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  When the number of seats is edited, handle that smartly #47 C:\inetpub\SnipeIT\app\Http\Middleware\CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  LDAP authentication #48 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))
  Calendar view(s) for asset check out/in, due date, etc. [$20] #49 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  XSS Issues #50 C:\inetpub\SnipeIT\app\Http\Middleware\CheckForSetup.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Add postcode to locations #51 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))
  Make the report columns sortable #52 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Add autocomplete to the search box #53 C:\inetpub\SnipeIT\vendor\fideloper\proxy\src\TrustProxies.php(57): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  New button weirdly placed on my iPad (3rd gen) #54 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
  Show months until asset is fully depreciated #55 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Disable sorting on action column #56 C:\inetpub\SnipeIT\app\Http\Middleware\NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Spaces get filtered out #57 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
  Modal stops passing title/message/href through if modal is canceled #58 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Checkin message is wrong #59 C:\inetpub\SnipeIT\app\Http\Middleware\ContentSecurityPolicyHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  CSRF protect all of the things #60 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\ContentSecurityPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
  DB seed fails when mysql is in strict mode #61 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Add 'retired' status #62 C:\inetpub\SnipeIT\app\Http\Middleware\ReferrerPolicyHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Asset Notes #63 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\ReferrerPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
  Notifications for when warranties are expiring... #64 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Invalid SQL #65 C:\inetpub\SnipeIT\app\Http\Middleware\XssProtectHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Broken Gravatar URL in SSL-only environments #66 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
  Patch 1 #67 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Fix insecure content warnings #68 C:\inetpub\SnipeIT\app\Http\Middleware\FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Initial install script failing on db installation, tries to drop tables that don't exist #69 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
  Modify the Assets and Licenses controllers and database schemas to work #70 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Can't edit address fields on locations #71 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Add address to location form #72 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
  Email input types #73 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  change location to status on assets table header #74 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  License Count misreporting #75 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
  Purchase as separate entity #76 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Allow '+' in Model Name & No #77 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Expand Manufacturer #78 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
  Services Management Section [big, needs fleshing out] #79 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Re-jigger the asset displays to make "more info" more prominent #80 C:\inetpub\SnipeIT\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  File uploads #81 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(149): Barryvdh\Cors\HandlePreflight->handle(Object(Illuminate\Http\Request), Object(Closure))
  allow more characters in model name (and number) #82 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
  Ignoring production configs #83 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
  Gitignore clean #84 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
  Replace enumeration of files with wildcard #85 C:\inetpub\SnipeIT\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
  Cancel and back buttons on edit forms now take you back properly #86 C:\inetpub\SnipeIT\public\index.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
  Make jquery data tables responsive #87 {main}
  "}

Additional context

• Is this a fresh install or an upgrade?
  Fresh install
• What OS and web server you're running Snipe-IT on
  Windows Server 2012 R2 with IIS 8.5
• What method you used to install Snipe-IT (install.sh, manual installation, docker, etc)
  manual install using Git as the source
• Include what you've done so far in the installation, and if you got any error messages along the way.
  installed, Location creation, LDAP import, add single asset and issue to end user. then attempted to check out the API section. No errors until the API section
• Indicate whether or not you've manually edited any data directly in the database
  I have not

Add any other context about the problem here.

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.

[stale]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

[stale]

This issue has been automatically closed because it has not had recent activity. If you believe this is still an issue, please confirm that this issue is still happening in the most recent version of Snipe-IT and reply to this thread to re-open it.

[uafaruqi]

Is this fixed? I am having same issue on build 4.9.3

[silver0a1]

same issue here new install

[silver0a1]

Was this ever fixed? I have the same issue

[snipe]

This issue was never an issue to begin with. Whenever there is a "table not found" error, it means that migrations were never run. If you're seeing a different error, please create a new issue.