Users page empty / individual users cause Error 500

[reardonp-fps]

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
A clear and concise description of what the bug is.

After an upgrade from 4.9.4 to 5.1.3 and various other permission issues/other issues, Snipe-IT is running almost fully. However, the People/Users page is completely blank, and trying to go into a single user page (e.g. http:///users/1) throws an Error 500.

The users are still in the database and assets can still be assigned.

Thank you!

Screenshots
If applicable, add screenshots to help explain your problem.

Server (please complete the following information):

• Snipe-IT Version
• OS: Windows Server 2012 R2
• Web Server: IIS
• PHP Version: 7.4.8

Desktop (please complete the following information):

• OS: Windows 10 20H2
• Browser Chrome 89

Error Messages

• WITH DEBUG TURNED ON, if you're getting an error in your browser, include that error
• If a stacktrace is provided in the error, include that too.
  Illuminate \ Database \ QueryException (42S22)
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accessories_users.note' in 'field list' (SQL: select accessories.*, accessories_users.assigned_to as pivot_assigned_to, accessories_users.accessory_id as pivot_accessory_id, accessories_users.id as pivot_id, accessories_users.created_at as pivot_created_at, accessories_users.note as pivot_note from accessories inner join accessories_users on accessories.id = accessories_users.accessory_id where accessories_users.assigned_to in (1))
  Previous exceptions
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accessories_users.note' in 'field list' (42S22)
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accessories_users.note' in 'field list' (42S22)

C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php
* @param array $bindings
* @param \Closure $callback
* @return mixed
*
* @throws \Illuminate\Database\QueryException
*/
protected function runQueryCallback($query, $bindings, Closure $callback)
{
// To execute the statement, we'll simply call the callback, which will actually
// run the SQL against the PDO connection. Then we can calculate the time it
// took to execute and log the query SQL, bindings and time in our memory.
try {
$result = $callback($query, $bindings);
}

    // If an exception occurs when attempting to run a query, we'll format the error
    // message to include the bindings with SQL, which will make this exception a
    // lot more helpful to the developer instead of just the database's errors.
    catch (Exception $e) {
        throw new QueryException(
            $query, $this->prepareBindings($bindings), $e
        );
    }

    return $result;
}

/**
 * Log a query in the connection's query log.
 *
 * @param  string  $query
 * @param  array  $bindings
 * @param  float|null  $time
 * @return void
 */
public function logQuery($query, $bindings, $time = null)
{
    $this->event(new QueryExecuted($query, $bindings, $time, $this));

    if ($this->loggingQueries) {

Arguments
"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accessories_users.note' in 'field list' (SQL: select accessories.*, accessories_users.assigned_to ▶"

• Confirm whether the error is reproducible on the demo: https://snipeitapp.com/demo. No.
• Include any additional information you can find in storage/logs and your webserver's logs.
• [previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accessories_users.note' in 'field list' at C:\inetpub\wwwroot\snipe-it\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:67)
  [stacktrace]
  #0 C:\inetpub\wwwroot\snipe-it\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(67): PDO->prepare()
  Fix depreciation math #1 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(331): Doctrine\DBAL\Driver\PDOConnection->prepare()
  Ability for admin to check out an asset to a user #2 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(662): Illuminate\Database\Connection->Illuminate\Database\{closure}()
  Add reports - depreciation, people with no assets, etc #3 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(629): Illuminate\Database\Connection->runQueryCallback()
  Add category back to Models blade/controller #4 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(338): Illuminate\Database\Connection->run()
  Needs sexy dashboard summary #5 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2159): Illuminate\Database\Connection->select()
  Disallow models/depreciations/categories to be deleted if they have assets associated #6 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2147): Illuminate\Database\Query\Builder->runSelect()
  Add location to users, propagate those to assets #7 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2619): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
  Figure out how to handle multi-seat licenses #8 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2148): Illuminate\Database\Query\Builder->onceWithColumns()
  Search box isn't hooked up to anything #9 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(546): Illuminate\Database\Query\Builder->get()
  Improve UI of category display to show nesting #10 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\BelongsToMany.php(650): Illuminate\Database\Eloquent\Builder->getModels()
  Build-out ACLs to set who can view which sections (reports, etc) #11 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\Relation.php(144): Illuminate\Database\Eloquent\Relations\BelongsToMany->get()
  A user (non-admin) should be able to request an asset [$15] #12 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(594): Illuminate\Database\Eloquent\Relations\Relation->getEager()
  Column sorting on table displays #13 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(563): Illuminate\Database\Eloquent\Builder->eagerLoadRelation()
  Add "clone" option in edit screen for assets #14 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(531): Illuminate\Database\Eloquent\Builder->eagerLoadRelations()
  Option to mark assets as requestable. #15 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Concerns\BuildsQueries.php(143): Illuminate\Database\Eloquent\Builder->get()
  Child assets linked to parent assets (HDD, replacement parts, etc) [$100] #16 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(354): Illuminate\Database\Eloquent\Builder->first()
  Add warrantee field to assets/models #17 C:\inetpub\wwwroot\snipe-it\app\Http\Controllers\Users\UsersController.php(407): Illuminate\Database\Eloquent\Builder->find()
  Move validation out of the controllers and into the models where it belongs #18 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(54): App\Http\Controllers\Users\UsersController->show()
  Seed database with models, manufacturers, categories, etc. #19 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction()
  Import functions for users, assets, models, etc #20 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch()
  Merge licenses table into assets table #21 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(176): Illuminate\Routing\Route->runController()
  Fix depreciation on model vs asset #22 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(681): Illuminate\Routing\Route->run()
  Support multiple companies [$500 awarded] #23 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing\{closure}()
  Tighten up checkin/checkout UX #24 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Auth\Middleware\Authenticate.php(43): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Show number of assets for each asset model in listing page #25 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Auth\Middleware\Authenticate->handle()
  Handle errors more sanely when nothing in the DB #26 C:\inetpub\wwwroot\snipe-it\app\Http\Middleware\AssetCountForSidebar.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Depreciation fix #27 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\AssetCountForSidebar->handle()
  Fix tables on mobile #28 C:\inetpub\wwwroot\snipe-it\vendor\laravel\passport\src\Http\Middleware\CreateFreshApiToken.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Integrate barcode generation #29 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Laravel\Passport\Http\Middleware\CreateFreshApiToken->handle()
  Confirmation screens on delete #30 C:\inetpub\wwwroot\snipe-it\app\Http\Middleware\CheckForTwoFactor.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Fixing bootstrap process with default values. #31 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\CheckForTwoFactor->handle()
  Added confirmation popups for deletes #32 C:\inetpub\wwwroot\snipe-it\app\Http\Middleware\CheckLocale.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Add notion of lost, stolen, out for deployment, RTD, etc #33 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\CheckLocale->handle()
  Update asset index/view blade to reflect new status  #34 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Add CSV export for reports #35 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
  Make the Edit Profile page look less assy #36 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  incorrect command chown in README #37 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
  Develop #38 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Implement settings  #39 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle()
  Settings edit #40 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Add asset_type to Asset controller #41 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(683): Illuminate\Pipeline\Pipeline->then()
  Fix delete-check on licenses #42 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(658): Illuminate\Routing\Router->runRouteWithinStack()
  Fix checkout for licenses #43 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(624): Illuminate\Routing\Router->runRoute()
  Fix depreciation report with new licenses structure #44 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(613): Illuminate\Routing\Router->dispatchToRoute()
  When you soft-delete a user, should free up all associated resources  #45 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(170): Illuminate\Routing\Router->dispatch()
  Fix miscount on assets in user view #46 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
  When the number of seats is edited, handle that smartly #47 C:\inetpub\wwwroot\snipe-it\vendor\barryvdh\laravel-debugbar\src\Middleware\InjectDebugbar.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  LDAP authentication #48 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Barryvdh\Debugbar\Middleware\InjectDebugbar->handle()
  Calendar view(s) for asset check out/in, due date, etc. [$20] #49 C:\inetpub\wwwroot\snipe-it\app\Http\Middleware\SecurityHeaders.php(26): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  XSS Issues #50 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\SecurityHeaders->handle()
  Add postcode to locations #51 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Make the report columns sortable #52 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
  Add autocomplete to the search box #53 C:\inetpub\wwwroot\snipe-it\app\Http\Middleware\CheckForDebug.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  New button weirdly placed on my iPad (3rd gen) #54 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\CheckForDebug->handle()
  Show months until asset is fully depreciated #55 C:\inetpub\wwwroot\snipe-it\app\Http\Middleware\CheckForSetup.php(26): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Disable sorting on action column #56 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\CheckForSetup->handle()
  Spaces get filtered out #57 C:\inetpub\wwwroot\snipe-it\vendor\fideloper\proxy\src\TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Modal stops passing title/message/href through if modal is canceled #58 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle()
  Checkin message is wrong #59 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  CSRF protect all of the things #60 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\View\Middleware\ShareErrorsFromSession->handle()
  DB seed fails when mysql is in strict mode #61 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Add 'retired' status #62 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Session\Middleware\StartSession->handle()
  Asset Notes #63 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Notifications for when warranties are expiring... #64 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle()
  Invalid SQL #65 C:\inetpub\wwwroot\snipe-it\app\Http\Middleware\NoSessionStore.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Broken Gravatar URL in SSL-only environments #66 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): App\Http\Middleware\NoSessionStore->handle()
  Patch 1 #67 C:\inetpub\wwwroot\snipe-it\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Fix insecure content warnings #68 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(171): Barryvdh\Cors\HandlePreflight->handle()
  Initial install script failing on db installation, tries to drop tables that don't exist #69 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
  Modify the Assets and Licenses controllers and database schemas to work #70 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(145): Illuminate\Pipeline\Pipeline->then()
  Can't edit address fields on locations #71 C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
  Add address to location form #72 C:\inetpub\wwwroot\snipe-it\public\index.php(58): Illuminate\Foundation\Http\Kernel->handle()
  Email input types #73 {main}
• Include the output from php -m (this should display what modules you have enabled.)
  [PHP Modules]
  bcmath
  calendar
  Core
  ctype
  curl
  date
  dom
  exif
  fileinfo
  filter
  gd
  hash
  iconv
  json
  ldap
  libxml
  mbstring
  mysqli
  mysqlnd
  openssl
  pcre
  PDO
  pdo_mysql
  Phar
  readline
  Reflection
  session
  SimpleXML
  SPL
  standard
  tokenizer
  xml
  xmlreader
  xmlwriter
  zip
  zlib

[Zend Modules]
Additional context

[welcome]

👋 Thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it. We get a lot of issues on this repo, so please be patient and we will get back to you as soon as we can.

[snipe]

Did you run migrations?

[reardonp-fps]

Apologies, I left that part out by mistake. php artisan migrate gives me the following:

C:\inetpub\wwwroot\snipe-it>php artisan migrate

---

• Application In Production!     *
  

---

Migrating: 2019_06_12_184327_rename_groups_table

Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or view alr
eady exists: 1050 Table 'permission_groups' already exists (SQL: rename table g roups to permission_groups)

at C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Databas
e\Connection.php:669
665| // If an exception occurs when attempting to run a query, we'll
format the error
666| // message to include the bindings with SQL, which will make th
is exception a
667| // lot more helpful to the developer instead of just the databa
se's errors.
668| catch (Exception $e) {
669| throw new QueryException(
670| $query, $this->prepareBindings($bindings), $e
671| );
672| }
673|

Exception trace:

1 Doctrine\DBAL\Driver\PDOException::("SQLSTATE[42S01]: Base table or view a
lready exists: 1050 Table 'permission_groups' already exists")
C:\inetpub\wwwroot\snipe-it\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver
PDOStatement.php:131

2 PDOException::("SQLSTATE[42S01]: Base table or view already exists: 1050 T
able 'permission_groups' already exists")
C:\inetpub\wwwroot\snipe-it\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver
PDOStatement.php:129

Please use the argument -v to see more details.

[slyr91]

I am also encountering this issue. Trying to perform a migration and upgrade from V4.8.0 to V5.1.4. Also, it isn't just the users page for me. I am encountering this issue on the accessories page as well. I am able to query the database tables for these respective items so the data is there. I need to get this migration done so are we aware of a stable version without this issue that I can attempt to migrate to?

My php artisan migrate looks like this:

Migrating: 2018_07_28_023826_create_checkout_acceptances_table

Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'checkout_acceptances' already exists (SQL: create table checkout_acceptances (id int unsigned not null auto_increment primary key, checkoutable_type varchar(191) not null, checkoutable_id bigint unsigned not null, assigned_to_id int null, signature_filename varchar(191) null, accepted_at timestamp null, declined_at timestamp null, created_at timestamp null, updated_at timestamp null, deleted_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)

at /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669
665| // If an exception occurs when attempting to run a query, we'll format the error
666| // message to include the bindings with SQL, which will make this exception a
667| // lot more helpful to the developer instead of just the database's errors.
668| catch (Exception $e) {

669| throw new QueryException(
670| $query, $this->prepareBindings($bindings), $e
671| );
672| }
673|

Exception trace:

1 Doctrine\DBAL\Driver\PDOException::("SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'checkout_acceptances' already exists")
/var/www/html/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:131

2 PDOException::("SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'checkout_acceptances' already exists")
/var/www/html/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129

Please use the argument -v to see more details.

[reardonp-fps]

I believe accessories are also affected in our installation, but I only attempted it with a new accessory as we had not yet used the feature. Error is the same, talking about column not found, 1054 Unknown column 'accessories_users.note' in 'field list'

[snipe]

So it looks like your migrations table got messed up somehow, and it's trying to re-run a migration that's already happened. Can you show me the contents of your migrations table?

[reardonp-fps]

Table attached (CSV not supported by github, so XLSX!).
migrations_table.xlsx

[snipe]

Ugh, okay - I really meant just the text, but ...

ID	Migration	Batch
1	2012_12_06_225921_migration_cartalyst_sentry_install_users	1
2	2012_12_06_225929_migration_cartalyst_sentry_install_groups	1
3	2012_12_06_225945_migration_cartalyst_sentry_install_users_groups_pivot	1
4	2012_12_06_225988_migration_cartalyst_sentry_install_throttle	1
5	2013_03_23_193214_update_users_table	1
6	2013_11_13_075318_create_models_table	1
7	2013_11_13_075335_create_categories_table	1
8	2013_11_13_075347_create_manufacturers_table	1
9	2013_11_15_015858_add_user_id_to_categories	1
10	2013_11_15_112701_add_user_id_to_manufacturers	1
11	2013_11_15_190327_create_assets_table	1
12	2013_11_15_190357_create_licenses_table	1
13	2013_11_15_201848_add_license_name_to_licenses	1
14	2013_11_16_040323_create_depreciations_table	1
15	2013_11_16_042851_add_depreciation_id_to_models	1
16	2013_11_16_084923_add_user_id_to_models	1
17	2013_11_16_103258_create_locations_table	1
18	2013_11_16_103336_add_location_id_to_assets	1
19	2013_11_16_103407_add_checkedout_to_to_assets	1
20	2013_11_16_103425_create_history_table	1
21	2013_11_17_054359_drop_licenses_table	1
22	2013_11_17_054526_add_physical_to_assets	1
23	2013_11_17_055126_create_settings_table	1
24	2013_11_17_062634_add_license_to_assets	1
25	2013_11_18_134332_add_contacts_to_users	1
26	2013_11_18_142847_add_info_to_locations	1
27	2013_11_18_152942_remove_location_id_from_asset	1
28	2013_11_18_164423_set_nullvalues_for_user	1
29	2013_11_19_013337_create_asset_logs_table	1
30	2013_11_19_061409_edit_added_on_asset_logs_table	1
31	2013_11_19_062250_edit_location_id_asset_logs_table	1
32	2013_11_20_055822_add_soft_delete_on_assets	1
33	2013_11_20_121404_add_soft_delete_on_locations	1
34	2013_11_20_123137_add_soft_delete_on_manufacturers	1
35	2013_11_20_123725_add_soft_delete_on_categories	1
36	2013_11_20_130248_create_status_labels	1
37	2013_11_20_130830_add_status_id_on_assets_table	1
38	2013_11_20_131544_add_status_type_on_status_labels	1
39	2013_11_20_134103_add_archived_to_assets	1
40	2013_11_21_002321_add_uploads_table	1
41	2013_11_21_024531_remove_deployable_boolean_from_status_labels	1
42	2013_11_22_075308_add_option_label_to_settings_table	1
43	2013_11_22_213400_edits_to_settings_table	1
44	2013_11_25_013244_create_licenses_table	1
45	2013_11_25_031458_create_license_seats_table	1
46	2013_11_25_032022_add_type_to_actionlog_table	1
47	2013_11_25_033008_delete_bad_licenses_table	1
48	2013_11_25_033131_create_new_licenses_table	1
49	2013_11_25_033534_add_licensed_to_licenses_table	1
50	2013_11_25_101308_add_warrantee_to_assets_table	1
51	2013_11_25_104343_alter_warranty_column_on_assets	1
52	2013_11_25_150450_drop_parent_from_categories	1
53	2013_11_25_151920_add_depreciate_to_assets	1
54	2013_11_25_152903_add_depreciate_to_licenses_table	1
55	2013_11_26_211820_drop_license_from_assets_table	1
56	2013_11_27_062510_add_note_to_asset_logs_table	1
57	2013_12_01_113426_add_filename_to_asset_log	1
58	2013_12_06_094618_add_nullable_to_licenses_table	1
59	2013_12_10_084038_add_eol_on_models_table	1
60	2013_12_12_055218_add_manager_to_users_table	1
61	2014_01_28_031200_add_qr_code_to_settings_table	1
62	2014_02_13_183016_add_qr_text_to_settings_table	1
63	2014_05_24_093839_alter_default_license_depreciation_id	1
64	2014_05_27_231658_alter_default_values_licenses	1
65	2014_06_19_191508_add_asset_name_to_settings	1
66	2014_06_20_004847_make_asset_log_checkedout_to_nullable	1
67	2014_06_20_005050_make_asset_log_purchasedate_to_nullable	1
68	2014_06_24_003011_add_suppliers	1
69	2014_06_24_010742_add_supplier_id_to_asset	1
70	2014_06_24_012839_add_zip_to_supplier	1
71	2014_06_24_033908_add_url_to_supplier	1
72	2014_07_08_054116_add_employee_id_to_users	1
73	2014_07_09_134316_add_requestable_to_assets	1
74	2014_07_17_085822_add_asset_to_software	1
75	2014_07_17_161625_make_asset_id_in_logs_nullable	1
76	2014_08_12_053504_alpha_0_4_2_release	1
77	2014_08_17_083523_make_location_id_nullable	1
78	2014_10_16_200626_add_rtd_location_to_assets	1
79	2014_10_24_000417_alter_supplier_state_to_32	1
80	2014_10_24_015641_add_display_checkout_date	1
81	2014_10_28_222654_add_avatar_field_to_users_table	1
82	2014_10_29_045924_add_image_field_to_models_table	1
83	2014_11_01_214955_add_eol_display_to_settings	1
84	2014_11_04_231416_update_group_field_for_reporting	1
85	2014_11_05_212408_add_fields_to_licenses	1
86	2014_11_07_021042_add_image_to_supplier	1
87	2014_11_20_203007_add_username_to_user	1
88	2014_11_20_223947_add_auto_to_settings	1
89	2014_11_20_224421_add_prefix_to_settings	1
90	2014_11_21_104401_change_licence_type	1
91	2014_12_09_082500_add_fields_maintained_term_to_licenses	1
92	2015_02_04_155757_increase_user_field_lengths	1
93	2015_02_07_013537_add_soft_deleted_to_log	1
94	2015_02_10_040958_fix_bad_assigned_to_ids	1
95	2015_02_10_053310_migrate_data_to_new_statuses	1
96	2015_02_11_044104_migrate_make_license_assigned_null	1
97	2015_02_11_104406_migrate_create_requests_table	1
98	2015_02_12_001312_add_mac_address_to_asset	1
99	2015_02_12_024100_change_license_notes_type	1
100	2015_02_17_231020_add_localonly_to_settings	1
101	2015_02_19_222322_add_logo_and_colors_to_settings	1
102	2015_02_24_072043_add_alerts_to_settings	1
103	2015_02_25_022931_add_eula_fields	1
104	2015_02_25_204513_add_accessories_table	1
105	2015_02_26_091228_add_accessories_user_table	1
106	2015_02_26_115128_add_deleted_at_models	1
107	2015_02_26_233005_add_category_type	1
108	2015_03_01_231912_update_accepted_at_to_acceptance_id	1
109	2015_03_05_011929_add_qr_type_to_settings	1
110	2015_03_18_055327_add_note_to_user	1
111	2015_04_29_234704_add_slack_to_settings	1
112	2015_05_04_085151_add_parent_id_to_locations_table	1
113	2015_05_22_124421_add_reassignable_to_licenses	1
114	2015_06_10_003314_fix_default_for_user_notes	1
115	2015_06_10_003554_create_consumables	1
116	2015_06_15_183253_move_email_to_username	1
117	2015_06_23_070346_make_email_nullable	1
118	2015_06_26_213716_create_asset_maintenances_table	1
119	2015_07_04_212443_create_custom_fields_table	1
120	2015_07_09_014359_add_currency_to_settings_and_locations	1
121	2015_07_21_122022_add_expected_checkin_date_to_asset_logs	1
122	2015_07_24_093845_add_checkin_email_to_category_table	1
123	2015_07_25_055415_remove_email_unique_constraint	1
124	2015_07_29_230054_add_thread_id_to_asset_logs_table	1
125	2015_07_31_015430_add_accepted_to_assets	1
126	2015_09_09_195301_add_custom_css_to_settings	1
127	2015_09_21_235926_create_custom_field_custom_fieldset	1
128	2015_09_22_000104_create_custom_fieldsets	1
129	2015_09_22_003321_add_fieldset_id_to_assets	1
130	2015_09_22_003413_migrate_mac_address	1
131	2015_09_28_003314_fix_default_purchase_order	1
132	2015_10_01_024551_add_accessory_consumable_price_info	1
133	2015_10_12_192706_add_brand_to_settings	1
134	2015_10_22_003314_fix_defaults_accessories	1
135	2015_10_23_182625_add_checkout_time_and_expected_checkout_date_to_assets	1
136	2015_11_05_061015_create_companies_table	1
137	2015_11_05_061115_add_company_id_to_consumables_table	1
138	2015_11_05_183749_image	1
139	2015_11_06_092038_add_company_id_to_accessories_table	1
140	2015_11_06_100045_add_company_id_to_users_table	1
141	2015_11_06_134742_add_company_id_to_licenses_table	1
142	2015_11_08_035832_add_company_id_to_assets_table	1
143	2015_11_08_222305_add_ldap_fields_to_settings	1
144	2015_11_15_151803_add_full_multiple_companies_support_to_settings_table	1
145	2015_11_26_195528_import_ldap_settings	1
146	2015_11_30_191504_remove_fk_company_id	1
147	2015_12_21_193006_add_ldap_server_cert_ignore_to_settings_table	1
148	2015_12_30_233509_add_timestamp_and_userId_to_custom_fields	1
149	2015_12_30_233658_add_timestamp_and_userId_to_custom_fieldsets	1
150	2016_01_28_041048_add_notes_to_models	1
151	2016_02_19_070119_add_remember_token_to_users_table	1
152	2016_02_19_073625_create_password_resets_table	1
153	2016_03_02_193043_add_ldap_flag_to_users	1
154	2016_03_02_220517_update_ldap_filter_to_longer_field	1
155	2016_03_08_225351_create_components_table	1
156	2016_03_09_024038_add_min_stock_to_tables	1
157	2016_03_10_133849_add_locale_to_users	1
158	2016_03_10_135519_add_locale_to_settings	1
159	2016_03_11_185621_add_label_settings_to_settings	1
160	2016_03_22_125911_fix_custom_fields_regexes	1
161	2016_04_28_141554_add_show_to_users	1
162	2016_05_16_164733_add_model_mfg_to_consumable	1
163	2016_05_19_180351_add_alt_barcode_settings	1
164	2016_05_19_191146_add_alter_interval	1
165	2016_05_19_192226_add_inventory_threshold	1
166	2016_05_20_024859_remove_option_keys_from_settings_table	1
167	2016_05_20_143758_remove_option_value_from_settings_table	1
168	2016_06_01_140218_add_email_domain_and_format_to_settings	1
169	2016_06_22_160725_add_user_id_to_maintenances	1
170	2016_07_13_150015_add_is_ad_to_settings	1
171	2016_07_14_153609_add_ad_domain_to_settings	1
172	2016_07_22_003348_fix_custom_fields_regex_stuff	1
173	2016_07_22_054850_one_more_mac_addr_fix	1
174	2016_07_22_143045_add_port_to_ldap_settings	1
175	2016_07_22_153432_add_tls_to_ldap_settings	1
176	2016_07_27_211034_add_zerofill_to_settings	1
177	2016_08_02_124944_add_color_to_statuslabel	1
178	2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings	1
179	2016_08_09_002225_add_manufacturer_to_licenses	1
180	2016_08_12_121613_add_manufacturer_to_accessories_table	1
181	2016_08_23_143353_add_new_fields_to_custom_fields	1
182	2016_08_23_145619_add_show_in_nav_to_status_labels	1
183	2016_08_30_084634_make_purchase_cost_nullable	1
184	2016_09_01_141051_add_requestable_to_asset_model	1
185	2016_09_02_001448_create_checkout_requests_table	1
186	2016_09_04_180400_create_actionlog_table	1
187	2016_09_04_182149_migrate_asset_log_to_action_log	1
188	2016_09_19_235935_fix_fieldtype_for_target_type	1
189	2016_09_23_140722_fix_modelno_in_consumables_to_string	1
190	2016_09_28_231359_add_company_to_logs	1
191	2016_10_14_130709_fix_order_number_to_varchar	1
192	2016_10_16_015024_rename_modelno_to_model_number	1
193	2016_10_16_015211_rename_consumable_modelno_to_model_number	1
194	2016_10_16_143235_rename_model_note_to_notes	1
195	2016_10_16_165052_rename_component_total_qty_to_qty	1
196	2016_10_19_145520_fix_order_number_in_components_to_string	1
197	2016_10_27_151715_add_serial_to_components	1
198	2016_10_27_213251_increase_serial_field_capacity	1
199	2016_10_29_002724_enable_2fa_fields	1
200	2016_10_29_082408_add_signature_to_acceptance	1
201	2016_11_01_030818_fix_forgotten_filename_in_action_logs	1
202	2016_11_13_020954_rename_component_serial_number_to_serial	1
203	2016_11_16_172119_increase_purchase_cost_size	1
204	2016_11_17_161317_longer_state_field_in_location	1
205	2016_11_17_193706_add_model_number_to_accessories	1
206	2016_11_24_160405_add_missing_target_type_to_logs_table	1
207	2016_12_07_173720_increase_size_of_state_in_suppliers	1
208	2016_12_19_004212_adjust_locale_length_to_10	1
209	2016_12_19_133936_extend_phone_lengths_in_supplier_and_elsewhere	1
210	2016_12_27_212631_make_asset_assigned_to_polymorphic	1
211	2017_01_09_040429_create_locations_ldap_query_field	1
212	2017_01_14_002418_create_imports_table	1
213	2017_01_25_063357_fix_utf8_custom_field_column_names	1
214	2017_03_03_154632_add_time_date_display_to_settings	1
215	2017_03_10_210807_add_fields_to_manufacturer	1
216	2017_05_08_195520_increase_size_of_field_values_in_custom_fields	1
217	2017_05_22_204422_create_departments	1
218	2017_05_22_233509_add_manager_to_locations_table	1
219	2017_06_14_122059_add_next_autoincrement_to_settings	1
220	2017_06_18_151753_add_header_and_first_row_to_importer_table	1
221	2017_07_07_191533_add_login_text	1
222	2017_07_25_130710_add_thumbsize_to_settings	1
223	2017_08_03_160105_set_asset_archived_to_zero_default	1
224	2017_08_22_180636_add_secure_password_options	1
225	2017_08_25_074822_add_auditing_tables	1
226	2017_08_25_101435_add_auditing_to_settings	1
227	2017_09_18_225619_fix_assigned_type_not_being_nulled	1
228	2017_10_03_015503_drop_foreign_keys	1
229	2017_10_10_123504_allow_nullable_depreciation_id_in_models	1
230	2017_10_17_133709_add_display_url_to_settings	1
231	2017_10_19_120002_add_custom_forgot_password_url	1
232	2017_10_19_130406_add_image_and_supplier_to_accessories	1
233	2017_10_20_234129_add_location_indices_to_assets	1
234	2017_10_25_202930_add_images_uploads_to_locations_manufacturers_etc	1
235	2017_10_27_180947_denorm_asset_locations	1
236	2017_10_27_192423_migrate_denormed_asset_locations	1
237	2017_10_30_182938_add_address_to_user	1
238	2017_11_08_025918_add_alert_menu_setting	1
239	2017_11_08_123942_labels_display_company_name	1
240	2017_12_12_010457_normalize_asset_last_audit_date	1
241	2017_12_12_033618_add_actionlog_meta	1
242	2017_12_26_170856_re_normalize_last_audit	1
243	2018_01_17_184354_add_archived_in_list_setting	1
244	2018_01_19_203121_add_dashboard_message_to_settings	1
245	2018_01_24_062633_add_footer_settings_to_settings	1
246	2018_01_24_093426_add_modellist_preferenc	1
247	2018_02_22_160436_add_remote_user_settings	1
248	2018_03_03_011032_add_theme_to_settings	1
249	2018_03_06_054937_add_default_flag_on_statuslabels	1
250	2018_03_23_212048_add_display_in_email_to_custom_fields	1
251	2018_03_24_030738_add_show_images_in_email_setting	1
252	2018_03_24_050108_add_cc_alerts	1
253	2018_03_29_053618_add_canceled_at_and_fulfilled_at_in_requests	1
254	2018_03_29_070121_add_drop_unique_requests	1
255	2018_03_29_070511_add_new_index_requestable	1
256	2018_04_02_150700_labels_display_model_name	1
257	2018_04_16_133902_create_custom_field_default_values_table	1
258	2018_05_04_073223_add_category_to_licenses	1
259	2018_05_04_075235_add_update_license_category	1
260	2018_05_08_031515_add_gdpr_privacy_footer	1
261	2018_05_14_215229_add_indexes	1
262	2018_05_14_223646_add_indexes_to_assets	1
263	2018_05_14_233638_denorm_counters_on_assets	1
264	2018_05_16_153409_add_first_counter_totals_to_assets	1
265	2018_06_21_134622_add_version_footer	1
266	2018_07_05_215440_add_unique_serial_option_to_settings	1
267	2018_07_17_005911_create_login_attempts_table	1
268	2018_07_24_154348_add_logo_to_print_assets	1
269	2016_06_01_000001_create_oauth_auth_codes_table	2
270	2016_06_01_000002_create_oauth_access_tokens_table	2
271	2016_06_01_000003_create_oauth_refresh_tokens_table	2
272	2016_06_01_000004_create_oauth_clients_table	2
273	2016_06_01_000005_create_oauth_personal_access_clients_table	2
274	2019_02_14_154310_change_auto_increment_prefix_to_nullable	3
275	2019_02_16_143518_auto_increment_back_to_string	3
276	2019_02_20_234421_make_serial_nullable	3
277	2019_02_21_224703_make_fields_nullable_for_integrity	3
278	2018_07_28_023826_create_checkout_acceptances_table	4
279	2018_08_20_204842_add_depreciation_option_to_settings	4
280	2018_09_10_082212_create_checkout_acceptances_for_unaccepted_assets	4
281	2018_10_18_191228_add_kits_licenses_table	4
282	2018_10_19_153910_add_kits_table	4
283	2018_10_19_154013_add_kits_models_table	4
284	2018_12_05_211936_add_favicon_to_settings	4
285	2018_12_05_212119_add_email_logo_to_settings	4
286	2019_02_07_185953_add_kits_consumables_table	4
287	2019_02_07_190030_add_kits_accessories_table	4
288	2019_02_12_182750_add_actiondate_to_actionlog	4
289	2019_02_17_205048_add_label_logo_to_settings	4

It definitely looks like your migrations got stuck. You should have 303 or so migrations, not 289.

Try running INSERT INTO migrations (migration, batch) VALUES ('2019_06_12_184327_rename_groups_table', '5'); and then re-run migrations and show me what the output is.

[reardonp-fps]

Apologies about the file--I'm relatively new to web servers and Github. This appears to have fixed the issue! Users and accessories are showing up. I will continue to use the program and build it out and see if anything else goes wrong, but very happy to have users working again! Thank you very much!

The result from migration:

Migrating: 2019_07_23_140906_add_show_assigned_assets_to_settings
Migrated: 2019_07_23_140906_add_show_assigned_assets_to_settings (0.04 sec

Migrating: 2019_08_20_084049_add_custom_remote_user_header
Migrated: 2019_08_20_084049_add_custom_remote_user_header (0.03 seconds)
Migrating: 2019_12_04_223111_passport_upgrade
Migrated: 2019_12_04_223111_passport_upgrade (0.19 seconds)
Migrating: 2020_02_04_172100_add_ad_append_domain_settings
Migrated: 2020_02_04_172100_add_ad_append_domain_settings (0.05 seconds)
Migrating: 2020_04_29_222305_add_saml_fields_to_settings
Migrated: 2020_04_29_222305_add_saml_fields_to_settings (0.04 seconds)
Migrating: 2020_10_22_233743_move_accessory_checkout_note_to_join_table
Migrated: 2020_10_22_233743_move_accessory_checkout_note_to_join_table (0.
conds)
Migrating: 2020_10_23_161736_fix_zero_values_for_locations
Migrated: 2020_10_23_161736_fix_zero_values_for_locations (0.01 seconds)
Migrating: 2020_11_18_214827_widen_license_serial_field
Migrated: 2020_11_18_214827_widen_license_serial_field (0.25 seconds)
Migrating: 2020_12_14_233815_add_digit_separator_to_settings
Migrated: 2020_12_14_233815_add_digit_separator_to_settings (0.03 seconds)
Migrating: 2020_12_18_090026_swap_target_type_index_order
Migrated: 2020_12_18_090026_swap_target_type_index_order (0.12 seconds)
Migrating: 2020_12_21_153235_update_min_password
Migrated: 2020_12_21_153235_update_min_password (0 seconds)
Migrating: 2020_12_21_210105_fix_bad_ldap_server_url_for_v5
Migrated: 2020_12_21_210105_fix_bad_ldap_server_url_for_v5 (0 seconds)
Migrating: 2021_02_05_172502_add_provider_to_oauth_table
Migrated: 2021_02_05_172502_add_provider_to_oauth_table (0.03 seconds)

[snipe]

Excellent - glad you're sorted!