query

  1. Zambfd

    Question Showthread Button Count really slow 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...
  2. Fillip H.

    [XenForo] DragonByte Shout v7.0.0 Beta 9 Released

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

    Question Query to uncheck "Enable Emails"

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

    Question Errors when I try to run queries

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

    Legacy Rep Conversion

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

    Question Caching a custom query using vboptimise?

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

    Question Problem with mysql

    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!
  8. ringnews24

    Bug Invalid query: Duplicate entry '127798' for key 'PRIMARY'57

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

    DragonByte Gallery Import from forums

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

    Bug Database error when going into someone profile after installing vbactivity&awards pro

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

    Bug Unable to parse URL

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

    Question Forum gets slowed with this plugin

    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???
  13. K

    Bug problem with Tapatalk

    no posts in tapatalk will show and this is the error in error_log: wehn i disable vbAnswers, tapatalk work
  14. Jj Michael Smith

    Bug Double posting when tagging

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

    Bug Database error on upgrade

    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`...
  16. chatty

    Bug Database Error in Admincp on Searching Treadrating Members

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

    Question Slow Queries

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

    Question Sitemap not build with 777

    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?
  19. C

    Question Tapatalk and Thanks Mod

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

    Question Some questions

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