Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2013, 11:14 PM
steve3402000's Avatar
steve3402000 steve3402000 is offline
 
Join Date: Nov 2004
Location: Detoilet
Posts: 107
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default SQL Querys

Since I am begging for help

Under the maintenance function, it says execute SQL query
I get this in response

You are not authorized to execute SQL queries

Thanks in Advance

Steve

--------------- Added [DATE]1385511326[/DATE] at [TIME]1385511326[/TIME] ---------------

Oh yes, Where do I make the permissions, I hope its not IN MySQL, I cannot access it
Reply With Quote
  #2  
Old 11-26-2013, 11:17 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by steve3402000 View Post
Since I am begging for help

Under the maintenance function, it says execute SQL query
I get this in response

You are not authorized to execute SQL queries

Thanks in Advance

Steve

--------------- Added [DATE]1385511326[/DATE] at [TIME]1385511326[/TIME] ---------------

Oh yes, Where do I make the permissions, I hope its not IN MySQL, I cannot access it
Permissions for SQL queries is in the config.php file.
Reply With Quote
  #3  
Old 11-26-2013, 11:18 PM
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Location: USA
Posts: 10,929
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

In your includes/config.php file.

Code:
    //    ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    //    The users specified here will be allowed to run queries from the control panel.
    //    See the above entries for more information on the format.
    //    Please note that the ability to run queries is quite powerful. You may wish
    //    to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '1';
Reply With Quote
Благодарность от:
tbworld
  #4  
Old 11-26-2013, 11:22 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

in your ftp go to your includes folder find the config.php file download this to your desktop and edit it with notepad++ find the line
$config['SpecialUsers']['canrunqueries'] = 'userid here';
will be on line 127 then close and save then upload file to ftp
Reply With Quote
Благодарность от:
ozzy47
  #5  
Old 11-26-2013, 11:26 PM
steve3402000's Avatar
steve3402000 steve3402000 is offline
 
Join Date: Nov 2004
Location: Detoilet
Posts: 107
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You guys rock

Thank you very much

Steve
Reply With Quote
  #6  
Old 11-26-2013, 11:29 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This thread is humorous. Heh.
Reply With Quote
  #7  
Old 11-26-2013, 11:32 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Max Taxable View Post
This thread is humorous. Heh.
Whys that?
Reply With Quote
  #8  
Old 11-26-2013, 11:34 PM
steve3402000's Avatar
steve3402000 steve3402000 is offline
 
Join Date: Nov 2004
Location: Detoilet
Posts: 107
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Probably because I know so little. The board has been relatively trouble free. Going on year 10. When it gets pooched up, I ask for help

The purpose of my board is to help people. So it is cool seeing the help I get here. On the official board, my posts sit unanswered for weeks.

Steve
Reply With Quote
  #9  
Old 11-26-2013, 11:37 PM
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Location: USA
Posts: 10,929
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think he said it's humorous, because 3 people answered in three different ways, almost at the same time.
Reply With Quote
Благодарность от:
Max Taxable
  #10  
Old 11-26-2013, 11:39 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by steve3402000 View Post
Probably because I know so little. The board has been relatively trouble free. Going on year 10. When it gets pooched up, I ask for help

The purpose of my board is to help people. So it is cool seeing the help I get here. On the official board, my posts sit unanswered for weeks.

Steve
No... Not that at all. Alot of us here just like to help no matter what the issue is.

I find it humorous because of the three answers. One somewhat cryptic and short, the next alot more detailed, and the third downright instructive and even more highly detailed! And all three within a few minutes of each other, and all three correct.
Reply With Quote
Reply


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 02:26 AM.


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.05094 seconds
  • Memory Usage 2,264KB
  • 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
  • (1)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (3)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete