﻿id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc
1039	Issues when number of folders in a subfolder is more than 1000	pashazadeh		"In FolderDAO, it first extracts sub-folder ids recursively, stores them in a Set<Long> and then does other operations on that.
Including:
- counting total number of documents
- calculating total size of documents
- deleting/undeleting a folder
- changing permissions on a folder
...

If total number of subfolders of a folder (recursively) exceeds 1000, Oracle database throws an exception on the query, and MySQL does not perform the operation on folderids which are exceed 1000 limit.

Logicaldoc counts the total number of documents, and total size of documents on administrator login. So if the total number of folders (recursively) exceed 1000, there will be an exception and Admin can not login at all.

This issue exists in 7.5.1, 7.5.2 and 8.5 (I've checked these versions, but I believe more versions have this issue)."	bug	closed	minor	8.5.1	Core	8.5	fixed	query folders	
