Bfly inventory not working?

AnalGoat11 · Dec 23, 2015

I'm using Butterfly EMU for r63, everything works but when I purchase furniture in the catalog it isnt going into my inventory...why?

JayC · Dec 23, 2015

In your emulator check what your table is called for items, see where it puts them and check if when you buy something it goes into the correct table.

AnalGoat11 · Dec 23, 2015

JayCustom said:
In your emulator check what your table is called for items, see where it puts them and check if when you buy something it goes into the correct table.

Im having some trouble doing that, I have Visual Studio I just don't know what file it is to look in? What file is it sorry

JayC · Dec 23, 2015

Search for "INSERT into `items`" if nothing is found search for "INSERT into items"

AnalGoat11 · Dec 23, 2015

JayCustom said:
Search for "INSERT into `items`" if nothing is found search for "INSERT into items"

Heres my results
Find all "INSERT into `items`", Subfolders, Find Results 1, Entire Solution, ""
Matching lines: 0 Matching files: 0 Total files searched: 352
---------------------------
Find all "INSERT into items", Subfolders, Find Results 1, Entire Solution, ""
C:\Users\Administrator\Desktop\FreshEmu\FreshEmu\Butterfly Emulator\HabboHotel\Catalogs\Catalog.cs(455): dbClient.setQuery("INSERT INTO items (user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos) VALUES (@userid, @roomid, @baseitem, @extradata, 0, 0, 0.0, 0, ' ')");
C:\Users\Administrator\Desktop\FreshEmu\FreshEmu\Butterfly Emulator\HabboHotel\SoundMachine\SongItem.cs(38): dbClient.runFastQuery("INSERT INTO items_rooms_songs VALUES (" + itemID + "," + roomID + "," + songID + ")");
C:\Users\Administrator\Desktop\FreshEmu\FreshEmu\Butterfly Emulator\HabboHotel\Users\Inventory\InventoryComponent.cs(286): dbClient.setQuery("INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)");
Matching lines: 3 Matching files: 3 Total files searched: 352

For some reason the database didn't come with a items table :s

Brad · Dec 23, 2015

Jaylen said:
I'm using Butterfly EMU for r63, everything works but when I purchase furniture in the catalog it isnt going into my inventory...why?

is there any error logs when this happens?

AnalGoat11 · Dec 23, 2015

Westyy said:
is there any error logs when this happens?

Nope...
UPDATE: Yes lol

Error in query:
INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' doesn't have a default value
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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery() in c:\Users\Jonty\Desktop\Emulators\FreshEmu\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 175

Error in query:
INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' doesn't have a default value
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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery() in c:\Users\Jonty\Desktop\Emulators\FreshEmu\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 175

Error in query:
INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' doesn't have a default value
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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery() in c:\Users\Jonty\Desktop\Emulators\FreshEmu\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 175

Error in query:
INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' doesn't have a default value
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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery() in c:\Users\Jonty\Desktop\Emulators\FreshEmu\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 175

Error in query:
INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' doesn't have a default value
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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery() in c:\Users\Jonty\Desktop\Emulators\FreshEmu\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 175

Brad · Dec 23, 2015

Jaylen said:
Nope...
UPDATE: Yes lol

Error in query:
INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' doesn't have a default value
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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery() in c:\Users\Jonty\Desktop\Emulators\FreshEmu\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 175

Error in query:
INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' doesn't have a default value
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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery() in c:\Users\Jonty\Desktop\Emulators\FreshEmu\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 175

Error in query:
INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' doesn't have a default value
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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery() in c:\Users\Jonty\Desktop\Emulators\FreshEmu\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 175

Error in query:
INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' doesn't have a default value
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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery() in c:\Users\Jonty\Desktop\Emulators\FreshEmu\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 175

Error in query:
INSERT INTO items (base_item, user_id, extra_data) VALUES (@baseitem, @userid, @extradata)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' doesn't have a default value
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 Database_Manager.Database.Session_Details.QueryAdapter.insertQuery() in c:\Users\Jonty\Desktop\Emulators\FreshEmu\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 175

in your `items` table is there a column called 'extradata'?

AnalGoat11 · Dec 23, 2015

Thanks @Westyy for telling me to check the logs its all been fixed now I have changed all fields to allow nul

Brad · Dec 23, 2015

Thread closed, due to being fixed.

Bfly inventory not working?

AnalGoat11

Queen

JayC

Well-Known Member

AnalGoat11

Queen

JayC

Well-Known Member

AnalGoat11

Queen

Brad

Well-Known Member

AnalGoat11

Queen

Brad

Well-Known Member

AnalGoat11

Queen

Brad

Well-Known Member

Users who are viewing this thread

Latest posts

Connect with us

Newest members