The contents you find here are totally obsolete so do not use this website to obtain a solution for your issues: the indications you get from here will not be accurate and may lead to data loss or other mayor problems

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: Bing [Bot] and 63 guests

× Attention! This forum has been dismissed and will be soon removed. The contents you find here are totally obsolete so do not use this website to obtain a solution for your issues: the indications you get from here will not be accurate and may lead to data loss or other mayor problems.