Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to create new asset models under local network. #2985

Closed
1 task
techc0de opened this issue Nov 29, 2016 · 22 comments
Closed
1 task

Unable to create new asset models under local network. #2985

techc0de opened this issue Nov 29, 2016 · 22 comments

Comments

@techc0de
Copy link

techc0de commented Nov 29, 2016

Expected Behavior (or desired behavior if a feature request)

I tried to create a new asset models by the following steps:

  1. Assets>>List All>>Create New
  2. Put in asset tag, click "new" for asset models.
  3. Fill out appropriate details.
  4. Click "Save"
  5. Asset should be save.

Actual Behavior

I tried to create a new asset models by the following steps:

  1. Assets>>List All>>Create New
  2. Put in asset tag, click "new" from the Asset models drop-down menu.
  3. Fill out appropriate details.
  4. Click "Save"
  5. Nothing happen.

The work around is to create new models under Admin settings.
In addition, after I did the work-around solution, I selected "Ready to Deploy" status, and waiting for the user field to populate, but nothing happened, it just spinning circle next to the R2D status.

It worked if I logged under the URL.

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


Please provide answers to these questions before posting your bug report:

  • Version of Snipe-IT you're running: v3.6.0-g91caba0
    php: 5.6.27
    mysql: 5.5.53-0+deb8u1

  • What OS and web server you're running Snipe-IT on: Debian Jessie

  • What method you used to install Snipe-IT (install.sh, manual installation, docker, etc): manual installation

  • 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

  • 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 reproduceable on the demo: not occured

  • Indicate whether or not you've manually edited any data directly in the database: No

@techc0de techc0de changed the title Unable to create new asset models Unable to create new asset models under local IP. Nov 29, 2016
@techc0de techc0de changed the title Unable to create new asset models under local IP. Unable to create new asset models under local network. Nov 29, 2016
@techc0de
Copy link
Author

``#0 [internal function]: Illuminate\Database\Query\Builder->__call('errors', Array)
#1 [internal function]: Illuminate\Database\Query\Builder->errors()
#2 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1426): call_user_func_array(Array, Array)
#3 [internal function]: Illuminate\Database\Eloquent\Builder->__call('errors', Array)
#4 [internal function]: Illuminate\Database\Eloquent\Builder->errors()
#5 /opt/snipe-it/bootstrap/cache/compiled.php(11663): call_user_func_array(Array, Array)
#6 /opt/snipe-it/app/Http/Controllers/LocationsController.php(144): Illuminate\Database\Eloquent\Model->__call('errors', Array)
#7 /opt/snipe-it/app/Http/Controllers/LocationsController.php(144): App\Models\Location->errors()
#8 [internal function]: App\Http\Controllers\LocationsController->store()
#9 /opt/snipe-it/bootstrap/cache/compiled.php(9424): call_user_func_array(Array, Array)
#10 /opt/snipe-it/bootstrap/cache/compiled.php(9486): Illuminate\Routing\Controller->callAction('store', Array)
#11 /opt/snipe-it/bootstrap/cache/compiled.php(9466): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\LocationsController), Object(Illuminate$
#12 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#13 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#14 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#15 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#16 /opt/snipe-it/bootstrap/cache/compiled.php(9467): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#17 /opt/snipe-it/bootstrap/cache/compiled.php(9454): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\LocationsController), Object$
#18 /opt/snipe-it/bootstrap/cache/compiled.php(8524): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Reques$
#19 /opt/snipe-it/bootstrap/cache/compiled.php(8511): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request))
#20 /opt/snipe-it/bootstrap/cache/compiled.php(8225): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))
#21 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#22 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#23 /opt/snipe-it/app/Http/Middleware/Authenticate.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#24 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#26 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#27 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#28 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#29 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#30 /opt/snipe-it/bootstrap/cache/compiled.php(8226): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#31 /opt/snipe-it/bootstrap/cache/compiled.php(8217): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#32 /opt/snipe-it/bootstrap/cache/compiled.php(8207): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#33 /opt/snipe-it/bootstrap/cache/compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#34 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
#35 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#36 /opt/snipe-it/vendor/fideloper/proxy/src/TrustProxies.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#37 [internal function]: Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#39 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#40 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#41 /opt/snipe-it/app/Http/Middleware/CheckForSetup.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#42 [internal function]: App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))
#43 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#44 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#45 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#46 /opt/snipe-it/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#47 [internal function]: App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#49 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#50 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#51 /opt/snipe-it/app/Http/Middleware/XssProtectHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#52 [internal function]: App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
#53 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#54 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#55 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#56 /opt/snipe-it/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#57 [internal function]: App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#59 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#60 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#61 /opt/snipe-it/bootstrap/cache/compiled.php(13474): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#62 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#63 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#64 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#65 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#66 /opt/snipe-it/bootstrap/cache/compiled.php(11964): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#67 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#68 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#69 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#70 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#71 /opt/snipe-it/vendor/misterphilip/maintenance-mode/src/MisterPhilip/MaintenanceMode/Http/Middleware/CheckForMaintenanceMode.php(145): Illuminate\Routing\Pipeline->$
#72 [internal function]: MisterPhilip\MaintenanceMode\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#73 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#74 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#75 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#76 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#77 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#78 /opt/snipe-it/bootstrap/cache/compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#79 /opt/snipe-it/bootstrap/cache/compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#80 /opt/snipe-it/public/index.php(60): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#81 {main}
[2016-11-26 21:49:48] production.ERROR: exception 'BadMethodCallException' with message 'Call to undefined method Illuminate\Database\Query\Builder::errors()' in /opt/$
Stack trace:
#0 [internal function]: Illuminate\Database\Query\Builder->__call('errors', Array)
#1 [internal function]: Illuminate\Database\Query\Builder->errors()
#2 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1426): call_user_func_array(Array, Array)
#3 [internal function]: Illuminate\Database\Eloquent\Builder->__call('errors', Array)
#4 [internal function]: Illuminate\Database\Eloquent\Builder->errors()
#5 /opt/snipe-it/bootstrap/cache/compiled.php(11663): call_user_func_array(Array, Array)
#6 /opt/snipe-it/app/Http/Controllers/LocationsController.php(144): Illuminate\Database\Eloquent\Model->__call('errors', Array)
#7 /opt/snipe-it/app/Http/Controllers/LocationsController.php(144): App\Models\Location->errors()
#8 [internal function]: App\Http\Controllers\LocationsController->store()
#9 /opt/snipe-it/bootstrap/cache/compiled.php(9424): call_user_func_array(Array, Array)
#10 /opt/snipe-it/bootstrap/cache/compiled.php(9486): Illuminate\Routing\Controller->callAction('store', Array)
#11 /opt/snipe-it/bootstrap/cache/compiled.php(9466): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\LocationsController), Object(Illuminate$
#12 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#13 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#14 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#15 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#16 /opt/snipe-it/bootstrap/cache/compiled.php(9467): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#17 /opt/snipe-it/bootstrap/cache/compiled.php(9454): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\LocationsController), Object$
#18 /opt/snipe-it/bootstrap/cache/compiled.php(8524): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Reques$
#19 /opt/snipe-it/bootstrap/cache/compiled.php(8511): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request))
#20 /opt/snipe-it/bootstrap/cache/compiled.php(8225): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))
#21 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#22 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#23 /opt/snipe-it/app/Http/Middleware/Authenticate.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#24 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#26 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#27 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#28 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#29 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#30 /opt/snipe-it/bootstrap/cache/compiled.php(8226): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#31 /opt/snipe-it/bootstrap/cache/compiled.php(8217): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#32 /opt/snipe-it/bootstrap/cache/compiled.php(8207): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#33 /opt/snipe-it/bootstrap/cache/compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#34 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
#35 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#36 /opt/snipe-it/vendor/fideloper/proxy/src/TrustProxies.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#37 [internal function]: Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#39 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#40 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#41 /opt/snipe-it/app/Http/Middleware/CheckForSetup.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#42 [internal function]: App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))
#43 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#44 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#45 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#46 /opt/snipe-it/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#47 [internal function]: App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#49 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#50 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#51 /opt/snipe-it/app/Http/Middleware/XssProtectHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#52 [internal function]: App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
#53 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#54 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#55 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#56 /opt/snipe-it/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#57 [internal function]: App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#59 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#60 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#61 /opt/snipe-it/bootstrap/cache/compiled.php(13474): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#62 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#63 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#64 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#65 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#66 /opt/snipe-it/bootstrap/cache/compiled.php(11964): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#67 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#68 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#69 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#70 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#71 /opt/snipe-it/vendor/misterphilip/maintenance-mode/src/MisterPhilip/MaintenanceMode/Http/Middleware/CheckForMaintenanceMode.php(145): Illuminate\Routing\Pipeline->$
#72 [internal function]: MisterPhilip\MaintenanceMode\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#73 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#74 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#75 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#76 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#77 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#78 /opt/snipe-it/bootstrap/cache/compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#79 /opt/snipe-it/bootstrap/cache/compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#80 /opt/snipe-it/public/index.php(60): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#81 {main}
[2016-11-26 22:13:45] production.DEBUG: Authenticating user against database.
[2016-11-26 22:14:25] production.DEBUG: Authenticating user against database.
[2016-11-26 22:15:21] production.DEBUG: Authenticating user against database.
[2016-11-27 11:06:52] production.DEBUG: Authenticating user against database.
[2016-11-27 11:06:52] production.DEBUG: Local authentication failed.
[2016-11-27 11:07:11] production.DEBUG: Authenticating user against database.
[2016-11-27 11:07:11] production.DEBUG: Local authentication failed.
[2016-11-27 11:07:29] production.DEBUG: Authenticating user against database.
[2016-11-27 11:07:29] production.DEBUG: Local authentication failed.
[2016-11-27 11:08:42] production.DEBUG: Authenticating user against database.
[2016-11-27 11:08:42] production.DEBUG: Local authentication failed.
[2016-11-27 11:09:33] production.DEBUG: Local authentication failed.
[2016-11-27 12:58:42] production.DEBUG: Authenticating user against database.
[2016-11-27 12:58:42] production.DEBUG: Local authentication failed.
[2016-11-27 14:36:21] production.DEBUG: Authenticating user against database.
[2016-11-27 14:36:21] production.DEBUG: Local authentication failed.
[2016-11-27 17:12:44] production.DEBUG: Authenticating user against database.
[2016-11-27 17:14:21] production.DEBUG: Authenticating user against database.
[2016-11-27 17:19:25] production.DEBUG: Authenticating user against database.
[2016-11-27 19:37:04] production.DEBUG: Authenticating user against database.
[2016-11-27 19:47:40] production.DEBUG: Authenticating user against database.
[2016-11-27 20:12:16] production.DEBUG: Authenticating user against database.
[2016-11-27 20:54:01] production.DEBUG: Authenticating user against database.
[2016-11-27 21:10:22] production.DEBUG: Authenticating user against database.
[2016-11-27 21:12:38] production.DEBUG: Authenticating user against database.
[2016-11-28 16:15:44] production.DEBUG: Authenticating user against database.
[2016-11-28 16:15:44] production.DEBUG: Local authentication failed.
[2016-11-28 16:16:13] production.DEBUG: Authenticating user against database.
[2016-11-28 16:16:13] production.DEBUG: Local authentication failed.
[2016-11-28 18:10:11] production.DEBUG: Authenticating user against database.

@snipe
Copy link
Owner

snipe commented Nov 29, 2016

Does that stack trace happen every time you try to save? Also please check for browser errors, and make sure the APP_URL in your .env is EXACTLY the same as the url you're accessing the site from.

@techc0de
Copy link
Author

I'm not sure about the stack. Should I clear the log, and retry that?
The APP_URL is in the https://my.domain.com:5443
and is working fine if I logged under there.

However, if I logged under my local IP>>http://192.168.1.17:5443
then the error persist.

@snipe
Copy link
Owner

snipe commented Nov 29, 2016

You have to access it via the URL in APP_URL. Browsers prevent loading JS from other domains, which means any JS functions won't work if you use a different domain name.

@techc0de
Copy link
Author

Is JS means Java Script?
What if I change to APP_URL to null?
Will that work for local and external url?

@snipe
Copy link
Owner

snipe commented Nov 29, 2016

No, it won't work.

@techc0de
Copy link
Author

I see.
Is the port # relevant to put in the APP_URL?

@snipe
Copy link
Owner

snipe commented Nov 29, 2016

If it's necessary in the URL. then yes

@techc0de
Copy link
Author

by the way, how do I clear out the log ?
Is the bulk asset deletion available?
I can't find it anywhere.

@snipe
Copy link
Owner

snipe commented Nov 29, 2016

by the way, how do I clear out the log ?

Open it and delete the contents, or remove the log file. It should create a new one.

Is the bulk asset deletion available?

Checkboxes in asset listing, then select "Delete" from the dropdown menu.

screen shot 2016-11-28 at 5 58 32 pm

@snipe snipe closed this as completed Nov 29, 2016
@techc0de
Copy link
Author

techc0de commented Nov 29, 2016

Sorry, I meant asset models.
I tried to do a bulk edit of the asset models.

Thanks.

@snipe
Copy link
Owner

snipe commented Nov 29, 2016

No bulk delete for asset models

@techc0de
Copy link
Author

techc0de commented Dec 4, 2016

Hi,

folder permissions:
/opt/snipe-it$ ls -la total 2064 drwxr-xr-x 13 snipeit snipeit 4096 Dec 4 11:05 . drwxr-xr-x 8 root root 4096 Dec 4 11:40 .. drwxr-xr-x 12 snipeit snipeit 4096 Dec 4 11:03 app -rwxr-xr-x 1 snipeit snipeit 1646 Dec 4 11:05 artisan drwxr-xr-x 3 snipeit snipeit 4096 Dec 4 11:03 bootstrap -rwxr-xr-x 1 snipeit snipeit 9210 Dec 4 11:05 c3.php -rwxr-xr-x 1 snipeit snipeit 242 Dec 4 11:05 circle.yml -rwxr-xr-x 1 snipeit snipeit 373 Dec 4 11:05 codeception.yml -rw-r--r-- 1 root root 3230 Dec 4 11:05 CODE_OF_CONDUCT.md -rwxr-xr-x 1 snipeit snipeit 2185 Dec 4 11:05 composer.json -rwxr-xr-x 1 snipeit snipeit 189984 Dec 4 11:05 composer.lock -rwxr-xr-x 1 snipeit snipeit 1706886 Dec 4 11:03 composer.phar drwxr-xr-x 2 snipeit snipeit 4096 Dec 4 11:03 config drwxr-xr-x 5 snipeit snipeit 4096 Dec 4 11:03 database drwxr-xr-x 2 snipeit snipeit 4096 Dec 4 11:03 docker -rwxr-xr-x 1 snipeit snipeit 685 Dec 4 11:05 docker.env -rwxr-xr-x 1 snipeit snipeit 2596 Dec 4 11:05 Dockerfile -rwxr-xr-x 1 snipeit snipeit 67 Dec 4 11:03 .dockerignore -rwxr-xr-x 1 snipeit snipeit 2102 Dec 4 11:24 .env -rwxr-xr-x 1 snipeit snipeit 1896 Dec 4 11:03 .env.example -rwxr-xr-x 1 snipeit snipeit 1764 Dec 4 11:03 .env.testing -rwxr-xr-x 1 snipeit snipeit 1758 Dec 4 11:03 .env.testing-ci -rwxr-xr-x 1 snipeit snipeit 1711 Dec 4 11:05 gh-changelog.php -rwxr-xr-x 1 snipeit snipeit 11 Dec 4 11:03 .gitattributes drwxr-xr-x 2 snipeit snipeit 4096 Dec 4 11:03 .github -rwxr-xr-x 1 snipeit snipeit 756 Dec 4 11:03 .gitignore -rwxr-xr-x 1 snipeit snipeit 1486 Dec 4 11:05 gulpfile.js -rwxr-xr-x 1 snipeit snipeit 1064 Dec 4 11:05 index.html -rwxr-xr-x 1 snipeit snipeit 240 Dec 4 11:05 install.sh -rwxr-xr-x 1 snipeit snipeit 34519 Dec 4 11:05 LICENSE -rwxr-xr-x 1 snipeit snipeit 873 Dec 4 11:05 phpunit.xml drwxr-xr-x 6 snipeit snipeit 4096 Dec 4 11:03 public -rwxr-xr-x 1 snipeit snipeit 3936 Dec 4 11:05 README.md drwxr-xr-x 6 snipeit snipeit 4096 Dec 4 11:03 resources -rwxr-xr-x 1 snipeit snipeit 567 Dec 4 11:05 server.php -rwxr-xr-x 1 snipeit snipeit 19614 Dec 4 11:05 snipeit.sh drwxr-xr-x 8 www-data www-data 4096 Dec 4 11:03 storage drwxr-xr-x 9 snipeit snipeit 4096 Dec 4 11:05 tests -rwxr-xr-x 1 snipeit snipeit 1895 Dec 4 11:03 .travis.yml drwxr-xr-x 37 snipeit snipeit 4096 Dec 4 11:08 vendor

I currently have two issues with v3.6.1:

  1. After the upgrade, the cipher keys isn't working due to the invalid cipher keys length from config/app.php. 'cipher' => 'rijndael-256'
    I had to changed it to 'cipher' => 'AES-128-CBC', to able to access Snipe-It.

  2. I can't create Asset Model from the Asset menu, only from the Admin panel.
    I even generated new key too.

Tried with/without: port number.
https://abc.xyz.com:5443
https://abc.xyz.com

Log:

[2016-12-04 11:28:27] production.ERROR: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'note' in 'field list'' in /opt/s$ Stack trace: #0 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(457): PDO->prepare('insert into mo...')
#1 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(722): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate$
#2 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->runQueryCallback('insert into mo...', Array, Ob$ #3 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(458): Illuminate\Database\Connection->run('insert into mo...', Array, Object(Closure))
#4 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): Illuminate\Database\Connection->statement('insert into mo...', Array) #5 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into mo...', Arra$
#6 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2107): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Il$
#7 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1423): call_user_func_array(Array, Array)
#9 /opt/snipe-it/bootstrap/cache/compiled.php(10862): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#10 /opt/snipe-it/bootstrap/cache/compiled.php(10862): Illuminate\Database\Eloquent\Builder->insertGetId(Array, 'id')
#11 /opt/snipe-it/bootstrap/cache/compiled.php(10851): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#12 /opt/snipe-it/bootstrap/cache/compiled.php(10802): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array)
#13 /opt/snipe-it/app/Http/Controllers/AssetModelsController.php(157): Illuminate\Database\Eloquent\Model->save()
#14 [internal function]: App\Http\Controllers\AssetModelsController->store()
#15 /opt/snipe-it/bootstrap/cache/compiled.php(9424): call_user_func_array(Array, Array)
#16 /opt/snipe-it/bootstrap/cache/compiled.php(9486): Illuminate\Routing\Controller->callAction('store', Array)
#17 /opt/snipe-it/bootstrap/cache/compiled.php(9466): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\AssetModelsController), Object(Illumina$
#18 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#19 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#20 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#21 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#22 /opt/snipe-it/bootstrap/cache/compiled.php(9467): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#23 /opt/snipe-it/bootstrap/cache/compiled.php(9454): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\AssetModelsController), Obje$
#24 /opt/snipe-it/bootstrap/cache/compiled.php(8524): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Reques$
#25 /opt/snipe-it/bootstrap/cache/compiled.php(8511): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request))
#26 /opt/snipe-it/bootstrap/cache/compiled.php(8225): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))
#27 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#28 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#29 /opt/snipe-it/app/Http/Middleware/Authenticate.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#30 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#32 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#33 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#34 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#35 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#36 /opt/snipe-it/bootstrap/cache/compiled.php(8226): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#37 /opt/snipe-it/bootstrap/cache/compiled.php(8217): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#38 /opt/snipe-it/bootstrap/cache/compiled.php(8207): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#39 /opt/snipe-it/bootstrap/cache/compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#40 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
#41 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#42 /opt/snipe-it/app/Http/Middleware/CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#43 [internal function]: App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#45 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#46 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#47 /opt/snipe-it/vendor/fideloper/proxy/src/TrustProxies.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#48 [internal function]: Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#49 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#50 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#51 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#52 /opt/snipe-it/app/Http/Middleware/CheckForSetup.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#53 [internal function]: App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#55 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#56 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#57 /opt/snipe-it/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#58 [internal function]: App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#59 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#60 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#61 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#62 /opt/snipe-it/app/Http/Middleware/XssProtectHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#63 [internal function]: App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
#64 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#65 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#66 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#67 /opt/snipe-it/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#68 [internal function]: App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#69 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#70 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#71 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#72 /opt/snipe-it/bootstrap/cache/compiled.php(13474): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#73 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#74 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#75 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#76 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#77 /opt/snipe-it/bootstrap/cache/compiled.php(11964): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#78 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#79 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#80 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#81 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#82 /opt/snipe-it/vendor/misterphilip/maintenance-mode/src/MisterPhilip/MaintenanceMode/Http/Middleware/CheckForMaintenanceMode.php(145): Illuminate\Routing\Pipeline->$
#83 [internal function]: MisterPhilip\MaintenanceMode\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#84 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#85 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#86 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#87 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#88 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#89 /opt/snipe-it/bootstrap/cache/compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#90 /opt/snipe-it/bootstrap/cache/compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#91 /opt/snipe-it/public/index.php(60): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#92 {main}

Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'note' in 'field list' (SQL: insert into mode$ Stack trace: #0 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->runQueryCallback('insert into mo...', Array, Ob$
#1 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(458): Illuminate\Database\Connection->run('insert into mo...', Array, Object(Closure)) #2 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): Illuminate\Database\Connection->statement('insert into mo...', Array)
#3 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `mo...', Arra$
#4 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2107): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Il$
#5 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1423): call_user_func_array(Array, Array)
#7 /opt/snipe-it/bootstrap/cache/compiled.php(10862): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#8 /opt/snipe-it/bootstrap/cache/compiled.php(10862): Illuminate\Database\Eloquent\Builder->insertGetId(Array, 'id')
#9 /opt/snipe-it/bootstrap/cache/compiled.php(10851): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 /opt/snipe-it/bootstrap/cache/compiled.php(10802): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array)
#11 /opt/snipe-it/app/Http/Controllers/AssetModelsController.php(157): Illuminate\Database\Eloquent\Model->save()
#12 [internal function]: App\Http\Controllers\AssetModelsController->store()
#13 /opt/snipe-it/bootstrap/cache/compiled.php(9424): call_user_func_array(Array, Array)
#14 /opt/snipe-it/bootstrap/cache/compiled.php(9486): Illuminate\Routing\Controller->callAction('store', Array)
#15 /opt/snipe-it/bootstrap/cache/compiled.php(9466): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\AssetModelsController), Object(Illumina$
#16 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#17 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#18 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#19 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#20 /opt/snipe-it/bootstrap/cache/compiled.php(9467): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#21 /opt/snipe-it/bootstrap/cache/compiled.php(9454): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\AssetModelsController), Obje$
#22 /opt/snipe-it/bootstrap/cache/compiled.php(8524): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Reques$
#23 /opt/snipe-it/bootstrap/cache/compiled.php(8511): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request))
#24 /opt/snipe-it/bootstrap/cache/compiled.php(8225): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))
#25 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#26 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#27 /opt/snipe-it/app/Http/Middleware/Authenticate.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#28 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#30 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#31 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#32 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#33 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#34 /opt/snipe-it/bootstrap/cache/compiled.php(8226): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#35 /opt/snipe-it/bootstrap/cache/compiled.php(8217): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#36 /opt/snipe-it/bootstrap/cache/compiled.php(8207): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#37 /opt/snipe-it/bootstrap/cache/compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#38 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
#39 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#40 /opt/snipe-it/app/Http/Middleware/CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#42 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#43 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#44 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#45 /opt/snipe-it/vendor/fideloper/proxy/src/TrustProxies.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#46 [internal function]: Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#48 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#49 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#50 /opt/snipe-it/app/Http/Middleware/CheckForSetup.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#51 [internal function]: App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#53 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#54 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#55 /opt/snipe-it/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#56 [internal function]: App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#58 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#59 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#60 /opt/snipe-it/app/Http/Middleware/XssProtectHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#61 [internal function]: App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
#62 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#63 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#64 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#65 /opt/snipe-it/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#66 [internal function]: App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#67 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#68 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#69 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#70 /opt/snipe-it/bootstrap/cache/compiled.php(13474): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#71 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#72 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#73 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#74 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#75 /opt/snipe-it/bootstrap/cache/compiled.php(11964): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#76 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#77 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#78 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#79 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#80 /opt/snipe-it/vendor/misterphilip/maintenance-mode/src/MisterPhilip/MaintenanceMode/Http/Middleware/CheckForMaintenanceMode.php(145): Illuminate\Routing\Pipeline->$

`

@dmeltzer
Copy link
Contributor

dmeltzer commented Dec 4, 2016

Did you run php artisan migrate when upgrading?

@techc0de
Copy link
Author

techc0de commented Dec 4, 2016

Yes, I ran all the commands instructed:

`php artisan config:clear
php composer.phar install --no-dev --prefer-source
php composer.phar dump-autoload
php artisan migrate

`

@dmeltzer dmeltzer mentioned this issue Dec 4, 2016
@dmeltzer
Copy link
Contributor

dmeltzer commented Dec 4, 2016

Oops, that's actually a bug. Will be fixed in develop shortly.

dmeltzer added a commit to dmeltzer/snipe-it that referenced this issue Dec 4, 2016
@techc0de
Copy link
Author

techc0de commented Dec 4, 2016

Thanks for the prompt responses.
You're guys are awesome.

Regarding issue #1, Do I need to change the key type after each upgrade?

@snipe
Copy link
Owner

snipe commented Dec 4, 2016

Any time you edit a file like that, you'll have to do it every time. It's why we don't recommend editing those files (including changing the cipher type)

@techc0de
Copy link
Author

techc0de commented Dec 4, 2016

If I don't change the cipher type, then Snipe-IT will not work.
What's your suggestion?

@snipe
Copy link
Owner

snipe commented Dec 4, 2016

Can you define 'will not work'?

@snipe
Copy link
Owner

snipe commented Dec 4, 2016

It defaults to using an mcrypt cipher. Install mcrypt and the existing cipher should work. But you can't change it from one to the other if you have any encrypted values in the db (encrypted custom fields, LDAP password, etc)

@techc0de
Copy link
Author

techc0de commented Dec 4, 2016

Well, Snipe-IT page gave me an error when I did the installation and after the upgrade.
So I did some research, and some users said to change the cipher type, and it worked.
Do I need to install mcrypt to avoid this error in the future?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants