BCStorm error logs

Results 1 to 2 of 2
  1. #1
    Alpha Member Glee is offline
    MemberRank
    Jun 2009 Join Date
    Niagara Falls,Location
    2,225Posts

    BCStorm error logs

    Okay so I followed everything that people has been posting...

    Things I have Imported into my database

    PHP Code:
    DELIMITER $$
    --
    -- 
    Procedures
    --
    CREATE DEFINER=`root`@`localhostPROCEDURE `getroomitems`(
    IN roomid int(10unsigned
    )
    BEGIN
    SELECT items_rooms
    .item_iditems_rooms.xitems_rooms.yitems_rooms.nitems.base_iditems_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`@`localhostPROCEDURE `getuseritems`(
    IN userid int(10unsigned
    )
    BEGIN
    SELECT items_users
    .item_iditems.base_iditems_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_nameVALUES ('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 


  2. #2
    Loyalty Vaulient is offline
    MemberRank
    May 2012 Join Date
    MalaysiaLocation
    1,796Posts

    Re: BCStorm error logs

    That code has nothing to do with te errors you have. Go to your database , ffind the column description , change the default value to 0 to get rid off the description error.



Advertisement