Property Groups

[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,

[jllort]

Which openkm version are you using.

Always property groups are stored in database. Try with query :

Code: Select all

select * from OKM_NODE_PROPERTY LIMIT 100;

[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.

[Netvoid]

Also just to add everything I have going...

v5.1 OpneKM
mySQL
Windows 2k8 R2

This is in my OpenKM.cfg

Code: Select all

hibernate.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,

[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.