Search results for query: *

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

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.*

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...

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...

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...

I'm testing this on our staging site. There are 300,000 users, 68M posts and 4M threads. This is the query: # Time: 210227 15:51:32 # User@Host: root[root] @ localhost [] # Thread_id: 167311 Schema: newlsa QC_hit: No # Query_time: 4411.449023 Lock_time: 0.000070 Rows_sent: 25...

I tried to post a ticket but kept getting an "invalid id" error message. I have a global branding free license for vbulletin. Will it transfer to Xenforo?

I currently have Dragonbyte Shop installed on a VB 4.25 forum. I have to turn it off during peak hours because of the load it places on the forum. During peak hours there are 2 - 3,000 members and 5 - 6,000 guests on the forum. Do you know if this mod has been installed/tested on large, active...

After upgrading VB Shop and adding reputation points as a new currency, all new posts on our forum were posted twice. I took the forum offline, disabled the plugins one by one until I found the conflict. It was VB Credits (version 2.1.1). After disabling VB Credits all of the duplicate posts...

Shop purchases take anywhere from 2 - 90 seconds. This is from the slow query log: # Query_time: 89.359487 Lock_time: 0.000049 Rows_sent: 355263 Rows_examined: 17523704 SET timestamp=1464027158; SELECT pointstable_4.reputation AS points_4...

This particular query started running really slow today: # User@Host: root[root] @ [10.0.0.3] # Thread_id: 443035 Schema: lipstick_forum QC_hit: No # Query_time: 979.511385 Lock_time: 781.017818 Rows_sent: 0 Rows_examined: 0 SET timestamp=1398816291; DELETE FROM dbtech_thanks_recententry...

I ran the Rebuild Button Click Cache. I have over 25Million entries, it got hung around 20M. What happens if I restart it? Will it empty the cache completely? None of the thanks that were given before the upgrade is showing in user profiles or on the threads. Thanks given since the upgrade...

After upgrading to the latest version the css style sheets are not being returned with the proper url. <!-- CSS Stylesheet --> <style type="text/css" id="vbulletin_css"> /** * vBulletin 3.8.8 Beta 2 CSS * Style: 'LSA 2014'; Style ID: 69 */ @import url("); </style> <link rel="stylesheet"...

I started getting this error during the Item Duration cron job after upgrading to the latest version of the shop. It causes such a huge load spike on the server I had to disable the shop. Any idea what caused it and how to fix it? Every item in the shop generates an Invalid shop ID error message.

How do I remove " Positive Rating: 0% [View]" from the shop list? I have feedback disabled but this text still appears.

After upgrading the following error message appears: Fatal error: Call to a member function get() on a non-object in /home/lipstick/public_html/dbtech/thanks/includes/class_cache.php on line 225

After upgrading to 2.53 the following error message appears: Fatal error: Class 'vB' not found in /home/lipstick/public_html/dbtech/vboptimise_pro/includes/class_vboptimise_dboverride.php on line 28

I switched my cache from memcache to xcache this morning and vboptomise stopped working. I uninstalled then reinstalled and it started working again. All the system checks passed. After about 10 minutes the load on the mysql server skyrocketed and when I checked I saw hundreds of the following...