Open Source Document Management System | OpenKM

PostPosted:**Thu Jul 31, 2014 12:12 pm**

He seguido los pasos para pasar de la BBDD a MySQL.

el problema es que me carga OK pero vacío, sin datos.
Miro las tablas en el MySQL y es como si empezase desde 0. okm_user (Administrator), etc.... cuando myo ya tenía varios usuarios.
No hay ningún fichero en la taxonomía, ni ningñun directorio....

Al cargar el tomcat y exportar me aparecen los siguientes errores:

Code: Select all

2014-07-31 13:55:00,114 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL07 on OKM_DB_METADATA_VALUE (DMV_COL07)
2014-07-31 13:55:00,114 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,208 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL08 on OKM_DB_METADATA_VALUE (DMV_COL08)
2014-07-31 13:55:00,208 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,208 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL09 on OKM_DB_METADATA_VALUE (DMV_COL09)
2014-07-31 13:55:00,208 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL14 on OKM_DB_METADATA_VALUE (DMV_COL14)
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL11 on OKM_DB_METADATA_VALUE (DMV_COL11)
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL10 on OKM_DB_METADATA_VALUE (DMV_COL10)
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL13 on OKM_DB_METADATA_VALUE (DMV_COL13)
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL12 on OKM_DB_METADATA_VALUE (DMV_COL12)
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL01 on OKM_DB_METADATA_VALUE (DMV_COL01)
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL02 on OKM_DB_METADATA_VALUE (DMV_COL02)
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL00 on OKM_DB_METADATA_VALUE (DMV_COL00)
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL05 on OKM_DB_METADATA_VALUE (DMV_COL05)
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL06 on OKM_DB_METADATA_VALUE (DMV_COL06)
2014-07-31 13:55:00,224 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,239 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL03 on OKM_DB_METADATA_VALUE (DMV_COL03)
2014-07-31 13:55:00,239 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:00,239 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create index IDX_DB_MD_VAL_COL04 on OKM_DB_METADATA_VALUE (DMV_COL04)
2014-07-31 13:55:00,239 [pool-2-thread-1] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Specified key was too long; max key length is 767 bytes
2014-07-31 13:55:04,171 [pool-2-thread-1] INFO  org.hibernate.tool.hbm2ddl.SchemaExport - schema export complete

PostPosted:**Thu Jul 31, 2014 1:28 pm**

He encontrado varias páginas que hablan de este problema:
Parece que es un problema del MySQL, lo que no tengo ni idea es de como solucionarlo y de si a vosotros no os ha dado este problema....

http://wildlyinaccurate.com/mysql-speci ... -767-bytes
http://www.yenlo.com/en/wso2-carbon-mys ... 767-bytes/
http://wiki.ispirer.com/sqlways/trouble ... y-too-long

PostPosted:**Sun Aug 03, 2014 9:07 am**

No tiene importancia, esto es una limitacion de la mysql que limita el indice a 767 bytes, lo que indica es que va a trucar el texto. Pero vamos esto no afecta a la tabla ni al contenido del automation. Por cierto el contenido del automation esta vacio y lo tienes que inicializar manualmente en la version 6.3 ( en la professional el tema ya se carga automaticamente ) http://wiki.openkm.com/index.php/Enable ... al_version

Open Source Document Management System | OpenKM

MySQL error

MySQL error

Re: MySQL error

Re: MySQL error