Room Report doesn't show on Ticket Browser

jasoks

New Member
Aug 27, 2016
21
5
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.
 

jasoks

New Member
Aug 27, 2016
21
5
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:
PHP:
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

Posting Freak
Feb 6, 2016
710
438
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

New Member
Aug 27, 2016
21
5
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.
 

Users who are viewing this thread

Top