query

The Query for the button counter is extremly slow in larger boards. File: hooks/showthread_query.php The current query on line 107 takes 6-12 seconds. 600.000+ Entries in the dbtech_thanks_entry-Table. Please change the query in further updates into the following code: $SQL[] = ' SELECT...

Hey all, We're releasing DragonByte Shout v7.0.0 Beta 9 for XenForo in order to improve performance. If you like the product you can show your support by reviewing it here: [DBTech] DragonByte Shout v7 [Lite] | xenForo Community or here: [DBTech] DragonByte Shout v7 [Pro] | xenForo Community...

I would like to switch the 'Disable Emails' to 'Enable Emails' so all new members don't have to make the change anymore. Is there a query I can run that will uncheck 'enable emails' after I switch it over? I don't want all the members who have checked "disable emails" to start getting emails...

Hi there, after the upgrade I'm not able to run queries and I have also found these errors in the ACP - Mainteinance - General Update Tools Warning: Declaration of vBForum_Item_SocialGroupMessage::getLoadQuery() should be compatible with that of vB_Model::getLoadQuery() in...

All looking good and working well. Thank you! I have a couple of things I'd like to do. I'm basically replacing the existing rep system with this, and would like to maintain existing scores. I've set 1 like = 1 rep in the settings, and prevented anybody from using rep. That should replace it...

I'm trying to figure out how to pass a custom query to vboptimize to cache it. I see that vb_optimise::cache is the function. Can pass it by literally saying vb_optimise::cache($queryvariable) ? What files would have to be included?

Hi all, When i show processlist MySQL, i see so many query from table tag, and my server alway overload SELECT tagtext AS id FROM tag WHERE tagtext REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\(đ|d)a-z]*;|[^a- What's this? Query of DBSEO?? Please help me solve this problem, thanks so much!

Invalid query: Duplicate entry I am getting this error again. I had it a while back but your fixed it and I have had no problems until now. I am going into hospital with my son tomorrow. So if you could email Rob and ringnews24@ringnews24.com and he will sort you out with any access that you...

I am considering using DragonByte Gallery on our site. My question is whether or not it is possible to create galleries from forum posts, blogs, etc. For example, we have several screenshot forums. It would be nice if I could run a query to create galleries for users from these images. Is...

Database error when going into someone profile after installing vbactivity&awards pro I Purchased the plugin, installed it, and when i go and click on my profile on the forums or any other member profile, i get a error. Im posting the image of the error and also the information on the error...

Hello Fillip, after update to 1.0.17 in some threads we get this error: Warnung: parse_url(http:///www.xxxxxxx.com) [function.parse-url]: Unable to parse URL in [path]/dbtech/dbseo/includes/class_core.php (Zeile 5850) or something like this: Warnung: parse_url(http://AF-S DX Zoom-Nikkor...

After installing this plugin, our site get slowed a lot. We're using plugin with default settings. We also have vbOptimise. Is there any possible solution or optimal settings to get rid of this slowness???

no posts in tapatalk will show and this is the error in error_log: wehn i disable vbAnswers, tapatalk work

When we tag we get an error at the top of the forum for a brief second and makes a double post. This is the error then double post happens. Any ideas? es). * * @param boolean Do the query? */ function post_delete($doquery = true) { // Decrement shout counters...

I'm trying to update to the latest version of the mod but receive the following error: Database error in vBulletin 4.2.2: Invalid SQL: ### INSERT QUERY GENERATED BY fetch_query_sql() ### INSERT IGNORE INTO dbtech_thanks_recententry (`entryid`, `varname`, `userid`, `contenttype`...

Hi there, easy to reproduce the bug : click on Thread Rating Management and type a Username to search for. Yo got this error : Database error in vBulletin 4.2.2: Invalid SQL: SELECT userid FROM vb_users WHERE username...

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 have chossen either /droot/sitemap and /droot/forum/sitemap, both set to the user this domain belongs to and both set to 777, but the script wont write my sitemap-files. Any idea what could be wrong?

I just noticed that Tapatalk 5.0.0 is supposed to support the thanks mod. So that's cool. :) But what I found when upgrading to Tapatalk 5.0.0, is that users are unable to view threads. They are getting this error: 'Call to a member function process _templates() on a non-object (showthread...

Hello, Just some quick questions regarding the vBdownloads (PRO) product: How to disable bbcode in downloads overview ? Is there a french transaltion ? How to get access to the moderation panel ? (vbdownload.php?do=modcp). I've got actually this error when i click on ModCP in the navbar: How...