This

[Roberticox12]

Hi, i have this three errors.

Error in query: 
INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'description' doesn't have a default value
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()

Error in query: 
UPDATE rooms SET caption = @caption, description = @description, password = @password, category = 6, state = 'password', tags = @tags, users_max = 25, allow_pets = 0, allow_pets_eat = 0, allow_walkthrough = 0, allow_hidewall = 0, floorthickness = 0, wallthickness = 0 WHERE id = 1634
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'allow_pets' at row 1
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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.ExecuteNonQuery()
   at Database_Manager.Database.Session_Details.QueryAdapter.runQuery()

Error in query: 
UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:07 AM', activity_points = '63400', activity_points_lastupdate = '1367884907', credits = '2032668', achievement_points = 70 WHERE id = '336'; DELETE FROM user_online WHERE userid = 336; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:07 AM', activity_points = '144800', activity_points_lastupdate = '1367884907', credits = '8534111', achievement_points = 660 WHERE id = '357'; DELETE FROM user_online WHERE userid = 357; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:07 AM', activity_points = '98400', activity_points_lastupdate = '1367884907', credits = '2096435', achievement_points = 235 WHERE id = '957'; DELETE FROM user_online WHERE userid = 957; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:07 AM', activity_points = '73000', activity_points_lastupdate = '1367884907', credits = '1729001', achievement_points = 215 WHERE id = '996'; DELETE FROM user_online WHERE userid = 996; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:07 AM', activity_points = '65300', activity_points_lastupdate = '1367884907', credits = '2011205', achievement_points = 160 WHERE id = '1706'; DELETE FROM user_online WHERE userid = 1706; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:07 AM', activity_points = '116700', activity_points_lastupdate = '1367884907', credits = '1937904', achievement_points = 595 WHERE id = '395'; DELETE FROM user_online WHERE userid = 395; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:08 AM', activity_points = '253856', activity_points_lastupdate = '1367884907', credits = '1821619', achievement_points = 285 WHERE id = '871'; DELETE FROM user_online WHERE userid = 871; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:08 AM', activity_points = '76600', activity_points_lastupdate = '1367884907', credits = '2083876', achievement_points = 185 WHERE id = '965'; DELETE FROM user_online WHERE userid = 965; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:08 AM', activity_points = '134900', activity_points_lastupdate = '1367884907', credits = '9186058', achievement_points = 395 WHERE id = '11'; DELETE FROM user_online WHERE userid = 11; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:08 AM', activity_points = '100500', activity_points_lastupdate = '1367884907', credits = '103500', achievement_points = 320 WHERE id = '1606'; DELETE FROM user_online WHERE userid = 1606; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:08 AM', activity_points = '133200', activity_points_lastupdate = '1367884907', credits = '18138200', achievement_points = 500 WHERE id = '363'; DELETE FROM user_online WHERE userid = 363; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:08 AM', activity_points = '60200', activity_points_lastupdate = '1367884907', credits = '2003200', achievement_points = 50 WHERE id = '1758'; DELETE FROM user_online WHERE userid = 1758; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:08 AM', activity_points = '73500', activity_points_lastupdate = '1367884907', credits = '2009189', achievement_points = 215 WHERE id = '1076'; DELETE FROM user_online WHERE userid = 1076; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:08 AM', activity_points = '112100', activity_points_lastupdate = '1367884907', credits = '2220591', achievement_points = 320 WHERE id = '519'; DELETE FROM user_online WHERE userid = 519; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:10 AM', activity_points = '93300', activity_points_lastupdate = '1367884907', credits = '8814207', achievement_points = 680 WHERE id = '219'; DELETE FROM user_online WHERE userid = 219; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:10 AM', activity_points = '107700', activity_points_lastupdate = '1367884907', credits = '8955957', achievement_points = 325 WHERE id = '254'; DELETE FROM user_online WHERE userid = 254; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:11 AM', activity_points = '74400', activity_points_lastupdate = '1367884907', credits = '2052607', achievement_points = 265 WHERE id = '1233'; DELETE FROM user_online WHERE userid = 1233; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:11 AM', activity_points = '151300', activity_points_lastupdate = '1367884907', credits = '6029217', achievement_points = 435 WHERE id = '28'; DELETE FROM user_online WHERE userid = 28; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:11 AM', activity_points = '150400', activity_points_lastupdate = '1367884907', credits = '9188711', achievement_points = 400 WHERE id = '369'; DELETE FROM user_online WHERE userid = 369; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:11 AM', activity_points = '100200', activity_points_lastupdate = '1367884948', credits = '2125708', achievement_points = 210 WHERE id = '1024'; DELETE FROM user_online WHERE userid = 1024; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:11 AM', activity_points = '77700', activity_points_lastupdate = '1367884907', credits = '2059230', achievement_points = 170 WHERE id = '959'; DELETE FROM user_online WHERE userid = 959; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:11 AM', activity_points = '105500', activity_points_lastupdate = '1367884907', credits = '2265264', achievement_points = 290 WHERE id = '825'; DELETE FROM user_online WHERE userid = 825; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:15 AM', activity_points = '71700', activity_points_lastupdate = '1367884907', credits = '1977253', achievement_points = 275 WHERE id = '966'; DELETE FROM user_online WHERE userid = 966; UPDATE users SET users.online = '0', users.last_online = '5/7/2013 4:03:15 AM', activity_points = '62300', activity_points_lastupdate = '1367884907', credits = '2011079', achievement_points = 90 WHERE id = '1668'; DELETE FROM user_online WHERE userid = 1668;
MySql.Data.MySqlClient.MySqlException (0x80004005): Out of range value for column 'activity_points_lastupdate' at row 1
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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.ExecuteNonQuery()
   at Database_Manager.Database.Session_Details.QueryAdapter.runQuery()

How do I solve in specific?

[MentaL]

[Yannickzz]

Open your phpmyadmin/navicat and go to your rooms table and set the default value for 'description' = none. Go to your rooms table and change the max_length and default value of allow_pets to 20 and default value=1. Do the same for activity_points in the users table.

[The General]

If you got Hubbo''s way you''ll end up editing many tables.

Run this SQL query for me in your phpmyadmin / navicat and tell me what it returns:

SELECT @@GLOBAL.sql_mode;

[Yannickzz]

If you got Hubbo''s way you''ll end up editing many tables.

Run this SQL query for me in your phpmyadmin / navicat and tell me what it returns:

SELECT @@GLOBAL.sql_mode;

But it's editing tables in a good way But your SQL query could also fix it, but it's more likely that he's using a users table that's a little bit different then the emulator requires.

[Roberticox12]

Open your phpmyadmin/navicat and go to your rooms table and set the default value for 'description' = none. Go to your rooms table and change the max_length and default value of allow_pets to 20 and default value=1. Do the same for activity_points in the users table.

Ok, I do not quite understand you can pass sql skype or something?