portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ate Douma (JIRA)" <jetspeed-...@portals.apache.org>
Subject [jira] Commented: (JS2-1025) Mysql maven2 build error - UNIQUE INDEX key too long
Date Thu, 11 Jun 2009 07:23:07 GMT

    [ https://issues.apache.org/jira/browse/JS2-1025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718328#action_12718328
] 

Ate Douma commented on JS2-1025:
--------------------------------

Follow up comment from Vangelis send to the jetspeed-dev@ list on 2009-06-06:

Evangelos Vlachogiannis wrote:
> I have probably found the solution:
> 
> the problem was that I was using utf-8 mysql encoding (see from example 
> http://bugs.mysql.com/bug.php?id=4541). So I edited the generated 
> create-schema.sql and set:
> 
> CREATE TABLE PORTLET_PREFERENCE
> (
>    ID INTEGER NOT NULL,
>    DTYPE VARCHAR(10) NOT NULL,
>    APPLICATION_NAME VARCHAR(80) NOT NULL,
>    PORTLET_NAME VARCHAR(80) NOT NULL,
>    ENTITY_ID VARCHAR(80) NULL,
>    USER_NAME VARCHAR(80) NULL,
>    NAME VARCHAR(254) NOT NULL,
>    READONLY SMALLINT NOT NULL,
>    PRIMARY KEY (ID)
> ) DEFAULT CHARACTER SET latin1;
> 
> then the db was created successfully. ... however the
> 
> mvn jetspeed:mvn -Dtarget=all
> 
> cannot work if the jetspeed jars does not contain something like that;) 
> so I have to build the portal stepby step.
> 
> BR,
> Vangelis


> 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
>            Priority: Minor
>
> 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