Search found 128 matches

by mamad
Wed Jan 08, 2020 6:21 pm
Forum: Usage
Topic: How to find Path of each document using sql
Replies: 2
Views: 152

Re: How to find Path of each document using sql

Your reason convinced me completely !
Thanks a lot
by mamad
Tue Jan 07, 2020 6:34 am
Forum: Usage
Topic: How to find Path of each document using sql
Replies: 2
Views: 152

How to find Path of each document using sql

Hi guys I want to build a view of documents which contains their name,uuid and path (my database is mysql 5.5) I don't know why NBS_PATH is empty for each node at OKM_NDOE_BASE table and i think i have to build the path by myself based on the NBS_UUID and NBS_PARENT of each node. I have written an s...
by mamad
Sat Jan 04, 2020 11:02 am
Forum: Configuration
Topic: Database Query does not show more than 500 results
Replies: 2
Views: 841

Re: Database Query does not show more than 500 results

Thank you so much for the support .
by mamad
Tue Dec 31, 2019 11:53 am
Forum: Configuration
Topic: Database Query does not show more than 500 results
Replies: 2
Views: 841

Database Query does not show more than 500 results

Hello guys
When i execute any select query in the "Database query" tab of openkm which returns more than 500 results, only the first 500 rows of whole results will show in the screen
Is is possible to remove this limitation to show the whole results in the screen ?
by mamad
Mon Dec 09, 2019 11:53 am
Forum: Usage
Topic: Search on unordered words of document name failed
Replies: 1
Views: 278

Search on unordered words of document name failed

hello guys Please consider the situation that for example i have a file with name "big red car.txt" When i search on names with a missed word no results will be find as the search result. For example if i search for "big car" no result will be find but "big red" or "red car" will be ok. would you pl...
by mamad
Thu Nov 14, 2019 8:22 am
Forum: Configuration
Topic: Can't connect to H2 database of openkm from ouside of it
Replies: 4
Views: 370

Re: Can't connect to H2 database of openkm from ouside of it

well,it seems like it's time to migrate to MySQL.
Thank you so much for your support
by mamad
Tue Nov 12, 2019 8:37 am
Forum: Configuration
Topic: Can't connect to H2 database of openkm from ouside of it
Replies: 4
Views: 370

Re: Can't connect to H2 database of openkm from ouside of it

I used this values for connecting to the database :

Driver Class : org.h2.Driver
JDBC URL : jdbc:h2:tcp://192.168.1.50/home/openkm/tomcat/repository/okmdb
User Name : sa
Password : sa

Are these values valid ?
by mamad
Tue Nov 12, 2019 7:22 am
Forum: Configuration
Topic: Can't connect to H2 database of openkm from ouside of it
Replies: 4
Views: 370

Can't connect to H2 database of openkm from ouside of it

Hi guys i installed openkm community edition with H2 database and now i want to connect to its H2 database from outside of it. I installed H2 console and after opening console and entering information of server and database, it raised an exception and did not connect to the database. This is a snaps...
by mamad
Wed Nov 06, 2019 8:31 am
Forum: Installation
Topic: How to find the type of database i installed openkm on
Replies: 2
Views: 722

How to find the type of database i installed openkm on

Hi there
I installed openkm 6.3.7 community edition a long time ago and i don't remember what kind of database i used for the installation.
Now i want to know the type of database that my openkm is currently using.
How to find that ?
thanks in advance
by mamad
Mon Nov 04, 2019 12:42 pm
Forum: Configuration
Topic: Is this possible to add document/folder name to the end of URL
Replies: 2
Views: 767

Is this possible to add document/folder name to the end of URL

Hi guys, As you know when we log in into openkm the following url will be shown on address bar and it wont change when we click on each document or folder http://ip address of server/OpenKM/frontend/index.jsp I want to know if its possible to add the name of each document or folder to the end of thi...
by mamad
Mon Nov 04, 2019 6:57 am
Forum: Configuration
Topic: JasperReport Template doesn't show Persian characters
Replies: 5
Views: 1001

Re: JasperReport Template doesn't show Persian characters

Hello again, After a while i checked the server again and the font that i used had been installed on the server ( i used Arial font ) try with another format of the report like CSV I also checked this and find that there is no problem on CSV or rtf reports and this problem exists only on pdf outputs.
by mamad
Wed Oct 23, 2019 8:16 am
Forum: Usage
Topic: Openkm constantly stops working
Replies: 4
Views: 770

Re: Openkm constantly stopped

i added that line to the end of setenv.sh and started tomcat. after about an hour openkm stopped again ( it failed to load the login page ) After that a file named java_pid27219.hprf was created in the catalina home path. The size of this file is too large ( 1.2 GB) and i cant open it with any text ...