query

Jackpot Is there a way to Manual Query all games to have a jackpot of 50? I have over 5000 games to add it to..

Ok, it started the other day. I finally upgraded vbshout to the 6.0.8 and then user tagging to 3.0.4. Then the site began to really take a hit. Load values were on par with each other, but mysql user was pegging 800%. Checked out the mysql process log and found this below: | mazdaspe_msf |...

After i installed vbDownloads Lite, when i change a usergroup from Member to Administrator, i get the following DB Error (Workaround: Disbaled vbDownloads, made the change, reenabled vbDownloads) Is this error also present in Pro? Database error in vBulletin 4.2.0: UPDATE user SET ###...

When I add a usergroup change to the shop, if I set it to last for 7 days, will it expire and therefore remove the usergroup from the user after that time? If so will it send the user back to their previous usergroup? I'm trying to replicate paid subscriptions through the VBShop.

after the update 3.0.0b2, the folowing error shows when previewing the "forumdisplay" pages.. . . . . . . Database error in vBulletin 3.8.7: Invalid SQL: SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg...

Steps to recreate the issue: View Profile: IcEWoLF - The 47 Ronin Click on Mentions tab Click on any pages: Once you click on one of the pages I get the following error:

I receive the following error when attempting to upload an image from the "Dragonbyte Gallery > Add Image" section of the gallery. Database error in vBulletin 4.1.10: Invalid SQL: INSERT INTO dbtech_gallery_images ( instanceid, userid, albumid...

I banned a user as a test from a thread. That worked fine, then I deactivated the ban. That worked. Then I edited the ban to change it to ban the same person on a different thread and then got the following error: ### INSERT QUERY GENERATED BY fetch_query_sql() ### INSERT INTO...

Hi Ozzy, do donors rank automatically reset from 1 month from their last donation? (Auto remove them from a group) I want to make sure it does this so this way users that donated once and then no longer donates don't keep maintaining the same donor rank after 1 month.

Your IP Address (xxx.xxx.xx.xx) is currently awaiting authorisation to be enabled for the user Nirjon. Please check the email address associated with your account and click the authorisation link. I'm not receiving the email and also cannot get other admin...how to fix this problem ?

I hit F5 to refresh various things on my website and when I do so, I notice that the forum tab is defaulted back to "ALL" instead of the one selected. It'd be nice if this information could be retained. This might also go partially into my suggestion of having a default tab. That'd help...

On top I am getting this error: The 47 Ronin - Donations Warning: explode() expects parameter 2 to be string, array given in [path]/dbtech/vbdonate/hooks/process_templates_complete.php on line 249 Also could we make the navigation tab wider to match the template? Awards...

We already have a number of members that donated through a previous simple widget donation system we had, which isn't included in the Import option in vBDonate. They are in a Group called Donators - is it possible for me to get them into the list of donators in vBDonate?

Syntax error when trying to delete a game.. Database error in vBulletin 4.2.0: Invalid SQL: SELECT tournid FROM dbtech_vbarcade_tourn WHERE gameid =; MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to...

Ok this is what i want to do: What i want is add massive points to my users to test vbavatars and learn about the system, but after this stage, what i want is restart the system and delete all avatars and all points and all users start from the begining again. Could you please tell me how to...

I set "Cache Showgroups Query" to high value such as "12". And most of the times / sometimes, when i open my showgroups page, the moderation are is not shown at all, so there only a list of moderator usernames there, without moderation area. When i changed it to 0, the showgroups page works...

Hello , I have noticed that there is no option in vbulletin to change and organize posts in a thread. i have a thread and it is very important to me to be able to organize the thread in a specific order. every week things are changing and i need it to be in a specifc order. Anyways , i wanted...

I would like to uninstall vbcredits deluxe lite 2.0.0 simply because I no longer have a use for it. I have had no problems with the script... it worked great when I used it, but I no longer need it on my site. How can I remove this completely and safely from my site? Reverse template edits?

Hi, I was running the old lite version of this mod, then recently upgraded to the new lite and finally paid version. However despite stated savings in the admincp of 240,000 and 360,000 saved queries per day respectively, I'm seeing no change in MYSQL statistics in my monitoring as per the...

Hi, A couple of days after installing paid version 2.5 of this mod I noticed the CMS home page of my website was no longer working. Disabling the mod fixed the problem. No other pages were affected that I know... Thanks. Hugh