SQL: PlusEMU
UPDATE `rooms` SET `caption` = @caption, `description` = @description, `password
` = @password, `category` = @categoryId, `state` = @state, `tags` = @tags, `user
s_max` = @maxUsers, `allow_pets` = @allowPets, `allow_pets_eat` = @allowPetsEat,
`room_blocking_disabled` = @roomBlockingDisabled, `allow_hidewall` = @allowHide
wall, `floorthick` = @floorThick, `wallthick` = @wallThick, `mute_settings` = @m
uteSettings, `kick_settings` = @kickSettings, `ban_settings` = @banSettings, `ch
at_mode` = @chatMode, `chat_size` = @chatSize, `chat_speed` = @chatSpeed, `chat_
extra_flood` = @extraFlood, `chat_hearing_distance` = @chatDistance, `trade_sett
ings` = @tradeSettings WHERE `id` = @roomId LIMIT 1
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'r
oom_blocking_disabled' at row 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& i
nsertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior
)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Sledmore\Desktop
\PlusEMU\Database\Adapter\QueryAdapter.cs:line
Alles anzeigen
weiß jemand wie ich das in der DB selber fixxe?
Ich habe mit F6 in Navicat schon den Befehl ausgeführt. Leider erfolglos.
Muss wohl manuell bearbeitet werden. Nur kann ich mit caption = @caption nix anfangen xD