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. 從你自己的網站。