Error MySQLerrors and criticalexcpetions under MarshMallow Emulator

[Lord Fool]

Good Morning :).

Today I installed the latest version of Marshmallow . Know first that under localhost everything works perfectly ! I did not change apart from access to the database and links to SWFS .

Let me explain, I can connect A once on the hotel ( quiet ) but once I would like to reconnect nothing works , the client remains blocked at 87%. I have two errors, one against MySQL , and the other a critical error. I use Azure CMS, but it works perfectly in localhost so I do not see why its not working there. Worse , the emulator does not display any error.

logs - MySQLerrors :

Spoiler:

<3/7/2015 8:10:04 AM> Error in query:
CALL getroomitems(@roomid)
MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE freeh_db_77444.getroomitems does not exist
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Database_Manager.Database.Session_Details.QueryAdapter.getTable() in c:\Users\carlos\Documents\GitHub\Emulator\Servidor\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 145

logs - criticalexceptions :

Spoiler:

<3/7/2015 8:10:01 AM> Invalid Dario bug duing user login: System.FormatException: The string was not recognized as a valid DateTime. There is an unknown word starting at index 17.
at System.DateTime.Parse(String s, IFormatProvider provider)
at System.Convert.ToDateTime(String value)
at Butterfly.HabboHotel.Users.Habbo..ctor(UInt32 Id, String Username, String RealName, UInt32 Rank, String Motto, Double UnixTime, String Look, String Gender, UInt32 Diamonds, UInt32 HomeRoom, UInt32 Respect, UInt32 DailyRespectPoints, UInt32 DailyPetRespectPoints, Boolean MutantPenalty, Boolean HasFriendRequestsDisabled, UInt32 currentQuestID, UInt32 currentQuestProgress, UInt32 achievementPoints, UInt32 nameChanges, UInt32 FavoriteGroup, Boolean block_trade, String _volumenSystem, Boolean preferoldchat, String lastpurchase, String achievementtext, List`1 pollparticipation, List`1 votedrooms, String lastfollowinglogin, Boolean ignoreRoomInvitations, Int32 citizenshipLevel, Int32 helperLevel, String wiredactrewards, Boolean newNavigatorEnabled, Boolean dontFocusUser, Dictionary`2 naviLogs) in c:\Users\carlos\Documents\GitHub\Emulator\Servidor\Butterfly Emulator\HabboHotel\Users\Habbo.cs:line 299
at Butterfly.HabboHotel.Users.Authenticator.HabboFactory.GenerateHabbo(DataRow dRow) in c:\Users\carlos\Documents\GitHub\Emulator\Servidor\Butterfly Emulator\HabboHotel\Users\Authenticator\Authenticator.cs:line 78
at Butterfly.HabboHotel.Users.UserDataManagement.UserDataFactory.GetUserData(String sessionTicket) in c:\Users\carlos\Documents\GitHub\Emulator\Servidor\Butterfly Emulator\HabboHotel\Users\UserData\UserDataFactory.cs:line 124
at Butterfly.HabboHotel.GameClients.GameClient.tryLogin(String AuthTicket) in c:\Users\carlos\Documents\GitHub\Emulator\Servidor\Butterfly Emulator\HabboHotel\GameClients\GameClient.cs:line 116

Thank's

UPDATE :
code for MySQL error :

Spoiler:

[code=nocode:0]public DataTable getTable()
{
var now = DateTime.Now;
var dataTable = new DataTable();
if (!dbEnabled)
return dataTable;
try
{
using (var adapter = new MySqlDataAdapter(command))
{
adapter.Fill(dataTable);
}
}
catch (Exception exception)
{
Writer.LogQueryError(exception, command.CommandText);
}
var span = DateTime.Now - now;
DatabaseStats.totalQueryTime += span.Milliseconds;
DatabaseStats.totalQueries++;
return dataTable;
}


[/code]

[MentaL]

[The General]

http://forum.ragezone.com/f333/plus-...6/#post8195806

[Lord Fool]

http://forum.ragezone.com/f333/plus-...6/#post8195806

The bug appears to be resolved. Thank you to you : D!