Find UI broken and not working as it should

Vote:
 

Hi! 

On one site we have a broken UI for Find at the moment. 

When trying to configure the optimize section I get a javascript exception and no best bets, related search or synonyms are showing. 

The exception is:

Message":"An error has occurred.","ExceptionMessage":"Failed to find any languages in the database (tblContentLanguage) for content with id: 6578. Originally requested language was: 8.

I've checked tblContentLanguage, but there isn't any content with id: 6578 there. 

So, what I think might have happened is that some content has been deleted from epi, but the reference with best bets with that specific content still exists in the DB. 

Anyone got a magic sql script to fix this or any suggestions on how I can try and solve this fantastic exception? 

Kind regards / Henric

#174990
Feb 09, 2017 9:36
Vote:
 

I solved it!

I had to delete some BestBets references in BigTable, BigTableIdentity and BigTableReferences. 

but first I had to find those references. I did so by checking after the content with id: 6578 in tblBigTable. 

SELECT [pkId]
,[Row]
,[StoreName]
,[ItemType]
,[String01]
,[String02]

FROM [TheDBHere].[dbo].[tblBigTable]

WHERE String02 = '6578'. 

The result I got gave me pkId I needed to delete the references from the tables. 

For an example: 

DELETE FROM [TheDBHere].[dbo].[tblBigTable]
WHERE pkid in (841659,841663,841667,843011)
GO

DELETE FROM [TheDBHere].[dbo].[tblBigTableReference]
WHERE RefIdValue in (841659,841663,841667,843011)
GO

DELETE FROM [TheDBHere].[dbo].[tblBigTableIdentity]
WHERE pkid in (841659,841663,841667,843011)
GO

After that I restarted the site, visited the Find UI and checked if I got it working or if I got a new exception with another content ID. 

I had to redo this 9 times, after that I got the best bets view working again. 

/ Henric

#175030
Feb 09, 2017 16:36
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.