Page 1 of 1
Property Groups
PostPosted:Thu Sep 12, 2013 8:47 pm
by Netvoid
Is it possible for property groups values to be configured for storage in mySQL DB, but not the files?
I am trying to query the property group values and only seem to find them in the file based repository DB. Any assistance would be greatly appreciated.
Thanks,
Re: Property Groups
PostPosted:Sat Sep 14, 2013 5:57 pm
by jllort
Which openkm version are you using.
Always property groups are stored in database. Try with query :
Code: Select allselect * from OKM_NODE_PROPERTY LIMIT 100;
Re: Property Groups
PostPosted:Mon Sep 16, 2013 11:19 pm
by Netvoid
Using version: 5.1
That table isn't in my database? I have dozens of tables and I think it's all setup but ... not sure why.
Re: Property Groups
PostPosted:Mon Sep 16, 2013 11:44 pm
by Netvoid
Also just to add everything I have going...
v5.1 OpneKM
mySQL
Windows 2k8 R2
This is in my OpenKM.cfg
Code: Select allhibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.hbm2ddl=none
system.openoffice=on
Did the "create" mode on that which did connect and create all the tables. Everything in the OpenKM front end seems to be working correctly.
Configured stuff throughout the system, including the openkm-ds.xml ...
The only table starting with okm_node I have is okm_node_contact. Certainly dozens of other okm_ tables though.
Thanks,
Re: Property Groups
PostPosted:Wed Sep 18, 2013 5:42 pm
by jllort
Forget it, try to upgrade to version 6.2. OpenKM 5.x is still under jack rabbit repository. The problem here - among others - is some fields are serialized into database.