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)

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/

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 ;)

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

@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)

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