snipe / snipe-it

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

MariaDB Error #3947

Closed hairysamurai closed 7 years ago

hairysamurai commented 7 years ago

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:


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

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 commented 7 years ago

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 commented 7 years ago
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 commented 7 years ago

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 commented 7 years ago

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. https://github.com/doctrine/dbal/pull/2825

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

snipe commented 7 years ago

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 commented 5 years ago

@snipe

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

nbwpuk commented 5 years ago

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 commented 5 years ago

@snipe Thoughts?