Today we will tell you about Cleaning and Re-Indexing your DotNetNuke Search Tables. A week ago, we put a great deal of exertion into upgrades to the inquiry and RSS parts of Efficion's Articles module. As a feature of that, we recognized that regardless of how often you hit the Re-Index substance interface on the Host-> search Admin page, the connections never really get redesigned. As we dug further, it got to be clear that to upgrade the connections utilized by DNN's pursuit and RSS, you really need to cleanse the hunt tables.

This has suggestions past our module so I thought I'd impart the steps as a decent practice to do each once in momentarily on your DNN site to verify you Search Results and RSS Feeds are connecting legitimately.

Along these lines, if your query items aren't showing or connecting the route you'd like them to, the first thing you ought to attempt is clearing and re-indexing the inquiry tables. To do this:

1.) Login as host or an alternate superuser account

2.) Go to the Host->sql tab and run the accompanying as script:

delete {databaseOwner}{objectQualifier}SearchItemWordPosition
delete {databaseOwner}{objectQualifier}SearchItemWord
delete {databaseOwner}{objectQualifier}SearchWord
delete {databaseOwner}{objectQualifier}SearchItem

3.) Go to Host -> Search Admin and click the Re-Index substance catch. It may take for a little while for the re-indexing to finish so provide for it a couple of hours before testing once more.

On the off chance that this does not work, there may be an alternate module that is creating issues with Search. Take a gander at your Event Viewer and check whether you can discover any slip messages identifying with hunt.

Best DotNetNuke Hosting Recommendation

ASPHostPortal.com
ASPHostPortal.com provides its customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server. ASPHostPortal.com offers DotNetNuke hosting starts from $5/month only. We also guarantees 30 days money back and guarantee 99.9% uptime. If you need a reliable affordable DotNetNuke Hosting, we should be your best choice.