Error after buying

[EKerik]

Hello all,

When i bought something and then reload the hotel, the follow error pops up:

TokenID: 0Invalid Dario bug duing user login: System.IndexOutOfRangeException: Cannot find column 3.
  at System.Data.DataColumnCollection.get_Item(Int32 index)
  at System.Data.DataRow.get_Item(Int32 columnIndex)
  at Butterfly.HabboHotel.Users.UserDataManagement.UserDataFactory.GetUserData(String sessionTicket, String ip, Byte& errorCode) in c:\Users\Administrator\Desktop\BcStorm\Butterfly\HabboHotel\Users\UserDataManagement\UserDataFactory.cs:line 246
  at Butterfly.HabboHotel.GameClients.GameClient.tryLogin(String AuthTicket) in c:\Users\Administrator\Desktop\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 242

Anyone an idea?? I really need this fixed else people won't be able to buy furni! Which is kinda important....

I am using BcStorm, and it worked fine before. I somewhere found someone that solved this but haven't had a reply yet.
Maybe it has something to do with the mannequins?? Cause before i kinda edited that, it worked perfect!

 

[St4nley]

Emulator meomery issues. Get a new one.

 

[EKerik]

-- Edit --

Problem solved!
Removed my functions and replaced them with this: (run this query after you deleted the functions)

-- ----------------------------
-- Procedure structure for `getroomitems`
-- ----------------------------
DROP PROCEDURE IF EXISTS `getroomitems`;
DELIMITER ;;
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, items.rareid, items.group_data, items.placedBy
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
;;
DELIMITER ;
 
-- ----------------------------
-- Procedure structure for `getuseritems`
-- ----------------------------
DROP PROCEDURE IF EXISTS `getuseritems`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN userid int(10) unsigned)
BEGIN
SELECT items_users.item_id, items.base_id, items_extradata.data, items.rareid, items.group_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 ;

For everyone having the same problem.
Request for close!

 

[Weasel]

Closed upon request. Thank you for also adding how you fixed it.