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

I would like to share with you the method of bulk indexing DeDeCms V5.6 data to Tate search engine. I believe most people don't know much about it, so share this article for your reference. I hope you will gain a lot after reading this article. Let's learn about it together.

How to index DeDeCms V5.6 data to Tate search engine in batches?

Batch indexing of DeDeCms V5.6 data to Tate search engine

Since DedeCms does not save the article generation address in the database, all you need to do is index a field: LinkUrl to save the article generation address.

1. Run the Sql statement through Mysql: alter table dede_archives add LinkUrl varchar

2. Back up the makehtml_archives_action.php in the background directory

3. Modify it to change the 110th line, $rurl = $ac- > MakeHtml ($isremote); modify it to:

$lnk=$cfg_basehost.$ac- > GetTrueUrl ($id); $ac- > dsql- > ExecuteNoneQuery ("Update `dede_ archives` set LinkUrl='". $lnk. "'where id='". $id. "'); echo $lnk; echo"

"

4. Go to the background-HTML update-update the document HTML, and enter the starting ID. Batch updates are fine.

5. After the update, restore makehtml_archives_action.php to the original file you just backed up.

6. Create a new table: t_tot

CREATE TABLE `ttot` (`id` int (11) NOT NULL auto_increment, `typeid` int (11) default '0percent, `title` varchar (100mm) default'', `substitution`varchar (250mm) default'', `Datestr` varchar (100mm) default', `LinkUrl`varchar (200C) default'', `body`text, PRIMARY KEY (`id`) ENGINE=MyISAM DEFAULT CHARSET=gbk

7. Copy the content to the index table

Insert into t_tot (id,typeid,title,description,Datestr,LinkUrl,body) SELECT a.typeiddiary a.titlerecorda.category FROM dede_archives now (), a.LinkUrl recordb.body FROM dede_archives a journal deprecated addonarticle b where a.id=b.aid

8. Import the t_tot table into Sqlserver through Mysql Odbc. When you connect, please choose to compile to GBK.

9. Run Reset.aspx index table t_tot

The above is all the contents of the method of bulk indexing DeDeCms V5.6 data to Tate search engine, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.