MariaDB Error #3947

hairysamurai · 2017-09-12T05:22:35Z

Expected Behavior (or desired behavior if a feature request)

Performing a manual installation of Snipe-IT. Grabbed required files, and all configured correctly up to the point where I am at the Pre-Flight Stage. And it's ready to start creating the database.

Actual Behavior

When the database creation page is requested, I get a SQL Query Exception.

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

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

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

Server OS: Ubuntu 16.04
HTTP Server: Nginx 1.10.3
MariaDB Server: 10.2.8
Installation Method: Manual
Snipe Version: Latest pull from Github as of 12/09/2017

Error

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '''' at line 1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '''' at line 1 (SQL: ALTER TABLE licenses CHANGE notes notes TEXT DEFAULT ''NULL'')

in Connection.php line 729
at Connection->runQueryCallback('ALTER TABLE licenses CHANGE notes notes TEXT DEFAULT ''NULL''', array(), object(Closure)) in Connection.php line 685
at Connection->run('ALTER TABLE licenses CHANGE notes notes TEXT DEFAULT ''NULL''', array(), object(Closure)) in Connection.php line 458
at Connection->statement('ALTER TABLE licenses CHANGE notes notes TEXT DEFAULT ''NULL''') in Blueprint.php line 83
at Blueprint->build(object(MySqlConnection), object(MySqlGrammar)) in Builder.php line 229
at Builder->build(object(Blueprint)) in Builder.php line 130
at Builder->table('licenses', object(Closure)) in compiled.php line 6327
at Facade::__callStatic('table', array('licenses', object(Closure))) in 2015_02_12_024100_change_license_notes_type.php line 15
at ChangeLicenseNotesType->up() in Migrator.php line 147
at Migrator->runUp('2015_02_12_024100_change_license_notes_type', '2', false) in Migrator.php line 117
at Migrator->runMigrationList(array('2015_02_12_024100_change_license_notes_type', '2015_02_17_231020_add_localonly_to_settings', '2015_02_19_222322_add_logo_and_colors_to_settings', '2015_02_24_072043_add_alerts_to_settings', '2015_02_25_022931_add_eula_fields', '2015_02_25_204513_add_accessories_table', '2015_02_26_091228_add_accessories_user_table', '2015_02_26_115128_add_deleted_at_models', '2015_02_26_233005_add_category_type', '2015_03_01_231912_update_accepted_at_to_acceptance_id', '2015_03_05_011929_add_qr_type_to_settings', '2015_03_18_055327_add_note_to_user', '2015_04_29_234704_add_slack_to_settings', '2015_05_04_085151_add_parent_id_to_locations_table', '2015_05_22_124421_add_reassignable_to_licenses', '2015_06_10_003314_fix_default_for_user_notes', '2015_06_10_003554_create_consumables', '2015_06_15_183253_move_email_to_username', '2015_06_23_070346_make_email_nullable', '2015_06_26_213716_create_asset_maintenances_table', '2015_07_04_212443_create_custom_fields_table', '2015_07_09_014359_add_currency_to_settings_and_locations', '2015_07_21_122022_add_expected_checkin_date_to_asset_logs', '2015_07_24_093845_add_checkin_email_to_category_table', '2015_07_25_055415_remove_email_unique_constraint', '2015_07_29_230054_add_thread_id_to_asset_logs_table', '2015_07_31_015430_add_accepted_to_assets', '2015_09_09_195301_add_custom_css_to_settings', '2015_09_21_235926_create_custom_field_custom_fieldset', '2015_09_22_000104_create_custom_fieldsets', '2015_09_22_003321_add_fieldset_id_to_assets', '2015_09_22_003413_migrate_mac_address', '2015_09_28_003314_fix_default_purchase_order', '2015_10_01_024551_add_accessory_consumable_price_info', '2015_10_12_192706_add_brand_to_settings', '2015_10_22_003314_fix_defaults_accessories', '2015_10_23_182625_add_checkout_time_and_expected_checkout_date_to_assets', '2015_11_05_061015_create_companies_table', '2015_11_05_061115_add_company_id_to_consumables_table', '2015_11_05_183749_image', '2015_11_06_092038_add_company_id_to_accessories_table', '2015_11_06_100045_add_company_id_to_users_table', '2015_11_06_134742_add_company_id_to_licenses_table', '2015_11_08_035832_add_company_id_to_assets_table', '2015_11_08_222305_add_ldap_fields_to_settings', '2015_11_15_151803_add_full_multiple_companies_support_to_settings_table', '2015_11_26_195528_import_ldap_settings', '2015_11_30_191504_remove_fk_company_id', '2015_12_21_193006_add_ldap_server_cert_ignore_to_settings_table', '2015_12_30_233509_add_timestamp_and_userId_to_custom_fields', '2015_12_30_233658_add_timestamp_and_userId_to_custom_fieldsets', '2016_01_28_041048_add_notes_to_models', '2016_02_19_070119_add_remember_token_to_users_table', '2016_02_19_073625_create_password_resets_table', '2016_03_02_193043_add_ldap_flag_to_users', '2016_03_02_220517_update_ldap_filter_to_longer_field', '2016_03_08_225351_create_components_table', '2016_03_09_024038_add_min_stock_to_tables', '2016_03_10_133849_add_locale_to_users', '2016_03_10_135519_add_locale_to_settings', '2016_03_11_185621_add_label_settings_to_settings', '2016_03_22_125911_fix_custom_fields_regexes', '2016_04_28_141554_add_show_to_users', '2016_05_16_164733_add_model_mfg_to_consumable', '2016_05_19_180351_add_alt_barcode_settings', '2016_05_19_191146_add_alter_interval', '2016_05_19_192226_add_inventory_threshold', '2016_05_20_024859_remove_option_keys_from_settings_table', '2016_05_20_143758_remove_option_value_from_settings_table', '2016_06_01_140218_add_email_domain_and_format_to_settings', '2016_06_22_160725_add_user_id_to_maintenances', '2016_07_13_150015_add_is_ad_to_settings', '2016_07_14_153609_add_ad_domain_to_settings', '2016_07_22_003348_fix_custom_fields_regex_stuff', '2016_07_22_054850_one_more_mac_addr_fix', '2016_07_22_143045_add_port_to_ldap_settings', '2016_07_22_153432_add_tls_to_ldap_settings', '2016_07_27_211034_add_zerofill_to_settings', '2016_08_02_124944_add_color_to_statuslabel', '2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings', '2016_08_09_002225_add_manufacturer_to_licenses', '2016_08_12_121613_add_manufacturer_to_accessories_table', '2016_08_23_143353_add_new_fields_to_custom_fields', '2016_08_23_145619_add_show_in_nav_to_status_labels', '2016_08_30_084634_make_purchase_cost_nullable', '2016_09_01_141051_add_requestable_to_asset_model', '2016_09_02_001448_create_checkout_requests_table', '2016_09_04_180400_create_actionlog_table', '2016_09_04_182149_migrate_asset_log_to_action_log', '2016_09_19_235935_fix_fieldtype_for_target_type', '2016_09_23_140722_fix_modelno_in_consumables_to_string', '2016_09_28_231359_add_company_to_logs', '2016_10_14_130709_fix_order_number_to_varchar', '2016_10_16_015024_rename_modelno_to_model_number', '2016_10_16_015211_rename_consumable_modelno_to_model_number', '2016_10_16_143235_rename_model_note_to_notes', '2016_10_16_165052_rename_component_total_qty_to_qty', '2016_10_19_145520_fix_order_number_in_components_to_string', '2016_10_27_151715_add_serial_to_components', '2016_10_27_213251_increase_serial_field_capacity', '2016_10_29_002724_enable_2fa_fields', '2016_10_29_082408_add_signature_to_acceptance', '2016_11_01_030818_fix_forgotten_filename_in_action_logs', '2016_11_13_020954_rename_component_serial_number_to_serial', '2016_11_16_172119_increase_purchase_cost_size', '2016_11_17_161317_longer_state_field_in_location', '2016_11_17_193706_add_model_number_to_accessories', '2016_11_24_160405_add_missing_target_type_to_logs_table', '2016_12_07_173720_increase_size_of_state_in_suppliers'), array('pretend' => false, 'step' => false)) in Migrator.php line 86
at Migrator->run('/opt/snipe-it/database/migrations', array('pretend' => false, 'step' => false)) in MigrateCommand.php line 76
at MigrateCommand->fire()
at call_user_func_array(array(object(MigrateCommand), 'fire'), array()) in compiled.php line 1257
at Container->call(array(object(MigrateCommand), 'fire')) in Command.php line 169
at Command->execute(object(ArrayInput), object(BufferedOutput)) in Command.php line 256
at Command->run(object(ArrayInput), object(BufferedOutput)) in Command.php line 155
at Command->run(object(ArrayInput), object(BufferedOutput)) in Application.php line 794
at Application->doRunCommand(object(MigrateCommand), object(ArrayInput), object(BufferedOutput)) in Application.php line 186
at Application->doRun(object(ArrayInput), object(BufferedOutput)) in Application.php line 117
at Application->run(object(ArrayInput), object(BufferedOutput)) in Application.php line 64
at Application->call('migrate', object(Collection)) in Kernel.php line 170
at Kernel->call('migrate', array('--force' => true)) in compiled.php line 6327
at Facade::__callStatic('call', array('migrate', array('--force' => true))) in SettingsController.php line 247
at SettingsController->getSetupMigrate()
at call_user_func_array(array(object(SettingsController), 'getSetupMigrate'), array()) in compiled.php line 9424
at Controller->callAction('getSetupMigrate', array()) in compiled.php line 9486
at ControllerDispatcher->call(object(SettingsController), object(Route), 'getSetupMigrate') in compiled.php line 9466
at ControllerDispatcher->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9948
at Pipeline->then(object(Closure)) in compiled.php line 9467
at ControllerDispatcher->callWithinStack(object(SettingsController), object(Route), object(Request), 'getSetupMigrate') in compiled.php line 9454
at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\SettingsController', 'getSetupMigrate') in compiled.php line 8524
at Route->runController(object(Request)) in compiled.php line 8511
at Route->run(object(Request)) in compiled.php line 8225
at Router->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForTwoFactor.php line 49
at CheckForTwoFactor->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForTwoFactor), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckLocale.php line 42
at CheckLocale->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckLocale), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3225
at VerifyCsrfToken->handle(object(Request), object(Closure))
at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13213
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13150
at EncryptCookies->handle(object(Request), object(Closure))
at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9948
at Pipeline->then(object(Closure)) in compiled.php line 8226
at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8217
at Router->dispatchToRoute(object(Request)) in compiled.php line 8207
at Router->dispatch(object(Request)) in compiled.php line 2419
at Kernel->Illuminate\Foundation\Http{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49
at Debugbar->handle(object(Request), object(Closure))
at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForDebug.php line 25
at CheckForDebug->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForDebug), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in TrustProxies.php line 46
at TrustProxies->handle(object(Request), object(Closure))
at call_user_func_array(array(object(TrustProxies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForSetup.php line 35
at CheckForSetup->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForSetup), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in NosniffGuard.php line 17
at NosniffGuard->handle(object(Request), object(Closure))
at call_user_func_array(array(object(NosniffGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in XssProtectHeader.php line 17
at XssProtectHeader->handle(object(Request), object(Closure))
at call_user_func_array(array(object(XssProtectHeader), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in FrameGuard.php line 17
at FrameGuard->handle(object(Request), object(Closure))
at call_user_func_array(array(object(FrameGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13474
at ShareErrorsFromSession->handle(object(Request), object(Closure))
at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 11964
at StartSession->handle(object(Request), object(Closure))
at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForMaintenanceMode.php line 145
at CheckForMaintenanceMode->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9948
at Pipeline->then(object(Closure)) in compiled.php line 2366
at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2350
at Kernel->handle(object(Request)) in index.php line 59

in Connection.php line 457
at PDO->prepare('ALTER TABLE licenses CHANGE notes notes TEXT DEFAULT ''NULL''') in Connection.php line 457
at Connection->Illuminate\Database{closure}(object(MySqlConnection), 'ALTER TABLE licenses CHANGE notes notes TEXT DEFAULT ''NULL''', array()) in Connection.php line 722
at Connection->runQueryCallback('ALTER TABLE licenses CHANGE notes notes TEXT DEFAULT ''NULL''', array(), object(Closure)) in Connection.php line 685
at Connection->run('ALTER TABLE licenses CHANGE notes notes TEXT DEFAULT ''NULL''', array(), object(Closure)) in Connection.php line 458
at Connection->statement('ALTER TABLE licenses CHANGE notes notes TEXT DEFAULT ''NULL''') in Blueprint.php line 83
at Blueprint->build(object(MySqlConnection), object(MySqlGrammar)) in Builder.php line 229
at Builder->build(object(Blueprint)) in Builder.php line 130
at Builder->table('licenses', object(Closure)) in compiled.php line 6327
at Facade::__callStatic('table', array('licenses', object(Closure))) in 2015_02_12_024100_change_license_notes_type.php line 15
at ChangeLicenseNotesType->up() in Migrator.php line 147
at Migrator->runUp('2015_02_12_024100_change_license_notes_type', '2', false) in Migrator.php line 117
at Migrator->runMigrationList(array('2015_02_12_024100_change_license_notes_type', '2015_02_17_231020_add_localonly_to_settings', '2015_02_19_222322_add_logo_and_colors_to_settings', '2015_02_24_072043_add_alerts_to_settings', '2015_02_25_022931_add_eula_fields', '2015_02_25_204513_add_accessories_table', '2015_02_26_091228_add_accessories_user_table', '2015_02_26_115128_add_deleted_at_models', '2015_02_26_233005_add_category_type', '2015_03_01_231912_update_accepted_at_to_acceptance_id', '2015_03_05_011929_add_qr_type_to_settings', '2015_03_18_055327_add_note_to_user', '2015_04_29_234704_add_slack_to_settings', '2015_05_04_085151_add_parent_id_to_locations_table', '2015_05_22_124421_add_reassignable_to_licenses', '2015_06_10_003314_fix_default_for_user_notes', '2015_06_10_003554_create_consumables', '2015_06_15_183253_move_email_to_username', '2015_06_23_070346_make_email_nullable', '2015_06_26_213716_create_asset_maintenances_table', '2015_07_04_212443_create_custom_fields_table', '2015_07_09_014359_add_currency_to_settings_and_locations', '2015_07_21_122022_add_expected_checkin_date_to_asset_logs', '2015_07_24_093845_add_checkin_email_to_category_table', '2015_07_25_055415_remove_email_unique_constraint', '2015_07_29_230054_add_thread_id_to_asset_logs_table', '2015_07_31_015430_add_accepted_to_assets', '2015_09_09_195301_add_custom_css_to_settings', '2015_09_21_235926_create_custom_field_custom_fieldset', '2015_09_22_000104_create_custom_fieldsets', '2015_09_22_003321_add_fieldset_id_to_assets', '2015_09_22_003413_migrate_mac_address', '2015_09_28_003314_fix_default_purchase_order', '2015_10_01_024551_add_accessory_consumable_price_info', '2015_10_12_192706_add_brand_to_settings', '2015_10_22_003314_fix_defaults_accessories', '2015_10_23_182625_add_checkout_time_and_expected_checkout_date_to_assets', '2015_11_05_061015_create_companies_table', '2015_11_05_061115_add_company_id_to_consumables_table', '2015_11_05_183749_image', '2015_11_06_092038_add_company_id_to_accessories_table', '2015_11_06_100045_add_company_id_to_users_table', '2015_11_06_134742_add_company_id_to_licenses_table', '2015_11_08_035832_add_company_id_to_assets_table', '2015_11_08_222305_add_ldap_fields_to_settings', '2015_11_15_151803_add_full_multiple_companies_support_to_settings_table', '2015_11_26_195528_import_ldap_settings', '2015_11_30_191504_remove_fk_company_id', '2015_12_21_193006_add_ldap_server_cert_ignore_to_settings_table', '2015_12_30_233509_add_timestamp_and_userId_to_custom_fields', '2015_12_30_233658_add_timestamp_and_userId_to_custom_fieldsets', '2016_01_28_041048_add_notes_to_models', '2016_02_19_070119_add_remember_token_to_users_table', '2016_02_19_073625_create_password_resets_table', '2016_03_02_193043_add_ldap_flag_to_users', '2016_03_02_220517_update_ldap_filter_to_longer_field', '2016_03_08_225351_create_components_table', '2016_03_09_024038_add_min_stock_to_tables', '2016_03_10_133849_add_locale_to_users', '2016_03_10_135519_add_locale_to_settings', '2016_03_11_185621_add_label_settings_to_settings', '2016_03_22_125911_fix_custom_fields_regexes', '2016_04_28_141554_add_show_to_users', '2016_05_16_164733_add_model_mfg_to_consumable', '2016_05_19_180351_add_alt_barcode_settings', '2016_05_19_191146_add_alter_interval', '2016_05_19_192226_add_inventory_threshold', '2016_05_20_024859_remove_option_keys_from_settings_table', '2016_05_20_143758_remove_option_value_from_settings_table', '2016_06_01_140218_add_email_domain_and_format_to_settings', '2016_06_22_160725_add_user_id_to_maintenances', '2016_07_13_150015_add_is_ad_to_settings', '2016_07_14_153609_add_ad_domain_to_settings', '2016_07_22_003348_fix_custom_fields_regex_stuff', '2016_07_22_054850_one_more_mac_addr_fix', '2016_07_22_143045_add_port_to_ldap_settings', '2016_07_22_153432_add_tls_to_ldap_settings', '2016_07_27_211034_add_zerofill_to_settings', '2016_08_02_124944_add_color_to_statuslabel', '2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings', '2016_08_09_002225_add_manufacturer_to_licenses', '2016_08_12_121613_add_manufacturer_to_accessories_table', '2016_08_23_143353_add_new_fields_to_custom_fields', '2016_08_23_145619_add_show_in_nav_to_status_labels', '2016_08_30_084634_make_purchase_cost_nullable', '2016_09_01_141051_add_requestable_to_asset_model', '2016_09_02_001448_create_checkout_requests_table', '2016_09_04_180400_create_actionlog_table', '2016_09_04_182149_migrate_asset_log_to_action_log', '2016_09_19_235935_fix_fieldtype_for_target_type', '2016_09_23_140722_fix_modelno_in_consumables_to_string', '2016_09_28_231359_add_company_to_logs', '2016_10_14_130709_fix_order_number_to_varchar', '2016_10_16_015024_rename_modelno_to_model_number', '2016_10_16_015211_rename_consumable_modelno_to_model_number', '2016_10_16_143235_rename_model_note_to_notes', '2016_10_16_165052_rename_component_total_qty_to_qty', '2016_10_19_145520_fix_order_number_in_components_to_string', '2016_10_27_151715_add_serial_to_components', '2016_10_27_213251_increase_serial_field_capacity', '2016_10_29_002724_enable_2fa_fields', '2016_10_29_082408_add_signature_to_acceptance', '2016_11_01_030818_fix_forgotten_filename_in_action_logs', '2016_11_13_020954_rename_component_serial_number_to_serial', '2016_11_16_172119_increase_purchase_cost_size', '2016_11_17_161317_longer_state_field_in_location', '2016_11_17_193706_add_model_number_to_accessories', '2016_11_24_160405_add_missing_target_type_to_logs_table', '2016_12_07_173720_increase_size_of_state_in_suppliers'), array('pretend' => false, 'step' => false)) in Migrator.php line 86
at Migrator->run('/opt/snipe-it/database/migrations', array('pretend' => false, 'step' => false)) in MigrateCommand.php line 76
at MigrateCommand->fire()
at call_user_func_array(array(object(MigrateCommand), 'fire'), array()) in compiled.php line 1257
at Container->call(array(object(MigrateCommand), 'fire')) in Command.php line 169
at Command->execute(object(ArrayInput), object(BufferedOutput)) in Command.php line 256
at Command->run(object(ArrayInput), object(BufferedOutput)) in Command.php line 155
at Command->run(object(ArrayInput), object(BufferedOutput)) in Application.php line 794
at Application->doRunCommand(object(MigrateCommand), object(ArrayInput), object(BufferedOutput)) in Application.php line 186
at Application->doRun(object(ArrayInput), object(BufferedOutput)) in Application.php line 117
at Application->run(object(ArrayInput), object(BufferedOutput)) in Application.php line 64
at Application->call('migrate', object(Collection)) in Kernel.php line 170
at Kernel->call('migrate', array('--force' => true)) in compiled.php line 6327
at Facade::__callStatic('call', array('migrate', array('--force' => true))) in SettingsController.php line 247
at SettingsController->getSetupMigrate()
at call_user_func_array(array(object(SettingsController), 'getSetupMigrate'), array()) in compiled.php line 9424
at Controller->callAction('getSetupMigrate', array()) in compiled.php line 9486
at ControllerDispatcher->call(object(SettingsController), object(Route), 'getSetupMigrate') in compiled.php line 9466
at ControllerDispatcher->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9948
at Pipeline->then(object(Closure)) in compiled.php line 9467
at ControllerDispatcher->callWithinStack(object(SettingsController), object(Route), object(Request), 'getSetupMigrate') in compiled.php line 9454
at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\SettingsController', 'getSetupMigrate') in compiled.php line 8524
at Route->runController(object(Request)) in compiled.php line 8511
at Route->run(object(Request)) in compiled.php line 8225
at Router->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForTwoFactor.php line 49
at CheckForTwoFactor->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForTwoFactor), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckLocale.php line 42
at CheckLocale->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckLocale), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3225
at VerifyCsrfToken->handle(object(Request), object(Closure))
at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13213
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13150
at EncryptCookies->handle(object(Request), object(Closure))
at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9948
at Pipeline->then(object(Closure)) in compiled.php line 8226
at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8217
at Router->dispatchToRoute(object(Request)) in compiled.php line 8207
at Router->dispatch(object(Request)) in compiled.php line 2419
at Kernel->Illuminate\Foundation\Http{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49
at Debugbar->handle(object(Request), object(Closure))
at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForDebug.php line 25
at CheckForDebug->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForDebug), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in TrustProxies.php line 46
at TrustProxies->handle(object(Request), object(Closure))
at call_user_func_array(array(object(TrustProxies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForSetup.php line 35
at CheckForSetup->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForSetup), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in NosniffGuard.php line 17
at NosniffGuard->handle(object(Request), object(Closure))
at call_user_func_array(array(object(NosniffGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in XssProtectHeader.php line 17
at XssProtectHeader->handle(object(Request), object(Closure))
at call_user_func_array(array(object(XssProtectHeader), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in FrameGuard.php line 17
at FrameGuard->handle(object(Request), object(Closure))
at call_user_func_array(array(object(FrameGuard), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13474
at ShareErrorsFromSession->handle(object(Request), object(Closure))
at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 11964
at StartSession->handle(object(Request), object(Closure))
at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForMaintenanceMode.php line 145
at CheckForMaintenanceMode->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in compiled.php line 9963
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9948
at Pipeline->then(object(Closure)) in compiled.php line 2366
at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2350
at Kernel->handle(object(Request)) in index.php line 59

Stack Trace

[05:12:17] LOG.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 MariaDB server version for the right syntax to use near '''' at line 1 in /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php:457
Stack trace:
#0 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(457): PDO->prepare('ALTER TABLE lic...')
#1 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(722): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\MySqlConnection), 'ALTER TABLE lic...', Array)
#2 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->runQueryCallback('ALTER TABLE lic...', Array, Object(Closure))
#3 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(458): Illuminate\Database\Connection->run('ALTER TABLE lic...', Array, Object(Closure))
#4 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(83): Illuminate\Database\Connection->statement('ALTER TABLE lic...')
#5 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(229): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#6 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(130): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#7 /opt/snipe-it/bootstrap/cache/compiled.php(6327): Illuminate\Database\Schema\Builder->table('licenses', Object(Closure))
#8 /opt/snipe-it/database/migrations/2015_02_12_024100_change_license_notes_type.php(15): Illuminate\Support\Facades\Facade::__callStatic('table', Array)
#9 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(147): ChangeLicenseNotesType->up()
#10 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(117): Illuminate\Database\Migrations\Migrator->runUp('2015_02_12_0241...', 2, false)
#11 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(86): Illuminate\Database\Migrations\Migrator->runMigrationList(Array, Array)
#12 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(76): Illuminate\Database\Migrations\Migrator->run('/opt/snipe-it/d...', Array)
#13 [internal function]: Illuminate\Database\Console\Migrations\MigrateCommand->fire()
#14 /opt/snipe-it/bootstrap/cache/compiled.php(1257): call_user_func_array(Array, Array)
#15 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Command.php(169): Illuminate\Container\Container->call(Array)
#16 /opt/snipe-it/vendor/symfony/console/Command/Command.php(256): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#17 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Command.php(155): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#18 /opt/snipe-it/vendor/symfony/console/Application.php(794): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#19 /opt/snipe-it/vendor/symfony/console/Application.php(186): Symfony\Component\Console\Application->doRunCommand(Object(Illuminate\Database\Console\Migrations\MigrateCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#20 /opt/snipe-it/vendor/symfony/console/Application.php(117): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#21 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Application.php(64): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#22 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(170): Illuminate\Console\Application->call('migrate', Object(Illuminate\Support\Collection))
#23 /opt/snipe-it/bootstrap/cache/compiled.php(6327): Illuminate\Foundation\Console\Kernel->call('migrate', Array)
#24 /opt/snipe-it/app/Http/Controllers/SettingsController.php(247): Illuminate\Support\Facades\Facade::__callStatic('call', Array)
#25 [internal function]: App\Http\Controllers\SettingsController->getSetupMigrate()
#26 /opt/snipe-it/bootstrap/cache/compiled.php(9424): call_user_func_array(Array, Array)
#27 /opt/snipe-it/bootstrap/cache/compiled.php(9486): Illuminate\Routing\Controller->callAction('getSetupMigrate', Array)
#28 /opt/snipe-it/bootstrap/cache/compiled.php(9466): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\SettingsController), Object(Illuminate\Routing\Route), 'getSetupMigrate')
#29 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#30 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#31 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#32 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#33 /opt/snipe-it/bootstrap/cache/compiled.php(9467): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#34 /opt/snipe-it/bootstrap/cache/compiled.php(9454): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\SettingsController), Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'getSetupMigrate')
#35 /opt/snipe-it/bootstrap/cache/compiled.php(8524): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'App\Http\Contro...', 'getSetupMigrate')
#36 /opt/snipe-it/bootstrap/cache/compiled.php(8511): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request))
#37 /opt/snipe-it/bootstrap/cache/compiled.php(8225): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))
#38 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#39 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#40 /opt/snipe-it/app/Http/Middleware/CheckForTwoFactor.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#41 [internal function]: App\Http\Middleware\CheckForTwoFactor->handle(Object(Illuminate\Http\Request), Object(Closure))
#42 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#43 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#44 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#45 /opt/snipe-it/app/Http/Middleware/CheckLocale.php(42): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#46 [internal function]: App\Http\Middleware\CheckLocale->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#48 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#49 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#50 /opt/snipe-it/bootstrap/cache/compiled.php(3225): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#51 [internal function]: Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#53 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#54 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#55 /opt/snipe-it/bootstrap/cache/compiled.php(13213): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#56 [internal function]: Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#58 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#59 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#60 /opt/snipe-it/bootstrap/cache/compiled.php(13150): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#61 [internal function]: Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#62 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#63 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#64 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#65 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#66 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#67 /opt/snipe-it/bootstrap/cache/compiled.php(8226): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#68 /opt/snipe-it/bootstrap/cache/compiled.php(8217): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#69 /opt/snipe-it/bootstrap/cache/compiled.php(8207): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#70 /opt/snipe-it/bootstrap/cache/compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#71 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
#72 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#73 /opt/snipe-it/vendor/barryvdh/laravel-debugbar/src/Middleware/Debugbar.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#74 [internal function]: Barryvdh\Debugbar\Middleware\Debugbar->handle(Object(Illuminate\Http\Request), Object(Closure))
#75 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#76 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#77 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#78 /opt/snipe-it/app/Http/Middleware/CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#79 [internal function]: App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))
#80 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#81 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#82 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#83 /opt/snipe-it/vendor/fideloper/proxy/src/TrustProxies.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#84 [internal function]: Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#85 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#86 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#87 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#88 /opt/snipe-it/app/Http/Middleware/CheckForSetup.php(35): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#89 [internal function]: App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))
#90 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#91 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#92 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#93 /opt/snipe-it/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#94 [internal function]: App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#95 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#96 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#97 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#98 /opt/snipe-it/app/Http/Middleware/XssProtectHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#99 [internal function]: App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
#100 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#101 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#102 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#103 /opt/snipe-it/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#104 [internal function]: App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#105 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#106 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#107 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#108 /opt/snipe-it/bootstrap/cache/compiled.php(13474): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#109 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#110 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#111 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#112 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#113 /opt/snipe-it/bootstrap/cache/compiled.php(11964): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#114 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#115 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#116 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#117 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#118 /opt/snipe-it/vendor/misterphilip/maintenance-mode/src/MisterPhilip/MaintenanceMode/Http/Middleware/CheckForMaintenanceMode.php(145): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#119 [internal function]: MisterPhilip\MaintenanceMode\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#120 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#121 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#122 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#123 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#124 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#125 /opt/snipe-it/bootstrap/cache/compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#126 /opt/snipe-it/bootstrap/cache/compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#127 /opt/snipe-it/public/index.php(59): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#128 {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 MariaDB server version for the right syntax to use near '''' at line 1 (SQL: ALTER TABLE licenses CHANGE notes notes TEXT DEFAULT ''NULL'') in /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php:729
Stack trace:
#0 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->runQueryCallback('ALTER TABLE lic...', Array, Object(Closure))
#1 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Connection.php(458): Illuminate\Database\Connection->run('ALTER TABLE lic...', Array, Object(Closure))
#2 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(83): Illuminate\Database\Connection->statement('ALTER TABLE lic...')
#3 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(229): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(130): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 /opt/snipe-it/bootstrap/cache/compiled.php(6327): Illuminate\Database\Schema\Builder->table('licenses', Object(Closure))
#6 /opt/snipe-it/database/migrations/2015_02_12_024100_change_license_notes_type.php(15): Illuminate\Support\Facades\Facade::__callStatic('table', Array)
#7 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(147): ChangeLicenseNotesType->up()
#8 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(117): Illuminate\Database\Migrations\Migrator->runUp('2015_02_12_0241...', 2, false)
#9 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(86): Illuminate\Database\Migrations\Migrator->runMigrationList(Array, Array)
#10 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(76): Illuminate\Database\Migrations\Migrator->run('/opt/snipe-it/d...', Array)
#11 [internal function]: Illuminate\Database\Console\Migrations\MigrateCommand->fire()
#12 /opt/snipe-it/bootstrap/cache/compiled.php(1257): call_user_func_array(Array, Array)
#13 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Command.php(169): Illuminate\Container\Container->call(Array)
#14 /opt/snipe-it/vendor/symfony/console/Command/Command.php(256): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#15 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Command.php(155): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#16 /opt/snipe-it/vendor/symfony/console/Application.php(794): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#17 /opt/snipe-it/vendor/symfony/console/Application.php(186): Symfony\Component\Console\Application->doRunCommand(Object(Illuminate\Database\Console\Migrations\MigrateCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#18 /opt/snipe-it/vendor/symfony/console/Application.php(117): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#19 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Console/Application.php(64): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\BufferedOutput))
#20 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(170): Illuminate\Console\Application->call('migrate', Object(Illuminate\Support\Collection))
#21 /opt/snipe-it/bootstrap/cache/compiled.php(6327): Illuminate\Foundation\Console\Kernel->call('migrate', Array)
#22 /opt/snipe-it/app/Http/Controllers/SettingsController.php(247): Illuminate\Support\Facades\Facade::__callStatic('call', Array)
#23 [internal function]: App\Http\Controllers\SettingsController->getSetupMigrate()
#24 /opt/snipe-it/bootstrap/cache/compiled.php(9424): call_user_func_array(Array, Array)
#25 /opt/snipe-it/bootstrap/cache/compiled.php(9486): Illuminate\Routing\Controller->callAction('getSetupMigrate', Array)
#26 /opt/snipe-it/bootstrap/cache/compiled.php(9466): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\SettingsController), Object(Illuminate\Routing\Route), 'getSetupMigrate')
#27 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#28 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#29 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#30 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#31 /opt/snipe-it/bootstrap/cache/compiled.php(9467): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#32 /opt/snipe-it/bootstrap/cache/compiled.php(9454): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\SettingsController), Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'getSetupMigrate')
#33 /opt/snipe-it/bootstrap/cache/compiled.php(8524): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'App\Http\Contro...', 'getSetupMigrate')
#34 /opt/snipe-it/bootstrap/cache/compiled.php(8511): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request))
#35 /opt/snipe-it/bootstrap/cache/compiled.php(8225): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))
#36 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#37 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#38 /opt/snipe-it/app/Http/Middleware/CheckForTwoFactor.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#39 [internal function]: App\Http\Middleware\CheckForTwoFactor->handle(Object(Illuminate\Http\Request), Object(Closure))
#40 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#41 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#42 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#43 /opt/snipe-it/app/Http/Middleware/CheckLocale.php(42): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#44 [internal function]: App\Http\Middleware\CheckLocale->handle(Object(Illuminate\Http\Request), Object(Closure))
#45 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#46 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#47 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#48 /opt/snipe-it/bootstrap/cache/compiled.php(3225): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#49 [internal function]: Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#50 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#51 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#52 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#53 /opt/snipe-it/bootstrap/cache/compiled.php(13213): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#54 [internal function]: Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#55 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#56 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#57 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#58 /opt/snipe-it/bootstrap/cache/compiled.php(13150): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#59 [internal function]: Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#60 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#61 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#62 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#63 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#64 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#65 /opt/snipe-it/bootstrap/cache/compiled.php(8226): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#66 /opt/snipe-it/bootstrap/cache/compiled.php(8217): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#67 /opt/snipe-it/bootstrap/cache/compiled.php(8207): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#68 /opt/snipe-it/bootstrap/cache/compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#69 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
#70 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#71 /opt/snipe-it/vendor/barryvdh/laravel-debugbar/src/Middleware/Debugbar.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#72 [internal function]: Barryvdh\Debugbar\Middleware\Debugbar->handle(Object(Illuminate\Http\Request), Object(Closure))
#73 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#74 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#75 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#76 /opt/snipe-it/app/Http/Middleware/CheckForDebug.php(25): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#77 [internal function]: App\Http\Middleware\CheckForDebug->handle(Object(Illuminate\Http\Request), Object(Closure))
#78 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#79 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#80 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#81 /opt/snipe-it/vendor/fideloper/proxy/src/TrustProxies.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#82 [internal function]: Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#83 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#84 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#85 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#86 /opt/snipe-it/app/Http/Middleware/CheckForSetup.php(35): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#87 [internal function]: App\Http\Middleware\CheckForSetup->handle(Object(Illuminate\Http\Request), Object(Closure))
#88 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#89 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#90 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#91 /opt/snipe-it/app/Http/Middleware/NosniffGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#92 [internal function]: App\Http\Middleware\NosniffGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#93 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#94 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#95 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#96 /opt/snipe-it/app/Http/Middleware/XssProtectHeader.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#97 [internal function]: App\Http\Middleware\XssProtectHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
#98 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#99 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#100 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#101 /opt/snipe-it/app/Http/Middleware/FrameGuard.php(17): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#102 [internal function]: App\Http\Middleware\FrameGuard->handle(Object(Illuminate\Http\Request), Object(Closure))
#103 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#104 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#105 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#106 /opt/snipe-it/bootstrap/cache/compiled.php(13474): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#107 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#108 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#109 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#110 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#111 /opt/snipe-it/bootstrap/cache/compiled.php(11964): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#112 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#113 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#114 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#115 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#116 /opt/snipe-it/vendor/misterphilip/maintenance-mode/src/MisterPhilip/MaintenanceMode/Http/Middleware/CheckForMaintenanceMode.php(145): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#117 [internal function]: MisterPhilip\MaintenanceMode\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#118 /opt/snipe-it/bootstrap/cache/compiled.php(9963): call_user_func_array(Array, Array)
#119 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#120 /opt/snipe-it/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#121 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#122 /opt/snipe-it/bootstrap/cache/compiled.php(9948): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#123 /opt/snipe-it/bootstrap/cache/compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#124 /opt/snipe-it/bootstrap/cache/compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#125 /opt/snipe-it/public/index.php(59): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#126 {main}
error

snipe · 2017-09-12T22:21:07Z

Hmm... Can you tell me what's in your migrations table? That error might be a red herring (the real error might be one level up) so I'm curious to see how far your migrations got.

hairysamurai · 2017-09-12T22:32:01Z

MariaDB [snipeit]> select * from snipeit.migrations;
+-------------------------------------------------------------------------+-------+
| migration                                                               | batch |
+-------------------------------------------------------------------------+-------+
| 2012_12_06_225921_migration_cartalyst_sentry_install_users              |     1 |
| 2012_12_06_225929_migration_cartalyst_sentry_install_groups             |     1 |
| 2012_12_06_225945_migration_cartalyst_sentry_install_users_groups_pivot |     1 |
| 2012_12_06_225988_migration_cartalyst_sentry_install_throttle           |     1 |
| 2013_03_23_193214_update_users_table                                    |     1 |
| 2013_11_13_075318_create_models_table                                   |     1 |
| 2013_11_13_075335_create_categories_table                               |     1 |
| 2013_11_13_075347_create_manufacturers_table                            |     1 |
| 2013_11_15_015858_add_user_id_to_categories                             |     1 |
| 2013_11_15_112701_add_user_id_to_manufacturers                          |     1 |
| 2013_11_15_190327_create_assets_table                                   |     1 |
| 2013_11_15_190357_create_licenses_table                                 |     1 |
| 2013_11_15_201848_add_license_name_to_licenses                          |     1 |
| 2013_11_16_040323_create_depreciations_table                            |     1 |
| 2013_11_16_042851_add_depreciation_id_to_models                         |     1 |
| 2013_11_16_084923_add_user_id_to_models                                 |     1 |
| 2013_11_16_103258_create_locations_table                                |     1 |
| 2013_11_16_103336_add_location_id_to_assets                             |     1 |
| 2013_11_16_103407_add_checkedout_to_to_assets                           |     1 |
| 2013_11_16_103425_create_history_table                                  |     1 |
| 2013_11_17_054359_drop_licenses_table                                   |     1 |
| 2013_11_17_054526_add_physical_to_assets                                |     1 |
| 2013_11_17_055126_create_settings_table                                 |     1 |
| 2013_11_17_062634_add_license_to_assets                                 |     1 |
| 2013_11_18_134332_add_contacts_to_users                                 |     1 |
| 2013_11_18_142847_add_info_to_locations                                 |     1 |
| 2013_11_18_152942_remove_location_id_from_asset                         |     1 |
| 2013_11_18_164423_set_nullvalues_for_user                               |     1 |
| 2013_11_19_013337_create_asset_logs_table                               |     1 |
| 2013_11_19_061409_edit_added_on_asset_logs_table                        |     1 |
| 2013_11_19_062250_edit_location_id_asset_logs_table                     |     1 |
| 2013_11_20_055822_add_soft_delete_on_assets                             |     1 |
| 2013_11_20_121404_add_soft_delete_on_locations                          |     1 |
| 2013_11_20_123137_add_soft_delete_on_manufacturers                      |     1 |
| 2013_11_20_123725_add_soft_delete_on_categories                         |     1 |
| 2013_11_20_130248_create_status_labels                                  |     1 |
| 2013_11_20_130830_add_status_id_on_assets_table                         |     1 |
| 2013_11_20_131544_add_status_type_on_status_labels                      |     1 |
| 2013_11_20_134103_add_archived_to_assets                                |     1 |
| 2013_11_21_002321_add_uploads_table                                     |     1 |
| 2013_11_21_024531_remove_deployable_boolean_from_status_labels          |     1 |
| 2013_11_22_075308_add_option_label_to_settings_table                    |     1 |
| 2013_11_22_213400_edits_to_settings_table                               |     1 |
| 2013_11_25_013244_create_licenses_table                                 |     1 |
| 2013_11_25_031458_create_license_seats_table                            |     1 |
| 2013_11_25_032022_add_type_to_actionlog_table                           |     1 |
| 2013_11_25_033008_delete_bad_licenses_table                             |     1 |
| 2013_11_25_033131_create_new_licenses_table                             |     1 |
| 2013_11_25_033534_add_licensed_to_licenses_table                        |     1 |
| 2013_11_25_101308_add_warrantee_to_assets_table                         |     1 |
| 2013_11_25_104343_alter_warranty_column_on_assets                       |     1 |
| 2013_11_25_150450_drop_parent_from_categories                           |     1 |
| 2013_11_25_151920_add_depreciate_to_assets                              |     1 |
| 2013_11_25_152903_add_depreciate_to_licenses_table                      |     1 |
| 2013_11_26_211820_drop_license_from_assets_table                        |     1 |
| 2013_11_27_062510_add_note_to_asset_logs_table                          |     1 |
| 2013_12_01_113426_add_filename_to_asset_log                             |     1 |
| 2013_12_06_094618_add_nullable_to_licenses_table                        |     1 |
| 2013_12_10_084038_add_eol_on_models_table                               |     1 |
| 2013_12_12_055218_add_manager_to_users_table                            |     1 |
| 2014_01_28_031200_add_qr_code_to_settings_table                         |     1 |
| 2014_02_13_183016_add_qr_text_to_settings_table                         |     1 |
| 2014_05_24_093839_alter_default_license_depreciation_id                 |     1 |
| 2014_05_27_231658_alter_default_values_licenses                         |     1 |
| 2014_06_19_191508_add_asset_name_to_settings                            |     1 |
| 2014_06_20_004847_make_asset_log_checkedout_to_nullable                 |     1 |
| 2014_06_20_005050_make_asset_log_purchasedate_to_nullable               |     1 |
| 2014_06_24_003011_add_suppliers                                         |     1 |
| 2014_06_24_010742_add_supplier_id_to_asset                              |     1 |
| 2014_06_24_012839_add_zip_to_supplier                                   |     1 |
| 2014_06_24_033908_add_url_to_supplier                                   |     1 |
| 2014_07_08_054116_add_employee_id_to_users                              |     1 |
| 2014_07_09_134316_add_requestable_to_assets                             |     1 |
| 2014_07_17_085822_add_asset_to_software                                 |     1 |
| 2014_07_17_161625_make_asset_id_in_logs_nullable                        |     1 |
| 2014_08_12_053504_alpha_0_4_2_release                                   |     1 |
| 2014_08_17_083523_make_location_id_nullable                             |     1 |
| 2014_10_16_200626_add_rtd_location_to_assets                            |     1 |
| 2014_10_24_000417_alter_supplier_state_to_32                            |     1 |
| 2014_10_24_015641_add_display_checkout_date                             |     1 |
| 2014_10_28_222654_add_avatar_field_to_users_table                       |     1 |
| 2014_10_29_045924_add_image_field_to_models_table                       |     1 |
| 2014_11_01_214955_add_eol_display_to_settings                           |     1 |
| 2014_11_04_231416_update_group_field_for_reporting                      |     1 |
| 2014_11_05_212408_add_fields_to_licenses                                |     1 |
| 2014_11_07_021042_add_image_to_supplier                                 |     1 |
| 2014_11_20_203007_add_username_to_user                                  |     1 |
| 2014_11_20_223947_add_auto_to_settings                                  |     1 |
| 2014_11_20_224421_add_prefix_to_settings                                |     1 |
| 2014_11_21_104401_change_licence_type                                   |     1 |
| 2014_12_09_082500_add_fields_maintained_term_to_licenses                |     1 |
| 2015_02_04_155757_increase_user_field_lengths                           |     1 |
| 2015_02_07_013537_add_soft_deleted_to_log                               |     1 |
| 2015_02_10_040958_fix_bad_assigned_to_ids                               |     1 |
| 2015_02_10_053310_migrate_data_to_new_statuses                          |     1 |
| 2015_02_11_044104_migrate_make_license_assigned_null                    |     1 |
| 2015_02_11_104406_migrate_create_requests_table                         |     1 |
| 2015_02_12_001312_add_mac_address_to_asset                              |     1 |
+-------------------------------------------------------------------------+-------+
98 rows in set (0.00 sec)

hh-trj · 2017-09-12T22:42:12Z

I ran into this same issue when using MariaDB 10.2. The same issue was reported in #3787 but the person there downgraded to 10.0. I opted to switch to MySQL.

Someone commented on that issue suggesting that a change in MariaDB in 10.2 causes the problem. They posted a possible fix after the issue was closed, but I didn't test that.

snipe · 2017-09-12T23:37:29Z

It looks to be an issue with Doctrine, and there's a PR open to fix it on Doctrine's side, but it's not been merged yet. doctrine/dbal#2825

For now, downgrading Maria might be the best option if possible in your environment. :(

snipe · 2017-09-25T23:30:58Z

I'm closing this one for now, since there's not much I can do in the meantime, but I'm monitoring that Doctrine thread and will test and upgrade Doctrine once it's ready, and will update this ticket.

coreypenford · 2019-01-14T19:38:27Z

@snipe

Looks like Doctrine has released an version that supports 10.3
https://github.com/doctrine/dbal/releases/tag/v2.9.0

nbwpuk · 2019-05-15T15:06:22Z

I have come across this issue when running MariaDB 10.3 and unable to downgrade.
If Doctrine have released a version that does support 10.3 what is the status of this issue?

jflattery · 2019-05-15T17:56:04Z

@snipe Thoughts?

snipe mentioned this issue Sep 22, 2017

Snipe-IT install. Can't get passed Pre-Flight #3984

Closed

snipe closed this as completed Sep 25, 2017

belgattitude mentioned this issue Sep 26, 2017

MariaDB 10.2 initial support doctrine/dbal#2825

Merged

8 tasks

almightynassar mentioned this issue Mar 22, 2018

MariaDB Error (two single quotes wrapped around field) with workaround #5242

Closed

2 tasks

jflattery mentioned this issue May 20, 2019

Please add support for MariaDB 10.2.7 and later. #7045

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

MariaDB Error #3947

MariaDB Error #3947

hairysamurai commented Sep 12, 2017

snipe commented Sep 12, 2017

hairysamurai commented Sep 12, 2017

hh-trj commented Sep 12, 2017

snipe commented Sep 12, 2017 •

edited

Loading

snipe commented Sep 25, 2017

coreypenford commented Jan 14, 2019

nbwpuk commented May 15, 2019

jflattery commented May 15, 2019

MariaDB Error #3947

MariaDB Error #3947

Comments

hairysamurai commented Sep 12, 2017

Expected Behavior (or desired behavior if a feature request)

Actual Behavior

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

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

Error

Stack Trace

snipe commented Sep 12, 2017

hairysamurai commented Sep 12, 2017

hh-trj commented Sep 12, 2017

snipe commented Sep 12, 2017 • edited Loading

snipe commented Sep 25, 2017

coreypenford commented Jan 14, 2019

nbwpuk commented May 15, 2019

jflattery commented May 15, 2019

snipe commented Sep 12, 2017 •

edited

Loading