Client loads, but I can't see rooms.

[Zenternal]

Well, I can see the rooms, but it won't let me enter them.

 
My SWFS came with the DB and EMU.

 

[Devjam]

sql > rooms see if you have any

 

[0liver]

sql > rooms see if you have any

Hence the thread title, and his screenshot, he has rooms lol.

@Zenternal, try a new database? That usually works.

 

[Zenternal]

Hence the thread title, and his screenshot, he has rooms lol.

@Zenternal, try a new database? That usually works.

I mean, this DB was provided with the EMU and SWFS, but sure.

 

[0liver]

I mean, this DB was provided with the EMU and SWFS, but sure.

I understand that. But sometimes an error could occur while importing the database SQL. read off your error log, if you get any, once you're done, please?

 

[Zenternal]

I'm guessing the "error in query caught" message has something to do with it.

 
I checked the logs folder, and it has these:

Error in thread Server status update task: 
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
  at MySql.Data.MySqlClient.NativeDriver.Open()
  at MySql.Data.MySqlClient.Driver.Open()
  at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
  at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
  at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
  at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
  at MySql.Data.MySqlClient.MySqlPool.GetConnection()
  at MySql.Data.MySqlClient.MySqlConnection.Open()
  at Plus.Database.DatabaseConnection.Open() in c:\Users\Brad_2\Desktop\PLUs\Database\DatabaseConnection.cs:line 27
  at Plus.Database.DatabaseConnection.connect() in c:\Users\Brad_2\Desktop\PLUs\Database\DatabaseConnection.cs:line 51
  at Plus.Database.DatabaseManager.getQueryreactor() in c:\Users\Brad_2\Desktop\PLUs\Database\DatabaseManager.cs:line 22
  at Plus.HabboHotel.Misc.LowPriorityWorker.Process() in c:\Users\Brad_2\Desktop\PLUs\HabboHotel\Misc\LowPriorityWorker.cs:line 50

and

Error in packet [566] BODY: [0][0][0][0]: 
System.ArgumentNullException: Value cannot be null.
Parameter name: source
  at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
  at Plus.HabboHotel.Rooms.RoomManager.GetVotedRooms() in c:\Users\Brad_2\Desktop\PLUs\HabboHotel\Rooms\RoomManager.cs:line 67
  at Plus.HabboHotel.Navigators.Navigator.SerializeNavigator(GameClient session, Int32 mode) in c:\Users\Brad_2\Desktop\PLUs\HabboHotel\Navigators\Navigator.cs:line 365
  at Plus.Messages.GameClientMessageHandler.GetHighRatedRooms() in c:\Users\Brad_2\Desktop\PLUs\Messages\Requests\Navigator.cs:line 188
  at Plus.Messages.StaticMessageHandlers.SharedPacketLib.GetHighRatedRooms(GameClientMessageHandler handler) in c:\Users\Brad_2\Desktop\PLUs\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 251
  at Plus.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Brad_2\Desktop\PLUs\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 33
  at Plus.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Brad_2\Desktop\PLUs\Messages\GameClientMessageHander.cs:line 43
  at Plus.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Brad_2\Desktop\PLUs\HabboHotel\GameClients\GameClient.cs:line 81

 
UPDATE :

 

[JayC]

Value cannot be null.

RoomManager.cs

Check your rooms table, one of your fields are set to null / allow null and they should have a default.