Buying a larger avatar size in bytes

Status
Not open for further replies.

Freekoid

Customer
Ok so a double question.

I added an item to the shop so a user could upload an avatar at 2.6MB, I made the item available and changed the value to 5000000bytes or 5MB, the user then got a mysql error about packet size, I checked and my packet size is 1MB but my upload size is 8MB

I have since removed the item from the shop, what happens to the user who originally bought this item? (as in does the 5Meg tag still run with this user?)
 
Last edited:
If you deleted the item, then it is also gone from the user's inventory and they will be using the old avatar size restrictions.

Btw, you can probably fix the root cause if you move User Pictures to be stored in the File System :)
Do the same for Attachments too, just for good measure. You'll see your database size drop dramatically, and a database crash will no longer irrepairably corrupt your attachments / pictures :)
 
Thanks I'll look into that, I currently have a 200GB hard drive for space and only utilize 1GB of it but if it speeds up my database calls, as it should only load the image once and then store as caché in the user's computer then it's worth it.
 
Status
Not open for further replies.

Legacy vBShop

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
1,261
Customer rating
0.00 star(s) 0 ratings
Back
Top