View Issue Details

IDProjectCategoryView StatusLast Update
0017778mantisbtattachmentspublic2015-03-30 03:48
Reporterschoppi71 Assigned Todregad  
PriorityurgentSeveritycrashReproducibilityalways
Status assignedResolutionopen 
PlatformVM-WareOSSuSe Linux Enterprise ServerOS Version10
Product Version1.2.17 
Summary0017778: Attachments get corrupted when attaching to a bug
Description

I have the same Problem as mentioned in this issue 0017097 but with every type of attachment.

I have implemented the bugfix decribed here 0017097:0039693 and it works now.

Additional Information

PostgreSQL 9.3.4 and PostgreSQL 8.3.7
PHP Version 5.2.5

TagsNo tags attached.

Relationships

related to 0017097 closeddregad Images get corrupted when attaching to a bug 

Activities

vboctor

vboctor

2014-10-27 12:47

manager   ~0041682

Reminder sent to: dregad

Adding @dregad since he was involved with the other issue referenced.

schoppi71

schoppi71

2014-11-26 06:24

reporter   ~0041919

Hello,
are there any activities on that issue?
Regards

schoppi71

schoppi71

2015-01-27 02:43

reporter   ~0048696

Hello,

with version 1.2.19 there is an additional problem with double backslashes in the bytea field. I'm using PoastgreSQL 8.3.
All new uploaded Attachment are corrupted because of this problem.

Regarding to the administration documentation MySQL and PostgreSQL are spported by Mantis.

Regards,
Andreas

dregad

dregad

2015-02-09 16:00

developer   ~0048805

Hi,

As mentioned in 0017097:0039697, I was not able to reproduce the problem the first time around, which makes it difficult to analyze the problem and evaluate the correctness of the patch proposed by piffio in 0017097:0039693 - which I have to say kind of looks like a hack, not to mention that it involves modifying the ADOdb library which we normally don't do (we usually report issues upstream and wait for them to fix things instead).

If you're able to consistently reproduce the issue, then maybe you can help getting to the bottom of the issue (root cause analysis).

dregad

dregad

2015-03-10 18:41

developer   ~0049172

schoppi71, can you help determining the root cause for this ? If not, I'll have to mark this as resolved as I still can't reproduce it.

It would also be useful if you could test against Mantis 1.3.0-beta.1

schoppi71

schoppi71

2015-03-11 02:55

reporter   ~0049174

Hi dregad,

yes of course.

Regrads

dregad

dregad

2015-03-11 09:19

developer   ~0049178

Thanks, I'll wait for your feedback then.

schoppi71

schoppi71

2015-03-18 11:04

reporter   ~0049261

Hi,

I tested with
mantisbt-1.3.0-beta.2
PostGreSQL Version 8.3
PHP-Version 5.6.0

and I got a DB error when I try to upload a file to an existing issue:

#-1: ERROR: null value in column "content" violates not-null constraint für die Abfrage: INSERT INTO mantis_bug_file_table ( bug_id, title, description, diskfile, filename, folder,
filesize, file_type, date_added, user_id )
VALUES
( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10 ).

It seems that there are other bugs within this beta version.

Regards

dregad

dregad

2015-03-19 10:07

developer   ~0049275

Is that on a fresh 1.3 install ?

schoppi71

schoppi71

2015-03-20 02:57

reporter   ~0049276

Yes

dregad

dregad

2015-03-20 06:35

developer   ~0049277

PostGreSQL Version 8.3

According to http://www.postgresql.org/support/versioning/ 8.3 is no longer supported (since Feb. 2013), is this reproducible also on a more current release, e.g. 9.x ?

schoppi71

schoppi71

2015-03-30 03:48

reporter   ~0049302

I applied a PostGreSQL DB Version 9.3 and I get the same DB error when I try to upload a file to an existing issue:

ERROR: null value in column "content" violates not-null constraint
INSERT INTO mantis_bug_file_table ( bug_id, title, description, diskfile, filename, folder, filesize, file_type, date_added, user_id )
VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10 ).