View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0008203 | mantisbt | db mssql | public | 2007-07-27 02:43 | 2014-05-16 15:00 |
| Reporter | AngelVel | Assigned To | grangeway | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | no change required | ||
| Product Version | 1.1.0a3 | ||||
| Summary | 0008203: Linux with MSSQL DB = bad datetime format | ||||
| Description | Mantis 1.1.0a3 was installed on Windows Server 2003 with MS SQL 2000 SP3 and working properly (with file upload to disk). | ||||
| Tags | No tags attached. | ||||
|
is this the same / caused by 0006240 ? |
|
|
Yes, it looks like 0006240. Sorry, I haven't seen it. |
|
|
Here is my patch: |
|
|
If you did not actually try, I would appreciate if you could test the fix in 0006240 and let us know if that works. |
|
|
The problems are different, thou in the same place. The 6240 cannot help me because I don't have problem with apostrophies, but with the format. I don't think strtotime() can handle the apostrophies, and it works for me. |
|
|
Reminder sent to: grangeway grangeway, what is your input on this since you are the MS SQL guy :) |
|
|
1.2.x stores dates as int's [to get avoid issues like this] |
|
|
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 |
|