Re: update jetspeed 2.2.0 to 2.2.2. --> invalid column name clone_parent

To migrate from 2.2.1 to 2.2.2, add one column CLONE_PARENT to the
PORTLET_DEFINITION table. Example of MySQL:

CREATE TABLE PORTLET_DEFINITION
(
    ID INTEGER NOT NULL,
    NAME VARCHAR(80) NULL,
    CLASS_NAME VARCHAR(255) NULL,
    APPLICATION_ID INTEGER NOT NULL,
    EXPIRATION_CACHE INTEGER,
    RESOURCE_BUNDLE VARCHAR(255) NULL,
    PREFERENCE_VALIDATOR VARCHAR(255) NULL,
    SECURITY_REF VARCHAR(40) NULL,
    CACHE_SCOPE VARCHAR(30) NULL,
    CLONE_PARENT VARCHAR(80) NULL,
    PRIMARY KEY (ID)
) ;

You can run an alter table command something like:

ALTER TABLE 'PORTLET_DEFINITION` ADD COLUMN `CLONE_PARENT` DEFAULT NULL;

I will update the Data Migration guide here today:

http://portals.apache.org/jetspeed-2/guide-migration.html


On Wed, Oct 12, 2011 at 6:27 AM, Frank Otto <[email protected]> wrote:
> hi,
>
> I want to update my custom portal from version 2.2.0 to 2.2.2. On starting
> the "new" portal, I get following error:
>
> invalid column name 'CLONE_PARENT'
>
> Is there a script to update the existing jetspeed database?
>
>
> best regards,
>
> Frank
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>



-- 
David