View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0020637mantisbtdb mssqlpublic2016-02-26 11:582025-05-01 02:31
Reporterrp14385 Assigned Todregad  
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionno change required 
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 .
Infoproyectos

Infoproyectos

2025-04-30 20:11

reporter   ~0070205

Hi. I haven't been able to solve it either.

  • SO Windows Server 2016
  • Apache 2.4.62.1
  • PHP 8.3.14
  • Sqlserver ExtensionVer 5.12.0+177.29
  • ODBC Driver 17 for SQL Server
dregad

dregad

2025-05-01 02:27

developer   ~0070206

@Infoproyectos this issue was reported 9 years ago on version 1.2 which is no longer supported.

I suggest you open a separate one with details about your specific problem. And please note that none of the core devs use MSSQL it may be difficult for us to help.
dregad

dregad

2025-05-01 02:31

developer   ~0070207

@rp14385 considerkng the lack of activity on this for so many years, I assume you managed to fix the problem somehow.

I'm resolving this issue as "no change required", because it was reported against an old version of MantisBT which is no longer supported.

I recommend that you upgrade to the latest stable version [1]; if the problem persists after doing so, do not hesitate to reopen the issue.

[1] https://mantisbt.org/download.php