Dede the revelation of setting up the shielding keyword by space quotient

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Say a bit funny, I find someone to use DEDECMS to build a website, after the establishment of the fear of ulterior motives of the people to add sensitive words caused the site by the space business shield, so the presumption in the background to screen the key words, set up after not to have much problem, until this morning to log back to the To find that the space is blocked, as shown in the figure:

See that keyword I know is in the background set to screen the key words, did not expect space vendors will directly screen backstage function, so hurriedly contact space service provider to find solutions, the answer is either modify the database, or FTP download repair and then upload. Because there is no such experience, do not know how to modify the database, and then hurriedly find relevant information online.

Because the Dede is backed up with SQL functionality, as long as a little understanding of SQL language can directly modify the database; it was just that time I immediately delete the set of screen word variables, delete variables and feel that this function is still a little useful, and then ready to add variables, just add variables when not aware of variable attributes, And then find the relevant variables locally, and then go to the space through the SQL to add the relevant variables, finally to solve the problem completely.

Let's talk about how to use the SQL language specifically.

First of all, 11545.html "> We need to know Dede system basic parameters of the database table for Dede_sysconfig, enter here you can set the relevant variables, each variable has the relevant variable name, here we want to modify the variable name is Cfg_ NOTALLOWSTR, if you do not know you can install Dede on the local before you enter the view.

First, remove the variable from the Dede_sysconfig cfg_notallowstr

Delete from dede_sysconfig where varname= "Cfg_notallowstr"

Delete variables can be directly into the system, there is no relationship between this variable

If you delete it and feel that you want to keep it intact, then restore the variable; the recovery variable is also very simple, but you have to look at the properties of the Cfg_notallowstr first, and then insert the property

SQL query variable properties on local site

SELECT *

From Dede_sysconfig

where varname= "Cfg_notallowstr"

The results of the lookup attribute are shown below

Aid:20

Varname:cfg_notallowstr

Info: Disable words (System will stop user actions directly)

Separate with | But not at the end |

Groupid:5

Type:bstring

Value: Disable word One, disable word two, disable word three

Re-enter Site background add variable

Insert Dede_sysconfig

(Aid,varname,info,groupid,type,value)

VALUES (' ', ' cfg_notallowstr ', ' Disable the word (the system will stop the user action directly)

with | separate, but not at the end plus | ', ' 5 ', ' bstring ', ' Disable word one, disable word two, disable word three ')

The modification completes, enters the backstage view, this variable is back backstage.

Third, of course, you can also directly modify the disabled word, here to modify the value above.

Update Dede_sysconfig

Set value= ' Here fill in the forbidden words you want to modify

where varname= "Cfg_notallowstr"

From this incident I get the revelation is that the old thought that foreign space can not set the Mask keyword, did not expect that the domestic space also did not set the necessary shielding keywords; if you set the keyword of the shield just in the key word library to be shielded, then your website backstage may be blocked, in the end you still have to delete, So the setting of the shielding keyword is not much needed.

This article by the love does not net (www.aibue.com) in A5 First, reprint please indicate the source, thanks!