Snipe-it: Syntax Error Groups Set Permissions

[itnaturenates]

Expected Behavior (or desired behavior if a feature request)

Setting up database tables in Pre-Flight, step 2.

---

Actual Behavior

Getting 3 errors.

(3/3) QueryException
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups set permissions = ? where id = ?' at line 1 (SQL: update groups set permissions = {"admin":1,"users":1,"reports":1} where id = 1)

(2/3) PDOException
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups set permissions = ? where id = ?' at line 1

(1/3) PDOException
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups set permissions = ? where id = ?' at line 1

---

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

• [x] I have enabled debug mode
• [x] I have read checked the Common Issues page

---

Provide answers to these questions:

• Is this a fresh install or an upgrade? Fresh Install
• Version of Snipe-IT you're running 4.6.3
• Version of PHP you're running 7.2.7
• Version of MySQL/MariaDB you're running MySQL Community 8.0.12
• What OS and web server you're running Snipe-IT on Windows Server 2012 IIS 8
• What method you used to install Snipe-IT (install.sh, manual installation, docker, etc) Manual Install
• WITH DEBUG TURNED ON, if you're getting an error in your browser, include that error Listed above
• What specific Snipe-IT page you're on, and what specific element you're interacting with to trigger the error Pre-flight step 2 create database tables
• If a stacktrace is provided in the error, include that too.
• Any errors that appear in your browser's error console.
• Confirm whether the error is reproducible on the demo: https://snipeitapp.com/demo. Pre-flight issue
• Include any additional information you can find in storage/logs and your webserver's logs.
• Include what you've done so far in the installation, and if you got any error messages along the way.
• Indicate whether or not you've manually edited any data directly in the database

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

https://snipe-it.readme.io/docs/getting-help

[EarlRamirez]

Looks like MySQL made some changes with this version, for testing purposes would you be able to try a previous version of MySQL and see if you experience the same behaviour?

[n-v-o]

@EarlRamirez I plan on doing this tonight .

I think you are correct and it's related to MySQL updates with the version

[EarlRamirez]

@n-v-o will you be able to try a previous version of MySQL?

[n-v-o]

@EarlRamirez Yeah, starting on this now, just going to remove 8.0.12 and install 5.7.23

Stack Traces:

`[2018-08-01 23:16:17] production.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups set permissions = ? where id = ?' at line 1 in C:\inetpub\wwwroot\snipe-it\Vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:77
Stack trace:

0 C:\inetpub\wwwroot\snipe-it\Vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(77): PDO->prepare('update groups s...', Array)

1 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(470): Doctrine\DBAL\Driver\PDOConnection->prepare('update groups s...')

2 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(640): Illuminate\Database\Connection->Illuminate\Database{closure}('update groups s...', Array)

3 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update groups s...', Array, Object(Closure))

4 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(477): Illuminate\Database\Connection->run('update groups s...', Array, Object(Closure))

5 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(416): Illuminate\Database\Connection->affectingStatement('update groups s...', Array)

6 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(327): Illuminate\Database\Connection->update('update groups s...', Array)

7 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(221): Illuminate\Database\DatabaseManager->__call('update', Array)

8 C:\inetpub\wwwroot\snipe-itdatabase\migrations\2014_11_04_231416_update_group_field_for_reporting.php(21): Illuminate\Support\Facades\Facade::__callStatic('update', Array)

9 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(359): UpdateGroupFieldForReporting->up()

10 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(365): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()

11 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(177): Illuminate\Database\Migrations\Migrator->runMigration(Object(UpdateGroupFieldForReporting), 'up')

12 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(146): Illuminate\Database\Migrations\Migrator->runUp('C:\inetpub\wwwr...', 2, false)

13 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(95): Illuminate\Database\Migrations\Migrator->runPending(Array, Array)

14 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Console\Migrations\MigrateCommand.php(69): Illuminate\Database\Migrations\Migrator->run(Array, Array)

15 [internal function]: Illuminate\Database\Console\Migrations\MigrateCommand->fire()

16 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(29): call_user_func_array(Array, Array)

17 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()

18 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))

19 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\Container.php(539): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)

20 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Console\Command.php(182): Illuminate\Container\Container->call(Array)

21 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Command\Command.php(251): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))

22 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Console\Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))

23 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Application.php(946): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

24 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Application.php(248): Symfony\Component\Console\Application->doRunCommand(Object(Illuminate\Database\Console\Migrations\MigrateCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

25 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

26 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Console\Application.php(141): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

27 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Console\Kernel.php(220): Illuminate\Console\Application->call('migrate', Object(Illuminate\Support\Collection), NULL)

28 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(221): Illuminate\Foundation\Console\Kernel->call('migrate', Array)

29 C:\inetpub\wwwroot\snipe-itapp\Http\Controllers\SettingsController.php(253): Illuminate\Support\Facades\Facade::__callStatic('call', Array)

30 [internal function]: App\Http\Controllers\SettingsController->getSetupMigrate()

31 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Controller.php(55): call_user_func_array(Array, Array)

32 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('getSetupMigrate', Array)

33 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\SettingsController), 'getSetupMigrate')

34 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Route.php(160): Illuminate\Routing\Route->runController()

35 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(572): Illuminate\Routing\Route->run()

36 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

37 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\passport\src\Http\Middleware\CreateFreshApiToken.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

38 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Laravel\Passport\Http\Middleware\CreateFreshApiToken->handle(Object(Illuminate\Http\Request), Object(Closure))

39 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

40 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckForTwoFactor.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

41 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckForTwoFactor->handle(Object(Illuminate\Http\Request), Object(Closure))

42 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

43 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckLocale.php(42): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

44 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckLocale->handle(Object(Illuminate\Http\Request), Object(Closure))

45 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

46 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

47 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))

48 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

49 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

50 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))

51 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

52 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

53 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))

54 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

55 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

56 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

57 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))

58 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

59 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))

60 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))

61 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

62 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))

63 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

64 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckForSetup.php(35): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

65 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))

66 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

67 C:\inetpub\wwwroot\snipe-it\Vendor\fideloperproxy\src\TrustProxies.php(56): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

68 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))

69 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

70 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

71 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

72 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

73 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\ContentSecurityPolicyHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

74 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\ContentSecurityPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

75 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

76 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\ReferrerPolicyHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

77 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\ReferrerPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

78 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

79 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\XssProtectHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

80 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

81 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

82 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

83 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

84 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

85 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

86 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))

87 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

88 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

89 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))

90 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

91 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

92 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))

93 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

94 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

95 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))

96 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

97 C:\inetpub\wwwroot\snipe-it\publicindex.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

98 {main}

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups set permissions = ? where id = ?' at line 1 in C:\inetpub\wwwroot\snipe-it\Vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:79
Stack trace:

0 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(470): Doctrine\DBAL\Driver\PDOConnection->prepare('update groups s...')

1 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(640): Illuminate\Database\Connection->Illuminate\Database{closure}('update groups s...', Array)

2 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update groups s...', Array, Object(Closure))

3 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(477): Illuminate\Database\Connection->run('update groups s...', Array, Object(Closure))

4 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(416): Illuminate\Database\Connection->affectingStatement('update groups s...', Array)

5 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(327): Illuminate\Database\Connection->update('update groups s...', Array)

6 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(221): Illuminate\Database\DatabaseManager->__call('update', Array)

7 C:\inetpub\wwwroot\snipe-itdatabase\migrations\2014_11_04_231416_update_group_field_for_reporting.php(21): Illuminate\Support\Facades\Facade::__callStatic('update', Array)

8 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(359): UpdateGroupFieldForReporting->up()

9 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(365): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()

10 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(177): Illuminate\Database\Migrations\Migrator->runMigration(Object(UpdateGroupFieldForReporting), 'up')

11 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(146): Illuminate\Database\Migrations\Migrator->runUp('C:\inetpub\wwwr...', 2, false)

12 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(95): Illuminate\Database\Migrations\Migrator->runPending(Array, Array)

13 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Console\Migrations\MigrateCommand.php(69): Illuminate\Database\Migrations\Migrator->run(Array, Array)

14 [internal function]: Illuminate\Database\Console\Migrations\MigrateCommand->fire()

15 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(29): call_user_func_array(Array, Array)

16 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()

17 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))

18 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\Container.php(539): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)

19 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Console\Command.php(182): Illuminate\Container\Container->call(Array)

20 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Command\Command.php(251): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))

21 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Console\Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))

22 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Application.php(946): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

23 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Application.php(248): Symfony\Component\Console\Application->doRunCommand(Object(Illuminate\Database\Console\Migrations\MigrateCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

24 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

25 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Console\Application.php(141): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

26 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Console\Kernel.php(220): Illuminate\Console\Application->call('migrate', Object(Illuminate\Support\Collection), NULL)

27 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(221): Illuminate\Foundation\Console\Kernel->call('migrate', Array)

28 C:\inetpub\wwwroot\snipe-itapp\Http\Controllers\SettingsController.php(253): Illuminate\Support\Facades\Facade::__callStatic('call', Array)

29 [internal function]: App\Http\Controllers\SettingsController->getSetupMigrate()

30 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Controller.php(55): call_user_func_array(Array, Array)

31 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('getSetupMigrate', Array)

32 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\SettingsController), 'getSetupMigrate')

33 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Route.php(160): Illuminate\Routing\Route->runController()

34 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(572): Illuminate\Routing\Route->run()

35 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

36 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\passport\src\Http\Middleware\CreateFreshApiToken.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

37 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Laravel\Passport\Http\Middleware\CreateFreshApiToken->handle(Object(Illuminate\Http\Request), Object(Closure))

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

39 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckForTwoFactor.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

40 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckForTwoFactor->handle(Object(Illuminate\Http\Request), Object(Closure))

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

42 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckLocale.php(42): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

43 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckLocale->handle(Object(Illuminate\Http\Request), Object(Closure))

44 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

45 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

46 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))

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

48 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

49 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))

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

51 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

52 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))

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

54 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

55 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

56 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))

57 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

58 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))

59 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))

60 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

61 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))

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

63 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckForSetup.php(35): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

64 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))

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

66 C:\inetpub\wwwroot\snipe-it\Vendor\fideloperproxy\src\TrustProxies.php(56): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

67 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))

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

69 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

70 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

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

72 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\ContentSecurityPolicyHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

73 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\ContentSecurityPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

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

75 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\ReferrerPolicyHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

76 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\ReferrerPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

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

78 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\XssProtectHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

79 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

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

81 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

82 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

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

84 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

85 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))

86 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

87 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

88 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))

89 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

90 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

91 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))

92 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

93 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

94 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))

95 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

96 C:\inetpub\wwwroot\snipe-it\publicindex.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

97 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups set permissions = ? where id = ?' at line 1 (SQL: update groups set permissions = {"admin":1,"users":1,"reports":1} where id = 1) in C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php:647
Stack trace:

0 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update groups s...', Array, Object(Closure))

1 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(477): Illuminate\Database\Connection->run('update groups s...', Array, Object(Closure))

2 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Connection.php(416): Illuminate\Database\Connection->affectingStatement('update groups s...', Array)

3 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(327): Illuminate\Database\Connection->update('update groups s...', Array)

4 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(221): Illuminate\Database\DatabaseManager->__call('update', Array)

5 C:\inetpub\wwwroot\snipe-itdatabase\migrations\2014_11_04_231416_update_group_field_for_reporting.php(21): Illuminate\Support\Facades\Facade::__callStatic('update', Array)

6 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(359): UpdateGroupFieldForReporting->up()

7 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(365): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()

8 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(177): Illuminate\Database\Migrations\Migrator->runMigration(Object(UpdateGroupFieldForReporting), 'up')

9 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(146): Illuminate\Database\Migrations\Migrator->runUp('C:\inetpub\wwwr...', 2, false)

10 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php(95): Illuminate\Database\Migrations\Migrator->runPending(Array, Array)

11 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Database\Console\Migrations\MigrateCommand.php(69): Illuminate\Database\Migrations\Migrator->run(Array, Array)

12 [internal function]: Illuminate\Database\Console\Migrations\MigrateCommand->fire()

13 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(29): call_user_func_array(Array, Array)

14 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()

15 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))

16 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Container\Container.php(539): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)

17 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Console\Command.php(182): Illuminate\Container\Container->call(Array)

18 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Command\Command.php(251): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))

19 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Console\Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Illuminate\Console\OutputStyle))

20 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Application.php(946): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

21 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Application.php(248): Symfony\Component\Console\Application->doRunCommand(Object(Illuminate\Database\Console\Migrations\MigrateCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

22 C:\inetpub\wwwroot\snipe-it\Vendor\symfony\console\Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

23 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Console\Application.php(141): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))

24 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Console\Kernel.php(220): Illuminate\Console\Application->call('migrate', Object(Illuminate\Support\Collection), NULL)

25 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(221): Illuminate\Foundation\Console\Kernel->call('migrate', Array)

26 C:\inetpub\wwwroot\snipe-itapp\Http\Controllers\SettingsController.php(253): Illuminate\Support\Facades\Facade::__callStatic('call', Array)

27 [internal function]: App\Http\Controllers\SettingsController->getSetupMigrate()

28 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Controller.php(55): call_user_func_array(Array, Array)

29 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('getSetupMigrate', Array)

30 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\SettingsController), 'getSetupMigrate')

31 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Route.php(160): Illuminate\Routing\Route->runController()

32 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(572): Illuminate\Routing\Route->run()

33 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

34 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\passport\src\Http\Middleware\CreateFreshApiToken.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

35 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Laravel\Passport\Http\Middleware\CreateFreshApiToken->handle(Object(Illuminate\Http\Request), Object(Closure))

36 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

37 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckForTwoFactor.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

38 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckForTwoFactor->handle(Object(Illuminate\Http\Request), Object(Closure))

39 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

40 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckLocale.php(42): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

41 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckLocale->handle(Object(Illuminate\Http\Request), Object(Closure))

42 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

43 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

44 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))

45 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

46 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

47 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))

48 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

49 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

50 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))

51 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

52 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

53 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))

54 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))

55 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))

56 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))

57 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))

58 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

59 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))

60 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

61 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\CheckForSetup.php(35): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

62 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))

63 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

64 C:\inetpub\wwwroot\snipe-it\Vendor\fideloperproxy\src\TrustProxies.php(56): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

65 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))

66 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

67 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

68 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

69 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

70 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\ContentSecurityPolicyHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

71 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\ContentSecurityPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

72 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

73 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\ReferrerPolicyHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

74 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\ReferrerPolicyHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

75 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

76 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\XssProtectHeader.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

77 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))

78 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

79 C:\inetpub\wwwroot\snipe-itapp\Http\Middleware\FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

80 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))

81 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

82 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

83 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))

84 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

85 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

86 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))

87 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

88 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

89 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))

90 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))

91 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))

92 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))

93 C:\inetpub\wwwroot\snipe-it\Vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))

94 C:\inetpub\wwwroot\snipe-it\publicindex.php(58): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

95 {main}

`

[n-v-o]

@EarlRamirez Uninstalling 8.0.12 and installing 5.7.23, then going back through the steps did indeed resolve the issue.

[EarlRamirez]

@n-v-o that is what I thought, will have to look at the release notes for MySQL version 8, there is also an issue with MariaDB version 10.2x, can't recall the precise version though, for now, the recommendations will be to stay on the version that works until we get these sorted.

[snipe]

MariaDB 10.2.7+ will work fine with Snipe-IT version 5, since we were able to upgrade the required version of PHP needed to use the Doctrine package that handles that issue. This MySQL Community Edition v8 issue is brand new, and I'm still investigating what's happening here. First I'm seeing it. We haven't changed the way those permissions work recently, I don't think.

[itnaturenates]

I appreciate the investigation into this problem. This is my second/third time to setup Snipe IT this week and I keep running into issues. I'll try again using MariaDB or MySQL 5.7.23

[EarlRamirez]

There is a custom ISO that includes Snipe-IT basically, it just have to
boot the ISO and it will do the work for you, after you initial login
it will force you to change your credentials, generate the app_key and
migrate the DB, then you simply have to point your browser to the IP
address and you should be good to go.

You can give it a try, the link is here ==>
https://github.com/EarlRamirez/snipeit_iso

--
Earl Ramirez [e-mail]

On Thu, 2018-08-02 at 13:35 +0000, itnaturenates wrote:

I appreciate the investigation into this problem. This is my
second/third time to setup Snipe IT this week and I keep running into
issues. I'll try again using MariaDB or MySQL 5.7.23

[EarlRamirez]

@snipe I already started looking at the release notes, will have some bandwidth over the weekend. Will see what I can find and report back

[EarlRamirez]

There were major changes with MySQL 8.0, commands were depreciated, new ones were added. One of the biggest change in this version is how authentication is managed. Based on the little research that I have done, PHP will need to be updated so that it can interface with MySQL 8.x before Snipe-IT can support it.

[stale[bot]]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

[stale[bot]]

This issue has been automatically closed because it has not had recent activity. If you believe this is still an issue, please confirm that this issue is still happening in the most recent version of Snipe-IT and reply to this thread to re-open it.

[rakeshravipati]

Hi,
I am having the same issue,
New Installation,
Installed via git clone and setup manually.
php7.0-fpm, nginx and mysql8.0.

I am facing issue at http://localhost/setup/setup/migrate?

(3/3) QueryException
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups set permissions = ? where id = ?' at line 1 (SQL: update groups set permissions = {"admin":1,"users":1,"reports":1} where id = 1)

Exceptions copied from INSPECTOR:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups set permissions = ? where id = ?' at line 1 (SQL: update groups set permissions = {"admin":1,"users":1,"reports":1} where id = 1)
/snape-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php#647
Illuminate\Database\QueryException
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups set permissions = ? where id = ?' at line 1
/snape-it/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php#79
Doctrine\DBAL\Driver\PDOException
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups set permissions = ? where id = ?' at line 1
/snape-it/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php#77

I have read @n-v-o did not have after downgrading.

Before downgrading my mysql version from 8.0 to 5.7.
Did any one get working with Mysql8.0.

Sorry If I have overlooked the solution.

[itnaturenates]

I ended up having to use 5.7.

[stale[bot]]

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

[rakeshravipati]

I ended up having to use 5.7.

Thank you, I would also use 5.7.

[rakeshravipati]

Thank you @itnaturenates worked with mysql5.7

[kmlucy]

I'm having this issue with mariadb 10.3.11.

Edit: Downgrading to 10.1.37 fixes the issue.

[lieszkol]

This has to do with "groups" becoming a reserved word in MySQL 8+. It's easy enough to fix /database/migrations/2014_11_04_231416_update_group_field_for_reporting.php however full MySQL8+ support only arrived with Laravel 5.5+, so snipe-it would need to be fully updated to run on that for it to be compatible with MySQL8.

I've written about this in issue #6701 "Please support MySQL 8+ (and upgrade to Laravel 5.7)"

[lieszkol]

Update: apparently the v5 update will be using Laravel 5.7 and will support MySQL 8. So we just need to be patient. Yay!!

[stale[bot]]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

[stale[bot]]

This issue has been automatically closed because it has not had recent activity. If you believe this is still an issue, please confirm that this issue is still happening in the most recent version of Snipe-IT and reply to this thread to re-open it.