Beim Laden des Clients bringt der Emu immer wieder in der exceptions.err folgenden Fehler:
Code
01.08.2013
15:09:02: MySql.Data.MySqlClient.MySqlException (0x80004005): Data
truncated for column 'login_timestamp' at row 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
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.ExecuteScalar()
at ns0.Class6.method_1(String string_0)
at ns0.Class12..ctor(String string_0, String string_1, Boolean bool_1)
at ns0.Class16.method_6(String string_0)Wie beheb ich das? (ich hab schon fast alles bei dem login_timestamp versucht
der db-table:
SQL
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
`user_id` int(11) NOT NULL DEFAULT '0',
`bans` int(11) NOT NULL DEFAULT '0',
`cautions` int(11) NOT NULL DEFAULT '0',
`reg_timestamp` double NOT NULL DEFAULT '0',
`login_timestamp` double NOT NULL DEFAULT '0',
`cfhs` int(11) NOT NULL DEFAULT '0',
`cfhs_abusive` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;Danke @Splaze:
Folgendermaßen beheben:
SQL
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
`user_id` int(11) NOT NULL DEFAULT '0',
`bans` int(11) NOT NULL DEFAULT '0',
`cautions` int(11) NOT NULL DEFAULT '0',
`reg_timestamp` double NOT NULL DEFAULT '0',
`login_timestamp` varchar(100) NOT NULL DEFAULT '0',
`cfhs` int(11) NOT NULL DEFAULT '0',
`cfhs_abusive` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;