somayweall commented 6 years ago

Expected Behavior (or desired behavior if a feature request)

Checking asset in or out works normally.

Actual Behavior

A "Whoops" error is displayed anytime an asset is checked out. (Yet the asset checkin/checkout status is changed).

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

Provide answers to these questions:

Is this a fresh install or an upgrade? Upgrade
Version of Snipe-IT you're running - v4.6.2 build 3844 (gbbb15d610)
Version of PHP you're running - 7.2.7-0ubuntu0.18.04.2
Version of MySQL/MariaDB you're running - mysql Ver 15.1 Distrib 10.1.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
What OS and web server you're running Snipe-IT on. Ubuntu 18.04. Apache2
What method you used to install Snipe-IT (install.sh, manual installation, docker, etc) install.sh
WITH DEBUG TURNED ON, if you're getting an error in your browser, include that error
What specific Snipe-IT page you're on, and what specific element you're interacting with to trigger the error logs below.
If a stacktrace is provided in the error, include that too.
Any errors that appear in your browser's error console.
Confirm whether the error is reproducible on the demo: https://snipeitapp.com/demo. Not reproducible in the demo.
Include any additional information you can find in storage/logs and your webserver's logs.
Include what you've done so far in the installation, and if you got any error messages along the way. checked permissions on the subfolders in /var/www/snipeit
Indicate whether or not you've manually edited any data directly in the database

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

output of tail-f storage/log/laravel.log when reproducing the issue:

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'checkout_counter' in 'field list' (SQL: update assets set checkout_counter = checkout_counter + 1, updated_at = 2018-07-22 19:22:42 where id = 181 and assets.deleted_at is null) in /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace:

0 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update `assets`...', Array, Object(Closure))

1 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(477): Illuminate\Database\Connection->run('update `assets`...', Array, Object(Closure))

2 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(416): Illuminate\Database\Connection->affectingStatement('update `assets`...', Array)

3 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\Database\Connection->update('update `assets`...', Array)

4 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2185): Illuminate\Database\Query\Builder->update(Array)

5 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(773): Illuminate\Database\Query\Builder->increment('checkout_counte...', 1, Array)

6 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(428): Illuminate\Database\Eloquent\Builder->increment('checkout_counte...', 1, Array)

7 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(391): Illuminate\Database\Eloquent\Model->incrementOrDecrement('checkout_counte...', 1, Array, 'increment')

8 /var/www/snipe-it/app/Models/Asset.php(247): Illuminate\Database\Eloquent\Model->increment('checkout_counte...', 1)

9 /var/www/snipe-it/app/Http/Controllers/AssetCheckoutController.php(83): App\Models\Asset->checkOut(Object(App\Models\User), Object(App\Models\User), '2018-07-22 19:2...', '', '', 'brother-printer')

10 [internal function]: App\Http\Controllers\AssetCheckoutController->store(Object(App\Http\Requests\AssetCheckoutRequest), '181')

11 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)

12 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('store', Array)

13 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\AssetCheckoutController), 'store')

14 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()

15 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php(572): Illuminate\Routing\Route->run()

16 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

17 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

18 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))

19 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

20 /var/www/snipe-it/vendor/laravel/passport/src/Http/Middleware/CreateFreshApiToken.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

21 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Laravel\Passport\Http\Middleware\CreateFreshApiToken->handle(Object(Illuminate\Http\Request), Object(Closure))

22 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

23 /var/www/snipe-it/app/Http/Middleware/CheckForTwoFactor.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

24 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\CheckForTwoFactor->handle(Object(Illuminate\Http\Request), Object(Closure))

25 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

26 /var/www/snipe-it/app/Http/Middleware/CheckLocale.php(42): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

27 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\CheckLocale->handle(Object(Illuminate\Http\Request), Object(Closure))

28 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

29 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

30 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))

31 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

32 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

33 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))

34 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

35 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

36 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))

37 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

38 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

39 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

40 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))

41 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

42 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))

43 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))

44 /var/www/snipe-it/vendor/barryvdh/laravel-debugbar/src/Middleware/Debugbar.php(51): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

45 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Barryvdh\Debugbar\Middleware\Debugbar->handle(Object(Illuminate\Http\Request), Object(Closure))

46 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

47 /var/www/snipe-it/app/Http/Middleware/CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

48 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))

49 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

50 /var/www/snipe-it/app/Http/Middleware/CheckForSetup.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

51 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))

52 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

53 /var/www/snipe-it/vendor/fideloper/proxy/src/TrustProxies.php(56): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

54 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))

55 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

56 /var/www/snipe-it/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

57 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

58 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

59 /var/www/snipe-it/app/Http/Middleware/ContentSecurityPolicyHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

60 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\ContentSecurityPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

61 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

62 /var/www/snipe-it/app/Http/Middleware/ReferrerPolicyHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

63 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\ReferrerPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

64 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

65 /var/www/snipe-it/app/Http/Middleware/XssProtectHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

66 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

67 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

68 /var/www/snipe-it/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

69 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

70 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

71 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

72 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))

73 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

74 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

75 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))

76 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

77 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

78 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))

79 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

80 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

81 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))

82 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

83 /var/www/snipe-it/public/index.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

84 {main}

Thank you for your help.

tilldeeke commented 6 years ago

Hey @thesurfaceofthevoid! This looks as if the latest migrations didn't get applied to your database. Could you run the upgrade script (php upgrade.php) in the root of your installation and try the checkout again? If it doesn't work after running the script, post the output of the script here please :)

somayweall commented 6 years ago

Thanks for the tip!

I've run php upgrade.php and the issue has persisted. Here is the output of the upgrade script.

Step 6: Migrating database:

-- In Connection.php line 647:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'models_cust
om_fields' already exists (SQL: create table models_custom_fields (id i
nt unsigned not null auto_increment primary key, asset_model_id int not n
ull, custom_field_id int not null, default_value text null) default cha
racter set utf8mb4 collate utf8mb4_unicode_ci engine = InnoDB)

In PDOStatement.php line 107:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'models_cust
om_fields' already exists

In PDOStatement.php line 105:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'models_cust
om_fields' already exists

tilldeeke commented 6 years ago

Thats strange. Could you post the contents of your migrations database table as well?

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

This suggests the create_custom_field_default_values_table migration was run already, but not recorded in the migrations table since it tried to run it again.

somayweall commented 6 years ago

Sure thing.

MariaDB [snipeit_db]> select * from migrations -> ; +-----+---------------------------------------------- | id | migration +-----+---------------------------------------------- | 1 | 2012_12_06_225921_migration_cartalyst_sentry_install_users | 2 | 2012_12_06_225929_migration_cartalyst_sentry_ | 3 | 2012_12_06_225945_migration_cartalyst_sentry_ | 4 | 2012_12_06_225988_migration_cartalyst_sentry_ | 5 | 2013_03_23_193214_update_users_table | 6 | 2013_11_13_075318_create_models_table | 7 | 2013_11_13_075335_create_categories_table | 8 | 2013_11_13_075347_create_manufacturers_table | 9 | 2013_11_15_015858_add_user_id_to_categories | 10 | 2013_11_15_112701_add_user_id_to_manufacturers | 11 | 2013_11_15_190327_create_assets_table | 12 | 2013_11_15_190357_create_licenses_table | 13 | 2013_11_15_201848_add_license_name_to_licenses | 14 | 2013_11_16_040323_create_depreciations_table | 15 | 2013_11_16_042851_add_depreciation_id_to_models | 16 | 2013_11_16_084923_add_user_id_to_models | 17 | 2013_11_16_103258_create_locations_table | 18 | 2013_11_16_103336_add_location_id_to_assets | 19 | 2013_11_16_103407_add_checkedout_to_to_assets | 20 | 2013_11_16_103425_create_history_table | 21 | 2013_11_17_054359_drop_licenses_table | 22 | 2013_11_17_054526_add_physical_to_assets | 23 | 2013_11_17_055126_create_settings_table | 24 | 2013_11_17_062634_add_license_to_assets | 25 | 2013_11_18_134332_add_contacts_to_users | 26 | 2013_11_18_142847_add_info_to_locations | 27 | 2013_11_18_152942_remove_location_id_from_asset | 28 | 2013_11_18_164423_set_nullvalues_for_user | 29 | 2013_11_19_013337_create_asset_logs_table | 30 | 2013_11_19_061409_edit_added_on_asset_logs_table | 31 | 2013_11_19_062250_edit_location_id_asset_logs_table | 32 | 2013_11_20_055822_add_soft_delete_on_assets | 33 | 2013_11_20_121404_add_soft_delete_on_locations | 34 | 2013_11_20_123137_add_soft_delete_on_manufacturers | 35 | 2013_11_20_123725_add_soft_delete_on_categories | 36 | 2013_11_20_130248_create_status_labels | 37 | 2013_11_20_130830_add_status_id_on_assets_table | 38 | 2013_11_20_131544_add_status_type_on_status_labels | 39 | 2013_11_20_134103_add_archived_to_assets | 40 | 2013_11_21_002321_add_uploads_table | 41 | 2013_11_21_024531_remove_deployable_boolean_f | 42 | 2013_11_22_075308_add_option_label_to_settings_table | 43 | 2013_11_22_213400_edits_to_settings_table | 44 | 2013_11_25_013244_create_licenses_table | 45 | 2013_11_25_031458_create_license_seats_table | 46 | 2013_11_25_032022_add_type_to_actionlog_table | 47 | 2013_11_25_033008_delete_bad_licenses_table | 48 | 2013_11_25_033131_create_new_licenses_table | 49 | 2013_11_25_033534_add_licensed_to_licenses_table | 50 | 2013_11_25_101308_add_warrantee_to_assets_table | 51 | 2013_11_25_104343_alter_warranty_column_on_assets | 52 | 2013_11_25_150450_drop_parent_from_categories | 53 | 2013_11_25_151920_add_depreciate_to_assets | 54 | 2013_11_25_152903_add_depreciate_to_licenses_table | 55 | 2013_11_26_211820_drop_license_from_assets_table | 56 | 2013_11_27_062510_add_note_to_asset_logs_table | 57 | 2013_12_01_113426_add_filename_to_asset_log | 58 | 2013_12_06_094618_add_nullable_to_licenses_table | 59 | 2013_12_10_084038_add_eol_on_models_table | 60 | 2013_12_12_055218_add_manager_to_users_table | 61 | 2014_01_28_031200_add_qr_code_to_settings_table | 62 | 2014_02_13_183016_add_qr_text_to_settings_table | 63 | 2014_05_24_093839_alter_default_license_depreciation_id | 64 | 2014_05_27_231658_alter_default_values_licenses | 65 | 2014_06_19_191508_add_asset_name_to_settings | 66 | 2014_06_20_004847_make_asset_log_checkedout_to_nullable | 67 | 2014_06_20_005050_make_asset_log_purchasedate_to_nullable | 68 | 2014_06_24_003011_add_suppliers | 69 | 2014_06_24_010742_add_supplier_id_to_asset | 70 | 2014_06_24_012839_add_zip_to_supplier | 71 | 2014_06_24_033908_add_url_to_supplier | 72 | 2014_07_08_054116_add_employee_id_to_users | 73 | 2014_07_09_134316_add_requestable_to_assets | 74 | 2014_07_17_085822_add_asset_to_software | 75 | 2014_07_17_161625_make_asset_id_in_logs_nullable | 76 | 2014_08_12_053504_alpha_0_4_2_release | 77 | 2014_08_17_083523_make_location_id_nullable | 78 | 2014_10_16_200626_add_rtd_location_to_assets | 79 | 2014_10_24_000417_alter_supplier_state_to_32 | 80 | 2014_10_24_015641_add_display_checkout_date | 81 | 2014_10_28_222654_add_avatar_field_to_users_table | 82 | 2014_10_29_045924_add_image_field_to_models_table | 83 | 2014_11_01_214955_add_eol_display_to_settings | 84 | 2014_11_04_231416_update_group_field_for_reporting | 85 | 2014_11_05_212408_add_fields_to_licenses | 86 | 2014_11_07_021042_add_image_to_supplier | 87 | 2014_11_20_203007_add_username_to_user | 88 | 2014_11_20_223947_add_auto_to_settings | 89 | 2014_11_20_224421_add_prefix_to_settings | 90 | 2014_11_21_104401_change_licence_type | 91 | 2014_12_09_082500_add_fields_maintained_term_to_licenses | 92 | 2015_02_04_155757_increase_user_field_lengths | 93 | 2015_02_07_013537_add_soft_deleted_to_log | 94 | 2015_02_10_040958_fix_bad_assigned_to_ids | 95 | 2015_02_10_053310_migrate_data_to_new_statuses | 96 | 2015_02_11_044104_migrate_make_license_assigned_null | 97 | 2015_02_11_104406_migrate_create_requests_table | 98 | 2015_02_12_001312_add_mac_address_to_asset | 99 | 2015_02_12_024100_change_license_notes_type | 100 | 2015_02_17_231020_add_localonly_to_settings | 101 | 2015_02_19_222322_add_logo_and_colors_to_settings | 102 | 2015_02_24_072043_add_alerts_to_settings | 103 | 2015_02_25_022931_add_eula_fields | 104 | 2015_02_25_204513_add_accessories_table | 105 | 2015_02_26_091228_add_accessories_user_table | 106 | 2015_02_26_115128_add_deleted_at_models | 107 | 2015_02_26_233005_add_category_type | 108 | 2015_03_01_231912_update_accepted_at_to_acceptance_id | 109 | 2015_03_05_011929_add_qr_type_to_settings | 110 | 2015_03_18_055327_add_note_to_user | 111 | 2015_04_29_234704_add_slack_to_settings | 112 | 2015_05_04_085151_add_parent_id_to_locations_table | 113 | 2015_05_22_124421_add_reassignable_to_licenses | 114 | 2015_06_10_003314_fix_default_for_user_notes | 115 | 2015_06_10_003554_create_consumables | 116 | 2015_06_15_183253_move_email_to_username | 117 | 2015_06_23_070346_make_email_nullable | 118 | 2015_06_26_213716_create_asset_maintenances_table | 119 | 2015_07_04_212443_create_custom_fields_table | 120 | 2015_07_09_014359_add_currency_to_settings_and_locations | 121 | 2015_07_21_122022_add_expected_checkin_date_to_asset_logs | 122 | 2015_07_24_093845_add_checkin_email_to_category_table | 123 | 2015_07_25_055415_remove_email_unique_constraint | 124 | 2015_07_29_230054_add_thread_id_to_asset_logs_table | 125 | 2015_07_31_015430_add_accepted_to_assets | 126 | 2015_09_09_195301_add_custom_css_to_settings | 127 | 2015_09_21_235926_create_custom_field_custom_fieldset | 128 | 2015_09_22_000104_create_custom_fieldsets | 129 | 2015_09_22_003321_add_fieldset_id_to_assets | 130 | 2015_09_22_003413_migrate_mac_address | 131 | 2015_09_28_003314_fix_default_purchase_order | 132 | 2015_10_01_024551_add_accessory_consumable_price_info | 133 | 2015_10_12_192706_add_brand_to_settings | 134 | 2015_10_22_003314_fix_defaults_accessories | 135 | 2015_10_23_182625_add_checkout_time_and_expec | 136 | 2015_11_05_061015_create_companies_table | 137 | 2015_11_05_061115_add_company_id_to_consumables_table | 138 | 2015_11_05_183749_image | 139 | 2015_11_06_092038_add_company_id_to_accessories_table | 140 | 2015_11_06_100045_add_company_id_to_users_table | 141 | 2015_11_06_134742_add_company_id_to_licenses_table | 142 | 2015_11_08_035832_add_company_id_to_assets_table | 143 | 2015_11_08_222305_add_ldap_fields_to_settings | 144 | 2015_11_15_151803_add_full_multiple_companies | 145 | 2015_11_26_195528_import_ldap_settings | 146 | 2015_11_30_191504_remove_fk_company_id | 147 | 2015_12_21_193006_add_ldap_server_cert_ignore | 148 | 2015_12_30_233509_add_timestamp_and_userId_to | 149 | 2015_12_30_233658_add_timestamp_and_userId_to | 150 | 2016_01_28_041048_add_notes_to_models | 151 | 2016_02_19_070119_add_remember_token_to_users_table | 152 | 2016_02_19_073625_create_password_resets_table | 153 | 2016_03_02_193043_add_ldap_flag_to_users | 154 | 2016_03_02_220517_update_ldap_filter_to_longer_field | 155 | 2016_03_08_225351_create_components_table | 156 | 2016_03_09_024038_add_min_stock_to_tables | 157 | 2016_03_10_133849_add_locale_to_users | 158 | 2016_03_10_135519_add_locale_to_settings | 159 | 2016_03_11_185621_add_label_settings_to_settings | 160 | 2016_03_22_125911_fix_custom_fields_regexes | 161 | 2016_04_28_141554_add_show_to_users | 162 | 2016_05_16_164733_add_model_mfg_to_consumable | 163 | 2016_05_19_180351_add_alt_barcode_settings | 164 | 2016_05_19_191146_add_alter_interval | 165 | 2016_05_19_192226_add_inventory_threshold | 166 | 2016_05_20_024859_remove_option_keys_from_settings_table | 167 | 2016_05_20_143758_remove_option_value_from_settings_table | 168 | 2016_06_01_140218_add_email_domain_and_format_to_settings | 169 | 2016_06_22_160725_add_user_id_to_maintenances | 170 | 2016_07_13_150015_add_is_ad_to_settings | 171 | 2016_07_14_153609_add_ad_domain_to_settings | 172 | 2016_07_22_003348_fix_custom_fields_regex_stuff | 173 | 2016_07_22_054850_one_more_mac_addr_fix | 174 | 2016_07_22_143045_add_port_to_ldap_settings | 175 | 2016_07_22_153432_add_tls_to_ldap_settings | 176 | 2016_07_27_211034_add_zerofill_to_settings | 177 | 2016_08_02_124944_add_color_to_statuslabel | 178 | 2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings | 179 | 2016_08_09_002225_add_manufacturer_to_licenses | 180 | 2016_08_12_121613_add_manufacturer_to_accessories_table | 181 | 2016_08_23_143353_add_new_fields_to_custom_fields | 182 | 2016_08_23_145619_add_show_in_nav_to_status_labels | 183 | 2016_08_30_084634_make_purchase_cost_nullable | 184 | 2016_09_01_141051_add_requestable_to_asset_model | 185 | 2016_09_02_001448_create_checkout_requests_table | 186 | 2016_09_04_180400_create_actionlog_table | 187 | 2016_09_04_182149_migrate_asset_log_to_action_log | 188 | 2016_09_19_235935_fix_fieldtype_for_target_type | 189 | 2016_09_23_140722_fix_modelno_in_consumables_to_string | 190 | 2016_09_28_231359_add_company_to_logs | 191 | 2016_10_14_130709_fix_order_number_to_varchar | 192 | 2016_10_16_015024_rename_modelno_to_model_number | 193 | 2016_10_16_015211_rename_consumable_modelno_t | 194 | 2016_10_16_143235_rename_model_note_to_notes | 195 | 2016_10_16_165052_rename_component_total_qty_to_qty | 196 | 2016_10_19_145520_fix_order_number_in_components_to_string | 197 | 2016_10_27_151715_add_serial_to_components | 198 | 2016_10_27_213251_increase_serial_field_capacity | 199 | 2016_10_29_002724_enable_2fa_fields | 200 | 2016_10_29_082408_add_signature_to_acceptance | 201 | 2016_11_01_030818_fix_forgotten_filename_in_action_logs | 202 | 2016_11_13_020954_rename_component_serial_number_to_serial | 203 | 2016_11_16_172119_increase_purchase_cost_size | 204 | 2016_11_17_161317_longer_state_field_in_location | 205 | 2016_11_17_193706_add_model_number_to_accessories | 206 | 2016_11_16_172119_increase_purchase_cost_size | 207 | 2016_11_24_160405_add_missing_target_type_to_logs_table | 208 | 2016_11_17_161317_longer_state_field_in_location | 209 | 2016_12_07_173720_increase_size_of_state_in_suppliers | 210 | 2016_12_19_004212_adjust_locale_length_to_10 | 211 | 2016_12_19_133936_extend_phone_lengths_in_sup | 212 | 2016_12_27_212631_make_asset_assigned_to_polymorphic | 213 | 2017_01_09_040429_create_locations_ldap_query_field | 214 | 2017_01_14_002418_create_imports_table | 215 | 2017_01_25_063357_fix_utf8_custom_field_column_names | 216 | 2017_03_03_154632_add_time_date_display_to_settings | 217 | 2017_03_10_210807_add_fields_to_manufacturer | 218 | 2017_05_08_195520_increase_size_of_field_valu | 219 | 2017_05_22_204422_create_departments | 220 | 2017_05_22_233509_add_manager_to_locations_table | 221 | 2017_06_14_122059_add_next_autoincrement_to_settings | 222 | 2017_06_18_151753_add_header_and_first_row_to | 223 | 2017_07_07_191533_add_login_text | 224 | 2017_07_25_130710_add_thumbsize_to_settings | 225 | 2017_08_03_160105_set_asset_archived_to_zero_default | 226 | 2017_08_22_180636_add_secure_password_options | 227 | 2017_08_25_074822_add_auditing_tables | 228 | 2017_08_25_101435_add_auditing_to_settings | 229 | 2017_09_18_225619_fix_assigned_type_not_being_nulled | 230 | 2017_10_03_015503_drop_foreign_keys | 231 | 2017_10_10_123504_allow_nullable_depreciation_id_in_models | 232 | 2017_10_17_133709_add_display_url_to_settings | 233 | 2017_10_19_120002_add_custom_forgot_password_url | 234 | 2017_10_19_130406_add_image_and_supplier_to_accessories | 235 | 2017_10_20_234129_add_location_indices_to_assets | 236 | 2017_10_25_202930_add_images_uploads_to_locat | 237 | 2017_10_27_180947_denorm_asset_locations | 238 | 2017_10_27_192423_migrate_denormed_asset_locations | 239 | 2017_10_30_182938_add_address_to_user | 240 | 2017_11_08_025918_add_alert_menu_setting | 241 | 2017_11_08_123942_labels_display_company_name | 242 | 2017_12_12_010457_normalize_asset_last_audit_date | 243 | 2017_12_12_033618_add_actionlog_meta | 244 | 2017_12_26_170856_re_normalize_last_audit | 245 | 2018_01_17_184354_add_archived_in_list_setting | 246 | 2016_06_01_000001_create_oauth_auth_codes_table | 247 | 2016_06_01_000002_create_oauth_access_tokens_table | 248 | 2016_06_01_000003_create_oauth_refresh_tokens_table | 249 | 2016_06_01_000004_create_oauth_clients_table | 250 | 2016_06_01_000005_create_oauth_personal_acces | 251 | 2018_01_19_203121_add_dashboard_message_to_settings | 252 | 2018_01_24_062633_add_footer_settings_to_settings | 253 | 2018_01_24_093426_add_modellist_preferenc | 254 | 2018_02_22_160436_add_remote_user_settings | 255 | 2018_03_03_011032_add_theme_to_settings | 256 | 2018_03_06_054937_add_default_flag_on_statuslabels | 257 | 2018_03_23_212048_add_display_in_email_to_custom_fields | 258 | 2018_03_24_030738_add_show_images_in_email_setting | 259 | 2018_03_24_050108_add_cc_alerts | 260 | 2018_03_29_053618_add_canceled_at_and_fulfill | 261 | 2018_03_29_070121_add_drop_unique_requests | 262 | 2018_03_29_070511_add_new_index_requestable | 263 | 2018_04_02_150700_labels_display_model_name +-----+---------------------------------------------- 263 rows in set (0.01 sec) ----------------------------+-------+ | batch | ----------------------------+-------+ | 1 | install_groups | 1 | install_users_groups_pivot | 1 | install_throttle | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | rom_status_labels | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | ted_checkout_date_to_assets | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | _support_to_settings_table | 1 | | 1 | | 1 | _to_settings_table | 1 | _custom_fields | 1 | _custom_fieldsets | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | o_model_number | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 2 | | 1 | | 2 | | 1 | | 1 | plier_and_elsewhere | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | es_in_custom_fields | 1 | | 1 | | 1 | | 1 | _importer_table | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | ions_manufacturers_etc | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 3 | | 3 | | 3 | | 3 | s_clients_table | 3 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | ed_at_in_requests | 4 | | 4 | | 4 | | 5 | ----------------------------+-------+

tilldeeke commented 6 years ago

Thanks! Somehow the migration was run, without registering it in the migrations table. How did you upgrade your installation?

Does your licenses table have a category_id column? That would have been added with the migration following create_custom_field_default_values_table. If no, my advice would be to make a backup of the models_custom_fields table (if you have any data in there), drop the table, run the migrations again and replay your backup.

If the column does exist, this gets a lot more complicated. It would probably be easier to make a backup of your files/database, do a fresh install of snipe-it and import your backup. 🤔

somayweall commented 6 years ago

@tilldeeke incredible! That solved it!

I also could not see categories in the /categories page. This fixed that as well.

Much appreciated!

ziyaul121 commented 6 years ago

Dear All,

I am having the same issue post upgrading the Snipe IT, Not able to checkin checkout. Pls help me too to fix out the issue. what does mean of replay your backup. @tilldeeke @thesurfaceofthevoid

In Connection.php line 647:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'models_cust om_fields' already exists (SQL: create table models_custom_fields (id i nt unsigned not null auto_increment primary key, asset_model_id int not n ull, custom_field_id int not null, default_value text null) default cha racter set utf8mb4 collate utf8mb4_unicode_ci engine = InnoDB)

In PDOStatement.php line 107:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'models_cust om_fields' already exists

In PDOStatement.php line 105:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'models_cust om_fields' already exists

EarlRamirez commented 6 years ago

From the root of the snipeit directory run php upgrade.php looks like some thing went wrong with the migration of the DB.

ziyaul121 commented 6 years ago

snipeit]# php upgrade.php

ERROR: This script should not be run as root/admin. Exiting.

So from which ID it need to be run?

EarlRamirez commented 6 years ago

Run the command as the user that own the files.

EarlRamirez commented 6 years ago

There are a few issues, your permission to the storage directory need to be sorted out, you don't seem to be able to access github from your server that is hosting snipeit.

You will need to sort these out before we can proceed.

On Sat, 28 Jul 2018, 16:18 ziyaul121, notifications@github.com wrote:

I have run the command and below is output but still issue persisted.

snipeit]$ php upgrade.php PHP Notice: Undefined offset: 1 in /var/www/snipeit/upgrade.php on line 16 Welcome to the Snipe-IT upgrader.

Please note that this script will not download the latest Snipe-IT files for you unless you have git installed. It simply runs the standard composer and artisan commands needed to finalize the upgrade after. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! WARNING !!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !! If you have any encrypted custom fields, BE SURE TO run the recrypter if upgrading from v3 to v4. !! See the Snipe-IT documentation for help: !! https://snipe-it.readme.io/docs/upgrading-to-v4 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! WARNING !!!!!!!!!!!!!!!!!!!!!!!!!!!!!! STEP 1: Backing up database:

-- Starting backup... Dumping database snipeit... Backup failed because The dump process failed with exitcode 1 : General error : sh: /var/www/snipeit/storage/laravel-backups/temp//snipeit.sql: No such file or directory . Backup failed because: The stream or file "/var/www/snipeit/storage/logs/laravel.log" could not be opened: failed to open stream: Permission denied.

In StreamHandler.php line 107:

The stream or file "/var/www/snipeit/storage/logs/laravel.log" could not be opened: failed to open stream: Permission denied

STEP 2: Putting application into maintenance mode:

-- Application is now in maintenance mode.

STEP 3: Pulling latest from Git (master branch):

Git is installed. Already on 'master'

*** Please tell me who you are.

Run

git config --global user.email "you@example.com" git config --global user.name "Your Name"

to set your account's default identity. Omit --global to set the identity only in this repository.

fatal: empty ident name (for snipeitapp@asset.(none)) not allowed Cannot save the current index state fatal: unable to access 'https://github.com/snipe/snipe-it/': TCP connection reset by peer -- -- M .github/ISSUE_TEMPLATE/Bug_report.md M .github/ISSUE_TEMPLATE/Feature_request.md M public/uploads/accessories/.gitignore M public/uploads/accessories/.gitkeep M public/uploads/assets/.gitignore M public/uploads/assets/.gitkeep M public/uploads/avatars/.gitignore M public/uploads/barcodes/.gitkeep M public/uploads/categories/.gitignore M public/uploads/companies/.gitignore M public/uploads/components/.gitignore M public/uploads/consumables/.gitignore M public/uploads/departments/.gitignore M public/uploads/locations/.gitignore M public/uploads/manufacturers/.gitignore M public/uploads/models/.gitignore M public/uploads/suppliers/.gitignore M storage/private_uploads/assetmodels/.gitignore M storage/private_uploads/assets/.gitignore M storage/private_uploads/imports/.gitignore M storage/private_uploads/licenses/.gitignore M storage/private_uploads/signatures/.gitignore M storage/private_uploads/users/.gitkeep

Step 4: Cleaning up old cached files:

-- No bootstrap/cache/compiled.php, so nothing to delete. -- Deleting bootstrap/cache/services.php. It it no longer used. -- No bootstrap/cache/config.php, so nothing to delete. -- Configuration cache cleared! -- Cache cleared successfully. -- Route cache cleared! -- Compiled views cleared!

Step 5: Updating composer dependencies: (This may take an moment.)

-- We couldn't find a local composer.phar - trying globally.

Generating optimized autoload files Loading composer repositories with package information Installing dependencies from lock file Warning: The lock file is not up to date with the latest changes in composer.json. You may be getting outdated dependencies. Run update to update them. Nothing to install or update Generating optimized autoload files

Step 6: Migrating database:

-- In StreamHandler.php line 107:

The stream or file "/var/www/snipeit/storage/logs/laravel.log" could not be opened: failed to open stream: Permission denied

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/snipe/snipe-it/issues/5920#issuecomment-408591614, or mute the thread https://github.com/notifications/unsubscribe-auth/ALvJq-_IBQuU269HjHgwdx8QRgUqfOqMks5uLB5AgaJpZM4VaHaD .

ziyaul121 commented 6 years ago

$ ls -lrt total 11160 -rw-r--r-- 1 apache apache 11421554 Jul 28 12:21 laravel.log [snipeitapp@asset logs]$ pwd /var/www/snipeit/storage/logs [snipeitapp@asset logs]$ id uid=1001(snipeitapp) gid=1001(snipeitapp) groups=1001(snipeitapp),48(apache) [snipeitapp@asset logs]$

ziyaul121 commented 6 years ago

Ok, I need to provide rw access to laravel.log only?? snipeit]$ ls -ld storage drwxrwxr-x 8 snipeitapp apache 4096 Jul 25 18:01 storage

EarlRamirez commented 6 years ago

Sorry yes, you do sudo chmod -R 0775 storage or you can try 0777

On Sat, 28 Jul 2018, 16:27 ziyaul121, notifications@github.com wrote:

Ok, I need to provide rw access to laravel.log only?? snipeit]$ ls -ld storage drwxrwxr-x 8 snipeitapp apache 4096 Jul 25 18:01 storage

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/snipe/snipe-it/issues/5920#issuecomment-408592063, or mute the thread https://github.com/notifications/unsubscribe-auth/ALvJq4E1BJfetjKlG7cS5Ly9VpW7CFbKks5uLCBZgaJpZM4VaHaD .

ziyaul121 commented 6 years ago

Ok permission issue resolved and run below command found below output.

snipeit]$ php upgrade.php

Step 6: Migrating database:

-- In Connection.php line 647:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'models_custom_fields' already exists (SQL: create table models_custom_fields (id int unsigned not null a uto_increment primary key, asset_model_id int not null, custom_field_id int not null, default_value text null) default character set utf8mb4 collate utf8mb4_unicode_c i engine = InnoDB)

In PDOStatement.php line 107:

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

In PDOStatement.php line 105:

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

EarlRamirez commented 6 years ago

Sorry for asking again, what os are you running?

ziyaul121 commented 6 years ago

snipeit]$ cat /etc/redhat-release CentOS Linux release 7.5.1804

ziyaul121 commented 6 years ago

Please support me to fix out the issue. :(

ziyaul121 commented 6 years ago

As Suggested by @tilldeeke in above comments **"Somehow the migration was run, without registering it in the migrations table. How did you upgrade your installation?

Does your licenses table have a category_id column? That would have been added with the migration following create_custom_field_default_values_table. If no, my advice would be to make a backup of the models_custom_fields table (if you have any data in there), drop the table, run the migrations again and replay your backup."**

I drop the table models_custom_fields and run the migration than below output is showing.

php artisan migrate

Application In Production! *

Do you really wish to run this command? (yes/no) [no]:

yes

In Connection.php line 647:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'login_attempts' already exists (SQL: create table login_attempts (id int unsigned not null auto_incremen t primary key, username varchar(191) null, remote_ip varchar(45) null, user_agent varchar(191) null, successful tinyint(1) null, created_at timestamp null, updat ed_at timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci engine = InnoDB)

In PDOStatement.php line 107:

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

In PDOStatement.php line 105:

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

snipe / snipe-it

Whoops error on checkin or checkout #5920

Expected Behavior (or desired behavior if a feature request)

Actual Behavior

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

Provide answers to these questions:

0 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update assets...', Array, Object(Closure))

1 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(477): Illuminate\Database\Connection->run('update assets...', Array, Object(Closure))

2 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(416): Illuminate\Database\Connection->affectingStatement('update assets...', Array)

3 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\Database\Connection->update('update assets...', Array)

4 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2185): Illuminate\Database\Query\Builder->update(Array)

5 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(773): Illuminate\Database\Query\Builder->increment('checkout_counte...', 1, Array)

6 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(428): Illuminate\Database\Eloquent\Builder->increment('checkout_counte...', 1, Array)

7 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(391): Illuminate\Database\Eloquent\Model->incrementOrDecrement('checkout_counte...', 1, Array, 'increment')

8 /var/www/snipe-it/app/Models/Asset.php(247): Illuminate\Database\Eloquent\Model->increment('checkout_counte...', 1)

9 /var/www/snipe-it/app/Http/Controllers/AssetCheckoutController.php(83): App\Models\Asset->checkOut(Object(App\Models\User), Object(App\Models\User), '2018-07-22 19:2...', '', '', 'brother-printer')

10 [internal function]: App\Http\Controllers\AssetCheckoutController->store(Object(App\Http\Requests\AssetCheckoutRequest), '181')

11 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)

12 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('store', Array)

13 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\AssetCheckoutController), 'store')

14 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()

15 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php(572): Illuminate\Routing\Route->run()

16 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

17 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

18 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))

19 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

20 /var/www/snipe-it/vendor/laravel/passport/src/Http/Middleware/CreateFreshApiToken.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

21 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Laravel\Passport\Http\Middleware\CreateFreshApiToken->handle(Object(Illuminate\Http\Request), Object(Closure))

22 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

23 /var/www/snipe-it/app/Http/Middleware/CheckForTwoFactor.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

24 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\CheckForTwoFactor->handle(Object(Illuminate\Http\Request), Object(Closure))

25 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

26 /var/www/snipe-it/app/Http/Middleware/CheckLocale.php(42): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

27 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\CheckLocale->handle(Object(Illuminate\Http\Request), Object(Closure))

28 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

29 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

30 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))

31 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

32 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

33 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))

34 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

35 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

36 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))

37 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

38 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

39 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

40 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))

41 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

42 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))

43 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))

44 /var/www/snipe-it/vendor/barryvdh/laravel-debugbar/src/Middleware/Debugbar.php(51): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

45 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Barryvdh\Debugbar\Middleware\Debugbar->handle(Object(Illuminate\Http\Request), Object(Closure))

46 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

47 /var/www/snipe-it/app/Http/Middleware/CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

48 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))

49 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

50 /var/www/snipe-it/app/Http/Middleware/CheckForSetup.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

51 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))

52 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

53 /var/www/snipe-it/vendor/fideloper/proxy/src/TrustProxies.php(56): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

54 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))

55 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

56 /var/www/snipe-it/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

57 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

58 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

59 /var/www/snipe-it/app/Http/Middleware/ContentSecurityPolicyHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

60 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\ContentSecurityPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

61 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

62 /var/www/snipe-it/app/Http/Middleware/ReferrerPolicyHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

63 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\ReferrerPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

64 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

65 /var/www/snipe-it/app/Http/Middleware/XssProtectHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

66 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

67 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

68 /var/www/snipe-it/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

69 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

70 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

71 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

72 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))

73 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

0 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update `assets`...', Array, Object(Closure))

1 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(477): Illuminate\Database\Connection->run('update `assets`...', Array, Object(Closure))

2 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(416): Illuminate\Database\Connection->affectingStatement('update `assets`...', Array)

3 /var/www/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\Database\Connection->update('update `assets`...', Array)