LogicalDoc Community 6.2. MySQL error

Problems with installing LogicalDOC? No problems, the solution is closer than you think.

Moderator: car031

mcseller
Posts: 1
Joined: Sat Jun 25, 2011 8:53 am

LogicalDoc Community 6.2. MySQL error

Mon Jun 27, 2011 1:49 pm

Hi all,

during setup I got this errors in log file catalina.out:
Execute sql/logicaldoc-core.sql
SQL Error at '/usr/share/apache/tomcat/temp/logicaldoc-core.sql4384839735286277664.sql' line 56:
"--On MySQL AK fields cannot be larger than
create unique index AK_DOCUMENT on ld_document (ld_customid)"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--On MySQL AK fields cannot be larger than
create unique index AK_DOCUMENT on l' at line 1
SQL Error at '/usr/share/apache/tomcat/temp/logicaldoc-core.sql4384839735286277664.sql' line 63:
"create unique index AK_GENERIC on ld_generic (ld_type, ld_subtype)"
Specified key was too long; max key length is 1000 bytes
Thanks
mmeschieri
Posts: 242
Joined: Mon Apr 19, 2010 3:40 pm

Re: LogicalDoc Community 6.2. MySQL error

Mon Jul 04, 2011 7:51 am

This kind of error depends on the database encoding, i think you don't have an UTF-8 database. Please check to have specified UTF-8 encoding.
In any case this error during the setup process doesn't invalidate your istallation, simply you will not have an alternate key enforced by a DB constraint.

Return to “Installation”

Who is online

Users browsing this forum: No registered users and 31 guests