We first look at the database permissions issues, and then do the following operation.
Sql:select value from [table]vars WHERE name= ' noteexists2′
Ucenter Info:mysql Query Error
Sql:select value from [table]vars WHERE name= ' noteexists2′
Error:select command denied to user ' database ' @ ' IP address ' for table ' Pre_ucenter_vars '
errno:1142
Help people migrate Discuz, originally thought very simple, data export, data import, modify uc_server/data/config.inc.php file in the database information, the website can visit, looks have been done, the result was told unable to login, prompted the database connection error. Had to find another lap, carefully check the config file or not. After a long afternoon, I finally found one of the config files is the "Database name. Table" format and the database name of this place is still the previous, all normal after the modification.
Error:select command denied to user ' pre_ucenter_vars ' errno:1142
Customers have purchased a Hong Kong Linux host to transfer data from the original forum. The customer deliberately stressed that the money on Taobao to ask people to help transfer. Finally Taobao on the man came up with a lot of seemingly sufficient reason to say that our server has problems can not transfer data. There is no way I had to help customers see, or this customer will refund to buy Taobao on the host. Help customer site transfer came after and found that the original customer has been Taobao that bought the host, on the poor to us to refund, thanks to my hands to help the site moved over. Just see Taobao that Ganji, now people really have no morals ah. In the past several customers are such installation site, transfer site to find Taobao people help lost customers to later to refund.
In the transfer also encountered a little problem, Kangsheng dz Discuz discuz! X1.5 Site Transfer Forum transfer Error database connection database link (sorry keyword! ）
Originally just want to import the database file, in phpadmin Import SQL file and then change the three files can be.
Modified the three database link files, modified the database name, database user and password
Copy Code code as follows:
uc_server/data/config.inc.php
conf/config_global.php
conf/config_ucenter.php
But there was a problem.
The front desk can not login, to the background admin.php still unable to login, prompted internal error, errno:1142
Copy Code code as follows:
Ucenter Info:mysql Query Error
Sql:select value from [table]vars WHERE name= ' noteexists1′
Error:select command denied to user ' abc ' @ ' localhost ' for table ' Pre_ucenter_vars '
errno:1142
Think of a few ways to change the table pre_ucenter_vars still no use
Finally Google
conf/config_ucenter.php file
The default statement is define (' Uc_dbtablepre ', ' pre_ucenter_ ');
The replacement cost example is to be changed to such a format
Define (' Uc_dbtablepre ', ' dbname '. Pre_ucenter_ ');
DBName is the new database name
