MSSQL APPLICATION ERROR #401 When Uploading Compressed Files

griddly · Post by **griddly** » 27 Apr 2005, 19:08

I currently have SQL SVR 2000 SP3 installed and version Mantis 1.0.0a2, PHP 4.3.6.6, IIS6, windows svr 2003 I made the appropriate mods to the old MSSQL.SQL File to accomodate for the missing fields. MANTIS Works fine, with exception of uploading compressed files, Like ZIP, CAB, etc etc. The appearance is that it reads the internal contents of the file and errors with an

APPLICATION ERROR #401
Database query failed. Error received from database was #105: Unclosed quotation mark before the character string ')'. for the query: INSERT INTO mantis_bug_file_table
(bug_id, title, description, diskfile, filename, folder, filesize, file_type, date_added, content)

I do realize that MSSQL is not officially supported, however, any help on this issue is appreciated.

Any other files such as txt, doc, etc etc documents that dont contain additional files do not have this issue. I have checked the CVS files for other posts regarding 401 issues and I already have the updated files regarding this so it is apparently something different.

Victor, I can provide the SQL file that I have to your programmers and they may possibly glean some information from it to construct an Updated MSSQL File to be run through SQL query analyzer.

Thanks for anyones help :)

thraxisp · Post by **thraxisp** » 27 Apr 2005, 23:59

This looks like there is an issue with quoting MSSQL strings. from my reading, MSSQL doubles up on quotes to escape them. Could you please file this in the tracker at http://bugs.mantisbt.org/ .

MSSQL support is covered in #5289 .

griddly · Post by **griddly** » 28 Apr 2005, 22:22

Thanks for your prompt response, I will do as soon as I get off work this PM

griddly · Post by **griddly** » 28 Apr 2005, 22:29

Thanks for your prompt response, I will do as soon as I get off work this PM