Create DB Tables Pre-Flight: Error in SQL syntax

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:

Go to '...'
Click on '....'
Scroll down to '....'
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

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.

snipe / snipe-it

Create DB Tables Pre-Flight: Error in SQL syntax #6181

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