Okay so I followed everything that people has been posting...
Things I have Imported into my database
PHP Code:
DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(
IN roomid int(10) unsigned
)
BEGIN
SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data
FROM items_rooms
JOIN items ON (items.item_id = items_rooms.item_id)
LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
WHERE items_rooms.room_id = roomid;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(
IN userid int(10) unsigned
)
BEGIN
SELECT items_users.item_id, items.base_id, items_extradata.data
FROM items_users
JOIN items ON (items.item_id = items_users.item_id)
LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
WHERE items_users.user_id = userid;
END$$
DELIMITER ;
and I keep getting these error logs messages.
PHP Code:
Error in query:
INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private' [MENTION=482331]Caption[/MENTION] [MENTION=664921]Username,[/MENTION [MENTION=1333478952]model[/MENTION])
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.ExecuteReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()
Error in query:
UPDATE users SET users.online = '0', users.last_online = '12/23/2013 2:04:19 PM', activity_points = '4300', activity_points_lastupdate = '1387825341', credits = '9624', achievement_points = 45 WHERE id = '1'; DELETE FROM user_online WHERE userid = 1;
MySql.Data.MySqlClient.MySqlException (0x80004005): Data too long for column 'last_online' 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.ExecuteReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery()
Error in packet [1650] BODY: [0][0][0][0][0]????:
TokenID: 0System.IndexOutOfRangeException: Cannot find column 8.
at System.Data.DataColumnCollection.get_Item(Int32 index)
at System.Data.DataRow.get_Item(Int32 columnIndex)
at Butterfly.HabboHotel.Rooms.RoomItemHandling.LoadFurniture() in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\HabboHotel\Rooms\RoomItemHandling.cs:line 235
at Butterfly.HabboHotel.Rooms.Room.Initialize(UInt32 Id, String Name, String Description, String Type, String Owner, Int32 OwnerId, Int32 Category, Int32 State, Int32 UsersMax, String ModelName, String CCTs, Int32 Score, List`1 pTags, Boolean AllowPets, Boolean AllowPetsEating, Boolean AllowWalkthrough, Boolean Hidewall, RoomIcon Icon, String Password, String Wallpaper, String Floor, String Landscape, RoomData RoomData, Boolean RightOverride, Int32 walltickness, Int32 floorthickness, Int32 groupid) in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\HabboHotel\Rooms\Room.cs:line 637
at Butterfly.HabboHotel.Rooms.Room.InitializeFromRoomData(RoomData Data) in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\HabboHotel\Rooms\Room.cs:line 660
at Butterfly.HabboHotel.Rooms.Room..ctor(RoomData Data) in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\HabboHotel\Rooms\Room.cs:line 109
at Butterfly.HabboHotel.Rooms.RoomManager.LoadRoom(UInt32 Id) in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\HabboHotel\Rooms\RoomManager.cs:line 330
at Butterfly.Messages.GameClientMessageHandler.PrepareRoomForUser(UInt32 Id, String Password) in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\Messages\GameClientMessageHandler.cs:line 5541
at Butterfly.Messages.GameClientMessageHandler.enterOnRoom(UInt32 roomId) in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\Messages\GameClientMessageHandler.cs:line 1835
at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.enterOnRoom(GameClientMessageHandler handler) in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 222
at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\Messages\GameClientMessageHandler.cs:line 3165
at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in C:\Users\Administrator\Desktop\BcStorm-Final\Butterfly\HabboHotel\GameClients\GameClient.cs:line 137