Shulou(Shulou.com)06/02 Report--

Editor to share with you how to upgrade dedecms5.1 to 5.3 resulting in the loss of TAG. I hope you will gain a lot after reading this article. Let's discuss it together.

What if the TAG is lost due to the upgrade of dedecms5.1 to 5.3?

Handling of problems such as loss of TAG due to upgrade of dedecms5.1 to 5.3

The TAG of the normal reality article page has been linked, and the TAG of the article has been restored before the upgrade. Here are the specific solutions. It is mainly the last sentence sql that executes the following.

Recommended study: dream weaving cms

In fact, many people have already answered the answer forum to fix TAG questions. It may be that everyone has not tried it seriously, and it is not because the code provided by others is incorrect.

But you can not completely COPY other people's code, a lot of code has to modify the prefix of the data table before it can be used.

Here's how I can solve the TAG problem:

The first step is to call the TAG code of the current article on the article page:

Replace the original code directly with Tag: {dede:field.tags/}

For example, my website used to get the current article TAG code is like this note that the red part is the code, black yourself as you like:

Tag: {dede:tag type='current'/}

So now the original code where the TAG is displayed is:

Tag: {dede:field.tags/}

The above is the first part. Now we need to modify the relevant files of DEDE CMS. Open the file\ include\ common.func.php.

Find / / get all the tag parts of a document and put the following code

The code is as follows:

Function GetTags ($aid) {global $dsql; $tags=''; $query = "Select tag From [url=mailto: `ddmx _ taglist] `ddmx_ taglist [/ url] `where aid='$aid'"; $dsql- > Execute ('tag',$query); while ($row = $dsql- > GetArray (' tag')) {$tags. = ($tags==''? $row ['tag']:','. $row ['tag']);} return $tags;} function ParamError () {ShowMsg (' Sorry, you entered the wrong parameter!' ,'_ javascript:;'); exit ();}

Replace it with the following code, during which you want to modify your table prefix according to your actual situation.

Notice that the 'dede_dedecmstaglist', below is modified according to its own table prefix.

The code is as follows:

Function GetTags ($aid) {global $dsql; $tags=''; $query = "Select tag From `Dedecmstaglist` where aid='$aid'"; $dsql- > Execute ('tag',$query); while ($row = $dsql- > GetArray (' tag')) {$tags. = ($tags==''? "{$row ['tag']}":','. "{$row ['tag']}");} return $tags;} function ParamError () {ShowMsg (' Sorry, you entered the wrong parameter!' ,'_ javascript:;'); exit ();}

OK, now, as long as the TAG of your article is not lost, complete the above steps to call the linked article TAG on the article page.

If your TAG is lost during the upgrade, follow these steps.

Go to the background of your website management

Select "system"-"SQL Command Line tool"

Run the SQL command:

The code is as follows:

UPDATE dede_tagindex,dede_taglist SET dede_taglist.tag = dede_tagindex.tag WHERE dede_taglist.tid=dede_tagindex.id

Be careful not to completely COPY the above code, but modify the table prefix according to your actual situation.

After reading this article, I believe you have a certain understanding of the method of TAG loss caused by the upgrade of dedecms5.1 to 5.3. if you want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.