portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Evangelos Vlachogiannis (JIRA)" <jetspeed-...@portals.apache.org>
Subject [jira] Created: (JS2-1025) Mysql maven2 build error - UNIQUE INDEX key too long
Date Sun, 31 May 2009 17:04:07 GMT
Mysql maven2 build error - UNIQUE INDEX key too long
----------------------------------------------------

                 Key: JS2-1025
                 URL: https://issues.apache.org/jira/browse/JS2-1025
             Project: Jetspeed 2
          Issue Type: Bug
          Components: Project Build
    Affects Versions: 2.2.2
         Environment: WinXP, jdk 1.6, mysql 5.0.45 community-nt
            Reporter: Evangelos Vlachogiannis


While building a custom j2.2 portal I got the following error:

Embedded error: Failed to execute:   CREATE UNIQUE INDEX UIX_PORTLET_PREFERENCE
ON PORTLET_PREFERENCE (DTYPE, APPLICATION_NAME, PORTLET_NAME, ENTITY_ID, USER_NA
ME, NAME)
Specified key was too long; max key length is 1000 bytes
[INFO] ------------------------------------------------------------------------
[INFO] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Unexpected error

I think that the:
CREATE UNIQUE INDEX UIX_PORTLET_PREFERENCE ON
PORTLET_PREFERENCE (DTYPE, APPLICATION_NAME, PORTLET_NAME, ENTITY_ID, USER_NAME, NAME)

query needs to be replaced with a shorter index e.g. (DTYPE, APPLICATION_NAME, PORTLET_NAME)
but I do not know about side effects.

Please provide fix and deploy also to jars as people cannot build custom portals with j2.2
/ mysql

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Mime
View raw message