"Installation Step 1 - MySQL Error: Creation of Quartz tables failed"
Hy!
I have almost finished the installation of RapidAnalytics, but during the installation step 1 I got the following error:
Could anyone help me please?
Cheers,
rberger
I have almost finished the installation of RapidAnalytics, but during the installation step 1 I got the following error:
I already googled this error and I think it is a problem with the MySQL character set.
ERROR: Creation of Quartz tables failed: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key lenght is 1000 bytes
Could anyone help me please?
Cheers,
rberger
Find more posts tagged with
Sort by:
1 - 3 of
31
Hy Simon!
Thank you very much! I solved the problem this way: I changed the default character set from mysql from utf8 to latin1.
If anyone has the same problem, here is the code:
Thank you very much! I solved the problem this way: I changed the default character set from mysql from utf8 to latin1.
If anyone has the same problem, here is the code:
Cheers!
alter database *yourdatabsename* default character set latin1 collate latin1_swedish_ci;
Thanks, used the changing charset solution! It worked!
quartz uses compound keys with three VARCHAR columns of length 200, I believe. That makes for a total of 600 characters. With most encodings, this is still ok, but in UTF16 this is 1200 bytes, which MySQL does not handle by default: Keys can have length at most 1200. Two solutions: Change encoding or allow longer keys. Consult MySQL manual for more info.
Best,
Simon