Client stuck at 76%

[Habways]

Hey all, I am doing a retro, double checked all the files, set port forward to: 3306,30000,30001 - inbound and outbound. Checked my variable files but it keeps crashing at 76%

 

[Maatt]

you need to check that you are using the correct ports as defined in your emulator's configuration.

Is this being made on a localhost set up (on your computer) or on a VPS?

 

[Habways]

VPS, I did the correct inbound/outbound ports of 3306,30000,30001

 

[Hypothesis]

If it's crashing at 76% it means that your emulator is making a connection but your SWFs are not linked properly. So allowing ports wouldn't solve your issue.

 

[Habways]

What would you suggest I do?
The Production is the same as my external variables etc.

 

[Hypothesis]

What would you suggest I do?
The Production is the same as my external variables etc.

Likely there are missing variables that cause the crash. Either this or your emulator is experiencing an error. Check your error logs.

 

[Habways]

Added

Post automatically merged: Jul 20, 2020

Error log

Error in query:
UPDATE `server_status` SET `users_online` = @Users, `loaded_rooms` = @loadedRooms LIMIT 1;
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'oliver.server_status' 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\Sledmore\Desktop\PlusEMU\Database\Adapter\QueryAdapter.cs:line 167

 

[Hypothesis]

Added

Post automatically merged: Jul 20, 2020

Error log

Error in query:
UPDATE `server_status` SET `users_online` = @Users, `loaded_rooms` = @loadedRooms LIMIT 1;
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'oliver.server_status' 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\Sledmore\Desktop\PlusEMU\Database\Adapter\QueryAdapter.cs:line 167

The error is right there. Your databse does not contain the table server_status.
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'oliver.server_status' doesn't exist

This is likely what is causing the disconnecting because your emulator is trying to update the user count there but it can't find the table to do such. If you're missing this table, I assume you might be missing other tables as well, which could contribute to the issue.

 

[Maatt]

In the first instance, I would suggest that you find a clean SQL and reset/reimport your MySQL database.

If you are using an existing MySQL database, you might try running the following SQLs but this is no silver bullet; it looks as if you could be missing other things too...

-- ----------------------------
-- Table structure for server_status
-- ----------------------------
DROP TABLE IF EXISTS `server_status`;
CREATE TABLE `server_status` (
  `users_online` int(11) NOT NULL DEFAULT 0,
  `loaded_rooms` int(11) NOT NULL DEFAULT 0,
  UNIQUE KEY `users_online` (`users_online`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of server_status
-- ----------------------------
INSERT INTO `
` VALUES ('0', '0');

 

[Hypothesis]

In the first instance, I would suggest that you find a clean SQL and reset/reimport your MySQL database.

If you are using an existing MySQL database, you might try running the following SQLs but this is no silver bullet; it looks as if you could be missing other things too...

-- ----------------------------
-- Table structure for server_status
-- ----------------------------
DROP TABLE IF EXISTS `server_status`;
CREATE TABLE `server_status` (
  `users_online` int(11) NOT NULL DEFAULT 0,
  `loaded_rooms` int(11) NOT NULL DEFAULT 0,
  UNIQUE KEY `users_online` (`users_online`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of server_status
-- ----------------------------
INSERT INTO `
` VALUES ('0', '0');

This was already fixed and his issue wasn't this, because his database already had this table.