Furni disappear

Hey RZ,

I have this problem in my retro hotel.
When you build a room, and you reload. Than the room is empty again.

Does anyone know where/what the fault is en how i can fix it?!

Do you recieve any exceptions, what emulator are you using R63, R63B or what? (And what is the name of the Emulator).

Send a picture of your room table too in your mysql database.

If you use R63 do you have a table called "room_items"

If you use R63B do you have a table called "itembase_items"

Or something like that? ;) Do you have the table that connects the bought items to the rooms?

Quote:

---

Originally Posted by Carlmagi

Do you recieve any exceptions, what emulator are you using R63, R63B or what? (And what is the name of the Emulator).

Send a picture of your room table too in your mysql database.

If you use R63 do you have a table called "room_items"

If you use R63B do you have a table called "itembase_items"

Or something like that? ;) Do you have the table that connects the bought items to the rooms?

---

Hey,

I'm using a R63A Butterfly Emulator.
http://i.imgur.com/2OMwW7k.png

This are all the room tables.

In the room_item is nothing.
http://i.imgur.com/iVSYTc2.png

If i look in the MySQLerrors file in the emu i see this.

Error in query:
CALL getroomitems(@roomid)
MySql.Data.MySqlClient.MySqlException (0x80004005): PROCEDURE maze.getroomitems does not exist
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.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
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() in C:\Users\Tumanda\Desktop\ZAP SOURCE\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 154

I would believe the emulator has some problems within INSERT INTO room_items, If you'll send me the emulator I can try to, but I can't tell you it'll work.