YAF 1.9.3: Searching error · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

ledangtrung
52.4% (Neutral)
YAF Forumling Topic Starter

16 years ago

Right after I upgraded from 1.9.1.8 to 1.9.3, I tried the Search function. It showed an error box but the results could still be seen. An now, after 1 week, it only shows the notification "An error occurred while searching" but no results. It stays in the search page.

Do you have any ideas what the problem is? What should I do to fix it?

Thanks!

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

Jaben
100% (Exalted)
YAF Developer

16 years ago

Look in the Admin->Event Log for search problems. Report back any errors.

vneye
50.6% (Neutral)
YAF Forumling

15 years ago

Dear Jaben,

I have the same problem like ledangtrung.

Follow your instruction, I see this error description from Admin->Event Log:

System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable.

at System.Data.SqlClient.SqlTransaction.ZombieCheck()

at System.Data.SqlClient.SqlTransaction.Commit()

at yaf.DB.GetData(SqlCommand cmd)

at yaf.DB.GetSearchResult(String ToSearch, SEARCH_FIELD sf, SEARCH_WHAT sw, Int32 fid, Int32 UserID, Int32 maxResults, Boolean useFullText)

at yaf.pages.search.BindData(Boolean newSearch)

Pls help to solve this bug.

Many thanks

Jaben
100% (Exalted)
YAF Developer

15 years ago

ZombieCheck() is bad -- it means your SQL Server is running out of resources or having internal problems.

Spectrum007
50.6% (Neutral)
YAF Forumling

15 years ago

ZombieCheck() is bad -- it means your SQL Server is running out of resources or having internal problems.

Jaben wrote:

What can be done?

Important Information: