View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0013828mantisbtdb mssqlpublic2012-01-31 08:252014-05-16 15:00
Reporterrabbit Assigned Toatrol  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionno change required 
Product Version1.2.8 
Summary0013828: Attachements get corruped with mssql
Description

When uploading attachements, some of them get corrupted.

I was able to upload very small .png s, but most of the attachement get corrupted.

Steps To Reproduce
  • Upload the file attached to this ticket on a system using mssql
  • Try to download the attachement from the ticket
Additional Information

Attachement configuration settings:



--- Attachments / File Uploads ---


$g_allow_file_upload    = ON;

$g_file_upload_method   = DATABASE; # or DISK

$g_absolute_path_default_upload_folder = ''; # used with DISK, must contain trailing \ or /.

$g_max_file_size        = 5000000;  # in bytes

$g_preview_attachments_inline_max_size = 256 * 1024;

$g_allowed_files        = '';       # extensions comma separated, e.g. 'php,html,java,exe,pl'

$g_disallowed_files     = '';       # extensions comma separated

TagsNo tags attached.
Attached Files
IO-Link_system_overview.pdf (491,476 bytes)
IO-Link_system_overview_corrupted.pdf (4,096 bytes)

Activities

rabbit

rabbit

2012-02-01 02:50

reporter   ~0031094

To precise:

The files get uploaded correctly. I verified this directly on the db server using SQL Maestro.

It looks like only the first 0xFFF (=4K) bytes are donwloaded. The corrupted file has the same content as the original, but it stops after 4K.
rabbit

rabbit

2012-02-01 03:04

reporter   ~0031095

The following settings in php.ini on the webserver solved the issue:

mssql.textlimit = 2147483647
mssql.textsize = 2147483647

Sry about the noise.
atrol

atrol

2012-02-01 04:53

developer   ~0031096

rabbit, thanks for comming back and telling the solution.
This is valuable information which will help other users with similar problems.
grangeway

grangeway

2014-05-16 15:00

reporter   ~0040379

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul