Create DB Tables Pre-Flight: Error in SQL syntax

[slgoff]

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

Describe the bug
A clear and concise description of what the bug is.

At step two of Pre-Flight, I get 'Whoops something went wrong' and three exceptions, one Query Exception and two PDO exceptions. All three have:

"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"

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Database tables are created.

Screenshots
If applicable, add screenshots to help explain your problem.

Server (please complete the following information):

• Snipe-IT Version: 4.6.4
• OS: [e.g. Ubuntu, CentOS] Windows Server 2016
• Web Server: [e.g. Apache, IIS] IIS
• PHP Version: 7.2.9 VC15 x64 Non Thread Safe

Error Messages

• WITH DEBUG TURNED ON, if you're getting an error in your browser, include that error
• If a stacktrace is provided in the error, include that too.

(3/3) QueryExceptionSQLSTATE[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 Connection.php line 647
at Connection->runQueryCallback('update groups set permissions = ? where id = ?', array('{"admin":1,"users":1,"reports":1}', 1), object(Closure))in Connection.php line 607
at Connection->run('update groups set permissions = ? where id = ?', array('{"admin":1,"users":1,"reports":1}', 1), object(Closure))in Connection.php line 477
at Connection->affectingStatement('update groups set permissions = ? where id = ?', array('{"admin":1,"users":1,"reports":1}', 1))in Connection.php line 416
at Connection->update('update groups set permissions = ? where id = ?', array('{"admin":1,"users":1,"reports":1}', 1))in DatabaseManager.php line 327
at DatabaseManager->__call('update', array('update groups set permissions = ? where id = ?', array('{"admin":1,"users":1,"reports":1}', 1)))in Facade.php line 221
at Facade::__callStatic('update', array('update groups set permissions = ? where id = ?', array('{"admin":1,"users":1,"reports":1}', 1)))in 2014_11_04_231416_update_group_field_for_reporting.php line 21
at UpdateGroupFieldForReporting->up()in Migrator.php line 359
at Migrator->Illuminate\Database\Migrations{closure}()in Migrator.php line 365
at Migrator->runMigration(object(UpdateGroupFieldForReporting), 'up')in Migrator.php line 177
at Migrator->runUp('C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2014_11_04_231416_update_group_field_for_reporting.php', 2, false)in Migrator.php line 146
at Migrator->runPending(array('C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2014_11_04_231416_update_group_field_for_reporting.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2014_11_05_212408_add_fields_to_licenses.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2014_11_07_021042_add_image_to_supplier.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2014_11_20_203007_add_username_to_user.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2014_11_20_223947_add_auto_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2014_11_20_224421_add_prefix_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2014_11_21_104401_change_licence_type.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2014_12_09_082500_add_fields_maintained_term_to_licenses.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_04_155757_increase_user_field_lengths.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_07_013537_add_soft_deleted_to_log.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_10_040958_fix_bad_assigned_to_ids.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_10_053310_migrate_data_to_new_statuses.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_11_044104_migrate_make_license_assigned_null.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_11_104406_migrate_create_requests_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_12_001312_add_mac_address_to_asset.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_12_024100_change_license_notes_type.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_17_231020_add_localonly_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_19_222322_add_logo_and_colors_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_24_072043_add_alerts_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_25_022931_add_eula_fields.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_25_204513_add_accessories_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_26_091228_add_accessories_user_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_26_115128_add_deleted_at_models.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_02_26_233005_add_category_type.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_03_01_231912_update_accepted_at_to_acceptance_id.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_03_05_011929_add_qr_type_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_03_18_055327_add_note_to_user.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_04_29_234704_add_slack_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_05_04_085151_add_parent_id_to_locations_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_05_22_124421_add_reassignable_to_licenses.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_06_10_003314_fix_default_for_user_notes.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_06_10_003554_create_consumables.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_06_15_183253_move_email_to_username.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_06_23_070346_make_email_nullable.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_06_26_213716_create_asset_maintenances_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_07_04_212443_create_custom_fields_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_07_09_014359_add_currency_to_settings_and_locations.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_07_21_122022_add_expected_checkin_date_to_asset_logs.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_07_24_093845_add_checkin_email_to_category_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_07_25_055415_remove_email_unique_constraint.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_07_29_230054_add_thread_id_to_asset_logs_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_07_31_015430_add_accepted_to_assets.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_09_09_195301_add_custom_css_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_09_21_235926_create_custom_field_custom_fieldset.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_09_22_000104_create_custom_fieldsets.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_09_22_003321_add_fieldset_id_to_assets.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_09_22_003413_migrate_mac_address.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_09_28_003314_fix_default_purchase_order.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_10_01_024551_add_accessory_consumable_price_info.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_10_12_192706_add_brand_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_10_22_003314_fix_defaults_accessories.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_10_23_182625_add_checkout_time_and_expected_checkout_date_to_assets.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_05_061015_create_companies_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_05_061115_add_company_id_to_consumables_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_05_183749_image.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_06_092038_add_company_id_to_accessories_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_06_100045_add_company_id_to_users_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_06_134742_add_company_id_to_licenses_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_08_035832_add_company_id_to_assets_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_08_222305_add_ldap_fields_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_15_151803_add_full_multiple_companies_support_to_settings_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_26_195528_import_ldap_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_11_30_191504_remove_fk_company_id.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_12_21_193006_add_ldap_server_cert_ignore_to_settings_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_12_30_233509_add_timestamp_and_userId_to_custom_fields.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2015_12_30_233658_add_timestamp_and_userId_to_custom_fieldsets.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_01_28_041048_add_notes_to_models.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_02_19_070119_add_remember_token_to_users_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_02_19_073625_create_password_resets_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_03_02_193043_add_ldap_flag_to_users.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_03_02_220517_update_ldap_filter_to_longer_field.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_03_08_225351_create_components_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_03_09_024038_add_min_stock_to_tables.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_03_10_133849_add_locale_to_users.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_03_10_135519_add_locale_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_03_11_185621_add_label_settings_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_03_22_125911_fix_custom_fields_regexes.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_04_28_141554_add_show_to_users.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_05_16_164733_add_model_mfg_to_consumable.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_05_19_180351_add_alt_barcode_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_05_19_191146_add_alter_interval.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_05_19_192226_add_inventory_threshold.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_05_20_024859_remove_option_keys_from_settings_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_05_20_143758_remove_option_value_from_settings_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_06_01_140218_add_email_domain_and_format_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_06_22_160725_add_user_id_to_maintenances.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_07_13_150015_add_is_ad_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_07_14_153609_add_ad_domain_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_07_22_003348_fix_custom_fields_regex_stuff.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_07_22_054850_one_more_mac_addr_fix.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_07_22_143045_add_port_to_ldap_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_07_22_153432_add_tls_to_ldap_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_07_27_211034_add_zerofill_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_08_02_124944_add_color_to_statuslabel.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_08_09_002225_add_manufacturer_to_licenses.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_08_12_121613_add_manufacturer_to_accessories_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_08_23_143353_add_new_fields_to_custom_fields.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_08_23_145619_add_show_in_nav_to_status_labels.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_08_30_084634_make_purchase_cost_nullable.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_09_01_141051_add_requestable_to_asset_model.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_09_02_001448_create_checkout_requests_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_09_04_180400_create_actionlog_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_09_04_182149_migrate_asset_log_to_action_log.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_09_19_235935_fix_fieldtype_for_target_type.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_09_23_140722_fix_modelno_in_consumables_to_string.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_09_28_231359_add_company_to_logs.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_10_14_130709_fix_order_number_to_varchar.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_10_16_015024_rename_modelno_to_model_number.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_10_16_015211_rename_consumable_modelno_to_model_number.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_10_16_143235_rename_model_note_to_notes.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_10_16_165052_rename_component_total_qty_to_qty.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_10_19_145520_fix_order_number_in_components_to_string.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_10_27_151715_add_serial_to_components.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_10_27_213251_increase_serial_field_capacity.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_10_29_002724_enable_2fa_fields.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_10_29_082408_add_signature_to_acceptance.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_11_01_030818_fix_forgotten_filename_in_action_logs.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_11_13_020954_rename_component_serial_number_to_serial.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_11_16_172119_increase_purchase_cost_size.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_11_17_161317_longer_state_field_in_location.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_11_17_193706_add_model_number_to_accessories.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_11_24_160405_add_missing_target_type_to_logs_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_12_07_173720_increase_size_of_state_in_suppliers.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_12_19_004212_adjust_locale_length_to_10.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_12_19_133936_extend_phone_lengths_in_supplier_and_elsewhere.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2016_12_27_212631_make_asset_assigned_to_polymorphic.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_01_09_040429_create_locations_ldap_query_field.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_01_14_002418_create_imports_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_01_25_063357_fix_utf8_custom_field_column_names.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_03_03_154632_add_time_date_display_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_03_10_210807_add_fields_to_manufacturer.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_05_08_195520_increase_size_of_field_values_in_custom_fields.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_05_22_204422_create_departments.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_05_22_233509_add_manager_to_locations_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_06_14_122059_add_next_autoincrement_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_06_18_151753_add_header_and_first_row_to_importer_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_07_07_191533_add_login_text.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_07_25_130710_add_thumbsize_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_08_03_160105_set_asset_archived_to_zero_default.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_08_22_180636_add_secure_password_options.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_08_25_074822_add_auditing_tables.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_08_25_101435_add_auditing_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_09_18_225619_fix_assigned_type_not_being_nulled.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_10_03_015503_drop_foreign_keys.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_10_10_123504_allow_nullable_depreciation_id_in_models.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_10_17_133709_add_display_url_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_10_19_120002_add_custom_forgot_password_url.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_10_19_130406_add_image_and_supplier_to_accessories.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_10_20_234129_add_location_indices_to_assets.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_10_25_202930_add_images_uploads_to_locations_manufacturers_etc.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_10_27_180947_denorm_asset_locations.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_10_27_192423_migrate_denormed_asset_locations.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_10_30_182938_add_address_to_user.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_11_08_025918_add_alert_menu_setting.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_11_08_123942_labels_display_company_name.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_12_12_010457_normalize_asset_last_audit_date.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_12_12_033618_add_actionlog_meta.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2017_12_26_170856_re_normalize_last_audit.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_01_17_184354_add_archived_in_list_setting.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_01_19_203121_add_dashboard_message_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_01_24_062633_add_footer_settings_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_01_24_093426_add_modellist_preferenc.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_02_22_160436_add_remote_user_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_03_03_011032_add_theme_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_03_06_054937_add_default_flag_on_statuslabels.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_03_23_212048_add_display_in_email_to_custom_fields.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_03_24_030738_add_show_images_in_email_setting.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_03_24_050108_add_cc_alerts.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_03_29_053618_add_canceled_at_and_fulfilled_at_in_requests.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_03_29_070121_add_drop_unique_requests.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_03_29_070511_add_new_index_requestable.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_04_02_150700_labels_display_model_name.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_04_16_133902_create_custom_field_default_values_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_05_04_073223_add_category_to_licenses.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_05_04_075235_add_update_license_category.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_05_08_031515_add_gdpr_privacy_footer.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_05_14_215229_add_indexes.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_05_14_223646_add_indexes_to_assets.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_05_14_233638_denorm_counters_on_assets.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_05_16_153409_add_first_counter_totals_to_assets.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_06_21_134622_add_version_footer.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_07_05_215440_add_unique_serial_option_to_settings.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_07_17_005911_create_login_attempts_table.php', 'C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations/2018_07_24_154348_add_logo_to_print_assets.php'), array('pretend' => false, 'step' => false))in Migrator.php line 95
at Migrator->run(array('C:\inetpub\wwwroot\Snipe-IT\snipe-it-4.6.4\snipe-it-4.6.4\database\migrations'), array('pretend' => false, 'step' => false))in MigrateCommand.php line 69
at MigrateCommand->fire()
at call_user_func_array(array(object(MigrateCommand), 'fire'), array())in BoundMethod.php line 29
at BoundMethod::Illuminate\Container{closure}()in BoundMethod.php line 87
at BoundMethod::callBoundMethod(object(Application), array(object(MigrateCommand), 'fire'), object(Closure))in BoundMethod.php line 31
at BoundMethod::call(object(Application), array(object(MigrateCommand), 'fire'), array(), null)in Container.php line 539
at Container->call(array(object(MigrateCommand), 'fire'))in Command.php line 182
at Command->execute(object(ArrayInput), object(OutputStyle))in Command.php line 251
at Command->run(object(ArrayInput), object(OutputStyle))in Command.php line 167
at Command->run(object(ArrayInput), object(BufferedOutput))in Application.php line 946
at Application->doRunCommand(object(MigrateCommand), object(ArrayInput), object(BufferedOutput))in Application.php line 248
at Application->doRun(object(ArrayInput), object(BufferedOutput))in Application.php line 148
at Application->run(object(ArrayInput), object(BufferedOutput))in Application.php line 141
at Application->call('migrate', object(Collection), null)in Kernel.php line 220
at Kernel->call('migrate', array('--force' => true))in Facade.php line 221
at Facade::__callStatic('call', array('migrate', array('--force' => true)))in SettingsController.php line 253
at SettingsController->getSetupMigrate()
at call_user_func_array(array(object(SettingsController), 'getSetupMigrate'), array())in Controller.php line 55
at Controller->callAction('getSetupMigrate', array())in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(SettingsController), 'getSetupMigrate')in Route.php line 203
at Route->runController()in Route.php line 160
at Route->run()in Router.php line 572
at Router->Illuminate\Routing{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing{closure}(object(Request))in CreateFreshApiToken.php line 49
at CreateFreshApiToken->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForTwoFactor.php line 49
at CheckForTwoFactor->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckLocale.php line 42
at CheckLocale->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Router.php line 574
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 533
at Router->dispatchToRoute(object(Request))in Router.php line 511
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing{closure}(object(Request))in Debugbar.php line 51
at Debugbar->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForDebug.php line 25
at CheckForDebug->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForSetup.php line 35
at CheckForSetup->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in TrustProxies.php line 56
at TrustProxies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in NosniffGuard.php line 17
at NosniffGuard->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in ContentSecurityPolicyHeader.php line 18
at ContentSecurityPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in ReferrerPolicyHeader.php line 17
at ReferrerPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in XssProtectHeader.php line 18
at XssProtectHeader->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in FrameGuard.php line 17
at FrameGuard->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 58

• Any errors that appear in your browser's error console.

None

• Confirm whether the error is reproducible on the demo: https://snipeitapp.com/demo.

n/a

• Include any additional information you can find in storage/logs and your webserver's logs.

laravel.log shows same stack trace

Additional context

• Is this a fresh install or an upgrade?

Fresh

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

Windows Server 2016 and IIS 10

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

manual

• Include what you've done so far in the installation, and if you got any error messages along the way.

Initially had Maria DB installed, with similar problems. Uninstalled MariaDB and composer, installed MySQL and composer.

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

no

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.

[EarlRamirez]

@slgoff what version of MySQL are you running, the recent version (8.x) implemented a significant amount of changes which will require a few changes on PHP side; therefore, it is recommended to use MySQL version 5.x and not 8.x. There is an issue open for this as well #6023, downgrade your MySQL version and let us know how it goes.

[slgoff]

@EarlRamirez That got me past the Create Tables! Thank you! But now it's not saving my admin user. Fill the page out, hit "save User," and it reloads to a blank Create Admin User page.

[slgoff]

Had the wrong cookie domain in .env. All good now!

[snipe]

Thanks for the follow up!

[lieszkol]

I've written a little about what would need to be done to support MySQL 8 in issue #6701

[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!!