Closed Kaymen closed 6 years ago
snipe
commented
7 years ago Could you please provide a little more info here? Where/when are you seeing this error? How far did you get in the installation and what errors or messages did you see along the way?
Kaymen
commented
7 years ago I see the first status page of the installation when I surf to the website, when I press next I get the message above when the migrations process are running. (Why are a migration done with new installation, why not start with an up to date database, easier to develop?)
I don´t know if the format/lang of the database is ok or why the migration not can be done.
When I was removing all migration steps I came forward in the guide and could create a user account but when I get to the results page after user account creation I get a similar error message as above. Some fields in the database are missing but the name of and e-mailadress and some more info are written to the database.
A this time I have drop the database and started all over again so, its locking up at the migration.
snipe
commented
7 years ago Why are a migration done with new installation, why not start with an up to date database, easier to develop
Because upgrading becomes impossible then. Migrations allow incremental changes, which means someone with v1 of Snipe-IT can upgrade as easily as someone running v3. Migrations are pretty standard practice in web application development.
Can you check and see if mysql is in strict mode? If it is, can you disable that and try again?
Kaymen
commented
7 years ago I have this line in my.ini
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Kaymen
commented
7 years ago When I check the database I get this. NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION I think its correct?
Address server.domain.xx/setup/migrate?
Whoops, looks like something went wrong.
(2/2) QueryException
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'labels_width' (SQL: alter table settings add labels_per_page tinyint not null default '30', add labels_width decimal(6, 5) not null default '2,625', add labels_height decimal(6, 5) not null default '1', add labels_pmargin_left decimal(6, 5) not null default '0,21975', add labels_pmargin_right decimal(6, 5) not null default '0,21975', add labels_pmargin_top decimal(6, 5) not null default '0,5', add labels_pmargin_bottom decimal(6, 5) not null default '0,5', add labels_display_bgutter decimal(6, 5) not null default '0,07', add labels_display_sgutter decimal(6, 5) not null default '0,05', add labels_fontsize tinyint not null default '9', add labels_pagewidth decimal(7, 5) not null default '8,5', add labels_pageheight decimal(7, 5) not null default '11', add labels_display_name tinyint not null default '0', add labels_display_serial tinyint not null default '1', add labels_display_tag tinyint not null default '1')
in Connection.php (line 647)
at Connection->runQueryCallback('alter table settings add labels_per_page tinyint not null default \'30\', add labels_width decimal(6, 5) not null default \'2,625\', add labels_height decimal(6, 5) not null default \'1\', add labels_pmargin_left decimal(6, 5) not null default \'0,21975\', add labels_pmargin_right decimal(6, 5) not null default \'0,21975\', add labels_pmargin_top decimal(6, 5) not null default \'0,5\', add labels_pmargin_bottom decimal(6, 5) not null default \'0,5\', add labels_display_bgutter decimal(6, 5) not null default \'0,07\', add labels_display_sgutter decimal(6, 5) not null default \'0,05\', add labels_fontsize tinyint not null default \'9\', add labels_pagewidth decimal(7, 5) not null default \'8,5\', add labels_pageheight decimal(7, 5) not null default \'11\', add labels_display_name tinyint not null default \'0\', add labels_display_serial tinyint not null default \'1\', add labels_display_tag tinyint not null default \'1\'', array(), object(Closure))
in Connection.php (line 607)
at Connection->run('alter table settings add labels_per_page tinyint not null default \'30\', add labels_width decimal(6, 5) not null default \'2,625\', add labels_height decimal(6, 5) not null default \'1\', add labels_pmargin_left decimal(6, 5) not null default \'0,21975\', add labels_pmargin_right decimal(6, 5) not null default \'0,21975\', add labels_pmargin_top decimal(6, 5) not null default \'0,5\', add labels_pmargin_bottom decimal(6, 5) not null default \'0,5\', add labels_display_bgutter decimal(6, 5) not null default \'0,07\', add labels_display_sgutter decimal(6, 5) not null default \'0,05\', add labels_fontsize tinyint not null default \'9\', add labels_pagewidth decimal(7, 5) not null default \'8,5\', add labels_pageheight decimal(7, 5) not null default \'11\', add labels_display_name tinyint not null default \'0\', add labels_display_serial tinyint not null default \'1\', add labels_display_tag tinyint not null default \'1\'', array(), object(Closure))
in Connection.php (line 450)
at Connection->statement('alter table settings add labels_per_page tinyint not null default \'30\', add labels_width decimal(6, 5) not null default \'2,625\', add labels_height decimal(6, 5) not null default \'1\', add labels_pmargin_left decimal(6, 5) not null default \'0,21975\', add labels_pmargin_right decimal(6, 5) not null default \'0,21975\', add labels_pmargin_top decimal(6, 5) not null default \'0,5\', add labels_pmargin_bottom decimal(6, 5) not null default \'0,5\', add labels_display_bgutter decimal(6, 5) not null default \'0,07\', add labels_display_sgutter decimal(6, 5) not null default \'0,05\', add labels_fontsize tinyint not null default \'9\', add labels_pagewidth decimal(7, 5) not null default \'8,5\', add labels_pageheight decimal(7, 5) not null default \'11\', add labels_display_name tinyint not null default \'0\', add labels_display_serial tinyint not null default \'1\', add labels_display_tag tinyint not null default \'1\'')
in Blueprint.php (line 83)
at Blueprint->build(object(MySqlConnection), object(MySqlGrammar))
in Builder.php (line 239)
at Builder->build(object(Blueprint))
in Builder.php (line 148)
at Builder->table('settings', object(Closure))
in Facade.php (line 221)
at Facade::__callStatic('table', array('settings', object(Closure)))
in 2016_03_11_185621_add_label_settings_to_settings.php (line 31)
at AddLabelSettingsToSettings->up()
in Migrator.php (line 353)
at Migrator->Illuminate\Database\Migrations{closure}()
in Migrator.php (line 359)
at Migrator->runMigration(object(AddLabelSettingsToSettings), 'up')
in Migrator.php (line 177)
at Migrator->runUp('C:\inetpub\wwwroot\snipe-it\database\migrations/2016_03_11_185621_add_label_settings_to_settings.php', 2, false)
in Migrator.php (line 146)
at Migrator->runPending(array('C:\inetpub\wwwroot\snipe-it\database\migrations/2016_03_11_185621_add_label_settings_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_03_22_125911_fix_custom_fields_regexes.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_04_28_141554_add_show_to_users.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_16_164733_add_model_mfg_to_consumable.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_19_180351_add_alt_barcode_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_19_191146_add_alter_interval.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_19_192226_add_inventory_threshold.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_20_024859_remove_option_keys_from_settings_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_20_143758_remove_option_value_from_settings_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_06_01_140218_add_email_domain_and_format_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_06_22_160725_add_user_id_to_maintenances.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_13_150015_add_is_ad_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_14_153609_add_ad_domain_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_22_003348_fix_custom_fields_regex_stuff.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_22_054850_one_more_mac_addr_fix.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_22_143045_add_port_to_ldap_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_22_153432_add_tls_to_ldap_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_27_211034_add_zerofill_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_02_124944_add_color_to_statuslabel.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_09_002225_add_manufacturer_to_licenses.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_12_121613_add_manufacturer_to_accessories_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_23_143353_add_new_fields_to_custom_fields.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_23_145619_add_show_in_nav_to_status_labels.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_30_084634_make_purchase_cost_nullable.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_01_141051_add_requestable_to_asset_model.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_02_001448_create_checkout_requests_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_04_180400_create_actionlog_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_04_182149_migrate_asset_log_to_action_log.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_19_235935_fix_fieldtype_for_target_type.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_23_140722_fix_modelno_in_consumables_to_string.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_28_231359_add_company_to_logs.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_14_130709_fix_order_number_to_varchar.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_16_015024_rename_modelno_to_model_number.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_16_015211_rename_consumable_modelno_to_model_number.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_16_143235_rename_model_note_to_notes.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_16_165052_rename_component_total_qty_to_qty.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_19_145520_fix_order_number_in_components_to_string.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_27_151715_add_serial_to_components.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_27_213251_increase_serial_field_capacity.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_29_002724_enable_2fa_fields.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_29_082408_add_signature_to_acceptance.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_01_030818_fix_forgotten_filename_in_action_logs.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_13_020954_rename_component_serial_number_to_serial.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_16_172119_increase_purchase_cost_size.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_17_161317_longer_state_field_in_location.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_17_193706_add_model_number_to_accessories.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_24_160405_add_missing_target_type_to_logs_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_12_07_173720_increase_size_of_state_in_suppliers.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_12_19_004212_adjust_locale_length_to_10.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_12_19_133936_extend_phone_lengths_in_supplier_and_elsewhere.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_12_27_212631_make_asset_assigned_to_polymorphic.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_01_09_040429_create_locations_ldap_query_field.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_01_14_002418_create_imports_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_01_25_063357_fix_utf8_custom_field_column_names.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_03_03_154632_add_time_date_display_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_03_10_210807_add_fields_to_manufacturer.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_05_08_195520_increase_size_of_field_values_in_custom_fields.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_05_22_204422_create_departments.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_05_22_233509_add_manager_to_locations_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_06_14_122059_add_next_autoincrement_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_06_18_151753_add_header_and_first_row_to_importer_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_07_07_191533_add_login_text.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_07_25_130710_add_thumbsize_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_08_03_160105_set_asset_archived_to_zero_default.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_08_22_180636_add_secure_password_options.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_08_25_074822_add_auditing_tables.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_08_25_101435_add_auditing_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_09_18_225619_fix_assigned_type_not_being_nulled.php'), array('pretend' => false, 'step' => false))
in Migrator.php (line 95)
at Migrator->run(array('C:\inetpub\wwwroot\snipe-it\database\migrations'), array('pretend' => false, 'step' => false))
in MigrateCommand.php (line 69)
at MigrateCommand->fire()
at call_user_func_array(array(object(MigrateCommand), 'fire'), array())
in BoundMethod.php (line 29)
at BoundMethod::Illuminate\Container{closure}()
in BoundMethod.php (line 87)
at BoundMethod::callBoundMethod(object(Application), array(object(MigrateCommand), 'fire'), object(Closure))
in BoundMethod.php (line 31)
at BoundMethod::call(object(Application), array(object(MigrateCommand), 'fire'), array(), null)
in Container.php (line 531)
at Container->call(array(object(MigrateCommand), 'fire'))
in Command.php (line 182)
at Command->execute(object(ArrayInput), object(OutputStyle))
in Command.php (line 264)
at Command->run(object(ArrayInput), object(OutputStyle))
in Command.php (line 167)
at Command->run(object(ArrayInput), object(BufferedOutput))
in Application.php (line 874)
at Application->doRunCommand(object(MigrateCommand), object(ArrayInput), object(BufferedOutput))
in Application.php (line 228)
at Application->doRun(object(ArrayInput), object(BufferedOutput))
in Application.php (line 130)
at Application->run(object(ArrayInput), object(BufferedOutput))
in Application.php (line 141)
at Application->call('migrate', object(Collection), null)
in Kernel.php (line 220)
at Kernel->call('migrate', array('--force' => true))
in Facade.php (line 221)
at Facade::callStatic('call', array('migrate', array('--force' => true)))
in SettingsController.php (line 261)
at SettingsController->getSetupMigrate()
at call_user_func_array(array(object(SettingsController), 'getSetupMigrate'), array())
in Controller.php (line 55)
at Controller->callAction('getSetupMigrate', array())
in ControllerDispatcher.php (line 44)
at ControllerDispatcher->dispatch(object(Route), object(SettingsController), 'getSetupMigrate')
in Route.php (line 203)
at Route->runController()
in Route.php (line 160)
at Route->run()
in Router.php (line 559)
at Router->Illuminate\Routing{closure}(object(Request))
in Pipeline.php (line 30)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CreateFreshApiToken.php (line 49)
at CreateFreshApiToken->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CheckForTwoFactor.php (line 49)
at CheckForTwoFactor->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CheckLocale.php (line 42)
at CheckLocale->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in VerifyCsrfToken.php (line 65)
at VerifyCsrfToken->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in AddQueuedCookiesToResponse.php (line 37)
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in EncryptCookies.php (line 59)
at EncryptCookies->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in Pipeline.php (line 102)
at Pipeline->then(object(Closure))
in Router.php (line 561)
at Router->runRouteWithinStack(object(Route), object(Request))
in Router.php (line 520)
at Router->dispatchToRoute(object(Request))
in Router.php (line 498)
at Router->dispatch(object(Request))
in Kernel.php (line 174)
at Kernel->Illuminate\Foundation\Http{closure}(object(Request))
in Pipeline.php (line 30)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in Debugbar.php (line 51)
at Debugbar->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CheckForDebug.php (line 25)
at CheckForDebug->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in TrustProxies.php (line 56)
at TrustProxies->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CheckForSetup.php (line 35)
at CheckForSetup->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in NosniffGuard.php (line 17)
at NosniffGuard->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in XssProtectHeader.php (line 17)
at XssProtectHeader->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in FrameGuard.php (line 17)
at FrameGuard->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in ShareErrorsFromSession.php (line 49)
at ShareErrorsFromSession->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in StartSession.php (line 64)
at StartSession->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CheckForMaintenanceMode.php (line 46)
at CheckForMaintenanceMode->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in Pipeline.php (line 102)
at Pipeline->then(object(Closure))
in Kernel.php (line 149)
at Kernel->sendRequestThroughRouter(object(Request))
in Kernel.php (line 116)
at Kernel->handle(object(Request))
in index.php (line 58)
(1/2) PDOException
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'labels_width'
in Connection.php (line 449)
at PDOStatement->execute()
in Connection.php (line 449)
at Connection->Illuminate\Database{closure}('alter table settings add labels_per_page tinyint not null default \'30\', add labels_width decimal(6, 5) not null default \'2,625\', add labels_height decimal(6, 5) not null default \'1\', add labels_pmargin_left decimal(6, 5) not null default \'0,21975\', add labels_pmargin_right decimal(6, 5) not null default \'0,21975\', add labels_pmargin_top decimal(6, 5) not null default \'0,5\', add labels_pmargin_bottom decimal(6, 5) not null default \'0,5\', add labels_display_bgutter decimal(6, 5) not null default \'0,07\', add labels_display_sgutter decimal(6, 5) not null default \'0,05\', add labels_fontsize tinyint not null default \'9\', add labels_pagewidth decimal(7, 5) not null default \'8,5\', add labels_pageheight decimal(7, 5) not null default \'11\', add labels_display_name tinyint not null default \'0\', add labels_display_serial tinyint not null default \'1\', add labels_display_tag tinyint not null default \'1\'', array())
in Connection.php (line 640)
at Connection->runQueryCallback('alter table settings add labels_per_page tinyint not null default \'30\', add labels_width decimal(6, 5) not null default \'2,625\', add labels_height decimal(6, 5) not null default \'1\', add labels_pmargin_left decimal(6, 5) not null default \'0,21975\', add labels_pmargin_right decimal(6, 5) not null default \'0,21975\', add labels_pmargin_top decimal(6, 5) not null default \'0,5\', add labels_pmargin_bottom decimal(6, 5) not null default \'0,5\', add labels_display_bgutter decimal(6, 5) not null default \'0,07\', add labels_display_sgutter decimal(6, 5) not null default \'0,05\', add labels_fontsize tinyint not null default \'9\', add labels_pagewidth decimal(7, 5) not null default \'8,5\', add labels_pageheight decimal(7, 5) not null default \'11\', add labels_display_name tinyint not null default \'0\', add labels_display_serial tinyint not null default \'1\', add labels_display_tag tinyint not null default \'1\'', array(), object(Closure))
in Connection.php (line 607)
at Connection->run('alter table settings add labels_per_page tinyint not null default \'30\', add labels_width decimal(6, 5) not null default \'2,625\', add labels_height decimal(6, 5) not null default \'1\', add labels_pmargin_left decimal(6, 5) not null default \'0,21975\', add labels_pmargin_right decimal(6, 5) not null default \'0,21975\', add labels_pmargin_top decimal(6, 5) not null default \'0,5\', add labels_pmargin_bottom decimal(6, 5) not null default \'0,5\', add labels_display_bgutter decimal(6, 5) not null default \'0,07\', add labels_display_sgutter decimal(6, 5) not null default \'0,05\', add labels_fontsize tinyint not null default \'9\', add labels_pagewidth decimal(7, 5) not null default \'8,5\', add labels_pageheight decimal(7, 5) not null default \'11\', add labels_display_name tinyint not null default \'0\', add labels_display_serial tinyint not null default \'1\', add labels_display_tag tinyint not null default \'1\'', array(), object(Closure))
in Connection.php (line 450)
at Connection->statement('alter table settings add labels_per_page tinyint not null default \'30\', add labels_width decimal(6, 5) not null default \'2,625\', add labels_height decimal(6, 5) not null default \'1\', add labels_pmargin_left decimal(6, 5) not null default \'0,21975\', add labels_pmargin_right decimal(6, 5) not null default \'0,21975\', add labels_pmargin_top decimal(6, 5) not null default \'0,5\', add labels_pmargin_bottom decimal(6, 5) not null default \'0,5\', add labels_display_bgutter decimal(6, 5) not null default \'0,07\', add labels_display_sgutter decimal(6, 5) not null default \'0,05\', add labels_fontsize tinyint not null default \'9\', add labels_pagewidth decimal(7, 5) not null default \'8,5\', add labels_pageheight decimal(7, 5) not null default \'11\', add labels_display_name tinyint not null default \'0\', add labels_display_serial tinyint not null default \'1\', add labels_display_tag tinyint not null default \'1\'')
in Blueprint.php (line 83)
at Blueprint->build(object(MySqlConnection), object(MySqlGrammar))
in Builder.php (line 239)
at Builder->build(object(Blueprint))
in Builder.php (line 148)
at Builder->table('settings', object(Closure))
in Facade.php (line 221)
at Facade::callStatic('table', array('settings', object(Closure)))
in 2016_03_11_185621_add_label_settings_to_settings.php (line 31)
at AddLabelSettingsToSettings->up()
in Migrator.php (line 353)
at Migrator->Illuminate\Database\Migrations{closure}()
in Migrator.php (line 359)
at Migrator->runMigration(object(AddLabelSettingsToSettings), 'up')
in Migrator.php (line 177)
at Migrator->runUp('C:\inetpub\wwwroot\snipe-it\database\migrations/2016_03_11_185621_add_label_settings_to_settings.php', 2, false)
in Migrator.php (line 146)
at Migrator->runPending(array('C:\inetpub\wwwroot\snipe-it\database\migrations/2016_03_11_185621_add_label_settings_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_03_22_125911_fix_custom_fields_regexes.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_04_28_141554_add_show_to_users.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_16_164733_add_model_mfg_to_consumable.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_19_180351_add_alt_barcode_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_19_191146_add_alter_interval.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_19_192226_add_inventory_threshold.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_20_024859_remove_option_keys_from_settings_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_05_20_143758_remove_option_value_from_settings_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_06_01_140218_add_email_domain_and_format_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_06_22_160725_add_user_id_to_maintenances.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_13_150015_add_is_ad_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_14_153609_add_ad_domain_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_22_003348_fix_custom_fields_regex_stuff.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_22_054850_one_more_mac_addr_fix.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_22_143045_add_port_to_ldap_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_22_153432_add_tls_to_ldap_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_07_27_211034_add_zerofill_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_02_124944_add_color_to_statuslabel.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_04_134500_add_disallow_ldap_pw_sync_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_09_002225_add_manufacturer_to_licenses.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_12_121613_add_manufacturer_to_accessories_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_23_143353_add_new_fields_to_custom_fields.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_23_145619_add_show_in_nav_to_status_labels.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_08_30_084634_make_purchase_cost_nullable.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_01_141051_add_requestable_to_asset_model.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_02_001448_create_checkout_requests_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_04_180400_create_actionlog_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_04_182149_migrate_asset_log_to_action_log.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_19_235935_fix_fieldtype_for_target_type.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_23_140722_fix_modelno_in_consumables_to_string.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_09_28_231359_add_company_to_logs.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_14_130709_fix_order_number_to_varchar.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_16_015024_rename_modelno_to_model_number.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_16_015211_rename_consumable_modelno_to_model_number.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_16_143235_rename_model_note_to_notes.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_16_165052_rename_component_total_qty_to_qty.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_19_145520_fix_order_number_in_components_to_string.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_27_151715_add_serial_to_components.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_27_213251_increase_serial_field_capacity.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_29_002724_enable_2fa_fields.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_10_29_082408_add_signature_to_acceptance.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_01_030818_fix_forgotten_filename_in_action_logs.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_13_020954_rename_component_serial_number_to_serial.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_16_172119_increase_purchase_cost_size.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_17_161317_longer_state_field_in_location.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_17_193706_add_model_number_to_accessories.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_11_24_160405_add_missing_target_type_to_logs_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_12_07_173720_increase_size_of_state_in_suppliers.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_12_19_004212_adjust_locale_length_to_10.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_12_19_133936_extend_phone_lengths_in_supplier_and_elsewhere.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2016_12_27_212631_make_asset_assigned_to_polymorphic.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_01_09_040429_create_locations_ldap_query_field.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_01_14_002418_create_imports_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_01_25_063357_fix_utf8_custom_field_column_names.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_03_03_154632_add_time_date_display_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_03_10_210807_add_fields_to_manufacturer.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_05_08_195520_increase_size_of_field_values_in_custom_fields.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_05_22_204422_create_departments.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_05_22_233509_add_manager_to_locations_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_06_14_122059_add_next_autoincrement_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_06_18_151753_add_header_and_first_row_to_importer_table.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_07_07_191533_add_login_text.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_07_25_130710_add_thumbsize_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_08_03_160105_set_asset_archived_to_zero_default.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_08_22_180636_add_secure_password_options.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_08_25_074822_add_auditing_tables.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_08_25_101435_add_auditing_to_settings.php', 'C:\inetpub\wwwroot\snipe-it\database\migrations/2017_09_18_225619_fix_assigned_type_not_being_nulled.php'), array('pretend' => false, 'step' => false))
in Migrator.php (line 95)
at Migrator->run(array('C:\inetpub\wwwroot\snipe-it\database\migrations'), array('pretend' => false, 'step' => false))
in MigrateCommand.php (line 69)
at MigrateCommand->fire()
at call_user_func_array(array(object(MigrateCommand), 'fire'), array())
in BoundMethod.php (line 29)
at BoundMethod::Illuminate\Container{closure}()
in BoundMethod.php (line 87)
at BoundMethod::callBoundMethod(object(Application), array(object(MigrateCommand), 'fire'), object(Closure))
in BoundMethod.php (line 31)
at BoundMethod::call(object(Application), array(object(MigrateCommand), 'fire'), array(), null)
in Container.php (line 531)
at Container->call(array(object(MigrateCommand), 'fire'))
in Command.php (line 182)
at Command->execute(object(ArrayInput), object(OutputStyle))
in Command.php (line 264)
at Command->run(object(ArrayInput), object(OutputStyle))
in Command.php (line 167)
at Command->run(object(ArrayInput), object(BufferedOutput))
in Application.php (line 874)
at Application->doRunCommand(object(MigrateCommand), object(ArrayInput), object(BufferedOutput))
in Application.php (line 228)
at Application->doRun(object(ArrayInput), object(BufferedOutput))
in Application.php (line 130)
at Application->run(object(ArrayInput), object(BufferedOutput))
in Application.php (line 141)
at Application->call('migrate', object(Collection), null)
in Kernel.php (line 220)
at Kernel->call('migrate', array('--force' => true))
in Facade.php (line 221)
at Facade::__callStatic('call', array('migrate', array('--force' => true)))
in SettingsController.php (line 261)
at SettingsController->getSetupMigrate()
at call_user_func_array(array(object(SettingsController), 'getSetupMigrate'), array())
in Controller.php (line 55)
at Controller->callAction('getSetupMigrate', array())
in ControllerDispatcher.php (line 44)
at ControllerDispatcher->dispatch(object(Route), object(SettingsController), 'getSetupMigrate')
in Route.php (line 203)
at Route->runController()
in Route.php (line 160)
at Route->run()
in Router.php (line 559)
at Router->Illuminate\Routing{closure}(object(Request))
in Pipeline.php (line 30)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CreateFreshApiToken.php (line 49)
at CreateFreshApiToken->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CheckForTwoFactor.php (line 49)
at CheckForTwoFactor->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CheckLocale.php (line 42)
at CheckLocale->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in VerifyCsrfToken.php (line 65)
at VerifyCsrfToken->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in AddQueuedCookiesToResponse.php (line 37)
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in EncryptCookies.php (line 59)
at EncryptCookies->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in Pipeline.php (line 102)
at Pipeline->then(object(Closure))
in Router.php (line 561)
at Router->runRouteWithinStack(object(Route), object(Request))
in Router.php (line 520)
at Router->dispatchToRoute(object(Request))
in Router.php (line 498)
at Router->dispatch(object(Request))
in Kernel.php (line 174)
at Kernel->Illuminate\Foundation\Http{closure}(object(Request))
in Pipeline.php (line 30)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in Debugbar.php (line 51)
at Debugbar->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CheckForDebug.php (line 25)
at CheckForDebug->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in TrustProxies.php (line 56)
at TrustProxies->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CheckForSetup.php (line 35)
at CheckForSetup->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in NosniffGuard.php (line 17)
at NosniffGuard->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in XssProtectHeader.php (line 17)
at XssProtectHeader->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in FrameGuard.php (line 17)
at FrameGuard->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in ShareErrorsFromSession.php (line 49)
at ShareErrorsFromSession->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in StartSession.php (line 64)
at StartSession->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in CheckForMaintenanceMode.php (line 46)
at CheckForMaintenanceMode->handle(object(Request), object(Closure))
in Pipeline.php (line 148)
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing{closure}(object(Request))
in Pipeline.php (line 102)
at Pipeline->then(object(Closure))
in Kernel.php (line 149)
at Kernel->sendRequestThroughRouter(object(Request))
in Kernel.php (line 116)
at Kernel->handle(object(Request))
in index.php (line 58)
Kaymen
commented
7 years ago When I remove 2016_03_11_185621_add_label_settings_to_settings.php the installation go futher an I can add a user. But I dont know if everyting will work?
snipe
commented
7 years ago It won’t - every migration is necessary, and you’ll end up breaking other stuff elsewhere :(
snipe
commented
7 years ago Can you paste in the contents of that migration? (Sorry, am afk - if you can’t, i’ll check when i’m back in front of the computer)
Kaymen
commented
7 years ago What can I do to get on with the problem?
Kaymen
commented
7 years ago Here are one log @snipe
snipe
commented
7 years ago So the bit that's strange here is that the migration is using decimals as the default, but for some people (you and @nockeer) are having it grokked as commas instead.
Schema::table('settings', function (Blueprint $table) {
$table->tinyInteger('labels_per_page')->default(30);
$table->decimal('labels_width', 6, 5)->default(2.625);
$table->decimal('labels_height', 6, 5)->default(1);
$table->decimal('labels_pmargin_left', 6, 5)->default(0.21975);
$table->decimal('labels_pmargin_right', 6, 5)->default(0.21975);
$table->decimal('labels_pmargin_top', 6, 5)->default(0.5);
$table->decimal('labels_pmargin_bottom', 6, 5)->default(0.5);
$table->decimal('labels_display_bgutter', 6, 5)->default(0.07);
$table->decimal('labels_display_sgutter', 6, 5)->default(0.05);
$table->tinyInteger('labels_fontsize')->default(9);
$table->decimal('labels_pagewidth', 7, 5)->default(8.5);
$table->decimal('labels_pageheight', 7, 5)->default(11);
$table->tinyInteger('labels_display_name')->default(0);
$table->tinyInteger('labels_display_serial')->default(1);
$table->tinyInteger('labels_display_tag')->default(1);
});What is your APP_LOCALE set to in your .env? This looks sort of related.
nockeer
commented
7 years ago I have 'pl'. Other settings:
DB_CHARSET=utf8mb4 DB_COLLATION=utf8mb4_general_ci
Edit: I changed app_locale to 'en' and migration of labels goes on :) But there is next error :/
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'rtf.oauth_clients' doesn't exist (SQL: insert into oauth_clients (user_id, name, secret, redirect, personal_access_client, password_client, revoked, updated_at, created_at) values (, Snipe-IT Personal Access Client, t9kJ46pmgHSub4trPQkCgmGohUR83TjqRnOutSbP, http://localhost, 1, 0, 0, 2017-10-18 14:39:28, 2017-10-18 14:39:28))
snipe
commented
7 years ago Try running migrations again
Kaymen
commented
7 years ago I have sv-SE
I will try EN
snipe
commented
7 years ago Any luck?
snipe
commented
6 years ago Hi there - We haven't heard back in a bit, so I'm going to close this ticket for now, but will re-open it if you're still having issues.
Sec1user
commented
4 years ago @Kaymen Did you manage to solve this?
burgich
commented
3 years ago Hello
I ran into exactly the error at installation (after clicking "Next: Create Database Tables"). Changing APP_LOCALE from my custom setting "de" back to default "en" was also for me the right work-around.
Edit: I use XAMPP as base for my installation, which uses MariaDB. So it seems to be a problem with MariaDB.
fesdan
commented
2 years ago Just for all to know..
I made my first installation with the same error.. Change APP_LOCAL before first create to german which does not work
EN than worked for me...
Expected Behavior (or desired behavior if a feature request)
A working installation
Snipe-IT 4.0 Windows Server 2016, IIS, PHP7, MariaDB manual installation
From server.domain.XX
Actual Behavior
(2/2) QueryException SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'labels_width' (SQL: alter table
settingsaddlabels_per_pagetinyint not null default '30', addlabels_widthdecimal(6, 5) not null default '2,625', addlabels_heightdecimal(6, 5) not null default '1', addlabels_pmargin_leftdecimal(6, 5) not null default '0,21975', addlabels_pmargin_rightdecimal(6, 5) not null default '0,21975', addlabels_pmargin_topdecimal(6, 5) not null default '0,5', addlabels_pmargin_bottomdecimal(6, 5) not null default '0,5', addlabels_display_bgutterdecimal(6, 5) not null default '0,07', addlabels_display_sgutterdecimal(6, 5) not null default '0,05', addlabels_fontsizetinyint not null default '9', addlabels_pagewidthdecimal(7, 5) not null default '8,5', addlabels_pageheightdecimal(7, 5) not null default '11', addlabels_display_nametinyint not null default '0', addlabels_display_serialtinyint not null default '1', addlabels_display_tagtinyint not null default '1')Please confirm you have done the following before posting your bug report: