• notice
  • Congratulations on the launch of the Sought Tech site

UcenterInfo: MySQLQueryErrorSql: SelectValueFrom [Table] Varswherenoteexists

Let's look at the database permissions first, and then proceed as follows.

SQL:SELECT value FROM [Table]vars WHERE name='noteexists2'

Ucenterinfo: 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

Helping people migrate discuz, I thought it was simple, data export, data Import and modify the database information in the uc_server/data/config.inc.php file, the website can be accessed, and it seems to be done, but the result is told that it cannot log in, and the database connection error is prompted.I had to look for it again and check the config file carefully.After tossing for a whole afternoon, I finally found that there is a place in the config file in the format of "database name.table" and the database name in this place is still the previous one.After the modification, everything is normal.

Error: SELECT command denied to user ‘pre_ucenter_vars' Errno:1142
The customer bought a Hong Kong linux host and wants to transfer the data from the original forum.This client specifically emphasized that he spent money on Taobao to ask someone to help with the transfer.In the end, this man on Taobao gave a lot of seemingly sufficient reasons to say that our server had a problem and could not transfer the data.There is really no way I have to help the customer to check, or the customer will refund the host on Taobao.I helped the customer after the site was transferred, and found out that this customer had already purchased the host from Taobao, so it was almost impossible for us to get a refund.Fortunately, I quickly moved the site over.Only after I saw Taobao's treacherous trick, people nowadays really have no morals.In the past, several customers installed the site in this way.The transfer site sought help from someone on Taobao.If the customer was lost, a refund came later.
I also encountered a little problem during the transfer, Kangsheng dz discuz Discuz! X1.5 site transfer forum transfer error database connection database link (sorry keyword!)
I originally just wanted to import database files, import sql in phpadmin File and then change three files.
Modified three database link files, modified database name, database user and password
The code is as follows:

uc_server/data/config.inc.php
conf/config_global.php
conf/config_ucenter.php

but there is still a problem
front desk I can’t log in, and I still can’t log in to the background admin.php.It prompts an internal error, Errno:1142
The code is as follows:

Ucenterinfo: 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

I thought of several ways to change the table pre_ucenter_vars, but it still didn’t work.
Finally, Google
conf/config_ucenter.php file
The default statement is define ('UC_DBTABLEPRE','pre_ucenter_');
The cost example must be changed to this format
define('UC_DBTABLEPRE','`dbname`.pre_ucenter_');
dbname is the new database First name

Tags

Technical otaku

Sought technology together

Related Topic

12 Comments

author

buy lipitor sale & lt;a href="https://lipiws.top/"& gt;lipitor 10mg ca& lt;/a& gt; buy atorvastatin 20mg online cheap

Endixl

2024-03-08

Leave a Reply

+