Bfly inventory not working?

Status
Not open for further replies.
AnalGoat11

AnalGoat11

Queen
Nov 25, 2015
71
12
I'm using Butterfly EMU for r63, everything works but when I purchase furniture in the catalog it isnt going into my inventory...why?
 
Sort by date Sort by votes
JayC

JayC

Always Learning
Aug 8, 2013
5,493
1,398
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.
 
Upvote 0 Downvote
AnalGoat11

AnalGoat11

Queen
Nov 25, 2015
71
12
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.
Click to expand...
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
 
Upvote 0 Downvote
AnalGoat11

AnalGoat11

Queen
Nov 25, 2015
71
12
JayCustom said:
Search for "INSERT into `items`" if nothing is found search for "INSERT into items"
Click to expand...
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
 
Upvote 0 Downvote
AnalGoat11

AnalGoat11

Queen
Nov 25, 2015
71
12
Westyy said:
is there any error logs when this happens?
Click to expand...
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
 
Upvote 0 Downvote
Brad

Brad

Well-Known Member
Jun 5, 2012
2,319
992
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
Click to expand...
in your `items` table is there a column called 'extradata'?
 
Upvote 0 Downvote
Status
Not open for further replies.

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top