View Issue Details

IDProjectCategoryView StatusLast Update
0020637mantisbtdb mssqlpublic2016-03-01 03:24
Reporterrp14385 Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status newResolutionopen 
PlatformWindowsOSwindows 2008R2OS Version2008
Product Version1.2.19 
Summary0020637: Getting error while signup/login to Mantisbt
Description

I am getting error while login in mantis BT. Error "Database query failed. Error received from database was 0000207: SQLState: 42S22
Error Code: 207
Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'expiry'.
for the query: DELETE FROM mantis_tokens_table WHERE ? > expiry.
"

Steps To Reproduce

While login in

Additional Information

attached error screenshots. I am using IIS7.5, PHP5.6, MSSQL2012R2

TagsNo tags attached.
Attached Files
mantis.png (75,083 bytes)   
mantis.png (75,083 bytes)   
mantis1.3.0error.png (19,731 bytes)   
mantis1.3.0error.png (19,731 bytes)   
mantis1.3.0-error.png (7,749 bytes)   
mantis1.3.0-error.png (7,749 bytes)   

Activities

dregad

dregad

2016-02-26 12:38

developer   ~0052579

Last edited: 2016-02-27 09:34

MSSQL does not work well with MantisBT 1.2.x. Is this a new install ?

In any case, I would suggest you try with the latest 1.3.x nightly build.

rp14385

rp14385

2016-02-26 12:55

reporter   ~0052580

Hi Dregad, Im trying to upgrade from 1.1.1 to 1.2.19. so, is there any stable release in 1.3.x which supports MSSQL ?

dregad

dregad

2016-02-27 09:35

developer   ~0052588

If you're not comfortable with testing using a nightly build, you can download the latest release candidate (1.3.0rc1).

rp14385

rp14385

2016-03-01 03:14

reporter   ~0052622

Hi Dregad, I tried upgrading using 1.3.0Rc1, but still I am unable to login, PFA error screenshot .