You Are Not Authorized to Execute SQL Queries in vBulletin Maintenance您未获授权执行SQL查询在vbulletin维修

After login to vBulletin Admin Control Panel, and click on “Execute SQL Query” link under the Maintenance section, the administrator may always been denied and rejected with an error message saying “You are not authorized to execute SQL queries”.登录后，以vbulletin管理员控制面板，并点击“执行SQL查询”链接，根据维修保养科，管理员可能会一直否认并拒绝与错误讯息说： “你是不是授权执行SQL查询” 。 This is the case even if you’re super administrator who authorized to do everything on the forums.在这种情况下即使您超级管理员谁授权尽一切就论坛。 However, a simple trick will grant the user who needs this Execute SQL Query function with the required permission and right.然而，一个简单的把戏，将给予该用户谁需要这执行SQL查询功能符合要求的许可和权利。

To grant an user permission and right to run Execute SQL Query from Control Panel, simply login to your web server which is running vBulletin forum.给予用户许可的权利和运行执行SQL查询从控制面板，只需登录到您的Web服务器是运行vbulletin论坛。 Then edit the /includes/config.php file.接着编辑/包括/ config.php文件。

Find the following line:找到以下行：

// ****** USERS WITH QUERY RUNNING PERMISSIONS ****** / / ******用户查询运行权限******

After a few lines, you should see the following setting:后几行，您应该可以看到以下设置：

$canrunqueries = ”;元canrunqueries = “ ;

Add in the user IDs of the forum members, moderators or administrators that you want to enable their ability to be able to run SQL queries in between the quotes (’).添加在该用户ID的论坛成员，版主或管理员，您想要让他们的能力，以便能够运行SQL查询在之间的引号（ ' ） 。 Note that it’s user ID and not user name.请注意，它的用户ID而不是用户名。 User ID is the number assigned to the user account automatically and sequentially.用户ID是多少分配给用户帐户自动和顺序。 For example, if you want to add the right to administrator, who is usually the first person created on the board, and thus has the user ID number 1, change the line to:例如，如果您要添加的权利管理员，谁是通常的第一人，创造了该委员会，因此，用户的ID号码1 ，行变更为：

$canrunqueries = ‘1′;元canrunqueries = '1 ' ;

To add more users, simply seperate them with comma (,).要添加更多的用户，只需将它们分开与逗号（ ， ） 。

IMPORTANT : This is a machine translated page which is provided "as is" without warranty. 重要说明 ：这是一个机器翻译网页是“按原样”提供的担保。 Machine translation may be difficult to understand.机器翻译可能很难理解。 Please refer to请参阅 original English article原来的英语文章 whenever possible.只要有可能。

Share and contribute or get technical support and help at分享和贡献，或取得技术的支持和帮助，在 My Digital Life Forums 我的数字生活论坛 . 。

Related Articles相关文章

• Change or Set MySQL Long Query Time Value for log-slow-queries改变或设置MySQL的长期查询时间价值为登录慢的疑问
• Enable Logging of Slow Queries (Slow Query Log) in MySQL Database启用日志记录慢查询（慢速查询日志）在MySQL数据库
• Oracle PL/SQL ORA-00947 Not Enough Values Error甲骨文PL / SQL的库存- 00947没有足够的价值观错误
• How to Disable and Turn Off vBulletin Plugin and Product System如何禁用和关闭vbulletin插件和产品系统
• Hack to Add Forum Sponsors to vBulletin Categories and Forums哈克加入论坛的赞助商vbulletin类别和论坛
• Oracle Database Link Oracle数据库的连接
• Check Oracle Version检查的Oracle版本
• Change or Increase vBulletin Maximum Number of Total Allowed Private Messages (PM)改变或增加vbulletin人数最多，共允许私人邮件（下午）
• How to Change the Logo of vBulletin Forum to Custom One如何改变标识的vbulletin论坛，自定义1
• ORA-00942 Table or View Does Not Exist Oracle Error库存- 00942表或视图不存在Oracle错误

This entry was posted on Tuesday, July 24th, 2007 at 6:12 pm and is filed under 此项目被张贴于周二， 2007年7月24日在下午6时12分，并提交下 Webmaster Resources 网站管理员资源 . 。 You can follow any responses to this entry through the 您可以按照任何的反应，此项目通过 RSS 2.0 2.0 feed. 喂养。 You can 您可以 leave a response 留下的回应 , or ，或 trackback Trackback跟踪 from your own site. 从你自己的网站。