View Issue Details

IDProjectCategoryView StatusLast Update
0021890mantisbtdb oraclepublic2022-05-11 04:10
Reportercproensa Assigned To 
PrioritynormalSeverityblockReproducibilityhave not tried
Status newResolutionopen 
Product Version1.3.3 
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

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

@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