Room Report doesn't show on Ticket Browser

[jasoks]

Hello, i've got this problem:

When i'm trying to report a room, if I go to Ticket Browser doesn't show report, only if I report a user.

I'm currently using Plus Emulator R2.

How to resolve that? Thanks in advance.

 

[Berk]

Do you have anything in your /logs/error/MySQL.txt file? (can't properly remember the path atm, so..)

 

[jasoks]

Do you have anything in your /logs/error/MySQL.txt file? (can't properly remember the path atm, so..)

Hello, that's my MySQL log:

Error in query:
INSERT INTO bots_petdata (id,type,race,color,experience,energy,createstamp) VALUES (1, 10,@1race,@1color,0,100,UNIX_TIMESTAMP())
MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '1' for key 'PRIMARY'
   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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Administrator\Desktop\Release 2\Emulator Source\Database\Adapter\QueryAdapter.cs:line 167



Date/Time: 2017-04-21 22:52:44,545
Thread: 5
Error in query:
INSERT INTO bots_petdata (id,type,race,color,experience,energy,createstamp) VALUES (1, 4,@1race,@1color,0,100,UNIX_TIMESTAMP())
MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '1' for key 'PRIMARY'
   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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Administrator\Desktop\Release 2\Emulator Source\Database\Adapter\QueryAdapter.cs:line 167



Date/Time: 2017-04-21 23:08:12,339
Thread: 14
Error in query:
UPDATE `users` SET `online` = '0', `last_online` = '1492808892.30078', `activity_points` = '454726', `credits` = '1687223', `vip_points` = '1174', `home_room` = '10', `gotw_points` = '0', `time_muted` = '0',`friend_bar_state` = '1' WHERE id = '1208' LIMIT 1;UPDATE `user_stats` SET `roomvisits` = '1', `onlineTime` = '209.291015625', `respect` = '3', `respectGiven` = '0', `giftsGiven` = '0', `giftsReceived` = '0', `dailyRespectPoints` = '20', `dailyPetRespectPoints` = '3', `AchievementScore` = '20', `quest_id` = '0', `quest_progress` = '0', `groupid` = '0',`forum_posts` = '0' WHERE `id` = '1208' LIMIT 1;
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'habbo.user_stats' doesn't 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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Administrator\Desktop\Release 2\Emulator Source\Database\Adapter\QueryAdapter.cs:line 167



Date/Time: 2017-04-21 23:08:19,447
Thread: 5
Error in query:
SELECT `id`,`roomvisits`,`onlinetime`,`respect`,`respectgiven`,`giftsgiven`,`giftsreceived`,`dailyrespectpoints`,`dailypetrespectpoints`,`achievementscore`,`quest_id`,`quest_progress`,`groupid`,`tickets_answered`,`respectstimestamp`,`forum_posts` FROM `user_stats` WHERE `id` = @user_id LIMIT 1
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'habbo.user_stats' doesn't 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 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Plus.Database.Adapter.QueryAdapter.GetRow() in C:\Users\Administrator\Desktop\Release 2\Emulator Source\Database\Adapter\QueryAdapter.cs:line 72



Date/Time: 2017-04-21 23:08:19,475
Thread: 5
Error in query:
INSERT INTO `user_stats` (`id`) VALUES ('1208')
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'habbo.user_stats' doesn't 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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Administrator\Desktop\Release 2\Emulator Source\Database\Adapter\QueryAdapter.cs:line 167



Date/Time: 2017-04-21 23:08:19,493
Thread: 5
Error in query:
SELECT `id`,`roomvisits`,`onlinetime`,`respect`,`respectgiven`,`giftsgiven`,`giftsreceived`,`dailyrespectpoints`,`dailypetrespectpoints`,`achievementscore`,`quest_id`,`quest_progress`,`groupid`,`tickets_answered`,`respectstimestamp`,`forum_posts` FROM `user_stats` WHERE `id` = @user_id LIMIT 1
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'habbo.user_stats' doesn't 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 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Plus.Database.Adapter.QueryAdapter.GetRow() in C:\Users\Administrator\Desktop\Release 2\Emulator Source\Database\Adapter\QueryAdapter.cs:line 72



Date/Time: 2017-04-21 23:13:56,710
Thread: 1
Error in query:
UPDATE `users` SET `online` = '0', `auth_ticket` = NULL
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'habbo.users' doesn't 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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Administrator\Desktop\Release 2\Emulator Source\Database\Adapter\QueryAdapter.cs:line 167



Date/Time: 2017-04-21 23:14:33,105
Thread: 1
Error in query:
UPDATE `users` SET `online` = '0' WHERE `online` = '1'
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'habbo.users' doesn't 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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Administrator\Desktop\Release 2\Emulator Source\Database\Adapter\QueryAdapter.cs:line 167



Date/Time: 2017-04-21 23:14:46,043
Thread: 1
Error in query:
UPDATE `users` SET `online` = '0', `auth_ticket` = NULL
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'habbo.users' doesn't 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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Administrator\Desktop\Release 2\Emulator Source\Database\Adapter\QueryAdapter.cs:line 167

What's the problem?

 

[JynX]

You have two bots with the same id as #1. The second one is saying user_stats is missing so you should add it. And the last one says that the users table doesn't exist so you should add it.

 

[jasoks]

You have two bots with the same id as #1. The second one is saying user_stats is missing so you should add it. And the last one says that the users table doesn't exist so you should add it.

Very strange, becouse user_stats exist in the database.

 

[JynX]

Very strange, becouse user_stats exist in the database.

By the looks of the errors they're from yesterday anyways.

Edit: I don't think the errors in your logs pertain to this issue anyways.

 

[jasoks]

Also according to me, but I think when i debug the Emulator logs doesn't update. Or I am wrong?