Liferay document checkin issue

Question

I'm still new to Liferay and using Liferay 6.2

what i'm doing: I am trying to add a document manually into my database using insert statement. I inserted into dlfileentry, dlfileversion and AssertEntry. Also, i created a folder with the valid name and file.

The issue: upon entering the Documents and Media portlet, i can see the document name there but when i click on checkout, it will prompt a error saying that Documents and Media is temporarily unavailable. however i am still able to download the valid document.

Am i doing something wrong? Personally, i feel that i am missing one more table for the database but i'm not sure .

Thanks!

Answer 1

Yes, you're doing something wrong: You should never write to Liferay's database with SQL, as there might be more data required than what's directly visible to you. Obviously, you're running into exactly such an issue.

Liferay has an API which you can use locally, from within the same application server, or remotely as JSON or SOAP service. You should exclusively use this for write access to the database.

Alternatively, you might consider WebDAV access to your document repository as the way to add more documents to the document library.