| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005544 | mantisbt | db mssql | public | 2005-04-29 13:54 | 2014-05-16 15:00 |
| Reporter | griddly | Assigned To | grangeway | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.0.0a2 | ||||
| Fixed in Version | 1.1.0a4 | ||||
| Summary | 0005544: MSSQL APPLICATION ERROR 0000401 When Uploading Files | ||||
| Description | 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 Files. The appearance is that it reads the internal contents of the file and errors with an APPLICATION ERROR 0000401 | ||||
| Additional Information | Since the Post on the forums I have come to find out that this happens frequently on other pages as well regardless of file type. It is Hit or miss at this point as to whether it is succesful or not. | ||||
| Tags | No tags attached. | ||||
 |
I think that our method of escaping quotes may be incorrect. |
 |
What Can I provide to you in order to diagnose? I did further investigation and found that it depends on the content of the file. Seems that Because it is reading the internal comments of the file it is delineating the "commas" as field seperaters? its just kinda odd to me as I thought it only imports the file and not open it. |
 |
your value of magic_quotes_sybase is ? |
|
|
Not sure where to find the information you are asking for? I dont recall setting a variable for this. |
|
|
I think that we're not escaping enough characters. We use "addslashes" to escape ('), ("), () and (null). The MSSQL manual says that other characters (ref http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vjref98/html/3_10_5.asp ). The php variables "magic_quotes_sybase" and "magic_quotes_gpc" affect how this works. |
|
|
I was thinking about changing mantis to use qstr from adodb instead of the current match of functions, however the implementation of qstr in adodb looked to me as a) possibly not dealing with this case b) being incomplete - or at least requiring the adodb c php library. This was just from a quick code browse without actually running it. http://phplens.com/adodb/reference.functions.qstr.html However, in theory if it works, this is probably the function that should replace the current call to addslashes that we make. |
|
|
From the information given I was able to find this in the PHP.INI magic_quotes_sybase = Off and magic_quotes_gpc = On |
|
|
iirc, magic_quotes_sybase should be set to on for mssql. Paul |
|
|
Set magic_quotes_sybase = On and this resolved the issue, however at this point the download "HANGS", You can Click an Attachment link, Get the File open or save dialog, after clicking Either button it hangs. I attached a screen shot. Seems to be related in some fashion to Bug 0005533. I have updated Fle_Download.php to ver 135 from the CVS to see if this resolves it, however No Joy. This Install is not https. and it only works with Text Files. |
 |
Please see 0005904 for my input and resolution on this. |
 |
Probably the same core problem. Client: Firefox2 on WinXP |
|
|
Hello all, i've just commited a fix to CVS for inclusion for 1.1.0a4 which appears to fix this issue. Paul |
|
|
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 |
