All Products
Search
Document Center

ApsaraDB RDS:"OPERATION need to be executed set by ADMIN" is displayed when you call the RDS Database after installing the ThinkSNS website

Last Updated:Aug 24, 2023

Note

Disclaimer: This article may contain information about third-party products. Such information is for reference only. Alibaba Cloud does not make any guarantee, express or implied, with respect to the performance and reliability of third-party products, as well as potential impacts of operations on the products.

Problem description

If you have created a database and authorized the account to install ThinkSNS, the following error message appears.

OPERATION need to be executed set by ADMIN

Solution

Note

Alibaba Cloud reminds you that:

  • When you perform operations that have risks, such as modifying instances or data, check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
  • Before you modify the configurations and data of instances including but not limited to ECS and RDS instances, we recommend that you create snapshots or enable RDS log backup.
  • If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.

  1. Find the installation package file and back up it. The path is ThinkSNS_V4.1.170_Beta_Full\ThinkSNS_V4_Beta_Full\install\install.php, in about 542 lines, find the following.
    Note

    Note: back up the file before modifying it.

  2. The above red box code changes for the following code.
    mysql_select_db($db_config['db_name ']);

Application scope

  • Apsaradb for MySQL