Can't enter rooms help :(

[dalle]

I can't enter eny rooms on my hotel can someone help me :/ ps using RevCMS 1.9.9
Pics:

You must be registered for see links

You must be registered for see links

 

[Brennen]

Try creating a room then entering that, rather then entering the pre-made rooms.

 

[dalle]

Then this comes -.-

You must be registered for see links

 

[Brennen]

Check your DB.

 

[dalle]

Wich one can i find the "enter rooms" errors in ?

 

[dalle]

You must be registered for see links

 

[brsy]

FFS, read the exception in your EMU folder..

 

[dalle]

FFS, read the exception in your EMU folder..

What do I need to do with the exception there?

 

[enet]

drop your whole db and start fresh derp also use proper swfs

 

[dalle]

drop your whole db and start fresh derp also use proper swfs

I dropped my database already & made a new, it did not help. And I got the SWF pack from a tutorial on Otaku.

 

[enet]

DROP TABLE IF EXISTS `user_roomvisits`;
CREATE TABLE `user_roomvisits` (
  `user_id` int(10) unsigned NOT NULL,
  `room_id` int(10) unsigned NOT NULL,
  `entry_timestamp` double NOT NULL,
  `exit_timestamp` double NOT NULL,
  `hour` int(11) NOT NULL,
  `minute` int(11) NOT NULL,
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

have you tried running that?

 

[dalle]

Yea and i have repaird it but dosent work ;/

 

[brsy]

Okay. Here's what you do. Open your EMU folder, and open the exceptions.err
Once that is done, copy & paste Everything that it says onto here. From there I can help you fix your issue.

 

[dalle]

User DC: MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'entry_timestamp' at row 1
ved MySql.Data.MySqlClient.MySqlStream.ReadPacket()
ved MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
ved MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
ved MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
ved MySql.Data.MySqlClient.MySqlDataReader.NextResult()
ved MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
ved MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
ved Phoenix.Storage.xc133500a5775b79b.xa266202b32508032(String xe6ac21f3fcfe8372)
ved Phoenix.HabboHotel.Rooms.xefa913121c70e125.x7fc5b234d779d58c(xca0375af76c32b7d xf16d877ad29a8cf1, Boolean x586fb91c9f89ea2a)
ved Phoenix.Messages.x02dcbe990499f50c.xde5f9db4c3498373()
ved Phoenix.Messages.x02dcbe990499f50c.xe4364a03608599c7(x49fa09cbda40e784 x6b03218578435fe3)
ved Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.xf896e51a95fce6ae(Byte[]& x4a3f0a05c02f235f)