Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Q&A
Phoenix 3.6.0 MySQL errors
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Heaplink" data-source="post: 61417" data-attributes="member: 8966"><p>I recently got back on my VPS after it restarted. I think Phoenix was running at the time - since the hosting provider I am using is restarting the servers 24/7 with their so called "updates".</p><p> </p><p>I started up the Emulator and got this error (attached file). After this, I went into the table <strong>server_status</strong> and couldn't see any issues with the row <strong>stamp</strong>. This is the exported version of <strong>server_status</strong> table:</p><p> </p><p>[CODE]--</p><p>-- Table structure for table `server_status`</p><p>--</p><p> </p><p>CREATE TABLE IF NOT EXISTS `server_status` (</p><p> `status` enum('0','1','2') NOT NULL DEFAULT '0',</p><p> `users_online` int(11) NOT NULL DEFAULT '0',</p><p> `rooms_loaded` int(11) NOT NULL DEFAULT '0',</p><p> `server_ver` text NOT NULL,</p><p> `stamp` double NOT NULL,</p><p> `userpeak` int(11) NOT NULL DEFAULT '0'</p><p>) ENGINE=MyISAM DEFAULT CHARSET=latin1;</p><p> </p><p>--</p><p>-- Dumping data for table `server_status`</p><p>--</p><p> </p><p>INSERT INTO `server_status` (`status`, `users_online`, `rooms_loaded`, `server_ver`, `stamp`, `userpeak`) VALUES</p><p>('1', 0, 0, 'Phoenix v3.6.4 (Build 13477)', 1324412153, 0);[/CODE]</p><p> </p><p>I even tried to use the same one as in phoenix 3.6.0.sql but with no luck.</p><p> </p><p>Then suddenly I tried again, and the emulator started. I thought it was over, until I saw errors again. I tried to enter my room and this error appeared in <strong>threaderror.err</strong>:</p><p> </p><p>[CODE]Error in thread Room [ID: 24] cycle task -- Process Users Updates:</p><p>System.NullReferenceException: Object reference not set to an instance of an object.</p><p> at Phoenix.HabboHotel.Rooms.xefa913121c70e125.x3cb8659ea4fc7306()[/CODE]</p><p> </p><p>Of what I can see there, there's an issue in the <strong>rooms</strong> table. I do also get an exception at same point:</p><p> </p><p>[CODE]User DC: MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'entry_timestamp' at row 1</p><p> at MySql.Data.MySqlClient.MySqlStream.ReadPacket()</p><p> at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)</p><p> at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)</p><p> at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)</p><p> at MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()</p><p> at Phoenix.Storage.xc133500a5775b79b.xa266202b32508032(String xe6ac21f3fcfe8372)</p><p> at Phoenix.HabboHotel.Rooms.xefa913121c70e125.x7fc5b234d779d58c(xca0375af76c32b7d xf16d877ad29a8cf1, Boolean x586fb91c9f89ea2a)</p><p> at Phoenix.Messages.x02dcbe990499f50c.xde5f9db4c3498373()</p><p> at Phoenix.Messages.x02dcbe990499f50c.xe4364a03608599c7(x49fa09cbda40e784 x6b03218578435fe3)</p><p> at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.xf896e51a95fce6ae(Byte[]& x4a3f0a05c02f235f)[/CODE]</p><p> </p><p>even AFTER truncating the <strong>user_roomvisits</strong> table.</p><p> </p><p>If you have any clue of why this thing is happening to me, and how I can fix it <strong>(without cleaning the database from scratch)</strong> I would appreciate it.</p><p> </p><p>Thanks in advance <img src="/styles/default/xenforo/smilies/emojione/thumbsup.png" class="smilie" loading="lazy" alt=":up:" title="Thumbs Up :up:" data-shortname=":up:" /></p><p> </p><p><strong>EDIT:</strong></p><p>I might see the problem. Phoenix really stuck things up at the rows with type of <strong>double</strong>. But why, I don't know.</p><p> </p><p><strong>EDIT - FIX!!!</strong></p><p>After hours of jacking around, I found the solution the my problem above. What I did was going to the MySQL configuration file (my.ini) and changed the SQL mode and removed STRICT_MODE, which MySQL does have by default. This can be done by changing:</p><p> </p><p>[CODE]"STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"[/CODE]</p><p> </p><p>to</p><p> </p><p>[CODE]"NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"[/CODE]</p><p> </p><p>If anyone else had this issue, try to do like above and remember to restart your MySQL server.</p></blockquote><p></p>
[QUOTE="Heaplink, post: 61417, member: 8966"] I recently got back on my VPS after it restarted. I think Phoenix was running at the time - since the hosting provider I am using is restarting the servers 24/7 with their so called "updates". I started up the Emulator and got this error (attached file). After this, I went into the table [B]server_status[/B] and couldn't see any issues with the row [B]stamp[/B]. This is the exported version of [B]server_status[/B] table: [CODE]-- -- Table structure for table `server_status` -- CREATE TABLE IF NOT EXISTS `server_status` ( `status` enum('0','1','2') NOT NULL DEFAULT '0', `users_online` int(11) NOT NULL DEFAULT '0', `rooms_loaded` int(11) NOT NULL DEFAULT '0', `server_ver` text NOT NULL, `stamp` double NOT NULL, `userpeak` int(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `server_status` -- INSERT INTO `server_status` (`status`, `users_online`, `rooms_loaded`, `server_ver`, `stamp`, `userpeak`) VALUES ('1', 0, 0, 'Phoenix v3.6.4 (Build 13477)', 1324412153, 0);[/CODE] I even tried to use the same one as in phoenix 3.6.0.sql but with no luck. Then suddenly I tried again, and the emulator started. I thought it was over, until I saw errors again. I tried to enter my room and this error appeared in [B]threaderror.err[/B]: [CODE]Error in thread Room [ID: 24] cycle task -- Process Users Updates: System.NullReferenceException: Object reference not set to an instance of an object. at Phoenix.HabboHotel.Rooms.xefa913121c70e125.x3cb8659ea4fc7306()[/CODE] Of what I can see there, there's an issue in the [B]rooms[/B] table. I do also get an exception at same point: [CODE]User DC: MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'entry_timestamp' at row 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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.ExecuteScalar() at Phoenix.Storage.xc133500a5775b79b.xa266202b32508032(String xe6ac21f3fcfe8372) at Phoenix.HabboHotel.Rooms.xefa913121c70e125.x7fc5b234d779d58c(xca0375af76c32b7d xf16d877ad29a8cf1, Boolean x586fb91c9f89ea2a) at Phoenix.Messages.x02dcbe990499f50c.xde5f9db4c3498373() at Phoenix.Messages.x02dcbe990499f50c.xe4364a03608599c7(x49fa09cbda40e784 x6b03218578435fe3) at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.xf896e51a95fce6ae(Byte[]& x4a3f0a05c02f235f)[/CODE] even AFTER truncating the [B]user_roomvisits[/B] table. If you have any clue of why this thing is happening to me, and how I can fix it [B](without cleaning the database from scratch)[/B] I would appreciate it. Thanks in advance :up: [B]EDIT:[/B] I might see the problem. Phoenix really stuck things up at the rows with type of [B]double[/B]. But why, I don't know. [B]EDIT - FIX!!![/B] After hours of jacking around, I found the solution the my problem above. What I did was going to the MySQL configuration file (my.ini) and changed the SQL mode and removed STRICT_MODE, which MySQL does have by default. This can be done by changing: [CODE]"STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"[/CODE] to [CODE]"NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"[/CODE] If anyone else had this issue, try to do like above and remember to restart your MySQL server. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
Phoenix 3.6.0 MySQL errors
Top