query

  1. T

    Question New Advanced Post SQL commands.

    Hello. We would like to obtain the "new" SQL commands required to activate/install the mod on a installation on VB5. I have seen the thread http://www.dragonbyte-tech.com/f52/%5Bbig-boards%5D-installation-issues-manual-queries-10144/ and this could work on VB4 or VB3. But on VB5 all tables...
  2. B

    Question Need some help - .htaccess

    Hello Need some help - unistalled ibroarcade and installed Dbtech vbarcade - had some problems with scores - maybe need adjust my .htaccess file # Retrieve gamedata requests and send to new dbtech locations # RewriteRule ^arcade/gamedata/(.*) dbtech/vbarcade/media/$1 [L] # Retrieve...
  3. W

    Question issue installing vbshout in vb5 5.0.2

    Hello i have tried to install vbshout in vbulletin 5.0.2, i upload all files into core directory, go to manage product and when i try to upload the xml file, appear the next error: Fatal error: Call to a member function query() on a non-object in...
  4. CharlieDelta

    Bug Database Error

    Getting the following database error when trying to show log entries. Warning: mysqli_query() [function.mysqli-query]: (42S22/1054): Unknown column 'id' in 'order clause' in [path]/includes/class_core.php on line 1391 Database error in vBulletin 4.2.0: Invalid SQL: SELECT...
  5. J

    Question Disable Hottest Thread or optimize query

    We've got a pretty large forum. After about 4 months of having the thanks hack installed (and trimmed down so it's basically a "like" button for posts), we have about 1.45 million rows in our dbtech_thanks_entry table. I've had to add quite a few indexes to keep things speedy, but I have one...
  6. catfish_pete

    Bug Fatal error

    Hello - Getting this error on install - any help, please? Fatal error: Call to a member function query() on a non-object in /home/litopi/public_html/colony/core/dbtech/registration/includes/class_install.php on line 247
  7. Taurus

    Question Id field missing.

    Just over a month ago my forum was severely hacked. Now after a month it is still a mess. My hosting company has tried to get it back, and the only way we got it half working is with a database of more than a year ago. However I can still not login to my ACP. I don't know if anyone here can help...
  8. G

    Bug Bug found

    Hi. Go to the adminCP, vbSecurity, Login Strikes Viewer and then list all users with login strikes. If you click on any of the users listed, you will get an error such as: Database error in vBulletin 3.8.7: Invalid SQL: SELECT COUNT(*) AS total FROM dbtech_vbsecurity_loginstrikes...
  9. S

    Question How many queries does it add?

    I plan to use it with my vb optimise but i concern about the page load time. how much queries does it add for each showthread / forum home visit? Thanks :)
  10. D

    Question Usergroup revert

    Hi, Since vBshop doesn't actually revert the usergroup back to normal after the time of the item expires i managed to manually add those users to paid subscription so that they have a expire date but for some reason vBulletin is not reverting users to the normal usergroup after their...
  11. K

    Legacy Rating for unregistered Users

    Is there a possibility to enable thread rating for every single unregistered user? It only counts for 1 guest now and changes the rating, when anoter guest votes. Maybe you could seperate it with somithing like IP-query?
  12. P

    Bug vBActivity - Build Points Cache scheduled task crashing DB

    Support, We have a major problem with inefficiencies in the DBTech plugins. Specifically, the VbActivity plugin is crashing our site/DB every day when the "DragonByte Tech: vBActivity - Build Points Cache" scheduled task runs. The table it is locking is 7.5GB with 40.5 million rows. Whenever...
  13. A

    Bug .htaccess issue with new install...

    Had a fresh, blank .htaccess in my forum root. I place this in it. Nothing else. Still can't get it to install or get past it asking me to put it there. My forum is at DOMAIN.com/forum/ and everything is right.... <IfModule mod_rewrite.c> RewriteEngine on # Set to vbulletin directory...
  14. H

    Question Move everything back to the rep system

    Since I am moving to XF, I will sadly be missing many of my awesome dbtech mods, however I really don't want to lose all the thanks/likes from dbtech. I believe if I can get all the thanks/likes moved into the rep system, than the xf importer will import them. I have code on how to do it for...
  15. mikez006

    Bug Thread Color bug

    I was using 3.0.2, but just upgraded to 3.1.0 since I thought that might fix the bug, but it didn't. When a user purchases the Thread Enhancement item from the shop, it changes the thread color for all of that persons thread. The problem is when someone else posts in the thread it changes the...
  16. S

    Bug Recalculate Points Database error

    Hello, After upgrading this mod to ver. 3.0.4 i get this database error if i start "Recalculate Points" This user cannot be edited and/or deleted. Can this be the reason of the error ? Many Thanks and great Easter days! sven
  17. angus

    Bug Database errors generated by IP´s from China

    Hello! For about 2 or 3 weeks I get database errors that are generated by IP´s from China. These errors appears several times a day with following content: The script and referrer url´s changes every time. Most occurring IP´s are 222.187.222.66 and 125.78.241.11 Do you have an idea what´s...
  18. W

    Bug Download Delay Causing Occasional SQL error for Unregistered Users

    Hi again! I pushed 2.01 to my live site today and it went great! ... except for a couple errors. After I deleted the listings.php file that caused one set of errors I ended up with just a couple of new errors involving unregistered users and the download delay producing an advertisement. Here...
  19. Sarab

    Bug SQL error

    Hello, @Fillip H. I have an urgent problem, on one of the forum I and other get: What the problem and how to solve it >,< It really an urgent mater ="( Best Regards, Saran
  20. Nirjonadda

    Bug Database error in vBulletin 4.2.0

    Hello Database error in vBulletin 4.2.0,How to fix on this issue? Database error in vBulletin 4.2.0: Invalid SQL: UPDATE vbdbtech_vbactivity_points SET registration = registration + 25 WHERE userid = '34254'; MySQL Error : Unknown column 'registration' in...
Back
Top