I replaced the Integration database with the production DB and no

I replaced the Integration database with the production DB and now I get an error when using EpiServer Find.

eperezjr

Vote:

This is the error:

'Content with id '286580' is of type 'Castle.Proxies.ImageOrVideoBlockProxy' which does not inherit required type 'EPiServer.Core.PageData''

The error occurs on search.GetPagesResult();. Here's what the code looks like:

var filter = BuildFilter(searchQuery, name, state, city, lat, lng, amenities, type, eventTypes, isVenue);
var search = client.Search<ClubPage>().Filter(filter).Take(MAXRESULTS);

if (sort == "distance" && lat != null && lng != null)
{
    search = search.OrderBy(p => p.Location).DistanceFrom(GetGeoLocation(lat, lng));
}
else
{
    search = search.OrderBy(p => p.DisplayName);
}

var results = search.GetPagesResult();

I ran the Find indexing before I exported the int database for local testing. And I made sure that the find URL and index for integration was in my web.config. Any ideas what's going on here?

#303399

Jun 12, 2023 18:54

Paul McGann (Netcel)

Vote:

Hi,

It looks as though something in your index has been corrupted.

When restoring databases, it would be better to clear the index first and ensure the index is empty before re-indexing.

If the problem exists after this, then you can either ask support to remove just that content using the id. Or you could write you own extension to allow you to enter an id and remove it from the index.

Thanks

Paul

#303400

Jun 12, 2023 19:59

eperezjr - Jun 12, 2023 21:03

I see. Is there a special process for clearing the indexes? Or you just mean the normal sql server indexes?

eperezjr - Jun 12, 2023 21:03

I see. Is there a special process for clearing the indexes? Or you just mean the normal sql server indexes?

Quan Mai

Vote:

You can reindex your content using this Scheduled job for indexing (Find 9) | Optimizely Developer Commun

it will clear the indexes once completes

#303440

Jun 13, 2023 5:49

Paul McGann (Netcel)

Vote:

Hi,

You should b abl to following the process here https://support.optimizely.com/hc/en-us/articles/4413200747789-Clear-the-index-and-reindexing

Thanks

Paul

#303442

Jun 13, 2023 7:58

eperezjr - Jun 13, 2023 18:36

How can I access that site? Is that just https://find.episerver.com/?

Paul McGann (Netcel) - Jun 14, 2023 9:28

You should just be able to do this in the CMS under Search and Navigation.