View Issue Details

IDProjectCategoryView StatusLast Update
0021890mantisbtdb oraclepublic2018-03-31 20:03
Reportercproensa Assigned To 
PrioritynormalSeverityblockReproducibilityhave not tried
Status newResolutionopen 
Product Version1.3.3 
Summary0021890: oracle, schema steps 203 204 fails
Description

<pre>
Error SQL: ORA-22859: invalid modification of columns

  1. 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.
    </pre>
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:
<pre>
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
</pre>

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
2017-04-01 00:20 vboctor Target Version 2.3.0 => 2.4.0
2017-04-30 14:53 vboctoradmin Target Version 2.4.0 => 2.5.0
2017-06-04 16:19 atrol Target Version 2.5.0 => 2.6.0
2017-09-03 18:49 vboctor Target Version 2.6.0 => 2.7.0
2017-10-08 23:55 vboctor Target Version 2.7.0 => 2.8.0
2017-10-28 19:14 vboctor Target Version 2.8.0 => 2.9.0
2017-12-04 02:25 vboctor Target Version 2.9.0 => 2.10.0
2017-12-30 18:39 vboctor Target Version 2.10.0 => 2.11.0
2018-02-06 21:22 vboctor Target Version 2.11.0 => 2.12.0
2018-03-04 00:41 vboctor Target Version 2.12.0 => 2.13.0
2018-03-31 20:03 vboctor Target Version 2.13.0 =>