You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Please provide answers to these questions before posting your bug report:
Version of Snipe-IT you're running
v3.3.0-16-ge52a0f6
What OS and web server you're running Snipe-IT on
CentOS Linux release 7.2.1511 (Core)
Apache/2.4.6 (CentOS)
What method you used to install Snipe-IT (install.sh, manual installation, docker, etc)
Upgade from version 2.1.x using git pull and migration guide
If you're getting an error in your browser, include that error
No error
What specific Snipe-IT page you're on, and what specific element you're interacting with to trigger the error
/hardware/create
If a stacktrace is provided in the error, include that too.
Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'purchase_cost' cannot be null (SQL: insert into assets (model_id, name, serial, company_id, order_number, notes, asset_tag, user_id, archived, physical, depreciate, status_id, warranty_months, purchase_cost, purchase_date, assigned_to, supplier_id, requestable, rtd_location_id, updated_at, created_at) values (2, , asdasd, , , , sl-00186, 1, 0, 1, 0, 10, , , , , 0, 0, , 2016-09-01 14:43:20, 2016-09-01 14:43:20)) in /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:729
Stack trace:
#0 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->runQueryCallback('insert into as...', Array, Object(Closure)) #1 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php(458): Illuminate\Database\Connection->run('insert into as...', Array, Object(Closure)) Ability for admin to check out an asset to a user #2 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): Illuminate\Database\Connection->statement('insert into as...', Array) #3 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into as...', Array) Add category back to Models blade/controller #4 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2082): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `as...', Array, 'id') Needs sexy dashboard summary #5 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id') Disallow models/depreciations/categories to be deleted if they have assets associated #6 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1423): call_user_func_array(Array, Array) Add location to users, propagate those to assets #7 /var/www/html/snipeit/bootstrap/cache/compiled.php(10862): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) Figure out how to handle multi-seat licenses #8 /var/www/html/snipeit/bootstrap/cache/compiled.php(10851): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) Search box isn't hooked up to anything #9 /var/www/html/snipeit/bootstrap/cache/compiled.php(10802): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array) Improve UI of category display to show nesting #10 /var/www/html/snipeit/app/Http/Controllers/AssetsController.php(266): Illuminate\Database\Eloquent\Model->save() Build-out ACLs to set who can view which sections (reports, etc) #11 [internal function]: App\Http\Controllers\AssetsController->postCreate(Object(App\Http\Requests\AssetRequest)) A user (non-admin) should be able to request an asset [$15] #12 /var/www/html/snipeit/bootstrap/cache/compiled.php(9424): call_user_func_array(Array, Array) Column sorting on table displays #13 /var/www/html/snipeit/bootstrap/cache/compiled.php(9486): Illuminate\Routing\Controller->callAction('postCreate', Array) Add "clone" option in edit screen for assets #14 /var/www/html/snipeit/bootstrap/cache/compiled.php(9466): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\AssetsController), Object(Illuminate\Routing\Route), 'postCreate') Option to mark assets as requestable. #15 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Child assets linked to parent assets (HDD, replacement parts, etc) [$100] #16 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Add warrantee field to assets/models #17 /var/www/html/snipeit/app/Http/Middleware/Authenticate.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Move validation out of the controllers and into the models where it belongs #18 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) Seed database with models, manufacturers, categories, etc. #19 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Import functions for users, assets, models, etc #20 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Merge licenses table into assets table #21 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Fix depreciation on model vs asset #22 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Support multiple companies [$500 awarded] #23 /var/www/html/snipeit/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Tighten up checkin/checkout UX #24 /var/www/html/snipeit/bootstrap/cache/compiled.php(9467): Illuminate\Pipeline\Pipeline->then(Object(Closure)) Show number of assets for each asset model in listing page #25 /var/www/html/snipeit/bootstrap/cache/compiled.php(9454): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\AssetsController), Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'postCreate') Handle errors more sanely when nothing in the DB #26 /var/www/html/snipeit/bootstrap/cache/compiled.php(8524): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'App\Http\Contro...', 'postCreate') Depreciation fix #27 /var/www/html/snipeit/bootstrap/cache/compiled.php(8511): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request)) Fix tables on mobile #28 /var/www/html/snipeit/bootstrap/cache/compiled.php(8225): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) Integrate barcode generation #29 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Confirmation screens on delete #30 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Fixing bootstrap process with default values. #31 /var/www/html/snipeit/app/Http/Middleware/CheckPermissions.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Added confirmation popups for deletes #32 [internal function]: App\Http\Middleware\CheckPermissions->handle(Object(Illuminate\Http\Request), Object(Closure), 'assets.create') Add notion of lost, stolen, out for deployment, RTD, etc #33 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Update asset index/view blade to reflect new status #34 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Add CSV export for reports #35 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Make the Edit Profile page look less assy #36 /var/www/html/snipeit/app/Http/Middleware/Authenticate.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) incorrect command chown in README #37 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) Develop #38 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Implement settings #39 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Settings edit #40 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Add asset_type to Asset controller #41 /var/www/html/snipeit/app/Http/Middleware/CheckLocale.php(40): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Fix delete-check on licenses #42 [internal function]: App\Http\Middleware\CheckLocale->handle(Object(Illuminate\Http\Request), Object(Closure)) Fix checkout for licenses #43 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Fix depreciation report with new licenses structure #44 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) When you soft-delete a user, should free up all associated resources #45 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Fix miscount on assets in user view #46 /var/www/html/snipeit/bootstrap/cache/compiled.php(3225): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) When the number of seats is edited, handle that smartly #47 [internal function]: Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) LDAP authentication #48 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Calendar view(s) for asset check out/in, due date, etc. [$20] #49 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) XSS Issues #50 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Add postcode to locations #51 /var/www/html/snipeit/bootstrap/cache/compiled.php(13212): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Make the report columns sortable #52 [internal function]: Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) Add autocomplete to the search box #53 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) New button weirdly placed on my iPad (3rd gen) #54 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Show months until asset is fully depreciated #55 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Disable sorting on action column #56 /var/www/html/snipeit/bootstrap/cache/compiled.php(13149): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Spaces get filtered out #57 [internal function]: Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) Modal stops passing title/message/href through if modal is canceled #58 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Checkin message is wrong #59 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) CSRF protect all of the things #60 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) DB seed fails when mysql is in strict mode #61 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Add 'retired' status #62 /var/www/html/snipeit/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Asset Notes #63 /var/www/html/snipeit/bootstrap/cache/compiled.php(8226): Illuminate\Pipeline\Pipeline->then(Object(Closure)) Notifications for when warranties are expiring... #64 /var/www/html/snipeit/bootstrap/cache/compiled.php(8217): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) Invalid SQL #65 /var/www/html/snipeit/bootstrap/cache/compiled.php(8207): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) Broken Gravatar URL in SSL-only environments #66 /var/www/html/snipeit/bootstrap/cache/compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) Patch 1 #67 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request)) Fix insecure content warnings #68 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Initial install script failing on db installation, tries to drop tables that don't exist #69 /var/www/html/snipeit/vendor/barryvdh/laravel-debugbar/src/Middleware/Debugbar.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Modify the Assets and Licenses controllers and database schemas to work #70 [internal function]: Barryvdh\Debugbar\Middleware\Debugbar->handle(Object(Illuminate\Http\Request), Object(Closure)) Can't edit address fields on locations #71 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Add address to location form #72 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Email input types #73 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) change location to status on assets table header #74 /var/www/html/snipeit/vendor/fideloper/proxy/src/TrustProxies.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) License Count misreporting #75 [internal function]: Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) Purchase as separate entity #76 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Allow '+' in Model Name & No #77 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Expand Manufacturer #78 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Services Management Section [big, needs fleshing out] #79 /var/www/html/snipeit/app/Http/Middleware/CheckForSetup.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Re-jigger the asset displays to make "more info" more prominent #80 [internal function]: App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure)) File uploads #81 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) allow more characters in model name (and number) #82 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Ignoring production configs #83 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Gitignore clean #84 /var/www/html/snipeit/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Replace enumeration of files with wildcard #85 [internal function]: App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure)) Cancel and back buttons on edit forms now take you back properly #86 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Make jquery data tables responsive #87 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Refactor routes/urls to resolve "assets" conflict #88 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Checkin/Checkout should, upon completion, take me back to whereever I came from #89 /var/www/html/snipeit/app/Http/Middleware/XssProtectHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) layout on ipad in Portrait mode is funky #90 [internal function]: App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) 1001 Queries on datatables #91 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Use eager loading to reduce query load on index pages #92 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Ensure that Settings object is only loaded once per-page #93 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Upgrade to bootstrap 3 #94 /var/www/html/snipeit/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Develop #95 [internal function]: App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure)) Removed post-install-cmd php artisan optimize. #96 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Making things a bit more environmentally sensitive... #97 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Custom Model Attributes #98 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Datatables groundwork, minor tweaks. #99 /var/www/html/snipeit/bootstrap/cache/compiled.php(13473): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Fixes mail config documentation #100 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) snipeitapp.com Global - Missing Favicon #101 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) snipeitapp.com Header - H1 Overlaps Description Span #102 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) snipeitapp.com Header - Missing Hover States for Accessibility #103 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) snipeitapp.com Homepage - Text Styled as Link #104 /var/www/html/snipeit/bootstrap/cache/compiled.php(11963): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Fixes mail config documentation #105 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) Two-factor authentication #106 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Fixes composer formatting issues #107 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Removes sorting from actions column. Fixes #56 #108 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Implements first pass at csv exports of reports #109 /var/www/html/snipeit/vendor/misterphilip/maintenance-mode/src/MisterPhilip/MaintenanceMode/Http/Middleware/CheckForMaintenanceMode.php(145): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Started implementing Datatables ... User table partially implemented. #110 [internal function]: MisterPhilip\MaintenanceMode\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) Reduce emphasis on asset name #111 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array) Add EOL field to category or asset model #112 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) Issue #58 - Modal stops passing title/message/href through if modal is canceled #113 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Hard-coded English text strings should be moved to their language files #114 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) Debug mode override and add error/debug log path to README.md #115 /var/www/html/snipeit/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) Fresh install, artisan "Undefined index: driver" error #116 /var/www/html/snipeit/bootstrap/cache/compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure)) Styles messed up on Update User page #117 /var/www/html/snipeit/bootstrap/cache/compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) Change "Serial" field in Create License form to textarea #118 /var/www/html/snipeit/public/index.php(54): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) Added support for QR codes in Asset view #119 {main}
Any errors that appear in your browser's error console.
Expected Behavior (or desired behavior if a feature request)
Creating an asset with an unknown cost, previous versions we would not enter a value.
Actual Behavior
After submitting I am taken back to the create asset screen. Apache logs show a 500 error on post but I am presented with nothing.
Debug output shows the following:
[2016-09-01 14:43:20] production.ERROR: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'purchase_cost' cannot be null in /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:457
Entering a cost corrects the issue.
I also bashed my head kinda hard when I figured it out. Please send ice.
Please confirm you have done the following before posting your bug report:
Please provide answers to these questions before posting your bug report:
v3.3.0-16-ge52a0f6
CentOS Linux release 7.2.1511 (Core)
Apache/2.4.6 (CentOS)
Upgade from version 2.1.x using git pull and migration guide
No error
/hardware/create
Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'purchase_cost' cannot be null (SQL: insert into
assets
(model_id
,name
,serial
,company_id
,order_number
,notes
,asset_tag
,user_id
,archived
,physical
,depreciate
,status_id
,warranty_months
,purchase_cost
,purchase_date
,assigned_to
,supplier_id
,requestable
,rtd_location_id
,updated_at
,created_at
) values (2, , asdasd, , , , sl-00186, 1, 0, 1, 0, 10, , , , , 0, 0, , 2016-09-01 14:43:20, 2016-09-01 14:43:20)) in /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:729Stack trace:
#0 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->runQueryCallback('insert into
as...', Array, Object(Closure)) #1 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php(458): Illuminate\Database\Connection->run('insert into
as...', Array, Object(Closure))Ability for admin to check out an asset to a user #2 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): Illuminate\Database\Connection->statement('insert into
as...', Array) #3 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into
as...', Array)Add category back to Models blade/controller #4 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2082): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `as...', Array, 'id')
Needs sexy dashboard summary #5 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
Disallow models/depreciations/categories to be deleted if they have assets associated #6 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1423): call_user_func_array(Array, Array)
Add location to users, propagate those to assets #7 /var/www/html/snipeit/bootstrap/cache/compiled.php(10862): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
Figure out how to handle multi-seat licenses #8 /var/www/html/snipeit/bootstrap/cache/compiled.php(10851): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
Search box isn't hooked up to anything #9 /var/www/html/snipeit/bootstrap/cache/compiled.php(10802): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array)
Improve UI of category display to show nesting #10 /var/www/html/snipeit/app/Http/Controllers/AssetsController.php(266): Illuminate\Database\Eloquent\Model->save()
Build-out ACLs to set who can view which sections (reports, etc) #11 [internal function]: App\Http\Controllers\AssetsController->postCreate(Object(App\Http\Requests\AssetRequest))
A user (non-admin) should be able to request an asset [$15] #12 /var/www/html/snipeit/bootstrap/cache/compiled.php(9424): call_user_func_array(Array, Array)
Column sorting on table displays #13 /var/www/html/snipeit/bootstrap/cache/compiled.php(9486): Illuminate\Routing\Controller->callAction('postCreate', Array)
Add "clone" option in edit screen for assets #14 /var/www/html/snipeit/bootstrap/cache/compiled.php(9466): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\AssetsController), Object(Illuminate\Routing\Route), 'postCreate')
Option to mark assets as requestable. #15 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Child assets linked to parent assets (HDD, replacement parts, etc) [$100] #16 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Add warrantee field to assets/models #17 /var/www/html/snipeit/app/Http/Middleware/Authenticate.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Move validation out of the controllers and into the models where it belongs #18 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
Seed database with models, manufacturers, categories, etc. #19 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Import functions for users, assets, models, etc #20 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Merge licenses table into assets table #21 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Fix depreciation on model vs asset #22 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Support multiple companies [$500 awarded] #23 /var/www/html/snipeit/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Tighten up checkin/checkout UX #24 /var/www/html/snipeit/bootstrap/cache/compiled.php(9467): Illuminate\Pipeline\Pipeline->then(Object(Closure))
Show number of assets for each asset model in listing page #25 /var/www/html/snipeit/bootstrap/cache/compiled.php(9454): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\AssetsController), Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'postCreate')
Handle errors more sanely when nothing in the DB #26 /var/www/html/snipeit/bootstrap/cache/compiled.php(8524): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'App\Http\Contro...', 'postCreate')
Depreciation fix #27 /var/www/html/snipeit/bootstrap/cache/compiled.php(8511): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request))
Fix tables on mobile #28 /var/www/html/snipeit/bootstrap/cache/compiled.php(8225): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))
Integrate barcode generation #29 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Confirmation screens on delete #30 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Fixing bootstrap process with default values. #31 /var/www/html/snipeit/app/Http/Middleware/CheckPermissions.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Added confirmation popups for deletes #32 [internal function]: App\Http\Middleware\CheckPermissions->handle(Object(Illuminate\Http\Request), Object(Closure), 'assets.create')
Add notion of lost, stolen, out for deployment, RTD, etc #33 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Update asset index/view blade to reflect new status #34 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Add CSV export for reports #35 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Make the Edit Profile page look less assy #36 /var/www/html/snipeit/app/Http/Middleware/Authenticate.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
incorrect command chown in README #37 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
Develop #38 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Implement settings #39 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Settings edit #40 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Add asset_type to Asset controller #41 /var/www/html/snipeit/app/Http/Middleware/CheckLocale.php(40): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Fix delete-check on licenses #42 [internal function]: App\Http\Middleware\CheckLocale->handle(Object(Illuminate\Http\Request), Object(Closure))
Fix checkout for licenses #43 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Fix depreciation report with new licenses structure #44 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
When you soft-delete a user, should free up all associated resources #45 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Fix miscount on assets in user view #46 /var/www/html/snipeit/bootstrap/cache/compiled.php(3225): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
When the number of seats is edited, handle that smartly #47 [internal function]: Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
LDAP authentication #48 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Calendar view(s) for asset check out/in, due date, etc. [$20] #49 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
XSS Issues #50 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Add postcode to locations #51 /var/www/html/snipeit/bootstrap/cache/compiled.php(13212): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Make the report columns sortable #52 [internal function]: Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
Add autocomplete to the search box #53 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
New button weirdly placed on my iPad (3rd gen) #54 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Show months until asset is fully depreciated #55 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Disable sorting on action column #56 /var/www/html/snipeit/bootstrap/cache/compiled.php(13149): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Spaces get filtered out #57 [internal function]: Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
Modal stops passing title/message/href through if modal is canceled #58 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Checkin message is wrong #59 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
CSRF protect all of the things #60 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
DB seed fails when mysql is in strict mode #61 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Add 'retired' status #62 /var/www/html/snipeit/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Asset Notes #63 /var/www/html/snipeit/bootstrap/cache/compiled.php(8226): Illuminate\Pipeline\Pipeline->then(Object(Closure))
Notifications for when warranties are expiring... #64 /var/www/html/snipeit/bootstrap/cache/compiled.php(8217): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
Invalid SQL #65 /var/www/html/snipeit/bootstrap/cache/compiled.php(8207): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
Broken Gravatar URL in SSL-only environments #66 /var/www/html/snipeit/bootstrap/cache/compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
Patch 1 #67 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
Fix insecure content warnings #68 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Initial install script failing on db installation, tries to drop tables that don't exist #69 /var/www/html/snipeit/vendor/barryvdh/laravel-debugbar/src/Middleware/Debugbar.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Modify the Assets and Licenses controllers and database schemas to work #70 [internal function]: Barryvdh\Debugbar\Middleware\Debugbar->handle(Object(Illuminate\Http\Request), Object(Closure))
Can't edit address fields on locations #71 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Add address to location form #72 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Email input types #73 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
change location to status on assets table header #74 /var/www/html/snipeit/vendor/fideloper/proxy/src/TrustProxies.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
License Count misreporting #75 [internal function]: Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
Purchase as separate entity #76 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Allow '+' in Model Name & No #77 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Expand Manufacturer #78 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Services Management Section [big, needs fleshing out] #79 /var/www/html/snipeit/app/Http/Middleware/CheckForSetup.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Re-jigger the asset displays to make "more info" more prominent #80 [internal function]: App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))
File uploads #81 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
allow more characters in model name (and number) #82 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Ignoring production configs #83 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Gitignore clean #84 /var/www/html/snipeit/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Replace enumeration of files with wildcard #85 [internal function]: App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
Cancel and back buttons on edit forms now take you back properly #86 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Make jquery data tables responsive #87 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Refactor routes/urls to resolve "assets" conflict #88 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Checkin/Checkout should, upon completion, take me back to whereever I came from #89 /var/www/html/snipeit/app/Http/Middleware/XssProtectHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
layout on ipad in Portrait mode is funky #90 [internal function]: App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
1001 Queries on datatables #91 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Use eager loading to reduce query load on index pages #92 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Ensure that Settings object is only loaded once per-page #93 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Upgrade to bootstrap 3 #94 /var/www/html/snipeit/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Develop #95 [internal function]: App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
Removed post-install-cmd php artisan optimize. #96 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Making things a bit more environmentally sensitive... #97 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Custom Model Attributes #98 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Datatables groundwork, minor tweaks. #99 /var/www/html/snipeit/bootstrap/cache/compiled.php(13473): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Fixes mail config documentation #100 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
snipeitapp.com Global - Missing Favicon #101 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
snipeitapp.com Header - H1 Overlaps Description Span #102 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
snipeitapp.com Header - Missing Hover States for Accessibility #103 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
snipeitapp.com Homepage - Text Styled as Link #104 /var/www/html/snipeit/bootstrap/cache/compiled.php(11963): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Fixes mail config documentation #105 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
Two-factor authentication #106 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Fixes composer formatting issues #107 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Removes sorting from actions column. Fixes #56 #108 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Implements first pass at csv exports of reports #109 /var/www/html/snipeit/vendor/misterphilip/maintenance-mode/src/MisterPhilip/MaintenanceMode/Http/Middleware/CheckForMaintenanceMode.php(145): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Started implementing Datatables ... User table partially implemented. #110 [internal function]: MisterPhilip\MaintenanceMode\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
Reduce emphasis on asset name #111 /var/www/html/snipeit/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
Add EOL field to category or asset model #112 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
Issue #58 - Modal stops passing title/message/href through if modal is canceled #113 /var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Hard-coded English text strings should be moved to their language files #114 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
Debug mode override and add error/debug log path to README.md #115 /var/www/html/snipeit/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
Fresh install, artisan "Undefined index: driver" error #116 /var/www/html/snipeit/bootstrap/cache/compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure))
Styles messed up on Update User page #117 /var/www/html/snipeit/bootstrap/cache/compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
Change "Serial" field in Create License form to textarea #118 /var/www/html/snipeit/public/index.php(54): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
Added support for QR codes in Asset view #119 {main}
Demo works fine
app/storage/logs
and your webserver's logs.The text was updated successfully, but these errors were encountered: