View Issue Details

IDProjectCategoryView StatusLast Update
0021890mantisbtdb oraclepublic2017-02-26 21:19
ReportercproensaAssigned To 
PrioritynormalSeverityblockReproducibilityhave not tried
Status newResolutionopen 
Product Version1.3.3 
Target Version2.3.0Fixed in Version 
Summary0021890: oracle, schema steps 203 204 fails
Description
Error SQL: ORA-22859: invalid modification of columns
22859. 00000 -  "invalid modification of columns"
*Cause:    An attempt was made to modify an object, REF, VARRAY, nested
           table, or LOB column type.
*Action:   Create a new column of the desired type and copy the current
           column data to the new type using the appropriate type
           constructor.
TagsNo tags attached.

Relationships

related to 0020547 closeddregad Attachments can't be uploaded after upgrade from 1.2 with MySQL in STRICT_ALL_TABLES sql_mode 

Activities

dregad

dregad

2016-11-09 10:55

developer   ~0054487

My dev box Oracle setup is broken since I upgraded it to Ubuntu 16.04 and I don't have time to fix it :-/

Can you please

  1. compare column definition of mantis_bug_file_table.content between

    • a 1.2.x install (assuming it even works, since there were many issues with oci8 support that were only fixed in 1.3)
    • a 1.3.x install
  2. set the 2 upgrade steps to NULL in schema.php, complete the upgrade and check if attachments work as expected (see issue 0020547)
cproensa

cproensa

2016-11-09 13:39

developer   ~0054490

Last edited: 2016-11-09 13:43

View 2 revisions

yeas, i will have a look when i have the time.

My dev box Oracle setup is broken since I upgraded it to Ubuntu 16.04 and I don't have time to fix it :-/

i managed to run a docker with oracle xe, wich is very lightweight and no hassle with configurations. you may want to try:
https://hub.docker.com/r/sath89/oracle-xe-11g/

dregad

dregad

2016-11-11 07:19

developer   ~0054506

Thanks for the pointer to the Docker image. I never used that before, but it sounds very useful, and definitely less hassle than manually setting up and maintaining a working local Oracle stack. I'll give it a try.

Wouldn't it be great if we could have that for MSSQL on a Linux box too ;)

atrol

atrol

2016-11-11 07:50

developer   ~0054507

Wouldn't it be great if we could have that for MSSQL on a Linux box too ;)

Announced for mid 2017
http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux

cproensa

cproensa

2016-11-12 15:13

developer   ~0054511

Last edited: 2016-11-12 15:14

View 2 revisions

@dregad

i have tried to install with 1.2 up until 1.3-beta3 with no luck (errors with adodb connection...)

I tried with the previous point to those schema changes
a3e52aab0964ca644a8c0714e3ab35e980e32ded~1

The table bug_file is created as:

Columns 
NAME          DATA TYPE            NULL  DEFAULT    COMMENTS
*ID           NUMBER(10,0)         No                   
 BUG_ID       NUMBER(10,0)         No    0              
 TITLE        VARCHAR2(250 BYTE)   Yes   ''             
 DESCRIPTION  VARCHAR2(250 BYTE)   Yes   ''             
 DISKFILE     VARCHAR2(250 BYTE)   Yes   ''             
 FILENAME     VARCHAR2(250 BYTE)   Yes   ''             
 FOLDER       VARCHAR2(250 BYTE)   Yes   ''             
 FILESIZE     NUMBER(10,0)         No    0              
 FILE_TYPE    VARCHAR2(250 BYTE)   Yes   ''             
 CONTENT      BLOB                 Yes   empty_blob()   
 DATE_ADDED   NUMBER(10,0)         No    1              
 USER_ID      NUMBER(10,0)         No    0              
Indexes
INDEX_NAME                  UNIQUENESS  STATUS  FUNCIDX_STATUS  COLUMNS   COLUMN_EXPRESSION  
MANTIS.SYS_C007499          UNIQUE      VALID                   ID                           
MANTIS.IDX_DISKFILE         NONUNIQUE   VALID                   DISKFILE                     
MANTIS.IDX_BUG_FILE_BUG_ID  NONUNIQUE   VALID                   BUG_ID  

At this point, would you skip those steps for oracle?
or fix the issue by actually altering the table (with a custom function to create a new field, move and drop)

cproensa

cproensa

2016-12-28 19:01

developer   ~0054857

Wouldn't it be great if we could have that for MSSQL on a Linux box too ;)
Announced for mid 2017
http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux

Havent tested yet:
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-docker

Issue History

Date Modified Username Field Change
2016-11-08 17:57 cproensa New Issue
2016-11-09 10:44 dregad Relationship added related to 0020547
2016-11-09 10:55 dregad Note Added: 0054487
2016-11-09 13:39 cproensa Note Added: 0054490
2016-11-09 13:43 cproensa Note Edited: 0054490 View Revisions
2016-11-11 07:19 dregad Note Added: 0054506
2016-11-11 07:50 atrol Note Added: 0054507
2016-11-12 15:13 cproensa Note Added: 0054511
2016-11-12 15:14 cproensa Note Edited: 0054511 View Revisions
2016-11-17 08:11 dregad Target Version => 1.3.4
2016-11-17 08:12 dregad Severity minor => block
2016-11-27 08:22 dregad Target Version 1.3.4 => 1.3.5
2016-12-28 19:01 cproensa Note Added: 0054857
2016-12-30 16:24 atrol Target Version 1.3.5 => 1.3.6
2017-02-01 22:47 vboctor Target Version 1.3.6 => 1.3.7
2017-02-26 21:19 vboctor Target Version 1.3.7 => 2.3.0