Emulator stuck

[Yannickzz]

Hi all,

I'm using the latest rev of SwiftEMU, but suddenly the emu won't boot up completely and it gets stuck at '>> Help tool --> READY!', after that it doesn't load anymore.



Help would be appreciated!

[MentaL]

[FatalLulz]

Have you tried debugging the emu? And applied the GenericBot.cs fix. Other wise it should work as mine works perfectly fine.

[Yannickzz]

Added the fix, debugged it, didn't work :(

Older rev's also don't work anymore.

It has to do something with my catalog_items_copy, because when I delete them it works... Droplr • catalog_items_copy.sql

SELECT * FROM catalog_items_copy
MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: An established connection was aborted by the software in your host machine. ---> System.Net.Sockets.SocketException: An established connection was aborted by the software in your host machine
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read)
   at MySql.Data.MySqlClient.NativeDriver.SetDatabase(String dbName)
   at MySql.Data.MySqlClient.Driver.SetDatabase(String dbName)
   at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase(String databaseName)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Database_Manager.Database.Session_Details.QueryAdapter.getTable()

[FatalLulz]

Hmm. Are you using the catalog_items_copy from I think it was the Rev 4 DB? I had problems with that one but fixed them

[Yannickzz]

Hmm. Are you using the catalog_items_copy from I think it was the Rev 4 DB? I had problems with that one but fixed them

Been using my catalog_items for over 2 years, had no problems in rev 4 but suddenly it stopped working. Narrowed down the problem: added every catalog item from 1 to 4051, but after that the catalog breaks.

[Gaby]

Can you press enter when the emulator boots and stops and tell us what it says?

[Yannickzz]

Can you press enter when the emulator boots and stops and tell us what it says?

I've deleted all of my catalog_items, and re-added most of them. The problems begin when adding furniture from id 4298 all the way to the end. I think that one of the 6000 furni is missing in my items_base, any way to check if all the item_ids from the catalog exist?

So, narrowed it down again to 700 furni now, one of them doesn't exist (or more). I think it's a simple code to check what furniture doesn't exists, but it would be realy helpfull! Droplr • missex-2.txt

[Gaby]

I've deleted all of my catalog_items, and re-added most of them. The problems begin when adding furniture from id 4298 all the way to the end. I think that one of the 6000 furni is missing in my items_base, any way to check if all the item_ids from the catalog exist?

So, narrowed it down again to 700 furni now, one of them doesn't exist (or more). I think it's a simple code to check what furniture doesn't exists, but it would be realy helpfull! Droplr • missex-2.txt

The only way is to boot your emulator and press enter, it will say what's wrong. ;p

[Yannickzz]

The only way is to boot your emulator and press enter, it will say what's wrong. ;p

I'll do that, thanks!

[Yannickzz]

The only way is to boot your emulator and press enter, it will say what's wrong. ;p

Pressing enter shows me nothing, it even doesn't do anything at all.

[AKllX]

You can try to comment out that line from Catalog.cs

dbClient.runFastQuery("UPDATE catalog_items_copy,items_base SET catalog_items_copy.amount = 1 WHERE items_base.allow_gift = 1 AND catalog_items_copy.amount > 1");

[Yannickzz]

You can try to comment out that line from Catalog.cs

dbClient.runFastQuery("UPDATE catalog_items_copy,items_base SET catalog_items_copy.amount = 1 WHERE items_base.allow_gift = 1 AND catalog_items_copy.amount > 1");

Doesn't change anything at all. '0 rows affected'

[Stefan Jennings]

Hubbo, just wait on the thing. Give it 2 minutes it will eventually come. I thought it froze for me too but it started loading down after a while.

[Yannickzz]

Hubbo, just wait on the thing. Give it 2 minutes it will eventually come. I thought it froze for me too but it started loading down after a while.

It's pretty annoying to be honest, I need to wait 3 minutes until everything boots up, and after that reloading the catalog takes 3 minutes also..