Recent content by Home Alone

I figured this out, you can close this ticket.

How do I empty the bank for all users? I want to reset and start from 0 for everyone. What table do I truncate?

We reduced the number of items in the shop from 1200 to 200 and the problems went away. The more items we added to the shop the slower the site became. Having this query run continously for every item in the shop and for every member viewing the shop caused the DB server to run out of available...

The site is hosted on a cluster managed by Giganet. They looked at the db server and it is optimized. SSD Drives in a RAID 10 configuration with 512GB of RAM. They looked at the my.cnf and it was optimized. The slow query log shows that the query I posted runs anywhere from 1 to 6 seconds. It...

I blocked access to the shop and this query is still running. Are you sure all it does is list the items in the shop?

If i disable the ability to react to items would that part of the query go away?

I disabled the shop on Sunday and the server ran very fast and without any issues. We had nearly 8000 people on the site without any issues at all. It's only when the shop is enabled that the site slows down.

And this is 1,000 to 2,000 people at once looking at the shop. When there aren't a lot of people on the site there are no issues. During peak hours it becomes a problem.

To be clear, this is just a query that returns the list of items in the shop? Why is it looking at reaction content?

SELECT `xf_dbtech_shop_item`.*, `xf_user_User_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_dbtech_shop_item_watch_Watch_3`.*, `xf_reaction_content_Reactions_4`.*, `xf_dbtech_shop_category_Category_5`.*, `xf_permission_cache_content_Permissions_6`.*...

Here's more information regarding this query from our slow query log: # User@Host: newlsa[newlsa] @ [192.168.0.73] # Thread_id: 159278854 Schema: newlsa QC_hit: No # Query_time: 5.635619 Lock_time: 0.000034 Rows_sent: 1185 Rows_examined: 5923 # Rows_affected: 0 Bytes_sent: 14608779 SET...

Can you tell me what this query is doing? All of a sudden it's running non-stop and causing the forum to slow down. SELECT xf_dbtech_shop_item., xf_user_User_1., xf_permission_cache_content_Permissions_2.*

I rebuilt the Credits addon and the error went away.

This error started appearing in Xenforo's error log this evening. No changes were made to the server's configuration. ErrorException: [E_NOTICE] Trying to get property 'message' of non-object src/addons/DBTech/Credits/XF/Entity/Thread.php:222 Generated by: Unknown account Apr 9...

Here are the registered members permissions: I created a shop item that allows members to purchase the option to create items. Here are the permissions for that item: