snipe / snipe-it

A free open source IT asset/license management system
https://snipeitapp.com
GNU Affero General Public License v3.0
11.01k stars 3.18k forks source link

Most Settings Give Error - looks like migrations are not completing #6389

Closed pritchard67 closed 5 years ago

pritchard67 commented 5 years ago

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

Describe the bug When I try to update the Settings for Branding I get an error page. This happened on other pages as well and I had to add columns to the database migrations, but adding to the migrations here does not help.

The error this time is SQLSTATE[42S22]: Column not found: 1054 Unknown column 'version_footer' in 'field list' (SQL: update settings set updated_at = 2018-11-02 13:24:34, header_color = #000000, custom_css = , footer_text = , skin = , version_footer = on, logo_print_assets = 0 where id = 1)

Server (please complete the following information):

Error Messages

I'll paste the laravel log below...

Additional context

Add any other context about the problem here.

Please do not post an issue without answering the related questions above. If you have opened a different issue and already answered these questions, answer them again, once for every ticket. It will be next to impossible for us to help you.

[2018-11-02 13:24:34] production.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'version_footer' in 'field list' in C:\wamp64\www\snipe-it\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:77 Stack trace:

0 C:\wamp64\www\snipe-it\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(77): PDO->prepare('update `setting...', Array)

1 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(470): Doctrine\DBAL\Driver\PDOConnection->prepare('update `setting...')

2 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(640): Illuminate\Database\Connection->Illuminate\Database{closure}('update `setting...', Array)

3 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update `setting...', Array, Object(Closure))

4 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(477): Illuminate\Database\Connection->run('update `setting...', Array, Object(Closure))

5 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(416): Illuminate\Database\Connection->affectingStatement('update `setting...', Array)

6 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2147): Illuminate\Database\Connection->update('update `setting...', Array)

7 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(759): Illuminate\Database\Query\Builder->update(Array)

8 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(595): Illuminate\Database\Eloquent\Builder->update(Array)

9 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(515): Illuminate\Database\Eloquent\Model->performUpdate(Object(Illuminate\Database\Eloquent\Builder))

10 C:\wamp64\www\snipe-it\app\Http\Controllers\SettingsController.php(440): Illuminate\Database\Eloquent\Model->save()

11 [internal function]: App\Http\Controllers\SettingsController->postBranding(Object(App\Http\Requests\ImageUploadRequest))

12 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(55): call_user_func_array(Array, Array)

13 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('postBranding', Array)

14 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\SettingsController), 'postBranding')

15 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(160): Illuminate\Routing\Route->runController()

16 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(572): Illuminate\Routing\Route->run()

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

18 C:\wamp64\www\snipe-it\app\Http\Middleware\CheckPermissions.php(28): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

19 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckPermissions->handle(Object(Illuminate\Http\Request), Object(Closure), 'superuser')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

43 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

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

45 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

86 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

87 C:\wamp64\www\snipe-it\public\index.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

88 {main}

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'version_footer' in 'field list' in C:\wamp64\www\snipe-it\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:79 Stack trace:

0 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(470): Doctrine\DBAL\Driver\PDOConnection->prepare('update `setting...')

1 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(640): Illuminate\Database\Connection->Illuminate\Database{closure}('update `setting...', Array)

2 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update `setting...', Array, Object(Closure))

3 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(477): Illuminate\Database\Connection->run('update `setting...', Array, Object(Closure))

4 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(416): Illuminate\Database\Connection->affectingStatement('update `setting...', Array)

5 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2147): Illuminate\Database\Connection->update('update `setting...', Array)

6 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(759): Illuminate\Database\Query\Builder->update(Array)

7 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(595): Illuminate\Database\Eloquent\Builder->update(Array)

8 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(515): Illuminate\Database\Eloquent\Model->performUpdate(Object(Illuminate\Database\Eloquent\Builder))

9 C:\wamp64\www\snipe-it\app\Http\Controllers\SettingsController.php(440): Illuminate\Database\Eloquent\Model->save()

10 [internal function]: App\Http\Controllers\SettingsController->postBranding(Object(App\Http\Requests\ImageUploadRequest))

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

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

13 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\SettingsController), 'postBranding')

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

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

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

17 C:\wamp64\www\snipe-it\app\Http\Middleware\CheckPermissions.php(28): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

18 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckPermissions->handle(Object(Illuminate\Http\Request), Object(Closure), 'superuser')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

42 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

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

44 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

85 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

86 C:\wamp64\www\snipe-it\public\index.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

87 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'version_footer' in 'field list' (SQL: update settings set updated_at = 2018-11-02 13:24:34, header_color = #000000, custom_css = , footer_text = , skin = , version_footer = on, logo_print_assets = 0 where id = 1) in C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php:647 Stack trace:

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

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

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

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

4 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(759): Illuminate\Database\Query\Builder->update(Array)

5 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(595): Illuminate\Database\Eloquent\Builder->update(Array)

6 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(515): Illuminate\Database\Eloquent\Model->performUpdate(Object(Illuminate\Database\Eloquent\Builder))

7 C:\wamp64\www\snipe-it\app\Http\Controllers\SettingsController.php(440): Illuminate\Database\Eloquent\Model->save()

8 [internal function]: App\Http\Controllers\SettingsController->postBranding(Object(App\Http\Requests\ImageUploadRequest))

9 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(55): call_user_func_array(Array, Array)

10 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('postBranding', Array)

11 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\SettingsController), 'postBranding')

12 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(160): Illuminate\Routing\Route->runController()

13 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(572): Illuminate\Routing\Route->run()

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

15 C:\wamp64\www\snipe-it\app\Http\Middleware\CheckPermissions.php(28): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

16 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckPermissions->handle(Object(Illuminate\Http\Request), Object(Closure), 'superuser')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

40 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

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

42 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

83 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

84 C:\wamp64\www\snipe-it\public\index.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

85 {main}

[2018-11-02 13:24:34] production.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'version_footer' in 'field list' in C:\wamp64\www\snipe-it\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:77 Stack trace:

0 C:\wamp64\www\snipe-it\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(77): PDO->prepare('update `setting...', Array)

1 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(470): Doctrine\DBAL\Driver\PDOConnection->prepare('update `setting...')

2 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(640): Illuminate\Database\Connection->Illuminate\Database{closure}('update `setting...', Array)

3 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update `setting...', Array, Object(Closure))

4 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(477): Illuminate\Database\Connection->run('update `setting...', Array, Object(Closure))

5 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(416): Illuminate\Database\Connection->affectingStatement('update `setting...', Array)

6 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2147): Illuminate\Database\Connection->update('update `setting...', Array)

7 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(759): Illuminate\Database\Query\Builder->update(Array)

8 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(595): Illuminate\Database\Eloquent\Builder->update(Array)

9 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(515): Illuminate\Database\Eloquent\Model->performUpdate(Object(Illuminate\Database\Eloquent\Builder))

10 C:\wamp64\www\snipe-it\app\Http\Controllers\SettingsController.php(440): Illuminate\Database\Eloquent\Model->save()

11 [internal function]: App\Http\Controllers\SettingsController->postBranding(Object(App\Http\Requests\ImageUploadRequest))

12 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(55): call_user_func_array(Array, Array)

13 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('postBranding', Array)

14 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\SettingsController), 'postBranding')

15 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(160): Illuminate\Routing\Route->runController()

16 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(572): Illuminate\Routing\Route->run()

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

18 C:\wamp64\www\snipe-it\app\Http\Middleware\CheckPermissions.php(28): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

19 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckPermissions->handle(Object(Illuminate\Http\Request), Object(Closure), 'superuser')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

43 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

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

45 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

86 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

87 C:\wamp64\www\snipe-it\public\index.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

88 {main}

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'version_footer' in 'field list' in C:\wamp64\www\snipe-it\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:79 Stack trace:

0 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(470): Doctrine\DBAL\Driver\PDOConnection->prepare('update `setting...')

1 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(640): Illuminate\Database\Connection->Illuminate\Database{closure}('update `setting...', Array)

2 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update `setting...', Array, Object(Closure))

3 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(477): Illuminate\Database\Connection->run('update `setting...', Array, Object(Closure))

4 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(416): Illuminate\Database\Connection->affectingStatement('update `setting...', Array)

5 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2147): Illuminate\Database\Connection->update('update `setting...', Array)

6 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(759): Illuminate\Database\Query\Builder->update(Array)

7 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(595): Illuminate\Database\Eloquent\Builder->update(Array)

8 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(515): Illuminate\Database\Eloquent\Model->performUpdate(Object(Illuminate\Database\Eloquent\Builder))

9 C:\wamp64\www\snipe-it\app\Http\Controllers\SettingsController.php(440): Illuminate\Database\Eloquent\Model->save()

10 [internal function]: App\Http\Controllers\SettingsController->postBranding(Object(App\Http\Requests\ImageUploadRequest))

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

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

13 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\SettingsController), 'postBranding')

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

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

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

17 C:\wamp64\www\snipe-it\app\Http\Middleware\CheckPermissions.php(28): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

18 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckPermissions->handle(Object(Illuminate\Http\Request), Object(Closure), 'superuser')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

42 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

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

44 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

85 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

86 C:\wamp64\www\snipe-it\public\index.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

87 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'version_footer' in 'field list' (SQL: update settings set updated_at = 2018-11-02 13:24:34, header_color = #000000, custom_css = , footer_text = , skin = , version_footer = on, logo_print_assets = 0 where id = 1) in C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php:647 Stack trace:

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

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

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

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

4 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(759): Illuminate\Database\Query\Builder->update(Array)

5 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(595): Illuminate\Database\Eloquent\Builder->update(Array)

6 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(515): Illuminate\Database\Eloquent\Model->performUpdate(Object(Illuminate\Database\Eloquent\Builder))

7 C:\wamp64\www\snipe-it\app\Http\Controllers\SettingsController.php(440): Illuminate\Database\Eloquent\Model->save()

8 [internal function]: App\Http\Controllers\SettingsController->postBranding(Object(App\Http\Requests\ImageUploadRequest))

9 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(55): call_user_func_array(Array, Array)

10 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('postBranding', Array)

11 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\SettingsController), 'postBranding')

12 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(160): Illuminate\Routing\Route->runController()

13 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(572): Illuminate\Routing\Route->run()

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

15 C:\wamp64\www\snipe-it\app\Http\Middleware\CheckPermissions.php(28): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

16 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckPermissions->handle(Object(Illuminate\Http\Request), Object(Closure), 'superuser')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

40 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

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

42 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

83 C:\wamp64\www\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

84 C:\wamp64\www\snipe-it\public\index.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

85 {main}

snipe commented 5 years ago

but I did also install a fresh new version and pulled over my database and it still shows these issues.

Did you actually run migrations?

pritchard67 commented 5 years ago

Yes, I ran migrations, then imported data from my backup.

snipe commented 5 years ago

Imported data, or imported the sql file? If you imported the sql file, that would have undone the migrations, since you're restoring from an older database schema.

pritchard67 commented 5 years ago

Ha, didn't think about that... will have to check the backup.

snipe commented 5 years ago

You should just be able to run php artisan migrate and it should resolve your issue.

pritchard67 commented 5 years ago

That was giving errors, but now I see it was because my restoring of the old database was dropping and recreating the tables. Now if I do a data only import there are columns missing which I assume were custom fields added in the old version.

snipe commented 5 years ago

What were the errors? You should be able to drop your existing (new) tables (or let your sql drop them for you), import your old backup sql, and then run migrations. The custom fields will be in the old version and will be carried over via the backup, and then everything should be upgraded as expected.

pritchard67 commented 5 years ago

I'll run it again and let you know, but it was something to affect of tables already existing.

pritchard67 commented 5 years ago

In Connection.php line 647:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauthauth codes' already exists (SQL: create table oauth_auth_codes (id varchar(1 00) not null, user_id int not null, client_id int not null, scopes te xt null, revoked tinyint(1) not null, expires_at datetime null) default character set utf8mb4 collate utf8mb4_unicode_ci engine = InnoDB)

In PDOStatement.php line 107:

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

In PDOStatement.php line 105:

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

snipe commented 5 years ago

Drop all of your tables, then run the import SQL, then migrations.

What version are you upgrading from?

pritchard67 commented 5 years ago

I have dropped all tables and run the import. I still get the error when running migrate after that.

v4.2.0 build 3479 (gbf74bb1)

I just realized that the PHP version is older (5.6.34), but would that be an issue?

snipe commented 5 years ago

I have dropped all tables and run the import. I still get the error when running migrate after that.

That doesn't make sense though - if the tables are dropped, oauth_auth_ codes can't already exist.

I just realized that the PHP version is older (5.6.34), but would that be an issue?

No, PHP 5.6.3 is minimum requirement for v4.x of Snipe-IT. We don't require PHP7 until v5 (which isn't out yet.)

pritchard67 commented 5 years ago

oauth_auth_codes is created when I import the database.

snipe commented 5 years ago

Right, but there shouldn't be anything trying to create it again.

snipe commented 5 years ago

Okay, let's do this - drop all tables, import, DO NOT MIGRATE YET. Drop your oauth_* tables ONLY, then migrate.

pritchard67 commented 5 years ago

Same error, now just on models_custom_fields

snipe commented 5 years ago

Something is wrong here. It's as if your old SQL file doesn't have the right migrations stored in it so it's trying to run them again.

snipe commented 5 years ago

What's in your migrations table?

pritchard67 commented 5 years ago

261 entries of the migrations files, most say batch one... maybe 12 or so, including the oauth ones say batch 2.

pritchard67 commented 5 years ago

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

snipe commented 5 years ago

Something is definitely donked here. This is what the migrations table should look for the latest version. Batch number obviously don't really matter here, but notice that your line 261 isn't the same as mine. My 261st migration is 261 2018_04_16_133902_create_custom_field_default_values_table, and yours is 2018_04_02_150700_labels_display_model_name. 2018_04_02_150700_labels_display_model_name (your 261st) is my 271st.

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

So... any suggestions?

jwhulette commented 5 years ago

@pritchard67 First, import your data back in from your backups. Run the migrations, and then check your migrations table against snipes to see if there are any differences.

What DB/version are you using? MySQL/MariaDB?

pritchard67 commented 5 years ago

Closing this out. I wasn't able to resolve via the route I was taking. The issues came from trying to populate a new install from a SQL backup (not a Snipe IT backup). I finally convinced the previous IT company to zip and send the entire Snipe IT folder from their server.

ghost commented 5 years ago

In my case everything works out, but just one step i get an error like if i want to update the branding i get an error which says Whoops, looks like something went wrong. Did the same steps as written in snipe ; created a database and import the old sql database to the newly created one, lastly run php artisan migrate, everything works out but just the brand page , i am not able to understand

jwhulette commented 5 years ago

@closterfield What does the error log say?

ghost commented 5 years ago

the error says in updating the brand setting pages otherwise works fine Whoops, looks like something went wrong.

Thank and Regards, Closterfield Lyngdoh 7308322601

http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free. www.avg.com http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sun, Nov 18, 2018 at 4:45 AM Wes Hulette notifications@github.com wrote:

@closterfield https://github.com/closterfield What does the error log say?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/snipe/snipe-it/issues/6389#issuecomment-439654684, or mute the thread https://github.com/notifications/unsubscribe-auth/AdeL_m8K0oHpjr4Rwn2HdaXHm2fdDn2vks5uwJiigaJpZM4YMFcW .

ghost commented 5 years ago

cn i install the same version of snipe to new server. Why i am saying this is because of these I installed snipe it in one server version 4.1.9 where everything works perfect with the alert of inventory license expiring etc.. I installed snipe in another server version 4.6.6 where it seems to be different the file location, and when running the command on terminals regarding expiring of license i dont receive any mails,, like the one which i used to receive in version 4.1.9

Thank and Regards, Closterfield Lyngdoh 7308322601

On Sun, Nov 18, 2018 at 9:44 AM closterfield lyngdoh clyngdohl8@gmail.com wrote:

the error says in updating the brand setting pages otherwise works fine Whoops, looks like something went wrong.

Thank and Regards, Closterfield Lyngdoh 7308322601

http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free. www.avg.com http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail <#m_-3730831594721897053_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sun, Nov 18, 2018 at 4:45 AM Wes Hulette notifications@github.com wrote:

@closterfield https://github.com/closterfield What does the error log say?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/snipe/snipe-it/issues/6389#issuecomment-439654684, or mute the thread https://github.com/notifications/unsubscribe-auth/AdeL_m8K0oHpjr4Rwn2HdaXHm2fdDn2vks5uwJiigaJpZM4YMFcW .

jwhulette commented 5 years ago

@closterfield What does storage/logs/laravel.log say? Look at this for troubleshooting, https://snipe-it.readme.io/docs/whoops