[ 
https://jira.duraspace.org/browse/DS-1379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=26814#comment-26814
 ] 

Artur Konczak commented on DS-1379:
-----------------------------------

One more issue in the same file (database_schema_18-3.sql) for oracle db

The line 
ALTER TABLE EPerson ALTER COLUMN password TYPE VARCHAR(128); 

should be replace by 
ALTER TABLE EPerson modify( password VARCHAR(128));
                
> Invalid update script for oracle db - database_schema_18-3.sql
> --------------------------------------------------------------
>
>                 Key: DS-1379
>                 URL: https://jira.duraspace.org/browse/DS-1379
>             Project: DSpace
>          Issue Type: Bug
>    Affects Versions: 3.0
>            Reporter: Artur Konczak
>            Assignee: Hardy Pottinger
>             Fix For: 3.0
>
>
> sql script for 'resourcepolicy' has a invalid separators for a columns 
> ';'(semicolon) instead of ','(commas)
> PATH: dspace/etc/oracle/database_schema_18-3.sql
> Current  version:
> ALTER TABLE resourcepolicy
>   ADD (
>         rpname VARCHAR2(30);
>         rptype VARCHAR2(30);
>         rpdescription VARCHAR2(100)
>       );
> Fixed version:
> ALTER TABLE resourcepolicy
>   ADD (
>         rpname VARCHAR2(30),
>         rptype VARCHAR2(30),
>         rpdescription VARCHAR2(100)
>       );

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_nov
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to