;)
;)
;)
Hi,
I did fresh installation of 'ConcourseSuite 5.0.5'.
I am using java 1.6 & MySQL 5.0.51
When I followed the steps as per installation quide, I got the below error while loading database schema & not able to proceed to next step.
"An error occurred while trying to create the database schema, the following error was provided: Specified key was too long; max key length is 767 bytes"
I found that there are 121 tables created in database.
SERVER TRACE:
HTTPUtils-> Checking: http://localhost:8080/centric
4
CustomHook-> Prepare send
CustomHook-> Sending: <?xml version="1.0" encoding="UTF-8"?><crmRegistration><na
meFirst>dhandapani</nameFirst><nameLast>k</nameLast><company>nval</company><emai
l>onlinedhandu@gmail.com</email><profile>dhandapani</profile><os>Windows XP x86
5.1</os><java>1.6.0_03</java><webserver>Apache-Coyote/1.1</webserver><zlib2>4fa7
0e91cba7fe45</zlib2><text>jevnMisDVDSAi1tFjuRW1g==
</text></crmRegistration>
CustomHook-> RESPONSE: <?xml version="1.0" encoding="UTF-8"?><aspcfs><response><
status>0</status><errorText/></response></aspcfs>
INFO [org.aspcfs.controller.ApplicationPrefs] - Saving preferences to file: C:\
dhandapani\projects\concursive\centric\build.properties
Prefs-> Instance name: C:\dhandapani\softwares\tomcat\Tomcat 5.5\webapps\centric
\
INFO [org.aspcfs.controller.ApplicationPrefs] - Saving preferences to file: C:\
dhandapani\projects\concursive\centric\build.properties
INFO [org.aspcfs.controller.ApplicationPrefs] - Saving preferences to file: C:\
dhandapani\projects\concursive\centric\build.properties
INFO [org.aspcfs.controller.ApplicationPrefs] - Saving preferences to file: C:\
dhandapani\projects\concursive\centric\build.properties
INFO [org.aspcfs.controller.ApplicationPrefs] - Saving preferences to file: C:\
dhandapani\projects\concursive\centric\build.properties
INFO [org.aspcfs.controller.ApplicationPrefs] - Saving preferences to file: C:\
dhandapani\projects\concursive\centric\build.properties
SetupUtils-> Installing Schema: jndi:/localhost/centric/WEB-INF/setup/mysql
Executed 5 total statements
Executed 186 total statements
Executed 42 total statements
DatabaseUtils-> ERROR(1), line: 544 message: Specified key was too long; max key
length is 767 bytes
ERROR [org.aspcfs.modules.setup.actions.Setup] - Inserting default data failed:
Specified key was too long; max key length is 767 bytes
FileUtils-> Destination already exists
INFO [org.aspcfs.controller.ApplicationPrefs] - Saving preferences to file: C:\
dhandapani\projects\concursive\centric\build.properties
SetupUtils-> Installing Schema: jndi:/localhost/centric/WEB-INF/setup/mysql
DatabaseUtils-> ERROR(1), line: 28 message: Table 'sites' already exists
ERROR [org.aspcfs.modules.setup.actions.Setup] - Inserting default data failed:
Table 'sites' already exists
FileUtils-> Destination already exists
INFO [org.aspcfs.controller.ApplicationPrefs] - Saving preferences to file: C:\
dhandapani\projects\concursive\centric\build.properties
SetupUtils-> Installing Schema: jndi:/localhost/centric/WEB-INF/setup/mysql
Executed 5 total statements
Executed 186 total statements
Executed 42 total statements
DatabaseUtils-> ERROR(1), line: 544 message: Specified key was too long; max key
length is 767 bytes
ERROR [org.aspcfs.modules.setup.actions.Setup] - Inserting default data failed:
Specified key was too long; max key length is 767 bytes
Could you please help me to resolve this issue?
Regards,
dhandapani