Inventory Stack Problem - Plus EMU

[Pippinboi]

Hey,
My Plus EMU doesn't allow inventory stack, for example,
when I buy a item, and then buy another, it replaces the first. And I can't buy more than one.

Whenever I try to buy anything, I also get a "Query caught" error on Emu, this is what the logs say.

Error in packet [1983] BODY: [0][0][0]?????[0][0][0][0][0]
:
System.NullReferenceException: Object reference not set to an instance of an object.
at Silverwave.HabboHotel.Catalogs.Catalog.HandlePurchase(GameClient Session, Int32 PageId, Int32 ItemId, String ExtraData, Int32 priceAmount, Boolean IsGift, String GiftUser, String GiftMessage, Int32 GiftSpriteId, Int32 GiftLazo, Int32 GiftColor, Boolean undef, UInt32 Group) in c:\Users\FelipeK?ster\Desktop\Silverwave\Silverwave\Silverwave Emulator\HabboHotel\Catalogs\Catalog.cs:line 252
at Silverwave.Communication.Packets.Incoming.Catalog.PurchaseFromCatalogEvent.Parse(GameClient Session, ClientMessage Packet) in c:\Users\FelipeK?ster\Desktop\Silverwave\Silverwave\Silverwave Emulator\Collections\Communication\Packets\Incoming\Catalog\PurchaseFromCatalogEvent.cs:line 22
at Silverwave.Communication.Packets.PacketManager.TryExecutePacket(GameClient Session, ClientMessage Packet) in c:\Users\FelipeK?ster\Desktop\Silverwave\Silverwave\Silverwave Emulator\Collections\Communication\Packets\PacketManager.cs:line 105
at Silverwave.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\FelipeK?ster\Desktop\Silverwave\Silverwave\Silverwave Emulator\Messages\GameClientMessageHander.cs:line 40
at Silverwave.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\FelipeK?ster\Desktop\Silverwave\Silverwave\Silverwave Emulator\HabboHotel\GameClients\GameClient.cs:line 82

Thanks,

[MentaL]

[farooq]

Ok so there are two ways to do this, the way i fixed it was.

1. Locate mysql.ini or my.ini its a configuration file for MYSQL. You can find this in programfiles (x86) or just programfiles
2. Once opened search (ctrl + h) Set the SQL mode to strict
3. Replace that whole paragraph with the following:
# Set the SQL mode to strictsql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

4. Restart IIS or xampp and the emulator.

Goodluck :)

[Pippinboi]

Ok so there are two ways to do this, the way i fixed it was.

1. Locate mysql.ini or my.ini its a configuration file for MYSQL. You can find this in programfiles (x86) or just programfiles
2. Once opened search (ctrl + h) Set the SQL mode to strict
3. Replace that whole paragraph with the following:
# Set the SQL mode to strictsql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

4. Restart IIS or xampp and the emulator.

Goodluck :)

Thanks for replying, but that was a bit confusing.

I went to C: > ProgramFiles > MySQL > MySQL Server 5.6 > my-default.ini (That was the closest I found to mysql.ini / my.ini)

It looks like this now, w/ the edit you said above.

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/...-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

# Set the SQL mode to strictsql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

But it didn't work, I get same error.

[moere]

Thanks for replying, but that was a bit confusing.

I went to C: > ProgramFiles > MySQL > MySQL Server 5.6 > my-default.ini (That was the closest I found to mysql.ini / my.ini)

It looks like this now, w/ the edit you said above.



But it didn't work, I get same error.

No not:

# Set the SQL mode to strictsql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

It has to be:

sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

[Pippinboi]

No not:

# Set the SQL mode to strictsql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

It has to be:

sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Ah, I tried doing that the first time. I also did it again right now, and no luck, same thing.
Do you happen to know any other methods? Thanks again for replying :P

[moere]

Well I solved this problem by using the db in the SQL folder with the name AKIIX's silverwave.sql.

But when you use this one then you have to fix some tables to use it with the revision 2. If you want to give it a try create a backup of the current db you have and try the other one.

[Pippinboi]

Well I solved this problem by using the db in the SQL folder with the name AKIIX's silverwave.sql.

But when you use this one then you have to fix some tables to use it with the revision 2. If you want to give it a try create a backup of the current db you have and try the other one.

Do you know what tables I have to fix to get the current DB to work?

[moere]

Do you know what tables I have to fix to get the current DB to work?

Well I would have to try. The errors are telling you everything you need. send me your TV Id and pass on pm and I take a look.

[PhazeHotel]

Sorry was this solved? And if so can you give me the solution?