Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 01-22-2004, 09:15 PM
SiXXGuNNZ's Avatar
SiXXGuNNZ SiXXGuNNZ is offline
 
Join Date: Oct 2001
Location: WA, USA
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Execute SQL Query Problem

Automatic Query
Helpful, predefined queries for mass updating the settings of users and posts. Once a query is executed it can not be reversed.

On - Display Reputation

"Error"
Query (On - Display Reputation)
UPDATE user SET options = options + 1024 WHERE NOT (options & 1024)

then click continue

An error occurred while attempting to execute your query. The following information was returned.
error number: 1065
error desc: Query was empty

I looked at the user table and could not find where the display reputation is, so I manually cannot even edit it, anybody got any clues on where it is so I can turn everyone on? lol, I mean turn the feature on for everyone
Reply With Quote
  #2  
Old 01-22-2004, 09:35 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Pretty sure that was a bug that I saw fixed at vB.com, either way just run the query it showed manually:

[sql]UPDATE user SET options = options + 1024 WHERE NOT (options & 1024)[/sql]
Reply With Quote
  #3  
Old 01-22-2004, 11:28 PM
SiXXGuNNZ's Avatar
SiXXGuNNZ SiXXGuNNZ is offline
 
Join Date: Oct 2001
Location: WA, USA
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by NTLDR
Pretty sure that was a bug that I saw fixed at vB.com, either way just run the query it showed manually:

[sql]UPDATE user SET options = options + 1024 WHERE NOT (options & 1024)[/sql]
thanks, sorry bout the wrong forum thing
Reply With Quote
  #4  
Old 01-23-2004, 01:16 AM
SiXXGuNNZ's Avatar
SiXXGuNNZ SiXXGuNNZ is offline
 
Join Date: Oct 2001
Location: WA, USA
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

just so ya know, I get this same error running the query seperate from the ACP

An error occurred while attempting to execute your query. The following information was returned.
error number: 1065
error desc: Query was empty

altho I can run the code from phpmyadmin just fine, maybe the ACP query is mussed up
Reply With Quote
  #5  
Old 01-23-2004, 09:18 AM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

http://www.vbulletin.com/forum/showt...930#post597930
http://www.vbulletin.com/forum/bugs....iew&bugid=1956

I assume its to do with that bug
Reply With Quote
  #6  
Old 01-23-2004, 11:20 AM
SiXXGuNNZ's Avatar
SiXXGuNNZ SiXXGuNNZ is offline
 
Join Date: Oct 2001
Location: WA, USA
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks, you are all over it

I appreciate your help
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:22 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03885 seconds
  • Memory Usage 2,202KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete