blob data size?

[Xildjian]

I setup a persistent vault with nwnx4 v1.09.

And it seems that there is a size limit storing an object as a blob in the database. Is this correct? What is the size limit?

The issue I'm seeing is storing bags of holding with items (greater than 50) don't seem to make it into the database, and I'm not seeing any MySQL errors.

Thanks!
_________________
Member Shadow of Iniquity development team

[virusman]

Maximum BLOB size is 65 536 bytes.
You can use MEDIUMBLOB (up to 16 777 216 bytes) or LONGBLOB (up to 4 GB).

[Xildjian]

oh thanks.
I didn't know those where options
_________________
Member Shadow of Iniquity development team

[Xildjian]

So I updated my table blob column as a LONGBLOB with the Query Browser tool, but I still seem to be having people loose bags placed into the vault. They have said the bags had over 100 items.

Is it possible that there is another size limitation somewhere besides the database?
Is it possible the database table wasn't really updated as a LONGBLOB even tho editing the table with the Query browser says it's now a LONGBLOB field?

Is there a setting in the mysql plugin for nwnx4 that should be set to tell it to save data as a longblob instead of a blob?

It seems unlikely that a bag of holding with 100+ items is exceeding the 4gig size limit.

Thanks!
_________________
Member Shadow of Iniquity development team

[Gryphyn]

[Kres]

This also falls within the container stack within a stack which is like arrow stacks for example... cap is 98 in this method leaving one slot for a overflow check. I am working on an infinate solution and have it tested out to 122 items than it fails not due to size but due to time out errors within the plugin.