Page 1 of 1

Database error in search

PostPosted:Mon Dec 16, 2019 8:46 am
by openkm_user
Hi,

When we search for both folder and document (on Advanced Search), it takes a lot of time to load and returns the following error,

Capture.JPG
Capture.JPG (19.82 KiB) Viewed 3032 times

The search term is actually in folder only, but we selected both Folder and Document in Advanced Search,

Capture1.JPG
Capture1.JPG (16.08 KiB) Viewed 3032 times
It usually returns the result that matches but now it shows above error, please explain why?

Re: Database error in search

PostPosted:Wed Dec 18, 2019 12:22 pm
by jllort
If you check only the folder the error also happens?

Re: Database error in search

PostPosted:Thu Dec 19, 2019 9:52 am
by openkm_user
No error if only Folder is checked, it happens only when both Document and Folder are selected.

Earlier it worked (didn't show this error) when both are selected, it returns data from wherever results are available.

Re: Database error in search

PostPosted:Sat Dec 21, 2019 5:40 pm
by jllort
Can you capture the complete error from catalina.log and share here.

In case you check only documents it does happens, confirm this point?

From the screenshot seems the error is caused by Email. Did you have categories in your system? and documents assigned to categories?