Search results for query: *

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:

When users add an item to the shop they get a message that says their item is waiting for approval. But there are no items in the moderator queue. I don't see any setting that requires approval for items. I have to rebuild permissions for the item to become visible. How is this supposed to work?

Transactions disappear from the transaction log and purchase log, then the item disappears from the purchasers inventory. This user purchased an item from the shop. Here is her transaction for the purchase made last night: It doesn't show up in her transaction log: The item briefly...

So the rich list updates every time someone steals? They were using clickbots.

In Xenforo permissions registered users are not allowed to edit their user titles. But when a registered user purchases or gifts a user title change there is no effect on the user title. What permissions need to be set in order for purchased user title changes to take effect?

I went live with the shop addon and enabled the steal function. Some users created a bot that when it found someone with a high amount of credits it kept stealing from them in rapid fashion until all of their credits were gone. The result of this was a DOS like attack on the server that kept...