After discuz is migrated, an error occurs. SQL: SELECT value FROM [Table] vars WHERE name = 'noteexists1' solution

I think most people suffer from such a situation, and the scalp gets paralyzed...

Is it swollen? I followed the online tutorial step by step? Why are there still errors?

In fact, this error is mostly caused by carelessness ..

The migration of website programs is an inevitable process for webmasters. However, there are also many migration methods that each person has summarized. There are many ways to use discuz.

Although many steps are complicated in this article, the probability of practical errors is also very small.

Of course, there are still many ways to move, so I am not arrogant, because there are a lot of online searches.

But what should I do if I encounter problems during migration? Of course Baidu encountered this small problem today. It was still caused by carelessness after careful troubleshooting.

In fact, we all know the three locations to be modified after the migration. This error is generated when the configuration file is modified.

Generally, you only need to modify the host address, database account and password, and database name.

We often ignore the table prefix, which is also the table prefix of the database mentioned in every tutorial ..

Define ('UC _ dbtablepre', ''database name'. Table prefix ')
 
 

For example, define ('UC _ dbtablepre', ''a020140322 '. pre_ucenter _');

The red a020140322 is actually the name of our database. Many webmasters often ignore this and cause errors.

If you encounter such a problem, please carefully check whether the configuration file has not all the database configurations changed. This is very important ....